Report Data Views and Data Definitions

Modified on Thu, 3 Mar, 2022 at 12:01 PM

 

View NameColumnData TypeSizeScale
vw_MW_Class_SemOccurClass_IDuniqueidentifier160

Semestervarchar20
vw_PVNCCDSB_Transportation_NextYearStudent numbervarchar250

Surnamenvarchar1000

Given namenvarchar1000

Gradevarchar30

Apartment numbervarchar100

House numbervarchar100

Street namevarchar2550

Cityvarchar500

Postal codevarchar250

Phone numbervarchar400

Sitter's namenvarchar2020

Sitter's house numbervarchar100

Sitter's street namevarchar2550

Sitter's cityvarchar500

Sitter's postal codevarchar250

Sitter's phone numbervarchar400

Birthdatedate100

Genderchar10

Attendance typevarchar500

Townshipvarchar500

School numbervarchar100

French immersion typevarchar1500

Homeroom numbervarchar50

Homeroom designationvarchar40

Grade next yearvarchar30

OEN numbervarchar120

School short namevarchar100

Entry datedate100

Mother's titlenvarchar600

Mother's given namenvarchar1000

Mother's surnamenvarchar1000

Mother's house numbervarchar100

Mother's street namevarchar2550

Mother's cityvarchar500

Mother's postal codevarchar250

Father's titlenvarchar600

Father's given namenvarchar1000

Father's surnamenvarchar1000

Father's house numbervarchar100

Father's street namevarchar2550

Father's cityvarchar500

Father's postal codevarchar250

Homeroom designation next yearvarchar40

Lives Withvarchar1500

Special Custodybit10
vw_MW_Course_Num_ClassesCodechar100

Code_IDuniqueidentifier160

Num_Classesint100

Scl_Year_info_IDuniqueidentifier160
vw_MW_Credit_Req_AreaSchool_IDuniqueidentifier160

School_Numbervarchar100

School_Codevarchar100

Person_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Status_IDuniqueidentifier160

mwStatusvarchar10

Student_OENvarchar120

DateOfCompletionsmalldatetime160

Termvarchar10

Codechar100

Requirement_Area_Codevarchar20

Attempted_Credit_Valuedecimal52

Compulsory_Earned_Credit_Valuedecimal52

Optional_Earned_Credit_Valuedecimal52

Total_Earned_Credit_Valuedecimal52

Granting_Institutionchar100

Surnamenvarchar1000

Usual_Namenvarchar1000

Student_Gradevarchar30

Ministry_Numvarchar120

Category_Groupvarchar1000

Aboriginal_Status_Codechar100
vw_MW_Student_CalScl_Year_Info_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Scl_Cal_Lst_IDuniqueidentifier160

Cal_Datedate100

DayOfCycletinyint30

AttTypechar10

Sem_Numbertinyint30

Term_Numbertinyint30

Day_Numbertinyint30
vw_PVNC_Student_Origin_SchoolSchool_Short_Namevarchar100

originvarchar100

origin_statusvarchar180

School_Namevarchar2550

Cityvarchar500

Homeroom_Designationvarchar40

Homroom_Room_Numbervarchar50

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

Homeroom_Teacher_Numbervarchar250

Ministry_Numbervarchar120

Student_Numberbigint190

namenvarchar2040

Gradevarchar30

Birthdatedate100

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Contact_Numberbigint190

Contact_Typevarchar2550

contactNamenvarchar2040

Contact_Work_Phone_Numbervarchar400

Contact_Cell_Phone_Numbervarchar400

Contact_Home_Phone_Numbervarchar400

Contact_Email_Addressvarchar2550

Contact_Addressnvarchar-10

Emergency_Contact_Numbersmallint50

Consentnvarchar2000

ConsentReceivedDatedate100
vw_MW_Student_Cal_NoAttTypeScl_Year_Info_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Cal_Datedate100

DayOfCycletinyint30
vw_MW_Student_Cal_WClassesStu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

Cal_Datedate100

DayOfCycletinyint30

AttTypechar10

Class_IDuniqueidentifier160

Scl_Cal_Lst_IDuniqueidentifier160

Sem_Numbertinyint30

Term_Numbertinyint30

Day_Numbertinyint30
vw_MW_Student_HalfDay_AttScl_Year_Info_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Cal_Datedate100

DayOfCycletinyint30

AttTypechar10

AM_Regchar10

PM_Regchar10

AM_Attendchar10

PM_Attendchar10

AM_Reptchar10

PM_Reptchar10

Sur_Namenvarchar1000

Usual_Namenvarchar1000

OENvarchar120

Gradevarchar30

School_Short_Namevarchar100

School_Namevarchar2550

AM_Attendance_Reason_Codevarchar500

AM_Attendance_Reasonvarchar1500

PM_Attendance_Reason_Codevarchar500

PM_Attendance_Reasonvarchar1500

Stu_Letterschar30
vw_MW_Student_Period_AttendStu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

Cal_Datedate100

DayOfCycletinyint30

AttTypechar10

Class_IDuniqueidentifier160

Period_Attendchar10

Attend_Reptchar10

Attend_Regchar10

Per_Numbertinyint30

Sur_Namenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

OENvarchar120

Gradevarchar30

Schedulingbit10

Period_Attend_Titlevarchar500

Attendance_Reason_Codevarchar500

Attendance_Reasonvarchar1500

School_Short_Namevarchar100

Course_Codevarchar100

Class_Sectionchar20

Sem_Numbertinyint30

Term_Numbertinyint30

Day_Numbertinyint30

Stu_Letterschar30
vw_Base_PVNCCDSB_SEOS_ExportStu_Enrol_IDuniqueidentifier160

person_iduniqueidentifier160

OENvarchar120

LastNamenvarchar1000

FirstNamenvarchar1000

DOBdate100

Sexchar10

Addressvarchar2770

Cityvarchar500

Postal_Codevarchar250

Father_Namenvarchar2040

Father_WorkPhonevarchar400

Mother_Namenvarchar2040

Mother_WorkPhonevarchar400

Home_Phonevarchar400

grade_iduniqueidentifier160

Gradevarchar30

Homeroom_Teachernvarchar2040

HomeroomNumbervarchar50

HomeroomDesignationvarchar40

Schoolvarchar2550

Midentvarchar100

MapleIDvarchar250

Exceptionalityvarchar1500

DateLastIPRCdate100

IEPbit10

AdmittedDatedate100

Placementvarchar1500

SpecializedEquipmentvarchar1500

DiplomaTypevarchar2550
vw_Student_Incidents_AllSchool_Short_Namevarchar100

Ministry_Numvarchar120

Student_Numbervarchar250

Surnamenvarchar1000

Given_Namenvarchar1000

Incident_Datedate100

Infractionsnvarchar-10

Consequencenvarchar2000

Durationnumeric52

Notenvarchar-10

Genderchar10

Gradevarchar30

Incident_Notenvarchar-10

Is_Special_Edbit10

Spec_Ed_Statusvarchar80

Exceptionalitiesnvarchar-10

IncidentNumbernvarchar400

Imposed_By_Rolenvarchar140

Imposed_By_Surnamevarchar500

Imposed_By_Given_Namevarchar500

Consequence_Start_Datedate100

Consequence_End_Datedate100

Locationnvarchar2000

Timeframenvarchar2000

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Suspension_Expulsion_Programnvarchar2000

Violent_Incidentbit10

Weapsons_Usedbit10

Police_Reportedbit10

Primary_Infractionnvarchar2200

Secondary_Infractionsnvarchar-10

Student_Birthdatedate100

Student_Age_At_Incidentint100

School_Namevarchar2550
vw_Student_SHSM_ONMident School#varchar100

School Namevarchar100

First Namenvarchar1000

Last Namenvarchar1000

OENvarchar120

StudentCodevarchar250

Stu_Statusvarchar180

Stu_Status_Codevarchar10

SHSMvarchar2550

Pathwayvarchar1000

Reach Aheadvarchar30

Ontario Skills Passportvarchar30

Experiential Learningvarchar30

Required Certificates and Training Completedvarchar30

Sector-partnered Contextualized experiencevarchar30

Innovation, Creativity, and Entrepreneurshipvarchar30

Codingvarchar30

Mathematical Literacyvarchar30

SHSM Completion Datedate100

Certificate 1varchar1500

Certificate 2varchar1500

Certificate 3varchar1500

Certificate 4varchar1500

Certificate 5varchar1500

Certificate 6varchar1500

Certificate 7varchar1500

Certificate 8varchar1500

Certificate 9varchar1500

Certificate 10varchar1500

Gradevarchar30

Genderchar10

Aboriginal_Self_IDvarchar1500

Spec_Ed_Statusvarchar80

Entry_Datedate100

Retirement_Datedate100

Diploma_Earnedvarchar2550

Diploma_Datedate100

Total_SHSM_Credits_Earneddecimal382

Total_Major_Earneddecimal382

Total_Major_Requireddecimal382

Total_Major_Remainingdecimal382

Total_CoOp_Earneddecimal382

Total_CoOp_Requireddecimal382

Total_CoOp_Remainingdecimal382

Total_English_Earneddecimal382

Total_English_Requireddecimal382

Total_English_Remainingdecimal382

Total_Math_Earneddecimal382

Total_Math_Requireddecimal382

Total_Math_Remainingdecimal382

Total_Other_Earneddecimal382

Total_Other_Requireddecimal382

Total_Other_Remainingdecimal382

Mandatory_Certificates_Earnedint100

Total_Mandatory_Certificatestinyint30

Elective_Certificates_Earnedint100

Total_Elective_Certificatestinyint30

Board_Resident_Statusvarchar1500

Is_Special_Edbit10

Exceptionalitiesnvarchar-10

School_Short_Namevarchar100

Community_Hours_Completednumeric192

Total_Creditsdecimal382

OSSLT_Statusvarchar140

OSSLT_Non_Participation_Statusvarchar200

Instructional_Settingvarchar1500
vw_Transcripts_ON_with_IEPTranscript_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Code_Def_IDuniqueidentifier160

School_Short_Namevarchar100

OENvarchar120

Sur_Namenvarchar1000

Usual_Namenvarchar1000

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Course_Codechar100

Course_Titlevarchar2550

Transcript_Datedate100

Markchar20

Credit_Earneddecimal72

Languagevarchar1500

Course_Typevarchar500

Delivery_Typevarchar500

Credit_Attempteddecimal52

Is_Special_Edbit10

Spec_Ed_Statusvarchar80

Exceptionalitiesnvarchar-10
vw_Student_SHSM_Projected_ONMident School#varchar100

School Namevarchar100

First Namenvarchar1000

Last Namenvarchar1000

OENvarchar120

StudentCodevarchar250

Stu_Statusvarchar180

Stu_Status_Codevarchar10

SHSMvarchar2550

Pathwayvarchar1000

Reach Aheadvarchar30

Ontario Skills Passportvarchar30

Experiential Learningvarchar30

Required Certificates and Training Completedvarchar30

Sector-partnered Contextualized experiencevarchar30

Innovation, Creativity, and Entrepreneurshipvarchar30

Codingvarchar30

Mathematical Literacyvarchar30

SHSM Completion Datedate100

Certificate 1varchar1500

Certificate 2varchar1500

Certificate 3varchar1500

Certificate 4varchar1500

Certificate 5varchar1500

Certificate 6varchar1500

Certificate 7varchar1500

Certificate 8varchar1500

Certificate 9varchar1500

Certificate 10varchar1500

Gradevarchar30

Genderchar10

Aboriginal_Self_IDvarchar1500

Spec_Ed_Statusvarchar80

Entry_Datedate100

Retirement_Datedate100

Diploma_Earnedvarchar2550

Diploma_Datedate100

Projected_Total_SHSM_Credits_Earneddecimal382

Projected_Total_Major_Earneddecimal382

Total_Major_Requireddecimal382

Projected_Total_Major_Remainingdecimal382

Projected_Total_CoOp_Earneddecimal382

Total_CoOp_Requireddecimal382

Projected_Total_CoOp_Remainingdecimal382

Projected_Total_English_Earneddecimal382

Total_English_Requireddecimal382

Projected_Total_English_Remainingdecimal382

Projected_Total_Math_Earneddecimal382

Total_Math_Requireddecimal382

Projected_Total_Math_Remainingdecimal382

Projected_Total_Other_Earneddecimal382

Total_Other_Requireddecimal382

Projected_Total_Other_Remainingdecimal382

Mandatory_Certificates_Earnedint100

Total_Mandatory_Certificatestinyint30

Elective_Certificates_Earnedint100

Total_Elective_Certificatestinyint30

Board_Resident_Statusvarchar1500

Is_Special_Edbit10

Exceptionalitiesnvarchar-10

School_Short_Namevarchar100

Community_Hours_Completednumeric192

Total_Creditsdecimal382

OSSLT_Statusvarchar140

OSSLT_Non_Participation_Statusvarchar200

Instructional_Settingvarchar1500

Total_Credits_Projecteddecimal382
vw_French_Immersion_Report_ONSurnamenvarchar1000

Given_Namenvarchar1000

OENvarchar120

Genderchar10

Gradevarchar30

Birthdatedate100

School_Midentvarchar100

School_Namevarchar2550

HCSchoolchar10

Stu_Statusvarchar180

French_Immersion_Programvarchar1500

End_Datedate100

School_Short_Namevarchar100

ESLbit10

ELDbit10

French_Immersion_Minutessmallint50

Aboriginal_Programvarchar1500

Aboriginal_Minutessmallint50

Special_Ed_Statusvarchar80

Next_Year_Gradevarchar30

Homeroom_Roomvarchar50

Homeroom_Designationvarchar40

Exceptionalitiesnvarchar-10

Entry_Date_To_Canadadate100

Country_Of_Birthvarchar1500
vw_Base_Students_PVNCStu_Enrol_IDuniqueidentifier160

Person_IDuniqueidentifier160

School_IDuniqueidentifier160

Contact_Lst_Lst_IDuniqueidentifier160

Homeroom_IDuniqueidentifier160

School_Short_Namevarchar100

School_Namevarchar2550

Ministry_Num_Fmtvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Birthdatedate100

Genderchar10

Grade_IDuniqueidentifier160

Gradevarchar30

Stu_Status_Codevarchar10

Stu_Statusvarchar180

HCSchoolchar10

Schedulingbit10

School_Numbervarchar100

Special_Edbit10

Stu_Numbervarchar250
vw_French_Immersion_Report_Scheduling_ONSurnamenvarchar1000

Given_Namenvarchar1000

OENvarchar120

Genderchar10

Gradevarchar30

Birthdatedate100

School_Midentvarchar100

School_Namevarchar2550

HCSchoolchar10

Stu_Statusvarchar180

French_Immersion_Programvarchar1500

End_Datedate100

School_Short_Namevarchar100

ESLbit10

ELDbit10

French_Immersion_Minutessmallint50

Aboriginal_Programvarchar1500

Aboriginal_Minutessmallint50

Special_Ed_Statusvarchar80

Next_Year_Gradevarchar30

Homeroom_Roomvarchar50

Homeroom_Designationvarchar40

Exceptionalitiesnvarchar-10

Entry_Date_To_Canadadate100

Country_Of_Birthvarchar1500
vw_Base_Students_PVNC_ElementaryStu_Enrol_IDuniqueidentifier160

Person_IDuniqueidentifier160

Contact_Lst_Lst_IDuniqueidentifier160

Homeroom_IDuniqueidentifier160

School_Short_Namevarchar100

School_Namevarchar2550

Ministry_Num_Fmtvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Birthdatedate100

Genderchar10

Grade_IDuniqueidentifier160

Gradevarchar30

Stu_Status_Codevarchar10

Stu_Statusvarchar180

HCSchoolchar10

Schedulingbit10

School_Numbervarchar100

Special_Edbit10

Stu_Numbervarchar250
vw_Base_PVNCCDSB_SEOS_Export_SecondaryStu_Enrol_IDuniqueidentifier160

person_iduniqueidentifier160

Ministry_Num_Fmtvarchar120

LastNamenvarchar1000

FirstNamenvarchar1000

Usual_Namenvarchar1000

DOBdate100

Sexchar10

Addressvarchar2770

Cityvarchar500

Postal_Codevarchar250

Father_Namenvarchar2040

Father_WorkPhonevarchar400

Mother_Namenvarchar2040

Mother_WorkPhonevarchar400

Home_Phonevarchar400

grade_iduniqueidentifier160

Gradevarchar30

Homeroom_IDuniqueidentifier160

School_Short_Namevarchar100

Schoolvarchar2550

school_IDuniqueidentifier160

school_numbervarchar100

MapleIDvarchar250

Exceptionalityvarchar1500

DateLastIPRCdate100

IEPbit10

AdmittedDatedate100

Placementvarchar1500

SpecializedEquipmentvarchar1500

DiplomaTypevarchar2550

Homeroom_Teachernvarchar2040

HomeroomNumbervarchar50

HomeroomDesignationvarchar40
vw_Base_PVNCCDSB_SEOS_Export_ElementaryStu_Enrol_IDuniqueidentifier160

OENvarchar120

LastNamenvarchar1000

FirstNamenvarchar1000

UsualNamenvarchar1000

DOBdate100

Sexchar10

Addressvarchar2770

Cityvarchar500

Postal_Codevarchar250

Father_Namenvarchar2040

Father_WorkPhonevarchar400

Mother_Namenvarchar2040

Mother_WorkPhonevarchar400

Home_Phonevarchar400

Gradevarchar30

Homeroom_Teachernvarchar2040

HomeroomNumbervarchar50

HomeroomDesignationvarchar40

School_Short_Namevarchar100

Schoolvarchar2550

Midentvarchar100

MapleIDvarchar250

Exceptionalityvarchar1500

DateLastIPRCdate100

IEPbit10

AdmittedDatedate100

Placementvarchar1500

SpecializedEquipmentvarchar1500
vw_Staff_Status_AllSchool_Short_Namevarchar100

School_Namevarchar2550

School_Numbervarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

Staff_Rolevarchar2550

Ministry_Numbervarchar150

Employee_Numbervarchar250

Email_Addressvarchar2550

Cityvarchar500

Provincevarchar500

Statusvarchar300

Status_Codechar10

Home_Phone_Numbervarchar400

Cell_Phone_Numbervarchar400
vw_Student_Early_Year_Questions_1_2_5_6_ONSchool_Short_Namevarchar100

OENvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Online_Regbit10

Gradevarchar30

Grade_Next_Yearvarchar30

Entry_Datedate100

Entered_Into_Maplewood_Datedate100

Origin_codevarchar1830

Age_Of_Childvarchar1500

Parent_Guardian_Care_FTbit10

Parent_Guardian_Care_PTbit10

Unpaid_Care_FTbit10

Unpaid_Care_PTbit10

Paid_Care_FTbit10

Paid_Care_PTbit10

Licensed_Home_Child_Care_FTbit10

Licensed_Home_Child_Care_PTbit10

Licensed_Child_Care_Centre_FTbit10

Licensed_Child_Care_Centre_PTbit10

Not_Applicablebit10

Question2nvarchar2000

Question5varchar1500

Question6varchar1500
vw_Student_Early_Year_Questions_3_4_7_ONSchool_Short_Namevarchar100

OENvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Online_Regbit10

Gradevarchar30

Grade_Next_Yearvarchar30

Entry_Datedate100

Entered_Into_Maplewood_Datedate100

Origin_codevarchar1830

Question3_Factor1varchar1500

Question3_Factor2varchar1500

Question3_Factor3varchar1500

Question4bit10

Question7_Factor1varchar1500

Question7_Factor2varchar1500

Question7_Factor3varchar1500
vw_Student_Enrolment_MBSchool_Short_Namevarchar100

School_Namevarchar2550

Student_Numberbigint190

METvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Gradevarchar30

Birthdatedate100

Genderchar10

Entry_Datedate100

Enrolment_Reasonvarchar1500

Retirement_Datedate100

Enrolment_Resultvarchar1500

Newcomer_EALvarchar1500

Newcomer_Additional_French_Supportbit10

Language_Program_1varchar1500

Language_Program_2varchar1500

Language_Program_3varchar1500

Language_Program_4varchar1500

Enrolled_Pupilbit10

Citizenshipvarchar1500

First_Languagevarchar1500

Student_Enrolment_Statusvarchar180

Home_Schoolbit10

Enrolment_Typevarchar1500

Residence_Divisionvarchar1500

Foreign_Exhange_Sponsorvarchar1500

Indian_Registry_Numbervarchar120

Residence_Statusvarchar1500

Band_Of_Residencevarchar1500

Reserve_Of_Residencevarchar1500

Band_Of_Financial_Responsibilityvarchar1500

Aboriginal_Identity_1varchar1500

Aboriginal_Identity_2varchar1500

Aboriginal_Identity_3varchar1500

Abroiginal_Identity_Descriptionvarchar250

Is_Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

Stu_Enrol_IDuniqueidentifier160

Person_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160
vw_Student_Enrolment_ONSchool_Short_Namevarchar100

School_Namevarchar2550

Student_Numberbigint190

OENvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Gradevarchar30

Birthdatedate100

Genderchar10

Entry_Datedate100

Enrolment_Reasonvarchar1500

Retirement_Datedate100

Enrolment_Resultvarchar1500

Citizenshipvarchar1500

Resident_Typevarchar1500

Country_Of_Birthvarchar1500

Base_Schoolvarchar1500

Tax_Supportvarchar1500

First_Languagevarchar1500

Student_Enrolment_Statusvarchar180

Home_Schoolbit10

Indian_Registry_Numbervarchar120

Residence_Statusvarchar1500

Band_Of_Residencevarchar1500

Reserve_Of_Residencevarchar1500

Band_Of_Financial_Responsibilityvarchar1500

Aboriginal_Status_Codevarchar1500

Aboriginal_Self_IDvarchar1500

Is_Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Exceptionality_2varchar1500

Exceptionality_3varchar1500

ESLbit10

ELDbit10

French_Programvarchar1500

Payment_Of_Other_Pupils_Feesvarchar1500

Stu_Enrol_IDuniqueidentifier160

Person_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160
vw_Archive_Achievement_ScheduleClass_IDuniqueidentifier160

School_Yearvarchar100

Schoolvarchar2550

School_Short_Namevarchar100

Classvarchar100

Sectionvarchar20

Class_Gradevarchar30

Teachernvarchar2640

Class_Semtinyint30

Class_Termtinyint30

Class_Daytinyint30

Class_Periodtinyint30
vw_Choices_Summary_ONSchool_Short_Namevarchar100

Course_Codechar100

Course_Titlevarchar2550

Course_Gradechar30

Credit_Valuedecimal52

Type_Of_Coursevarchar1200

Departmentvarchar1500

Course_Typevarchar500

Delivery_Typevarchar500

Languagevarchar1500

Dual_Credit_Course_Typevarchar1500

Stu_Countint100

Stu_Count_Mandatoryint100

Stu_Count_Electiveint100

Stu_Count_Alternateint100
vw_Class_Achievement_SetupSchool_Short_Namevarchar100

Course_Codevarchar100

Class_Sectionchar20

Course_Numbervarchar100

Course_Gradevarchar30

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Alt_Teacher_Surnamenvarchar1000

Alt_Teacher_Given_Namenvarchar1000

Occupancyint100

Languagevarchar1500

Grouped_Classesnvarchar-10

Achievement_Termsnvarchar-10

Achievement_Topicsnvarchar-10

Semester_Term_Patternnvarchar-10
vw_PVNCCDSB_Transportation_STSCOStudent numbervarchar250

Surnamenvarchar1000

Given namenvarchar1000

Gradevarchar30

Apartment numbervarchar100

House numbervarchar100

Street namevarchar2550

Cityvarchar500

Postal codevarchar250

Phone numbervarchar400

Sitter's namenvarchar2020

Sitter's house numbervarchar100

Sitter's street namevarchar2550

Sitter's cityvarchar500

Sitter's postal codevarchar250

Sitter's phone numbervarchar400

Birthdatedate100

Genderchar10

Attendance typevarchar500

Townshipvarchar500

School numbervarchar100

French immersion typevarchar1500

Homeroom numbervarchar50

Homeroom designationvarchar40

Grade next yearvarchar30

OEN numbervarchar120

School short namevarchar100

Entry datedate100

Mother's titlenvarchar600

Mother's given namenvarchar1000

Mother's surnamenvarchar1000

Mother's house numbervarchar100

Mother's street namevarchar2550

Mother's cityvarchar500

Mother's postal codevarchar250

Father's titlenvarchar600

Father's given namenvarchar1000

Father's surnamenvarchar1000

Father's house numbervarchar100

Father's street namevarchar2550

Father's cityvarchar500

Father's postal codevarchar250

Homeroom designation next yearvarchar40

Lives Withvarchar1500

Special Custodybit10
vw_Classes_Days_TaughtClass_IDuniqueidentifier160

School_Short_Namevarchar100

Classvarchar130

Course_Codevarchar100

Course_Numbervarchar100

Course_Gradevarchar30

Class_Sectionvarchar20

Class_Start_Datedate100

Class_End_Datedate100

Days_Taughtint100
vw_PVNCCDSB_Attendance_Rate_HalfDaySchool_Short_Namevarchar100

Gradevarchar30

Sep_Attend_Pctdecimal96

Oct_Attend_Pctdecimal96

Nov_Attend_Pctdecimal96

Dec_Attend_Pctdecimal96

Jan_Attend_Pctdecimal96

Feb_Attend_Pctdecimal96

Mar_Attend_Pctdecimal96

Apr_Attend_Pctdecimal96

May_Attend_Pctdecimal96

Jun_Attend_Pctdecimal96

S1_Attend_Pctdecimal96

S2_Attend_Pctdecimal96

Attend_Pctdecimal96

Retention_Pctdecimal96
vw_connectEd_Security_User_PermissionsSchool_Short_Namevarchar100

connectEd_User_Namevarchar1000

connectEd_Full_Namevarchar2550

connectEd_User_Groupvarchar250

Staff_Namevarchar1000

Student_Surnamevarchar500

Student_Given_Namevarchar500

Student_Usual_Namevarchar500

connectEd_Document_Hierarchynvarchar-10

CanViewbit10

CanAddbit10

CanEditbit10

CanDeletebit10
vw_PVNCCDSB_Transportation_ExportStudent numbervarchar250

Surnamenvarchar1000

Given namenvarchar1000

Gradevarchar30

Apartment numbervarchar100

House numbervarchar100

Street namevarchar2550

Cityvarchar500

Postal codevarchar250

Sitter's namenvarchar2020

Sitter's house numbervarchar100

Sitter's street namevarchar2550

Sitter's cityvarchar500

Sitter's postal codevarchar250

Sitter's phone numbervarchar400

Birthdatedate100

Genderchar10

Attendance typevarchar500

Townshipvarchar500

School numbervarchar100

French immersion typevarchar1500

Homeroom numbervarchar50

Homeroom designationvarchar40

Grade next yearvarchar30

OEN numbervarchar120

School short namevarchar100

Entry datedate100

Mother's titlenvarchar600

Mother's given namenvarchar1000

Mother's surnamenvarchar1000

Mother's house numbervarchar100

Mother's street namevarchar2550

Mother's cityvarchar500

Mother's postal codevarchar250

Father's titlenvarchar600

Father's given namenvarchar1000

Father's surnamenvarchar1000

Father's house numbervarchar100

Father's street namevarchar2550

Father's cityvarchar500

Father's postal codevarchar250

Homeroom designation next yearvarchar40

Lives Withvarchar1500

Special Custodybit10
vw_Course_Substitutions_ONSchool_Short_Namevarchar100

School_Namevarchar2550

Schedulingbit10

Course_Codevarchar100

Course_Numbervarchar100

Gradevarchar30

Credit_Valuedecimal52

Course_Typevarchar500

Delivery_Typevarchar500

Languagevarchar1500

Effective_Datedate100

Expiration_Datedate100

Substitutionbit10

Categorynvarchar-10

SHSM_Categorynvarchar-10
vw_PVNCCSDB_Attendance_Rate_PeriodSchool_Short_Namevarchar100

Gradevarchar30

Sep_Attend_Pctdecimal96

Oct_Attend_Pctdecimal96

Nov_Attend_Pctdecimal96

Dec_Attend_Pctdecimal96

Jan_Attend_Pctdecimal96

Feb_Attend_Pctdecimal96

Mar_Attend_Pctdecimal96

Apr_Attend_Pctdecimal96

May_Attend_Pctdecimal96

Jun_Attend_Pctdecimal96

S1_Attend_Pctdecimal96

S2_Attend_Pctdecimal96

Attend_Pctdecimal96

Retention_Pctdecimal96
vw_Courses_ONSchool_Short_Namevarchar100

Course_Codevarchar100

Course_Numbervarchar100

Schedulingbit10

Required_For_Transcriptsbit10

Course_Titlevarchar2550

Title_Matches_Codebit10

Languagevarchar1500

Weightchar10

Exclude_From_OnSISbit10

Show_In_Online_Choicesbit10

Departmentvarchar1500

Gradechar30

Credit_Valuedecimal52

Categoriesnvarchar-10

SHSM_Categoriesnvarchar-10

SHSM_Program_Associationnvarchar-10

Course_Typevarchar500

Dual_Credits_Typevarchar1500

Delivery_Typevarchar500
vw_Grade_10_Literacy_OntarioSchool_Namevarchar2550

OENvarchar80000

Sur_Namenvarchar1000

Usual_Namenvarchar1000

Gradechar30

Grade_6_EQAO_Readingreal240

Grade_6_EQAO_Writingreal240

Grade_6_EQAO_Mathreal240

Grade_9_English_Coursevarchar100

Grade_9_English_Markvarchar300

Grade_9_Geography_Coursevarchar100

Grade_9_Geography_Markvarchar300

Grade_9_Science_Coursevarchar100

Grade_9_Science_Markvarchar300

Grade_10_English_Coursevarchar100

Grade_10_English_Markvarchar300

Spring_OCA_Q1_Resultvarchar100

Spring_OCA_Q2_Resultvarchar100

Spring_OCA_Q3_Resultvarchar100

Spring_OCA_Q4_Resultvarchar100

Spring_OCA_Q5_Resultvarchar100

Literacy_Statuschar10

OSSLTvarchar500

IEPbit10

IEPWithnvarchar-10

Support_Servicevarchar1500

Exceptionality_1varchar1500

Achievedbit10

School_Short_Namevarchar100
vw_PVNC_French_Immersion_Report_All_ONSurnamenvarchar1000

Given_Namenvarchar1000

OENvarchar120

Genderchar10

Gradevarchar30

Birthdatedate100

School_Midentvarchar100

School_Namevarchar2550

HCSchoolchar10

Stu_Statusvarchar180

Sec_Entry_Datesmalldatetime160

Entry_Datedate100

Retirement_Datedate100

French_Immersion_Programvarchar1500

End_Datedate100

School_Short_Namevarchar100

ESLbit10

ELDbit10

French_Immersion_Minutessmallint50

Aboriginal_Programvarchar1500

Aboriginal_Minutessmallint50

Special_Ed_Statusvarchar80

Stu_Status_Codevarchar10

Next_Year_Gradevarchar30

Homeroom_Roomvarchar50

Homeroom_Designationvarchar40

Sched_Homeroom_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Contact_Lst_Lst_IDuniqueidentifier160

Exceptionalitiesnvarchar-10

Entry_Date_To_Canadadate100

Country_Of_Birthvarchar1500
vw_Homeroom_Additional_Staff_connectEd_AccountsSchool_Short_Namenvarchar-10

Homeroom_Room_Numbernvarchar-10

Homeroom_Designationnvarchar-10

Primary_Teacher_Titlenvarchar-10

Primary_Teacher_Surnamenvarchar-10

Primary_Teacher_Given_Namenvarchar-10

Primary_Teacher_Staff_Numbervarchar250

Additional_Staff_Typevarchar50

Additional_Staff_Titlenvarchar-10

Additional_Staff_Surnamenvarchar-10

Additional_Staff_Given_Namenvarchar-10

Additional_Staff_Staff_Numbervarchar250

Additional_Staff_Account_Namenvarchar-10

Additional_Staff_User_Namenvarchar-10

Additional_Staff_User_Typenvarchar-10

Additional_Staff_Member_Activevarchar150
vw_Homerooms_OccupancySchool_Short_Namevarchar100

Homeroom_Designationvarchar40

Homeroom_Numbervarchar50

Gradevarchar30

Occupancyint100

Teacher_Sur_Namenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Surnamenvarchar1000

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Total_Occupancysmallint50

School_Numbervarchar100
vw_NonStudentPaymentsSchoolNumberchar100

SchoolShortNamevarchar100

PaymentDatedate100

Payernvarchar2000

TransactionTypevarchar250

FeeTypevarchar1000

Amountdecimal102

PaymentTypevarchar500

RevenueAccountNumbervarchar500

AccountNumbervarchar500

PaymentTypeAccountNumbervarchar250

ReceiptNumbervarchar250

ReferenceNumbervarchar250

Operatornvarchar2040

Commentnvarchar-10
vw_OnlineRegistration_SubmissionStatusDateRecieveddatetime233

RequestPDFUrlnvarchar-10

FormIDnvarchar500

ResponseSetIDnvarchar500

SchoolBSIDnvarchar500

SchoolNamenvarchar2560

RequestVerificationSignaturenvarchar2560

RequestVerificationDatedatetime233

Errornvarchar-10

RequestIduniqueidentifier160
vw_PVNCCDSB_OnLineRegistrationReg_Gradenvarchar500

Reg_ExpectedEntryDatedatetime233

Scl_BSIDnvarchar500

Scl_Namenvarchar2560

Stu_LegalLastNamenvarchar2560

stu_LegalFirstNamenvarchar2560

Stu_Gendernvarchar300

Stu_OLRegSuccessbit10

IsDeletedbit10

Reg_RequestedHomeSchoolnvarchar2000
vw_PVNC_Student_ContactsStu_Enrol_IDuniqueidentifier160

Contact_Lst_IDuniqueidentifier160

Contact_Info_IDuniqueidentifier160

Person_Role_IDuniqueidentifier160

School_Short_Namevarchar100

Homeroom_Designationvarchar40

Homroom_Room_Numbervarchar50

Ministry_Numbervarchar120

Student_Numberbigint190

Student_Surnamenvarchar1000

Student_Given_Namenvarchar1000

Student_Usual_Namenvarchar1000

Gradevarchar30

Birthdatedate100

Stu_Statusvarchar180

Stu_Status_Codevarchar10

HCSchoolchar10

Contact_Numberbigint190

Contact_Typevarchar2550

Contact_Surnamenvarchar1000

Contact_Given_Namenvarchar1000

Contact_Work_Phone_Numbervarchar400

Contact_Cell_Phone_Numbervarchar400

Contact_Home_Phone_Numbervarchar400

Contact_Email_Addressvarchar2550

Contact_Addressnvarchar-10

Scl_Year_Info_IDuniqueidentifier160

Emergency_Contact_Numbersmallint50
vw_OSBIE_Incidents_ONSchool_Short_Namevarchar100

School_Namevarchar2550

Incident_Datedate100

Report_Datedate100

Student_Namevarchar600

Descriptionnvarchar10000

Sport_Descriptionvarchar1000
vw_PVNCCDSB_Deep_LearningOENvarchar120

Lastnamenvarchar1000

Firstnamenvarchar1000

School_Yearvarchar100

Classvarchar70

Markvarchar60

Termvarchar2550

Topicvarchar2550

G3_Readingreal240

G3_Writingreal240

G3_Mathreal240

G6_Readingreal240

G6_Writingreal240

G6_Mathreal240
vw_PVNCCDSB_Coop_NextYearfirst_namenvarchar1000

last_namenvarchar1000

emailvarchar1150

student_numvarchar120

Gradevarchar30

phonevarchar400

year_startedint100

birth_datedate100

genderchar10

address_street_1varchar2660

address_street_2varchar10

address_cityvarchar500

address_provincevarchar20

address_countryvarchar60

address_postvarchar250

teacher_firstnvarchar1000

preferred_namevarchar10

teacher_lastnvarchar1000

teacher_phonevarchar260

teacher_numvarchar250

board_numvarchar60

school_numvarchar100

semesetervarchar40
vw_PublicWorks_ExportStudent_Global_IDvarchar120

Student_Local_IDvarchar250

Student_First_Namenvarchar1000

Student_Middle_Namenvarchar1000

Student_Last_Namenvarchar1000

Student_DOBdate100

Student_Building_Namevarchar2550

Student_Building_IRNvarchar100

Student_Gradevarchar30

Homeroom_Teachers_First_Namenvarchar1000

Homeroom_Teachers_Last_Namenvarchar1000

Parent_First_Namenvarchar1000

Parent_Last_Namenvarchar1000

Parent_Phone_Numbervarchar400

Parent_Address_Streetvarchar2550

Parent_Address_Cityvarchar500

Parent_Address_Statevarchar500

Parent_Address_Zipvarchar250

Parent_Email_Addressvarchar2550

Student_Building_Codeint100

Student_IEPint100

Student_EDint100

Student_LEPint100

Student_Migrantint100

504int100
vw_Period_Attendance_Code_TotalsSchool_Short_Namevarchar100

Attendance_Datedate100

Periodtinyint30

Attendance_Codechar10

Attendance_Code_Titlevarchar500

Student_Countint100
vw_PVNC_OnSIS_DataCheckOENvarchar120

Surnamenvarchar1000

GivenNamenvarchar1000

Statusvarchar180

School_Namevarchar2550

School_Short_Namevarchar100

Gradechar30

Entry_Datedate100

Enrolment_Reasonvarchar1500

Retirement_Datedate100

Enrolment_Resultvarchar1500

Citizenshipvarchar1500

Resident_Typevarchar1500

Country_Of_Birthvarchar1500

First_Languagevarchar1500

Home_Schoolbit10

Base_Schoolvarchar1500

Entry_Date_To_Boarddate100

This_Sch_Entry_Datesmalldatetime160

Elem_Entry_Datesmalldatetime160

Sec_Entry_Datesmalldatetime160

Residence_Statusvarchar1500

Aboriginal_Self_IDvarchar1500

IEPbit10

IsSchedulingbit10

IsCurrentbit10

School_Yearvarchar100

FrenchProgramvarchar1500
vw_School_InformationSchool_BSIDchar100

School_Namevarchar2550

School_Codevarchar100

Address_Line_1varchar2770

Address_Line_2varchar270

Cityvarchar500

Provincevarchar500

Postal_Codevarchar80000

School_Typevarchar40

Phone_Numbervarchar260

Fax_Numbervarchar260

Email_Accountvarchar2550

Principalnvarchar2020
vw_Codes_Standardization_Base_Incl_Oth_Course_InfoCode_IDuniqueidentifier160

Code_Def_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

School_Short_Namevarchar100

Course_Codevarchar100

Course_Numbervarchar100

Course_Titlevarchar2550

Gradechar30

Credit_Valuedecimal52

Course_Typevarchar500

Delivery_Typevarchar500

Languagevarchar1500

Categoriesnvarchar-10

Dual_Credit_IDuniqueidentifier160

Special_Indicatorbit10

Modified_Curriculumbit10

Alternative_Expectationbit10

Interdisciplinary_Studiesbit10

Is_Board_Definedbit10

Effective_Datedate100

Expiration_Datedate100

GPAbit10

Other_Info_Credit_Recoverybit10

Other_Info_Ministry_Developedbit10
vw_Staff_Export_SynrevoiceSchool_Short_Namevarchar100

School_Namevarchar2550

School_Numbervarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

Staff_Rolevarchar2550

Ministry_Numbervarchar150

Employee_Numbervarchar250

Email_Addressvarchar2550

Cityvarchar500

Provincevarchar500

Statusvarchar300

Status_Codechar10

Home_Phone_Numbervarchar400

Cell_Phone_Numbervarchar400
vw_Codes_Standardization_ON_Incl_Oth_Course_InfoSchool_Short_Namevarchar100

Course_Codevarchar100

Course_Numbervarchar100

Course_Titlevarchar2550

Gradechar30

Credit_Valuedecimal52

Course_Typevarchar500

Dual_Credits_Typevarchar1500

Delivery_Typevarchar500

Languagevarchar1500

Categoriesnvarchar-10

SHSM_Categoriesnvarchar-10

SHSM_Program_Associationnvarchar-10

Special_Indicatorbit10

Modified_Curriculumbit10

Alternative_Expectationbit10

Interdisciplinary_Studiesbit10

Is_Board_Definedbit10

Effective_Datedate100

Expiration_Datedate100

GPAbit10

Other_Info_Credit_Recoverybit10

Other_Info_Ministry_Developedbit10
vw_Student_Counts_By_SchoolSchool_Short_Namevarchar100

School_Namevarchar2550

School_Numbervarchar100

This Year and Nextint100

This Year Onlyint100

Next Year Onlyint100

Deletedint100

Pastint100

Current Studentsint100

Projected Studentsint100

Differenceint100
vw_Transcript_Substitutions_ONSchool_Namevarchar2550

OENvarchar80000

Sur_Namenvarchar1000

Usual_Namenvarchar1000

Gradechar30

Date Of Completionsmalldatetime160

Course Codechar100

Credit Valuedecimal52

Substitution Flagbit10

Substition Categoriesnvarchar-10

Student_Statuschar10

School_Short_Namevarchar100
vw_PVNC_SecondaryStudentContactsOENvarchar120

School_Short_Namevarchar100

Course_Codevarchar100

Class_Sectionchar20

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Sem_Term_Patternvarchar300

Class_End_Datedate100

Is_Droppedbit10

Student_Surnamenvarchar1000

Student_Usual_Namenvarchar1000

Stu_Statusvarchar180

Contact_Typevarchar2550

Contact_Numberbigint190

Contact_Home_Phone_Numbervarchar400

Contact_Cell_Phone_Numbervarchar400

Contact_Surnamenvarchar1000

Contact_Given_Namenvarchar1000

Contact_Email_Addressvarchar2550
vw_PVNC_Student_Contacts_IEPStu_Enrol_IDuniqueidentifier160

Contact_Lst_IDuniqueidentifier160

Contact_Info_IDuniqueidentifier160

Person_Role_IDuniqueidentifier160

School_Short_Namevarchar100

Special_Edbit10

Homeroom_Designationvarchar40

Homroom_Room_Numbervarchar50

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

Homeroom_Teacher_Numbervarchar250

Ministry_Numbervarchar120

Student_Numberbigint190

Student_Surnamenvarchar1000

Student_Given_Namenvarchar1000

Student_Usual_Namenvarchar1000

Gradevarchar30

Birthdatedate100

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Contact_Numberbigint190

Contact_Typevarchar2550

Contact_Surnamenvarchar1000

Contact_Given_Namenvarchar1000

Contact_Work_Phone_Numbervarchar400

Contact_Cell_Phone_Numbervarchar400

Contact_Home_Phone_Numbervarchar400

Contact_Email_Addressvarchar2550

Contact_Addressnvarchar-10

Scl_Year_Info_IDuniqueidentifier160

Emergency_Contact_Numbervarchar400
vw_PVNC_Pathway_Ontario_not_PastSchool_Short_Namevarchar100

School Namevarchar2550

OENvarchar120

Student Last Namenvarchar1000

Student Usual Namenvarchar1000

Genderchar10

DOBdate100

Gradevarchar30

Course Start Datesmalldatetime160

Course End Datesmalldatetime160

Course Codechar100

Markvarchar100

Credit Valuedecimal52

Course Typevarchar500

Is Transcript Recordint100

Issuing_Schoolvarchar1500

SHSM Programvarchar2550

SHSM Completion Datesmalldatetime160

Stu_Status_Codevarchar10

Stu_Statusvarchar180

OYAPbit10

Is_Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

Exceptionality_1varchar1500
vw_PVNC_Student_Contacts_with_CASLStu_Enrol_IDuniqueidentifier160

Contact_Lst_IDuniqueidentifier160

Contact_Info_IDuniqueidentifier160

Person_Role_IDuniqueidentifier160

School_Short_Namevarchar100

Homeroom_Designationvarchar40

Homroom_Room_Numbervarchar50

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

Homeroom_Teacher_Numbervarchar250

Ministry_Numbervarchar120

Student_Numberbigint190

Student_Surnamenvarchar1000

Student_Given_Namenvarchar1000

Student_Usual_Namenvarchar1000

Gradevarchar30

Birthdatedate100

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Contact_Numberbigint190

Contact_Typevarchar2550

Contact_Surnamenvarchar1000

Contact_Given_Namenvarchar1000

Contact_Work_Phone_Numbervarchar400

Contact_Cell_Phone_Numbervarchar400

Contact_Home_Phone_Numbervarchar400

Contact_Email_Addressvarchar2550

Contact_Addressnvarchar-10

Scl_Year_Info_IDuniqueidentifier160

Emergency_Contact_Numbersmallint50

Title_Engnvarchar2000

ConsentReceivedDatedate100
vw_Archive_Attendance_Equivalent_Full_Day_TotalsPerson_IDuniqueidentifier160

Gradevarchar20

School_IDuniqueidentifier160

School_Yearvarchar100

Absentnumeric381

Lateint100

Suspendedint100

School_Short_Namevarchar100

School_Namevarchar2550

Surnamenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Genderchar10

Ministry_Num_Fmtvarchar120

Stu_Numbervarchar250

Stu_Status_Codevarchar10

Stu_Statusvarchar180
vw_PVNCCDSB_Stu_Custom_FieldsSchool_Short_Namevarchar100

HCSchoolchar10

Ministry_Num_Fmtvarchar120

Sur_Namenvarchar1000

Given_Namenvarchar1000

Genderchar10

Gradevarchar30

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Field_Typevarchar500

Field_Namevarchar500

Field_Valuevarchar1000

Board_Definedbit10

Stu_Enrol_IDuniqueidentifier160

Homeroom_Teacher_Numbervarchar250

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

Homeroom_Alt_Teacher_Numbervarchar250

Homeroom_Alt_Teacher_Surnamenvarchar1000

Homeroom_Alt_Teacher_Given_Namenvarchar1000

Origin_Schoolvarchar1500

Destination_Schoolvarchar1500

Stu_Numbervarchar250

Person_IDuniqueidentifier160
vw_Archive_HalfDay_Attendance_Student_TotalsSchool_Namevarchar2550

School_Short_Namevarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Gradevarchar20

Homeroom_Designationvarchar100

Homeroom_Roomvarchar50

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

School_Yearvarchar100

Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Support_Servicevarchar1500

Special_Ed_Resourcesvarchar1500

A_Totalint100

B_Totalint100

C_Totalint100

D_Totalint100

E_Totalint100

F_Totalint100

G_Totalint100

H_Totalint100

I_Totalint100

J_Totalint100

K_Totalint100

L_Totalint100

M_Totalint100

N_Totalint100

O_Totalint100

Q_Totalint100

R_Totalint100

S_Totalint100

T_Totalint100

U_Totalint100

V_Totalint100

W_Totalint100

X_Totalint100

Y_Totalint100

Z_Totalint100

Not_Enrolled_Totalint100

Ministry_Numvarchar120
vw_PVNCCDSB_Bus_Needs_Med_ConditionsMinistry_Num_Fmtvarchar120

Stu_Numbervarchar250

Sur_Namenvarchar1000

Given_Namenvarchar1000

Genderchar10

Gradevarchar30

Stu_Statusvarchar180

School_Short_Namevarchar100

Field_Valuevarchar1000

HCSchoolchar10
vw_Archive_Period_Attendance_Student_TotalsSchool_Namevarchar2550

School_Short_Namevarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Gradevarchar20

Homeroom_Designationvarchar100

Homeroom_Roomvarchar50

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

School_Yearvarchar100

Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Support_Servicevarchar1500

Special_Ed_Resourcesvarchar1500

A_Totalint100

B_Totalint100

C_Totalint100

D_Totalint100

E_Totalint100

F_Totalint100

G_Totalint100

H_Totalint100

I_Totalint100

J_Totalint100

K_Totalint100

L_Totalint100

M_Totalint100

N_Totalint100

O_Totalint100

Q_Totalint100

R_Totalint100

S_Totalint100

T_Totalint100

U_Totalint100

V_Totalint100

W_Totalint100

X_Totalint100

Y_Totalint100

Z_Totalint100

Cancelled_Totalint100

Not_Enrolled_Totalint100

Ministry_Numvarchar120
vw_base_transportation_exportSchool_Short_Namevarchar100

school_Namevarchar2550

School numbervarchar100

Ministry numbervarchar120

Student numbervarchar250

First namenvarchar1000

Middle_Namenvarchar1000

Last namenvarchar1000

Genderchar10

Birthdaydate10