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

Birthdaydate100

Statuschar10

stu_statusvarchar180

Gradevarchar30

Student Cohortvarchar1500

CriticalWorkerTiervarchar500

Homeroomvarchar120

Apartmentvarchar100

Street numbervarchar100

Street namevarchar2550

Cityvarchar500

Postal Codevarchar250

PO Boxvarchar170

provincevarchar500

Countryvarchar500

Townshipvarchar500

Student Emergency Codevarchar1000

RR_Numbervarchar50

Address_Groupvarchar200

Legal_Land_Descriptionvarchar1210

Additional Informationnvarchar-10

Mailing_Address_line_1nvarchar5120

Mailing_Address_line_2varchar500

Mailing_Address_line_3varchar500

Student phone numbervarchar400

Student Special Custody Notenvarchar-10

Future Apartmentvarchar100

Future Street numbervarchar100

Future Street namevarchar2550

Future Cityvarchar500

Future Postal Codevarchar250

Future PO Boxvarchar170

Future Provincevarchar500

Future Countryvarchar500

Future Address Effective Datedate100

Contact Order 1 namenvarchar2020

Contact Order 1 Typevarchar2550

Contact order 1 Legal Guardianbit10

Contact order 1 Custodianbit10

Contact 1 Custody Notenvarchar-10

Contact order 1 emergency contacttinyint30

Contact Order 1 home phonevarchar400

Contact Order 1 cell phonevarchar400

Contact Order 1 employervarchar2550

Contact Order 1 employer phonevarchar400

Contact Order 1 Emailvarchar2550

Contact Order 1 Apartmentvarchar100

Contact Order 1 Street numbervarchar100

Contact Order 1 Street namevarchar2550

Contact Order 1 Cityvarchar500

Contact Order 1 Postal Codevarchar250

Contact Order 1 PO Boxvarchar170

Contact Order 1 provincevarchar500

Contact Order 1 Countryvarchar500

Contact Order 1 Emergency Codevarchar1000

Contact Order 2 namenvarchar2020

Contact Order 2 Typevarchar2550

Contact order 2 Legal Guardianbit10

Contact order 2 Custodianbit10

Contact 2 Custody Notenvarchar-10

Contact order 2 emergency contacttinyint30

Contact Order 2 home phonevarchar400

Contact Order 2 cell phonevarchar400

Contact Order 2 employervarchar2550

Contact Order 2 employer phonevarchar400

Contact Order 2 Emailvarchar2550

Contact Order 2 Apartmentvarchar100

Contact Order 2 Street numbervarchar100

Contact Order 2 Street namevarchar2550

Contact Order 2 Cityvarchar500

Contact Order 2 Postal Codevarchar250

Contact Order 2 PO Boxvarchar170

Contact Order 2 provincevarchar500

Contact Order 2 Countryvarchar500

Contact Order 2 Emergency Codevarchar1000

Special Custodybit10

Lives Withvarchar1630

Sitter's Namenvarchar2020

Sitter home phonevarchar400

Sitter cell phonevarchar400

Sitter employervarchar2550

Sitter employer phonevarchar400

Sitter Emailvarchar2550

Father_Surnamenvarchar1000

Father_Given_Namenvarchar1000

Father_Cell_Phone_Numbervarchar400

Mother_Surnamenvarchar1000

Mother_Given_Namenvarchar1000

Mother_Cell_Phone_Numbervarchar400

Emergency_Contact_Surnamenvarchar1000

Emergency_Contact_Given_Namenvarchar1000

Emergency_Contact_Home_Phone_Numbervarchar400

Emergency_Contact_Emailvarchar2550

Sitter Apartmentvarchar100

Sitter Street numbervarchar100

Sitter Street namevarchar2550

Sitter Cityvarchar500

Sitter Postal Codevarchar250

Sitter PO Boxvarchar170

Sitter provincevarchar500

Sitter Countryvarchar500

Sitter Emergency Codevarchar1000

Current Pick Up Apartmentvarchar100

Current Pick Up Street numbervarchar100

Current Pick Up Street namevarchar2550

Current Pick Up Cityvarchar500

Current Pick Up Postal Codevarchar250

Current Pick Up PO Boxvarchar170

Current Pick Up provincevarchar500

Current Pick Up Countryvarchar500

Current Drop Off Apartmentvarchar100

Current Drop Off Street numbervarchar100

Current Drop Off Street namevarchar2550

Current Drop Off Cityvarchar500

Current Drop Off Postal Codevarchar250

Current Drop Off PO Boxvarchar170

Current Drop Off provincevarchar500

Current Drop Off Countryvarchar500

Entry datedate100

Retirement/transfer datedate100

Medical notesnvarchar-10

Special Ed Codechar100

Program Codevarchar1500

Grant Type 1char100

Grant Type 2char100

Grant Type 3char100

Enrollment Type 1char100

Enrollment Type 2char100

Enrollment Type 3char100

French Programvarchar1500

Main school (holder of OSR)varchar1500

Student board residence statusvarchar1500

Transportation Special Custodyvarchar30

Next Year Gradevarchar30

Next Year School Numbervarchar100

Student Emailvarchar2550

Transportation_Reasonvarchar100
vw_Classes_Ontario_BaseSchool_Namevarchar2550

School_Numberchar100

Class_Codevarchar100

Section_Letterchar20

Departmentvarchar1500

Semester_Term_Patternvarchar300

Period_Patternvarchar300

Course_Typevarchar500

Dual_Credit_Course_Typevarchar1500

Deliveryvarchar500

Credit_Valuenumeric52

Languagevarchar1500

Reportablebit10

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Occupancyint100

School_Short_Namevarchar100

Course_Titlevarchar2550

Dual_Credit_Course_Assocvarchar1720

Class_Roomnvarchar-10

Schedulingbit10

Class_Start_Datedate100

Class_End_Datedate100

Minutes_Per_Daysmallint50

Continuous_Entrybit10

Num_Lessons_Work_Unitssmallint50

Num_Sessionstinyint30

Course_Gradevarchar30

Is_Reportablebit10

Attendance_Last_Taken_Datedate100

Course_Offering_Typevarchar1500

OnSisCodevarchar160
vw_Codes_StandardizationSchool_Short_Namevarchar100

Course_Codevarchar100

Course_Numbervarchar100

Course_Titlevarchar2550

Gradechar30

Credit_Valuedecimal52

Course_Typevarchar500

Delivery_Typevarchar500

Languagevarchar1500

Categoriesnvarchar-10

Is_Board_Definedbit10

Effective_Datedate100

Expiration_Datedate100

GPAbit10
vw_Codes_Standardization_ONSchool_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
vw_Con_Ed_Student_ONSchool_Short_Namevarchar100

OENvarchar120

Stu_Statusvarchar180

Surnamenvarchar1000

Usual_Namenvarchar1000

Con_Ed_Student_Typevarchar1500

Home_School_Short_Namevarchar100

Home_School_Attendance_Typevarchar500

Home_School_SAL_Attendance_Typevarchar500
vw_Current_Student_StatusSchool_Namevarchar2550

OENvarchar120

Sur_Namenvarchar1000

Given_Namenvarchar1000

Genderchar10

Gradevarchar30

Stu_Statusvarchar180

HCSchoolchar10

Grade_Next_Yearchar30

School_Short_Namevarchar100

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

School_Cityvarchar500

Homeroom_Designationvarchar40

Homeroom_Numbervarchar50

Homeroom_Designation_Next_Yearvarchar40

Homeroom_Number_Next_Yearvarchar50

Stu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

Person_IDuniqueidentifier160

Entry_Datedate100

Retirement_Datedate100

Stu_Numbervarchar250

Stu_Number_Valuebigint190

Usual_Namenvarchar1000

Birthdatedate100

Internal_School_IDint100

Homeroom_Teacher_Numbervarchar250

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

Homeroom_Alt_Teacher_Numbervarchar250

Homeroom_Alt_Teacher_Surnamenvarchar1000

Homeroom_Alt_Teacher_Given_Namenvarchar1000

Homeroom_Teacher_Number_Next_Yearvarchar250

Homeroom_Teacher_Surname_Next_Yearnvarchar1000

Homeroom_Teacher_Given_Name_Next_Yearnvarchar1000

First_Languagevarchar1500

Entered_Into_Maplewood_Datedate100

connectEd_User_Namevarchar1000

Citizenshipvarchar1500
vw_EQAO_Accommodations_ONSchool_Short_Namevarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

OENvarchar120

Student_Numberbigint190

Gradevarchar30

Exceptionalitiesnvarchar-10

Accomodationsnvarchar-10
vw_FNMI_Students_ABSchool_Namevarchar2550

School_Short_Namevarchar100

ASNvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Gradevarchar30

Homeroom_Roomchar50

Homeroom_Designationvarchar40

PASI_FNMI_Declarationvarchar1500

Enrolment_Type_Codechar100

Aboriginal_Statusvarchar1500

ESL_Codechar100

Exceptionality_1varchar1500

Genderchar10

Birthdatedate100

HCSchoolchar10

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Band_Of_Residencevarchar1500

Reserve_Of_Residencevarchar1500

Treaty_Numvarchar120
vw_ONSIS_validation_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

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_French_Immersion_Report_All_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

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_ONSIS_validation_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

Question3_Factor1varchar1500

Question3_Factor2varchar1500

Question3_Factor3varchar1500

Question4bit10

Question7_Factor1varchar1500

Question7_Factor2varchar1500

Question7_Factor3varchar1500
vw_Graduation_Diploma_Verification_ONSchool_Short_Namevarchar100

OENvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Legal_Surnamenvarchar1000

Usual_Namenvarchar1000

Middle_Namenvarchar1000

Birthdatedate100

Genderchar10

StartGrade9InOntariobit10

CohortYearvarchar100

Gradevarchar30

RetirementDatedate100

FirstDiplomaOrCertificatevarchar2550

FirstDiplomaOrCerticateDatedate100

SecondDiplomaOrCertificatevarchar2550

SecondDiplomaOrCertificateDatedate100

Total_Compulsorydecimal382

Total_Optionaldecimal382

Total_Creditsdecimal382

Area_Of_Requirementvarchar2550

Main_Schoolvarchar1500

Board_Resident_Statusvarchar1500

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Entry_Datedate100

Entry_To_Secondary_Datedate100

Retirement_Datedate100

Community_Hours_Completedbit10

Community_Hoursdecimal62

Literacy_Completebit10

Literacy_Statusvarchar140

OYAPbit10

Ontario_Scholarbit10

SHSMvarchar2550

Pathwayvarchar1000

OEN_Fmtvarchar120

Aboriginal_Self_IDvarchar1500

Is_Special_Edbit10

Spec_Ed_Statusvarchar80

Placementvarchar1500

Compulsory_Credits_Remainingdecimal382

SHSM_Compulsory_Credits_Remainingdecimal382
vw_Student_CohortSchool_Short_Namevarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

Ministry_Num_Fmtvarchar120

Gradevarchar30

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

Birthdatedate100

Genderchar10

Stu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

Person_IDuniqueidentifier160

Entry_Datedate100

Retirement_Datedate100

Cohort__Codechar100

Cohort_Name_ENGvarchar1500

Cohort_Name_FREvarchar1500
vw_Residency_Status_ONSchool_Short_Namevarchar100

School_Numbervarchar100

OENvarchar120

Board_Resident_Statusvarchar1500

Stu_Statusvarchar180

Origin_Typevarchar1500

Origin_Schoolvarchar1500

Gradevarchar30

Surnamenvarchar1000

Given_Namenvarchar1000

Genderchar10

Citizenshipvarchar1500

Entry_Date_To_Canadadate100

Aboriginal_Self_IDvarchar1500

HCSchoolchar10

Country_Of_Birthvarchar1500

First_Languagevarchar1500
vw_Sample_Transportation_Exportschool namevarchar2550

School numbervarchar100

Ministry numbervarchar120

Student numbervarchar250

First namenvarchar1000

Last namenvarchar1000

Genderchar10

Birthdaydate100

Statuschar10

Gradevarchar30

Homeroomvarchar120

Apartmentvarchar100

Street numbervarchar100

Street namevarchar2550

Cityvarchar500

Postal Codevarchar250

PO Boxvarchar170

Provincevarchar500

Townshipvarchar500

Legal_Land_Descriptionvarchar1210

Student phone numbervarchar400

Mailing address line 1nvarchar5120

Mailing address line 2varchar500

Mailing address line 3varchar500

Mother's namenvarchar2020

Mother home phonevarchar400

Mother cell phonevarchar400

Mother employervarchar2550

Mother employer phonevarchar400

Father namenvarchar2020

Father home phonevarchar400

Father cell phonevarchar400

Father employervarchar2550

Father employer phonevarchar400

Special Custodybit10

Custodianvarchar1630

Lives Withvarchar1630

Legal Guardianvarchar1630

Emergency Contactnvarchar2020

Emergency Contact Namevarchar400

Sitter Namenvarchar2020

Sitter Phonevarchar400

PU Apt Numvarchar100

PU House Numvarchar100

PU Streetvarchar2550

PU Cityvarchar500

PU Townshipvarchar500

PU Postalvarchar250

DO Apt Numvarchar100

DO House Numvarchar100

DO Streetvarchar2550

DO Cityvarchar500

DO Townshipvarchar500

DO Postalvarchar250

Entry datedate100

Retirement/transfer datedate100

Medical notesnvarchar-10

Special Ed Codechar100

Emergency Codevarchar10

Grant Type 1char100

Grant Type 2char100

Grant Type 3char100

Enrollment Type 1char100

Enrollment Type 2char100

Enrollment Type 3char100
vw_SAL_Students_ONSchool_Short_Namevarchar100

OENvarchar120

Stu_Statusvarchar180

Sur_Namenvarchar1000

Usual_Namenvarchar1000

Birthdatedate100

Current_Ageint100

Gradevarchar30

FTEdecimal32

SAL_Attendance_Typevarchar1500

SAL_Statusvarchar1500

SAL_Start_Datedate100

SAL_End_Datedate100

SAL_Exit_Typevarchar1500

Component_1_Titlevarchar1500

Component_1_Start_Datedate100

Component_1_End_Datedate100

Component_2_Titlevarchar1500

Component_2_Start_Datedate100

Component_2_End_Datedate100

Component_3_Titlevarchar1500

Component_3_Start_Datedate100

Component_3_End_Datedate100

Stu_Enrol_IDuniqueidentifier160
vw_AB_Transportation_ExportSchool_Short_Namevarchar100

school_Namevarchar2550

School numbervarchar100

Ministry numbervarchar120

Student numbervarchar250

First namenvarchar1000

Last namenvarchar1000

Genderchar10

Birthdaydate100

Statuschar10

Gradevarchar30

Homeroomvarchar120

Apartmentvarchar100

Street numbervarchar100

Street namevarchar2550

Cityvarchar500

Postal Codevarchar250

PO Boxvarchar170

provincevarchar500

Townshipvarchar500

Legal_Land_Descriptionvarchar1210

Student phone numbervarchar400

Mailing address line 1nvarchar5120

Mailing address line 2varchar500

Mailing address line 3varchar500

Mother's namenvarchar2020

Mother home phonevarchar400

Mother cell phonevarchar400

Mother employervarchar2550

Mother employer phonevarchar400

Father namenvarchar2020

Father home phonevarchar400

Father cell phonevarchar400

Father employervarchar2550

Father employer phonevarchar400

Special Custodybit10

Custodianvarchar1630

Lives Withvarchar1630

Legal Guardianvarchar1630

Emergency Contactnvarchar2020

Emergency Contact Namevarchar400

Sitter Namenvarchar2020

Sitter Phonevarchar400

PU Apt Numvarchar100

PU House Numvarchar100

PU Streetvarchar2550

PU Cityvarchar500

PU Townshipvarchar500

PU Postalvarchar250

DO Apt Numvarchar100

DO House Numvarchar100

DO Streetvarchar2550

DO Cityvarchar500

DO Townshipvarchar500

DO Postalvarchar250

Entry datedate100

Retirement/transfer datedate100

Medical notesnvarchar-10

Special Ed Codechar100

Emergency Codevarchar10

Grant Type 1char100

Grant Type 2char100

Grant Type 3char100

Enrollment Type 1char100

Enrollment Type 2char100

Enrollment Type 3char100
vw_School_Board_Wide_AssessmentSurnamenvarchar1000

Usual Namenvarchar1000

Testvarchar500

Subjectvarchar500

Strandvarchar500

Timeframevarchar500

Gradevarchar30

School Namevarchar2550

OENvarchar120

Test_Def_IDuniqueidentifier160

Markvarchar100

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Closed_Schoolint100

Homeroon_Roomchar50

Homeroom_Designationvarchar40

Birthdatedate100

School_Short_Namevarchar100

Genderchar10

Person_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

Homeroom_Teacher_Numbervarchar250

Homeroom_Alt_Teacher_Surnamenvarchar1000

Homeroom_Alt_Teacher_Given_Namenvarchar1000

Homeroom_Alt_Teacher_Numbervarchar250

Next_Year_Homeroon_Roomchar50

Next_Year_Homeroom_Designationvarchar40

Next_Year_Homeroom_Teacher_Surnamenvarchar1000

Next_Year_Homeroom_Teacher_Given_Namenvarchar1000

Next_Year_Homeroom_Teacher_Numbervarchar250

Aboriginal_Status_Codevarchar1500

Origin_Typevarchar1500

Origin_Schoolvarchar1500
vw_School_Board_Wide_Assessment_MBSurnamenvarchar1000

Usual Namenvarchar1000

Testvarchar500

Subjectvarchar500

Strandvarchar500

Timeframevarchar500

Gradevarchar30

School Namevarchar2550

METvarchar120

Test_Def_IDuniqueidentifier160

Markvarchar100

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Closed_Schoolint100

Homeroon_Roomchar50

Homeroom_Designationvarchar40

Birthdatedate100

School_Short_Namevarchar100

Genderchar10

Aboriginal_Status_Codevarchar1500

EALbit10

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

Homeroom_Teacher_Numbervarchar250

Homeroom_Alt_Teacher_Surnamenvarchar1000

Homeroom_Alt_Teacher_Given_Namenvarchar1000

Homeroom_Alt_Teacher_Numbervarchar250

Next_Year_Homeroon_Roomchar50

Next_Year_Homeroom_Designationvarchar40

Next_Year_Homeroom_Teacher_Surnamenvarchar1000

Next_Year_Homeroom_Teacher_Given_Namenvarchar1000

Next_Year_Homeroom_Teacher_Numbervarchar250

Aboriginal_Identity_1varchar1500
vw_Secondary_Class_Attendance_ONClass_IDuniqueidentifier160

School_IDuniqueidentifier160

Person_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

School_Short_Namevarchar100

OENvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

FNMIvarchar1500

Spec_Ed_Statusvarchar80

Exceptionality_1varchar1500

Sem_Numbertinyint30

Term_Numbertinyint30

Classvarchar130

TT_Rankbigint190

Times_Absentint100

Stu_Status_Codevarchar10

Stu_Statusvarchar180

Times_Lateint100

Usual_Namenvarchar1000

Student_Gradevarchar30

Genderchar10

Main_Schoolvarchar1500

Times_Att_Code_Sint100
vw_Secondary_Learning_Skills_Achievement_ONSchool_Yearvarchar100

School_Short_Namevarchar100

OENvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Gradevarchar30

Genderchar10

Course_Codevarchar100

School_Completed_Invarchar100

Termvarchar500

Final_Markvarchar60

Spoken_French_Markvarchar60

Responsibility_Markvarchar60

Organization_Markvarchar60

Independent_Work_Markvarchar60

Collaboration_Markvarchar60

Initiative_Markvarchar60

Self_Regulation_Markvarchar60
vw_Security_Audit_Reports_AccountsAccount namenvarchar2000

Authentication typenvarchar1000

Primary groupnvarchar2000

Additional Groups (can be multiple)nvarchar2000

People (can be multiple)nvarchar3400

School (can be multiple)nvarchar-10

SiteFunctionNameEnglishnvarchar1000

Target sitesnvarchar5100

Permission typesnvarchar1000

Site typenvarchar1000

Target sitenvarchar5100

Target groupsnvarchar5100

Password never expiresbit10

Cannot change passwordbit10

Must change passwordbit10

Account locked outbit10

Account activebit10

Auto activation date (yes/ no)varchar30

Auto activation date (Date)date100

Account never expiresint100

Account expiry datedate100

Permissions assigned to user but not the groupbit10
vw_Secondary_Timetable_Add_DropsSchool_Short_Namevarchar100

School_Namevarchar2550

Ministry_Numvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Gradevarchar30

Course_Codevarchar100

Class_Sectionvarchar20

Add_Drop_Datedate100

AddOrDropvarchar80

AddDropPerformedBy_Surnamenvarchar1000

AddDropPerformedBy_Given_Namenvarchar1000

Class_IDuniqueidentifier160

Stu_Numbervarchar250

Stu_Number_Valuebigint190

Last_Modifieddatetime2190
vw_Security_Audit_Reports_GroupGroup namenvarchar2000

Default Authentication typenvarchar1000

Site typenvarchar1000

Default target sitenvarchar5100

SiteFunctionName, Data accessnvarchar1000

List permissions, Data accessbit10

SiteFunctionName, Account managementnvarchar1000

List permissions, Account managementbit10

Password never expiresbit10

Cannot change passwordbit10

Must change passwordbit10

Account locked outbit10

Account activebit10

Auto activation date (yes/ no)varchar30

Auto activation date (Date)date100

Account never expiresint100

Account expiry datedate100
vw_Special_Ed_Stu_ExceptionalitiesPerson_IDuniqueidentifier160

Sur_Namenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Birthdatedate100

Genderchar10

Person_Numbervarchar250

HCSchoolchar10

School_Namevarchar2550

School_Numbervarchar100

Exceptionality1varchar1500

Exceptionality2varchar1500

Exceptionality3varchar1500

OENvarchar120

Gradevarchar30

MWStatusvarchar180

ExceptionalityCode1char100

ExceptionalityCode2char100

ExceptionalityCode3char100

Special_Ed_Programvarchar1500

Support_Servicevarchar1500

Placementvarchar1500

Placement_Datedate100

Surnamenvarchar1000

School_Short_Namevarchar100

Is_Spec_Ed_Activebit10

Special_Ed_Resourcesvarchar1500

Special_Edbit10

Placement_End_Datedate100

Homeroom_Designationvarchar40

Homeroom_Roomvarchar50

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30
vw_Security_Audit_Reports_GroupWithAccountsAccount namenvarchar2000

Authentication typenvarchar1000

Primary groupnvarchar2000

Additional Groups (can be multiple)nvarchar2000

PersonIduniqueidentifier160

People (can be multiple)nvarchar3400

School (can be multiple)nvarchar-10

Target sitesnvarchar5100

Permission typesnvarchar1000

Site typenvarchar1000

Target sitenvarchar5100

Target groupsnvarchar5100

Password never expiresbit10

Cannot change passwordbit10

Must change passwordbit10

Account locked outbit10

Account activebit10

Auto activation date (yes/ no)varchar30

Auto activation date (Date)date100

Account never expiresint100

Account expiry datedate100
vw_Staff_TimetableStaff_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

Person_IDuniqueidentifier160

School_Short_Namevarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

Ministry_Numbervarchar150

Staff_Numbervarchar250

RegistrationNumbervarchar150

Rolevarchar2550

Status_Codevarchar10

Statusvarchar180

Birthdatedate100

Genderchar10

This_School_Datedate100

Transfer_Datedate100

Homeroom_Designationvarchar40

Homeroom_Roomvarchar50

Is_Homeroom_Alternate_Teacherint100

Is_Homeroom_Other_Staffint100

Course_Codevarchar100

Class_Sectionchar20

Course_Numbervarchar100

Course_Gradevarchar30

Course_Titlevarchar2550

Is_Alternate_Teacherint100

Is_Other_Staffint100

Class_Start_Datedate100

Class_End_Datedate100

Is_Next_Yearbit10

Is_CTS_Modulebit10

Is_Continuous_Entrybit10

Is_Flex_Classbit10

Course_Typevarchar500

Delivery_Typevarchar500
vw_Stu_Custom_FieldsSchool_Short_Namevarchar100

HCSchoolchar10

Ministry_Num_Fmtvarchar120

Sur_Namenvarchar1000

Given_Namenvarchar1000

Genderchar10

Gradevarchar30

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Field_Typenvarchar-10

Field_Namenvarchar-10

Field_Valuenvarchar-10

Board_Definedbit10

Stu_Enrol_IDuniqueidentifier160

Person_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
vw_Compulsory_Credit_AchievedSchool_Numbervarchar100

School_Codevarchar100

Person_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Student_OENvarchar120

DateOfCompletionsmalldatetime160

Termvarchar10

Codechar100

Requirement_Area_Codevarchar20

Attempted_Credit_Valuedecimal52

Compulsory_Earned_Credit_Valuedecimal52
vw_Student_ChoicesSchool_Short_Namevarchar100

Ministry_Num_Fmtvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Stu_Status_Codevarchar10

Stu_Statusvarchar180

Defined_Character_1varchar30

Defined_Character_2varchar30

Defined_Character_3varchar30

Defined_Character_4varchar30

This_Year_Gradevarchar30

Next_Year_Gradechar30

Course_Codevarchar100

Course_Titlevarchar2550

Choice_Typevarchar500

Choice_Requiredbit10

Sort_Ordersmallint50

Assigned_To_Classbit10

Credit_Valuedecimal52

Total_Credit_Earneddecimal382
vw_Transportation_Program_ADSBStudentNumbervarchar250

Surnamenvarchar1000

GivenNamenvarchar1000

LegalSortNamenvarchar3400

HouseNumbervarchar100

Streetvarchar2550

Cityvarchar500

PostalCodevarchar250

Provincevarchar500

BirthDatedate100

SchoolShortNamevarchar100

Gradechar30

Programvarchar40

TPUPHouseNumbervarchar100

TPUPStreetvarchar2550

TPUPCityvarchar500

TPUPPostalCodevarchar250

TPUPProvincevarchar500

TDOFFHouseNumbervarchar100

TDOFFStreetvarchar2550

TDOFFCityvarchar500

TDOFFPostalCodevarchar250

TDOFFProvincevarchar500

Contact1Namenvarchar3400

Contact1Phonevarchar400

Contact2Namenvarchar3400

Contact2Phonevarchar400
vw_Student_Contacts_AllStu_Enrol_IDuniqueidentifier160

person_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_Numbertinyint30
vw_Transportation_Program_ADSB_NextYearStudentNumbervarchar250

Surnamenvarchar1000

GivenNamenvarchar1000

HouseNumbervarchar100

Streetvarchar2550

Cityvarchar500

PostalCodevarchar250

Provincevarchar500

BirthDatedate100

SchoolShortNamevarchar100

SchedulingGradechar30

Programvarchar40

TPUPHouseNumbervarchar100

TPUPStreetvarchar2550

TPUPCityvarchar500

TDOFFHouseNumbervarchar100

TDOFFStreetvarchar2550

TDOFFCityvarchar500

Contact1Namenvarchar3400

Contact1Phonevarchar400

Contact2Namenvarchar3400

Contact2Phonevarchar400

MinistryNumbernvarchar-10
vw_PVNC_Contacts_CustodySchool_Short_Namevarchar100

Ministry_Numbervarchar120

Student_Numberbigint190

Student_Surnamenvarchar1000

Student_Usual_Namenvarchar1000

Gradevarchar30

Stu_Statusvarchar180

Contact_Numberbigint190

Contact_Typevarchar2550

Contact_Surnamenvarchar1000

Contact_Given_Namenvarchar1000

Contact_Email_Addressvarchar2550

Scl_Year_Info_IDuniqueidentifier160

Emergency_Contact_Numbersmallint50

Special_Custodybit10

LivesWithuniqueidentifier160

Lives_Withvarchar1500
vw_Student_HomeroomsSchool_Short_Namevarchar100

Min_Numvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Gradevarchar30

Stu_Status_Codevarchar10

HCSchoolchar10

Schedulingbit10

Homeroom_Room_Numbervarchar50

Homeroom_Designationvarchar40

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Genderchar10

Stu_Lettersvarchar30
vw_RCCDSB_Transportation_ExportOEN_Numbervarchar120

Student_Surnamenvarchar1000

Student_Given_Namenvarchar1000

School_Short_Namevarchar100

Entry_Datedate100

Retirement_Datedate100

Is_Activebit10

Is_PreRegbit10

Gradevarchar30

Genderchar10

Birthdatedate100

Homeroom_Numbervarchar50

French_Language_Programvarchar1500

Student_Home_Phone_Numbervarchar400

Student_House_Numbervarchar100

Student_Street_Namevarchar2550

Student_Cityvarchar500

Student_Postal_Codevarchar250

Student_Provincevarchar500

Student_Apartment_Numbervarchar100

Student_PO_Boxvarchar100

Lives_Withvarchar1500

Father_Surnamenvarchar1000

Father_Given_Namenvarchar1000

Father_Home_Phonevarchar400

Father_Employer_Phonevarchar400

Father_Cell_Phonevarchar400

Father_Email_Addressvarchar2550

Father_House_Numbervarchar100

Father_Street_Namevarchar2550

Father_Cityvarchar500

Father_Postal_Codevarchar250

Father_Provincevarchar500

Father_Apartment_Numbervarchar100

Father_PO_Boxvarchar100

Mother_Surnamenvarchar1000

Mother_Given_Namenvarchar1000

Mother_Home_Phonevarchar400

Mother_Employer_Phonevarchar400

Mother_Cell_Phonevarchar400

Mother_Email_Addressvarchar2550

Mother_House_Numbervarchar100

Mother_Street_Namevarchar2550

Mother_Cityvarchar500

Mother_Postal_Codevarchar250

Mother_Provincevarchar500

Mother_Apartment_Numbervarchar100

Mother_PO_Boxvarchar100

Guardian_Surnamenvarchar1000

Guardian_Given_Namenvarchar1000

Guardian_Home_Phonevarchar400

Guardian_Employer_Phonevarchar400

Guardian_Cell_Phonevarchar400

Guardian_Email_Addressvarchar2550

Pickup_Contact_Typevarchar2550

Pickup_House_Numbervarchar100

Pickup_Street_Namevarchar2550

Pickup_Cityvarchar500

Pickup_Postal_Codevarchar250

Pickup_Provincevarchar500

Pickup_Apartment_Numbervarchar100

Dropoff_Contact_Typevarchar2550

Dropoff_House_Numbervarchar100

Dropoff_Street_Namevarchar2550

Dropoff_Cityvarchar500

Dropoff_Postal_Codevarchar250

Dropoff_Provincevarchar500

Dropoff_Apartment_Numbervarchar100

Sitter_Surnamenvarchar1000

Sitter_Given_Namenvarchar1000

Sitter_Home_Phonevarchar400

Sitter_Employer_Phonevarchar400

Sitter_Cell_Phonevarchar400

Sitter_Email_Addressvarchar2550
vw_Student_IncidentsSchool_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
vw_Edsembli_Student_CountSchool_Short_Namenvarchar2560

StudentCountint100
vw_Student_Internal_TransfersSchool_Short_Namevarchar100

Ministry_Numbervarchar120

Stu_Numbervarchar250

Surnamenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Stu_Statusvarchar180

Stu_Status_Codevarchar10

HCSchoolchar10

Gradevarchar30

Entry_Datedate100

Retirement_Datedate100

Transfer_Type_Codechar10

Transfer_Type_Titlevarchar500

Transfer_SubTypevarchar220

Start_Datedate100

End_Datedate100

Original_Valuevarchar2550

New_Valuevarchar2550
vw_Student_TimetableSchool_Short_Namevarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

Ministry_Num_Fmtvarchar120

Stu_Number_Valuebigint190

Gradevarchar30

Course_Codevarchar100

Class_Sectionchar20

Course_Numbervarchar100

Course_Gradevarchar30

Course_Titlevarchar2550

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alt_Teacher_Surnamenvarchar1000

Alt_Teacher_Given_Namenvarchar1000

Alt_Teacher_Numbervarchar250

Class_Start_Datedate100

Class_End_Datedate100

Is_Droppedbit10

Is_Next_Yearbit10

Is_CTS_Modulebit10

Is_Continuous_Entrybit10

Is_Flex_Classbit10

Continuous_Entry_Start_Datedate100

Continuous_Entry_Completion_Datedate100

Course_Typevarchar500

Delivery_Typevarchar500

Attendance_Typevarchar500

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

Birthdatedate100

Genderchar10

Stu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

Person_IDuniqueidentifier160

Entry_Datedate100

Retirement_Datedate100

Sem_Term_Patternvarchar300

Day_Per_Patternvarchar300

Drop_Datedate100

Credit_Attempteddecimal52
vw_Base_Clever_Schools_UpdatedSchool_idvarchar100

School_namevarchar2550

School_numbervarchar100

State_idvarchar100

Low_Gradechar30

High_Gradechar30

Principalnvarchar2640
vw_Student_Timetable_ConflictsSchool_Short_Namevarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

Stu_Status_Codevarchar10

Schedulingbit10

Class_Codevarchar100

Section_Letterchar20

Course_Titlevarchar2550

Sem_Numbertinyint30

Term_Numbertinyint30

Day_Numbertinyint30

Per_Numbertinyint30
vw_Base_Clever_Enrolments_UpdatedSchool_idvarchar100

Section_idvarchar120

Student_idbigint190
vw_Student_Transportation_List_ONOEN_Numbervarchar120

Student_Numbervarchar250

Given_Namenvarchar1000

Usual_Namenvarchar1000

Sur_Namenvarchar1000

Birthdatedate100

School_Short_Namevarchar100

Grade_Currentvarchar30

Grade_Next_Yearvarchar30

Genderchar10

Father_Given_Namenvarchar1000

Father_Surnamenvarchar1000

Father_Cell_Numbervarchar400

Father_Work_Numbervarchar400

Mother_Given_Namenvarchar1000

Mother_Surnamenvarchar1000

Mother_Cell_Numbervarchar400

Mother_Work_Numbervarchar400

Emergency_Contact_Given_Namenvarchar1000

Emergency_Contact_Surnamenvarchar1000

Emergency_Contact_Home_Numbervarchar400

House_Numbervarchar100

Apartment_Numbervarchar100

Street_Namevarchar2550

Townshipvarchar500

Postal_Codevarchar250

RR_Numbervarchar50

Cityvarchar500

Student_Home_Numbervarchar400

French_Immersion_Programchar100

Exceptionality_1varchar1500

Exceptionality_2varchar1500

Exceptionality_3varchar1500

Entry_Datedate100

Retirement_Datedate100

School_Numbervarchar100

Homeroom_Designation_Currentvarchar40

Custody_Notesnvarchar-10
vw_PVNCCDSB_Coop_CurrentYearfirst_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_Base_Clever_Staff_UpdatedSchool_idvarchar100

Staff_idvarchar250

Staff_emailvarchar2550

First_namenvarchar1000

Last_namenvarchar1000

Departmentvarchar1500

Titlenvarchar600

Usernamevarchar10

Passwordvarchar10

Rolenvarchar2000
vw_Timetable_RepeatsSchool_Short_Namevarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

Gradevarchar30

Ministry_Num_Fmtvarchar120

Course_Codevarchar100

Class_Sectionchar20

Is_Repeatbit10

Previous_Course_Codechar100

Previous_Completion_Datedate100

Previous_Creditdecimal52

Previous_Markvarchar30
vw_Base_Clever_Students_UpdatedSchool_idvarchar100

Student_idbigint190

Student_numbervarchar120

State_idvarchar100

Last_namenvarchar1000

Middle_Namenvarchar1000

First_namenvarchar1000

Gradevarchar30

Genderchar10

Graduation yeardate100

DOB- date of birthdate100

racevarchar10

Hispanic_Latinovarchar10

Home_languagevarchar1500

ELL_statusvarchar10

Frl_statusvarchar10

IEP_statusvarchar30

Student_streetvarchar2550

Student_cityvarchar500

Student_statevarchar500

Student_emailvarchar2550

Contact_relationshipvarchar2550

Contact_typevarchar2550

Contact_namenvarchar2020

Contact_phonevarchar400

Contact_phone_typenvarchar2000

Contact_emailvarchar2550

Contact_sis_iduniqueidentifier160

Usernamevarchar10

Passwordvarchar10

Unweighted GPAvarchar10

Weighted_GPAvarchar10

ext*varchar10
vw_Transcript_Substitutions_Current_ONSchool_Namevarchar2550

OENvarchar80000

Sur_Namenvarchar1000

Usual_Namenvarchar1000

Gradechar30

Date Of Completionsmalldatetime160

Course Codechar100

Credit Valuedecimal52

Substitution Flagbit10

Substition Categoriesnvarchar-10

School_Short_Namevarchar100
vw_Base_Clever_Teachers_UpdatedSchool_idvarchar100

Teacher_idvarchar250

Teacher_numbervarchar250

State_teacher_idchar150

Teacher_emailvarchar2550

First_namenvarchar1000

Middle_namenvarchar1000

Last_namenvarchar1000

Titlenvarchar600

Usernamevarchar10

Passwordvarchar10
vw_Classes_Current_ABSchool_Short_Namevarchar100

School_Namevarchar2550

School_Numberchar100

Class_Codevarchar100

Section_Letterchar20

Departmentvarchar1500

Semester_Term_Patternvarchar300

Period_Patternvarchar300

Course_Typevarchar500

Deliveryvarchar500

Credit_Valuenumeric52

Languagevarchar1500

Reportablebit10

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Alternate_Teacher_Numbervarchar250

Occupancyint100

Course_Titlevarchar2550

Class_Roomnvarchar-10

Is_CTS_Master_Classbit10

Is_CTS_Modulebit10

CTS_Master_Class_Codevarchar100

CTS_Master_Class_Sectionchar20

Class_Start_Datedate100

Class_End_Datedate100

Minutes_Per_Daysmallint50

Continuous_Entrybit10

Course_Gradevarchar30

Is_Reportablebit10

Attendance_Last_Taken_Datedate100
vw_Transportation_ExportSchool_Short_Namevarchar100

school_Namevarchar2550

School numbervarchar100

Ministry numbervarchar120

Student numbervarchar250

First namenvarchar1000

Last namenvarchar1000

Genderchar10

Birthdaydate100

Statuschar10

Gradevarchar30

Student Cohortvarchar1500

Homeroomvarchar120

Apartmentvarchar100

Street numbervarchar100

Street namevarchar2550

Cityvarchar500

Postal Codevarchar250

PO Boxvarchar170

provincevarchar500

Countryvarchar500

Townshipvarchar500

Legal_Land_Descriptionvarchar1210

Student phone numbervarchar400

Student Special Custody Notenvarchar-10

Future Apartmentvarchar100

Future Street numbervarchar100

Future Street namevarchar2550

Future Cityvarchar500

Future Postal Codevarchar250

Future PO Boxvarchar170

Future Provincevarchar500

Future Countryvarchar500

Future Address Effective Datedate100

Contact Order 1 namenvarchar2020

Contact Order 1 Typevarchar2550

Contact order 1 Legal Guardianbit10

Contact order 1 Custodianbit10

Contact 1 Custody Notenvarchar-10

Contact order 1 emergency contacttinyint30

Contact Order 1 home phonevarchar400

Contact Order 1 cell phonevarchar400

Contact Order 1 employervarchar2550

Contact Order 1 employer phonevarchar400

Contact Order 1 Emailvarchar2550

Contact Order 1 Apartmentvarchar100

Contact Order 1 Street numbervarchar100

Contact Order 1 Street namevarchar2550

Contact Order 1 Cityvarchar500

Contact Order 1 Postal Codevarchar250

Contact Order 1 PO Boxvarchar170

Contact Order 1 provincevarchar500

Contact Order 1 Countryvarchar500

Contact Order 1 Emergency Codevarchar1000

Contact Order 2 namenvarchar2020

Contact Order 2 Typevarchar2550

Contact order 2 Legal Guardianbit10

Contact order 2 Custodianbit10

Contact 2 Custody Notenvarchar-10

Contact order 2 emergency contacttinyint30

Contact Order 2 home phonevarchar400

Contact Order 2 cell phonevarchar400

Contact Order 2 employervarchar2550

Contact Order 2 employer phonevarchar400

Contact Order 2 Emailvarchar2550

Contact Order 2 Apartmentvarchar100

Contact Order 2 Street numbervarchar100

Contact Order 2 Street namevarchar2550

Contact Order 2 Cityvarchar500

Contact Order 2 Postal Codevarchar250

Contact Order 2 PO Boxvarchar170

Contact Order 2 provincevarchar500

Contact Order 2 Countryvarchar500

Contact Order 2 Emergency Codevarchar1000

Special Custodybit10

Lives Withvarchar1630

Sitter's Namenvarchar2020

Sitter home phonevarchar400

Sitter cell phonevarchar400

Sitter employervarchar2550

Sitter employer phonevarchar400

Sitter Emailvarchar2550

Sitter Apartmentvarchar100

Sitter Street numbervarchar100

Sitter Street namevarchar2550

Sitter Cityvarchar500

Sitter Postal Codevarchar250

Sitter PO Boxvarchar170

Sitter provincevarchar500

Sitter Countryvarchar500

Sitter Emergency Codevarchar1000

Current Pick Up Apartmentvarchar100

Current Pick Up Street numbervarchar100

Current Pick Up Street namevarchar2550

Current Pick Up Cityvarchar500

Current Pick Up Postal Codevarchar250

Current Pick Up PO Boxvarchar170

Current Pick Up provincevarchar500

Current Pick Up Countryvarchar500

Current Drop Off Apartmentvarchar100

Current Drop Off Street numbervarchar100

Current Drop Off Street namevarchar2550

Current Drop Off Cityvarchar500

Current Drop Off Postal Codevarchar250

Current Drop Off PO Boxvarchar170

Current Drop Off provincevarchar500

Current Drop Off Countryvarchar500

Entry datedate100

Retirement/transfer datedate100

Medical notesnvarchar-10

Special Ed Codechar100

Grant Type 1char100

Grant Type 2char100

Grant Type 3char100

Enrollment Type 1char100

Enrollment Type 2char100

Enrollment Type 3char100

Next Year Gradevarchar30

Next Year School Numbervarchar100

Student Emailvarchar2550
vw_Base_Clever_Sections_UpdatedSchool_idchar100

Section_idvarchar120

Teacher_idvarchar250

Teacher_2_idvarchar250

Teacher_3_idvarchar10

Teacher_4_idvarchar10

Namenvarchar2020

Section_numbersmallint50

Gradevarchar30

Course_namevarchar2550

Course_Numbersmallint50

Course_descriptionvarchar5000

Periodtinyint30

Subjectvarchar1500

Term_namevarchar300

Term_startdate100

Term_enddate100
vw_Classes_OntarioSchool_Namevarchar2550

School_Numberchar100

Class_Codevarchar100

Section_Letterchar20

Departmentvarchar1500

Semester_Term_Patternvarchar300

Period_Patternvarchar300

Course_Typevarchar500

Dual_Credit_Course_Typevarchar1500

Deliveryvarchar500

Credit_Valuenumeric52

Languagevarchar1500

Reportablebit10

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Occupancyint100

School_Short_Namevarchar100

Course_Titlevarchar2550

Dual_Credit_Course_Assocvarchar1720

Class_Roomnvarchar-10

Class_Start_Datedate100

Class_End_Datedate100

Minutes_Per_Daysmallint50

Continuous_Entrybit10

Num_Lessons_Work_Unitssmallint50

Num_Sessionstinyint30

Course_Gradevarchar30

Is_Reportablebit10

Attendance_Last_Taken_Datedate100

Course_Offering_Typevarchar1500
vw_Edsembli_Student_Count_DetailSchool_Short_Namenvarchar2560

Person_Iduniqueidentifier160

Studentnumbervarchar250
vw_Classes_Ontario_SchedulingSchool_Namevarchar2550

School_Numberchar100

Class_Codevarchar100

Section_Letterchar20

Departmentvarchar1500

Semester_Term_Patternvarchar300

Period_Patternvarchar300

Course_Typevarchar500

Dual_Credit_Course_Typevarchar1500

Deliveryvarchar500

Credit_Valuenumeric52

Languagevarchar1500

Reportablebit10

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Occupancyint100

School_Short_Namevarchar100

Course_Titlevarchar2550

Dual_Credit_Course_Assocvarchar1720

Class_Roomnvarchar-10

Course_Gradevarchar30

Is_Reportablebit10

Course_Offering_Typevarchar1500
vw_Destiny_exportLastNamenvarchar1000

FirstNamenvarchar1000

MiddleNamenvarchar1000

StudentID ASNvarchar120

Emailvarchar2550

Genderchar10

Birthdaydate100

Gradevarchar30

PatronID ASNvarchar120

Homeroomvarchar120

SchoolIDvarchar100

GraduationYeardate100
vw_IntPartner_PSTGI_Grade_SummarySchool_Short_Namevarchar100

School_Numbervarchar100

School_Namevarchar2550

Gradevarchar30

Special_Edbit10

French_Programvarchar1500

Stu_Statusvarchar180

Occupancy_Countint100
vw_Classes_Scheduling_ABSchool_Short_Namevarchar100

School_Namevarchar2550

School_Numberchar100

Class_Codevarchar100

Section_Letterchar20

Departmentvarchar1500

Semester_Term_Patternvarchar300

Period_Patternvarchar300

Course_Typevarchar500

Deliveryvarchar500

Credit_Valuenumeric52

Languagevarchar1500

Reportablebit10

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Alternate_Teacher_Numbervarchar250

Occupancyint100

Course_Titlevarchar2550

Class_Roomnvarchar-10

Is_CTS_Master_Classbit10

Is_CTS_Modulebit10

CTS_Master_Class_Codevarchar100

CTS_Master_Class_Sectionchar20

Course_Gradevarchar30

Is_Reportablebit10
vw_SeeSaw_Export_StudentStudent Namenvarchar2020

Student IDvarchar250

Student Emailvarchar2550
vw_IntPartner_PSTGI_Homeroom_SummarySchool_Short_Namevarchar100

School_Numbervarchar100

School_Namevarchar2550

Homeroom_Designationvarchar40

Homeroom_Roomvarchar50

Teacher_Numbervarchar250

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Alternate_Teacher_Numbervarchar250

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Gradevarchar30

Special_Edbit10

Special_Ed_Programvarchar1500

French_Programvarchar1500

Occupancy_Countint100
vw_Current_Student_Status_ONSchool_Namevarchar2550

OENvarchar120

Sur_Namenvarchar1000

Given_Namenvarchar1000

Genderchar10

Gradevarchar30

Stu_Statusvarchar180

HCSchoolchar10

Grade_Next_Yearchar30

School_Short_Namevarchar100

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

School_Cityvarchar500

Homeroom_Designationvarchar40

Homeroom_Numbervarchar50

Homeroom_Designation_Next_Yearvarchar40

Homeroom_Number_Next_Yearvarchar50

Main_Holder_Of_OSRvarchar1500

Entry_Datedate100

Retirement_Datedate100

Stu_Numbervarchar250

Stu_Number_Valuebigint190

Usual_Namenvarchar1000

Birthdatedate100

Internal_School_IDint100

Homeroom_Teacher_Numbervarchar250

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

Homeroom_Alt_Teacher_Numbervarchar250

Homeroom_Alt_Teacher_Surnamenvarchar1000

Homeroom_Alt_Teacher_Given_Namenvarchar1000

Homeroom_Teacher_Number_Next_Yearvarchar250

Homeroom_Teacher_Surname_Next_Yearnvarchar1000

Homeroom_Teacher_Given_Name_Next_Yearnvarchar1000

Country_Of_Birthvarchar1500

Province_Of_Birthvarchar1500

First_Languagevarchar1500

Student_Board_Residency_Statusvarchar1500

Instructional_Settingvarchar1500

Person_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Entered_Into_Maplewood_Datedate100

connectEd_User_Namevarchar1000

Student_Religionvarchar1500

Mother_Religionvarchar1500

Father_Religionvarchar1500

Citizenshipvarchar1500

Registration_Sourcevarchar2000
vw_SeeSaw_Export_TeacherTeacher Emailvarchar2550

Teacher First Namenvarchar1000

Teacher Last Namenvarchar1000

Class Namevarchar120

Grade Levelvarchar30
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_Valuenvarchar-10

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_Base_Address_PartsEmerg_Cont_Numtinyint30

Contact_Lst_Lst_IDuniqueidentifier160

Person_Role_IDuniqueidentifier160

Contact_Lst_IDuniqueidentifier160

Contact_Info_IDuniqueidentifier160

Scl_Year_Info_IDint100

First_Line_Addressnvarchar5120

Apartment_Numbervarchar100

House_Numbervarchar100

Street_Namevarchar2550

Cityvarchar500

Postal_Codevarchar250

Provincevarchar500

PO_Boxvarchar100

Emergency_Codevarchar1000

RR_Numbervarchar50

Address_Groupvarchar200

Quartervarchar20

Lotvarchar50

Townshipvarchar500

Concessionvarchar500

Meridianvarchar100

Legal_Land_Descriptionvarchar1210
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_Base_AddressesContact_Info_IDuniqueidentifier160

ComposedAddressnvarchar-10
vw_LockersSchool_Short_Namevarchar100

Locker_Numvarchar500

Availablebit10

Max_Studentssmallint50

Locker_Bankvarchar500

Surnamenvarchar1000

Given_Namenvarchar1000

Gradevarchar30
vw_Families_In_DivisionSchool Namevarchar2550

School Short Namevarchar100

Family Namenvarchar1000

Family Addressnvarchar-10

Number Students Attending This Schoolint100

Oldest Sibling Surnamenvarchar1000

Oldest Sibling Given Namenvarchar1000

Oldest Sibling Usual Namenvarchar1000

Oldest Sibling Student Numberbigint190

HouseholdIDuniqueidentifier160

Student_Sur_namenvarchar1000

student_Given_namenvarchar1000
vw_PVNCCDSB_OnLineRegistrationReg_Gradenvarchar500

Reg_ExpectedEntryDatedatetime233

Scl_BSIDnvarchar500

Scl_Namenvarchar2560

Stu_LegalLastNamenvarchar2560

stu_LegalFirstNamenvarchar2560

Stu_Gendernvarchar300

Stu_OLRegSuccessbit10

IsDeletedbit10

Reg_RequestedHomeSchoolnvarchar2000
vw_Base_Archive_AchievementClass_IDuniqueidentifier160

Enrol_IDuniqueidentifier160

Person_IDuniqueidentifier160

School_IDuniqueidentifier160

Topic_IDuniqueidentifier160

Term_IDuniqueidentifier160

List_IDuniqueidentifier160

School_Yearvarchar100

Schoolvarchar2550

School_Short_Namevarchar100

Student_Gradevarchar20

Course_Codevarchar100

Course_Gradevarchar30

Class_Sectionvarchar20

Class_Titlevarchar2550

Homeroom_Roomvarchar50

Homeroom_Designationvarchar100

Termvarchar500

Term_Codevarchar50

Final_Termbit10

Topicvarchar2550

Topic_Codevarchar50

Final_Topicbit10

Markvarchar60

Overridevarchar60

Mark_Last_Modifieddatetime233

SubmissionDatedate100
vw_Pathway_OntarioSchool Numbervarchar100

School Namevarchar2550

OENvarchar120

Student Last Namenvarchar1000

Student Usual Namenvarchar1000

Street Addressvarchar2660

Cityvarchar500

Postal Codevarchar250

Student Email Addressvarchar2550

Student Phone Numbervarchar400

Genderchar10

DOBdate100

Gradevarchar30

Course Start Datedate100

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

School_Short_Namevarchar100

Homeroom_Designationvarchar40

Homeroom_Numbervarchar50

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

Homeroom_Teacher_Numbervarchar250

Homeroom_Alt_Teacher_Surnamenvarchar1000

Homeroom_Alt_Teacher_Given_Namenvarchar1000

Homeroom_Alt_Teacher_Numbervarchar250

OYAPbit10

Is_Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Special_Ed_Resourcesvarchar1500

Exceptionality_1varchar1500

Exceptionality_2varchar1500

Exceptionality_3varchar1500
vw_PVNC_Scheduling_CohortStudent_Numbervarchar250

OEN_Numbervarchar120

Surnamenvarchar1000

Usual_Namenvarchar1000

Gradevarchar30

Birthdatedate100

Genderchar10

Defined Character 2varchar30

Apartment_Numbervarchar100

House_Numbervarchar100

Street_Namevarchar2550

Cityvarchar500

Postal_Codevarchar250

Townshipvarchar500

Home_Phonevarchar400

Attendance_Typevarchar500

School_Numbervarchar100

French_Immersion_Typevarchar1500

Homeroom_Numbervarchar50

Homeroom_Designationvarchar40

Homeroom_Designation_Next_Yearvarchar40

Grade_Next_Yearvarchar30

School_Short_Namevarchar100

Entry_Datedate100

Sitter_Namenvarchar2020

Sitter_House_Numbervarchar100

Sitter_Street_Namevarchar2550

Sitter_Cityvarchar500

Sitter_Postal_Codevarchar250

Sitter_Phone_Numbervarchar400

Mother_Titlenvarchar600

Mother_Given_Namenvarchar1000

Mother_Surnamenvarchar1000

Mothers_Cell_Phonevarchar400

Mother_Emailvarchar2550

Mother_House_Numbervarchar100

Mother_Street_Namevarchar2550

Mother_Cityvarchar500

Mother_Postal_Codevarchar250

Father_Titlenvarchar600

Father_Given_Namenvarchar1000

Father_Surnamenvarchar1000

Father_Cell_Phonevarchar400

Father_Emailvarchar2550

Father_House_Numbervarchar100

Father_Street_Namevarchar2550

Father_Cityvarchar500

Father_Postal_Codevarchar250

Emergency_Contact_Given_Namenvarchar1000

Emergency_Contact_Surnamenvarchar1000

Emergency_Contact_Cell_Phonevarchar400

Lives_Withvarchar1500

Special Custodybit10
vw_PVNCCDSB_Class_Drop_CountsSchool_Short_Namevarchar100

Course_Codevarchar100

Class_Sectionvarchar20

Course_Gradevarchar30

Teacher_Surnamenvarchar1000

Teacher_GivenNamenvarchar1000

Teacher_Titlenvarchar600

StaffNumberbigint190

Semestertinyint30

Periodtinyint30

Number_Students_Enrolled_On_FirstDayint100

Number_Students_Currently_Enrolledint100

Number_Students_Dropped_Classint100

Class_IDuniqueidentifier160
vw_Base_Archive_Attendance_Equivalent_Full_Day_TotalsPerson_IDuniqueidentifier160

Gradevarchar20

School_IDuniqueidentifier160

School_Yearvarchar100

Absentnumeric381

Lateint100

Suspendedint100
vw_PVNCCDSB_Transportation_Export_V2Student_Numbervarchar250

OEN_Numbervarchar120

Surnamenvarchar1000

Usual_Namenvarchar1000

Gradevarchar30

Birthdatedate100

Genderchar10

Apartment_Numbervarchar100

House_Numbervarchar100

Street_Namevarchar2550

Cityvarchar500

Postal_Codevarchar250

Townshipvarchar500

Home_Phonevarchar400

Attendance_Typevarchar500

School_Numbervarchar100

French_Immersion_Typevarchar1500

Homeroom_Numbervarchar50

Homeroom_Designationvarchar40

Homeroom_Designation_Next_Yearvarchar40

Grade_Next_Yearvarchar30

School_Short_Namevarchar100

Entry_Datedate100

Sitter_Namenvarchar2020

Sitter_House_Numbervarchar100

Sitter_Street_Namevarchar2550

Sitter_Cityvarchar500

Sitter_Postal_Codevarchar250

Sitter_Phone_Numbervarchar400

Mother_Titlenvarchar600

Mother_Given_Namenvarchar1000

Mother_Surnamenvarchar1000

Mothers_Cell_Phonevarchar400

Mother_Emailvarchar2550

Mother_House_Numbervarchar100

Mother_Street_Namevarchar2550

Mother_Cityvarchar500

Mother_Postal_Codevarchar250

Father_Titlenvarchar600

Father_Given_Namenvarchar1000

Father_Surnamenvarchar1000

Father_Cell_Phonevarchar400

Father_Emailvarchar2550

Father_House_Numbervarchar100

Father_Street_Namevarchar2550

Father_Cityvarchar500

Father_Postal_Codevarchar250

Emergency_Contact_Given_Namenvarchar1000

Emergency_Contact_Surnamenvarchar1000

Emergency_Contact_Cell_Phonevarchar400

Lives_Withvarchar1500

Special Custodybit10

PINnvarchar-10
vw_Student_Choices_ONSchool_Short_Namevarchar100

OENvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Stu_Status_Codevarchar10

Stu_Statusvarchar180

Defined_Character_1varchar30

Defined_Character_2varchar30

Defined_Character_3varchar30

Defined_Character_4varchar30

This_Year_Gradevarchar30

Next_Year_Gradechar30

Course_Codevarchar100

Course_Titlevarchar2550

Choice_Typevarchar500

Choice_Requiredbit10

Sort_Ordersmallint50

Assigned_To_Classbit10

Credit_Valuedecimal52

Total_Credit_Earneddecimal382

Type_Of_Coursevarchar1200
vw_PVNCCDSB_Bus_Needs_Med_ConditionsMinistry_Num_Fmtvarchar120

Stu_Numbervarchar250

Sur_Namenvarchar1000

Given_Namenvarchar1000

Genderchar10

Gradevarchar30

Stu_Statusvarchar180

School_Short_Namevarchar100

Field_Valuenvarchar-10

HCSchoolchar10
vw_Base_AssessmentPerson_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Test_Def_IDuniqueidentifier160

Test_Version_IDuniqueidentifier160

Testvarchar500

Subjectvarchar500

Strandvarchar500

Timeframevarchar500

Markreal240

Mark_Levelchar100

Mark_Fmtvarchar100

Test_Identifiervarchar200

Subject_Identifiervarchar200

Strand_Identifiervarchar200
vw_Student_Enrolment_SKSchool_Short_Namevarchar100

School_Namevarchar2550

Student_Numberbigint190

DENvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Gradevarchar30

Birthdatedate100

Genderchar10

Entry_Datedate100

Enrolment_Reasonvarchar1500

Retirement_Datedate100

Enrolment_Resultvarchar1500

EAL_Proficiency_Levelvarchar1500

EAL_Start_Datedate100

Citizenshipvarchar1500

Resident_Typevarchar1500

Country_Of_Birthvarchar1500

First_Languagevarchar1500

Second_Languagevarchar1500

Base_Schoolbit10

Student_Enrolment_Statusvarchar180

Place_Of_Originvarchar1500

Previous_Province_Statevarchar1500

Tuition_Statusvarchar1500

Exchange_Program_Namevarchar1500

Home_Schoolbit10

Programvarchar1500

Prekindergarten_Ministry_Designatedbit10

Indian_Registry_Numbervarchar120

Residence_Statusvarchar1500

Band_Of_Residencevarchar1500

Reserve_Of_Residencevarchar1500

Band_Of_Financial_Responsibilityvarchar1500

Aboriginal_Statusvarchar1500

Stu_Enrol_IDuniqueidentifier160
vw_PVNC_Student_EnrolmentStu_Enrol_IDuniqueidentifier160

IsSchedulingbit10

Scl_Year_Info_IDuniqueidentifier160

IsCurrentbit10

School_IDuniqueidentifier160

School_Yearvarchar100

Person_IDuniqueidentifier160

Oenint100

IsHomeSchoolbit10

This_Sch_Entry_Datesmalldatetime160

Retirement_Datesmalldatetime160

Gradechar30

Homeroom_IDuniqueidentifier160

FrenchProgramvarchar1500

mwStatuschar10

StatusTextvarchar300

Accum_Std_Creditsdecimal52

Accum_OAC_Creditsdecimal52

Elem_Entry_Datesmalldatetime160

Sec_Entry_Datesmalldatetime160

Fre_Imm_Minsmallint50

Special_Edbit10

Special_Ed_Statuschar10

English_Language_Learnervarchar500

Short_Namevarchar100

Date_Importeddatetime233
vw_Base_ClassesClass_IDuniqueidentifier160

Course_IDuniqueidentifier160

OnSisCodevarchar160

Code_IDuniqueidentifier160

School_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

School_Short_Namevarchar100

School_Namevarchar2550

School_Numberchar100

Class_Codevarchar100

Section_Letterchar20

Departmentvarchar1500

Semester_Term_Patternvarchar300

Period_Patternvarchar300

Course_Typevarchar500

Deliveryvarchar500

Credit_Valuenumeric52

Languagevarchar1500

Reportablebit10

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Alternate_Teacher_Numbervarchar250

Occupancyint100

Course_Titlevarchar2550

Class_Roomnvarchar-10

Schedulingbit10

Class_Start_Datedate100

Class_End_Datedate100

Minutes_Per_Daysmallint50

Continuous_Entrybit10

Num_Lessons_Work_Unitssmallint50

Num_Sessionstinyint30

Course_Gradevarchar30

Is_Reportablebit10

Attendance_Last_Taken_Datedate100
vw_Student_Enrolments_SKSchool_Short_Namevarchar100

School_Numbervarchar100

PENvarchar120

Stu_Numbervarchar250

Surnamenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Entry_Datedate100

Entry_Reason_Codevarchar100

Entry_Reasonvarchar1500

Origin_School_Numbervarchar100

Origin_Schoolvarchar1500

Retirement_Datedate100

Enrolment_Result_Codevarchar100

Enrolment_Resultvarchar1500

Destination_School_Numbervarchar100

Destination_Schoolvarchar1500
vw_PVNC_Stu_Custom_FieldsSchool_Short_Namevarchar100

HCSchoolchar10

Ministry_Num_Fmtvarchar120

Sur_Namenvarchar1000

Given_Namenvarchar1000

Genderchar10

Gradevarchar30

Birthdatedate100

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Field_Typevarchar500

Field_Namevarchar500

Field_Valuenvarchar-10

Board_Definedbit10

Stu_Enrol_IDuniqueidentifier160

Person_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
vw_Base_Clever_SchoolsSchool_idvarchar100

School_namevarchar2550

School_numbervarchar100

School_addressvarchar3080

School_cityvarchar500

School_statevarchar500

School_zipvarchar80000
vw_Student_Special_Education_Full_ONPerson_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

School_Short_Namevarchar100

Surnamenvarchar1000

Usual_Namenvarchar1000

Birthdatedate100

Genderchar10

OENvarchar120

Gradevarchar30

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Spec_Ed_Statusvarchar80

Exceptionality_Placement_Numbertinyint30

Exceptionality_Codevarchar100

Exceptionalityvarchar1500

Execptionality_Start_Datedate100

Exceptionality_End_Datedate100

Placementvarchar1500

Placement_Start_Datedate100

Placement_End_Datedate100

Special_Ed_Programvarchar1500

Support_Servicevarchar1500

Special_Ed_Resourcesvarchar1500

IEP_Withnvarchar-10

Residencyvarchar1500
vw_PVNC_Scheduling_Classes_OntarioSchool_Namevarchar2550

School_Numberchar100

Class_Codevarchar100

Section_Letterchar20

Departmentvarchar1500

Semester_Term_Patternvarchar300

Period_Patternvarchar300

Course_Typevarchar500

Dual_Credit_Course_Typevarchar1500

Deliveryvarchar500

Credit_Valuenumeric52

Languagevarchar1500

Reportablebit10

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Occupancyint100

School_Short_Namevarchar100

Course_Titlevarchar2550

Dual_Credit_Course_Assocvarchar1720
vw_Base_Current_Students_HouseholdsHouseholdAddressInfoIDuniqueidentifier160

OldestSiblingPersonIDuniqueidentifier160

YoungestSiblingPersonIDuniqueidentifier160

Person_IDuniqueidentifier160

FamilyNamenvarchar1000

OldestSiblingsContactInfoIDuniqueidentifier160
vw_Student_Timetable_ONSchool_Short_Namevarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

OENvarchar120

Gradevarchar30

Course_Codevarchar100

Class_Sectionchar20

Course_Numbervarchar100

Course_Gradevarchar30

Course_Titlevarchar2550

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alt_Teacher_Surnamenvarchar1000

Alt_Teacher_Given_Namenvarchar1000

Alt_Teacher_Numbervarchar250

Class_Start_Datedate100

Class_End_Datedate100

Is_Droppedbit10

Is_Next_Yearbit10

Is_Continuous_Entrybit10

Continuous_Entry_Start_Datedate100

Continuous_Entry_Completion_Datedate100

Course_Typevarchar500

Delivery_Typevarchar500

Attendance_Typevarchar500

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

Birthdatedate100

Genderchar10

Aboriginal_Self_IDvarchar1500

Exceptionality_1varchar1500

Exceptionality_2varchar1500

Exceptionality_3varchar1500

Placement_Settingvarchar1500

Entry_Datedate100

Retirement_Datedate100

Sem_Term_Patternvarchar300

Day_Per_Patternvarchar300

Drop_Datedate100

Credit_Attempteddecimal52
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_Base_HomeroomsHomeroom_IDuniqueidentifier160

Homeroom_Designationvarchar40

Homeroom_Roomvarchar50

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Alternate_Teacher_Numbervarchar250
vw_Transcript_RepeatsSchool_Short_Namevarchar100

Min_Numvarchar120

Surnamenvarchar1000

Usual_Namenvarchar1000

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Is_Exact_Code_Matchbit10

Course_Codechar100

Markvarchar30

Transcript_Datedate100

Credit_Earneddecimal52

Delivery_Typevarchar500

Repeat_Course_Codechar100

Repeat_Markvarchar30

Repeat_Datedate100

Repeat_Credit_Earneddecimal52

Repeat_Delivery_Typevarchar500
vw_Base_ReligionPerson_IDuniqueidentifier160

StudentReligionEnglishvarchar1500

StudentReligionFrenchvarchar1500

StudentParishvarchar1500

MotherReligionEnglishvarchar1500

MotherReligionFrenchvarchar1500

MotherParishvarchar1500

FatherReligionEnglishvarchar1500

FatherReligionFrenchvarchar1500

FatherParishvarchar1500

GuardianReligionEnglishvarchar1500

GuardianReligionFrenchvarchar1500

GuardianParishvarchar1500

BaptismDatesmalldatetime160

BaptismParishvarchar1500

BaptismSchoolvarchar1500

ConfirmationDatesmalldatetime160

ConfirmationParishvarchar1500

ConfirmationSchoolvarchar1500

FirstEucharistDatesmalldatetime160

FirstEucharistParishvarchar1500

FirstEucharistSchoolvarchar1500

FirstReconciliationDatesmalldatetime160

FirstReconciliationParishvarchar1500

FirstReconciliationSchoolvarchar1500
vw_TranscriptsTranscript_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Code_Def_IDuniqueidentifier160

School_Short_Namevarchar100

Min_Numvarchar120

Surnamenvarchar1000

Usual_Namenvarchar1000

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Course_Codechar100

Course_Numberchar100

Course_Titlevarchar2550

Transcript_Datedate100

Markvarchar30

Languagevarchar1500

Course_Typevarchar500

Delivery_Typevarchar500

Credit_Attempteddecimal52

Credit_Earneddecimal52

Student_Gradevarchar30

Achieved_At_Schoolvarchar1500

Mark_Numericsmallint50
vw_Base_StaffStaff_IDuniqueidentifier160

Person_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

Contact_Lst_Lst_IDuniqueidentifier160

School_Short_Namevarchar100

School_Namevarchar2550

Staff_Numbervarchar250

Ministry_Numbervarchar150

Titlenvarchar600

Surnamenvarchar1000

Given_Namenvarchar1000

Genderchar10

Birthdatedate100

Rolevarchar2550

IsTeacherbit10

Employmentvarchar500

Status_Codevarchar10

Statusvarchar180

Teaching_Since_Datedate100

This_Board_Datedate100

This_School_Datedate100

Transfer_Datedate100

RegistrationNumbervarchar150
vw_Transcripts_ONTranscript_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

Markvarchar30

Credit_Earneddecimal72

Languagevarchar1500

Course_Typevarchar500

Delivery_Typevarchar500

Credit_Attempteddecimal52

Att_Absentdecimal50

Att_Excuseddecimal50

Att_Latedecimal50

Att_Possibledecimal41

Dual_Credit_Typevarchar1500

Dual_Credit_Institutionvarchar1500

Dual_Credit_Course_Codevarchar500

Student_Gradevarchar30

Achieved_At_Schoolvarchar1500

Birthdatedate100

Aboriginal_Self_IDvarchar1500

Mark_Numericsmallint50
vw_Base_StudentsStu_Enrol_IDuniqueidentifier160

Stu_Info_IDuniqueidentifier160

Person_IDuniqueidentifier160

School_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

Contact_Lst_Lst_IDuniqueidentifier160

Homeroom_IDuniqueidentifier160

School_Short_Namevarchar100

School_Namevarchar2550

Ministry_Numvarchar120

Ministry_Num_Fmtvarchar120

Sur_Namenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Middle_Namenvarchar1000

Usual_Name_Fmtnvarchar1000

Birthdatedate100

Genderchar10

Gradevarchar30

Stu_Status_Codevarchar10

Stu_Statusvarchar180

HCSchoolchar10

Schedulingbit10

School_Numbervarchar100

School_Typechar10

Legal_Namenvarchar1000

Legal_Name_Fmtnvarchar1000

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

Surnamenvarchar1000

Special_Edbit10

Person_Status_IDuniqueidentifier160

Entry_Datedate100

Retirement_Datedate100

Stu_Numbervarchar250

Stu_Number_Valuebigint190

Entered_Into_Maplewood_Datedate100

Stu_Letterschar30

School_Yearvarchar100
vw_Archive_AchievementSchool_Yearvarchar100

Schoolvarchar2550

School_Short_Namevarchar100

Sur_Namenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Ministry_Numvarchar80000

Classvarchar100

Sectionvarchar20

Teachernvarchar2640

Termvarchar500

Topicvarchar2550

Markvarchar60

Overridevarchar60

Mark_Last_Modifieddatetime233

Commentvarchar-10

Class_Semtinyint30

Class_Termtinyint30

Class_Daytinyint30

Class_Periodtinyint30

Class_Gradevarchar30

Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Special_Ed_Programvarchar1500

Support_Servicevarchar1500

Special_Ed_Resourcesvarchar1500
vw_PVNC_Student_Contacts_SchedulingStu_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_Base_Students_Contact_EmailContact_Lst_Lst_IDuniqueidentifier160

Person_Role_IDuniqueidentifier160

Seq_Numbigint190

Email_Addressvarchar2550

Contact_Lst_IDuniqueidentifier160

Contact_Info_IDuniqueidentifier160
vw_Archive_Achievement_Correspondence_Lessons_ONSchool_Short_Namevarchar100

Class_Codevarchar130

Class_Credit_Valuenumeric52

Student_Class_Statusvarchar70

Semester_Term_Pattern_Namevarchar300

Delivery_Typevarchar500

Type_Of_Coursevarchar500

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Alternate_Teacher_Numbervarchar250

Student_Surnamenvarchar1000

Student_Given_Namenvarchar1000

OENvarchar120

Student_Statusvarchar180

Main_Schoolvarchar1500

Student_Board_Residence_Statusvarchar1500

Con_Ed_Student_Typevarchar1500

Genderchar10

Home_Concurrent_Statuschar10

Student_Phone_Numbervarchar400

Student_Emailvarchar2550

Parent_Email_1varchar2550

Parent_Email_2varchar2550

Lessons_Completedvarchar2550

Markvarchar60

SubmissionDatedate100

Add_Datedate100

Drop_Datedate100

Homeroom_Designationvarchar40

Homeroom_Roomvarchar50

ContEntry_Active_Datedate100

ContEntry_Completion_Datedate100
vw_Base_Students_Contact_PhoneContact_Lst_Lst_IDuniqueidentifier160

Person_Role_IDuniqueidentifier160

Phone_Type_IDuniqueidentifier160

Whole_Numbervarchar400

Contact_Lst_IDuniqueidentifier160

Contact_Info_IDuniqueidentifier160

Seq_Numbigint190
vw_Archive_Achievement_Marks_MBClass_IDuniqueidentifier160

School_Yearvarchar100

Schoolvarchar2550

School_Short_Namevarchar100

Sur_Namenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Ministry_Numvarchar80000

Classvarchar100

Sectionvarchar20

Class_Gradevarchar30

Teachernvarchar2640

Termvarchar500

Topicvarchar2550

Markvarchar60

Overridevarchar60

Mark_Last_Modifieddatetime233

Commentvarchar-10

Person_IDuniqueidentifier160

School_IDuniqueidentifier160

Term_Codevarchar50

Topic_Codevarchar50

Final_Topicbit10

Student_Gradevarchar20

Final_Termbit10

Homeroom_Roomvarchar50

Homeroom_Designationvarchar100

Genderchar10

Aboriginal_Status_Codechar100

Aboriginal_Status_Titlevarchar1500

Surnamenvarchar1000

Class_Titlevarchar2550

Alternate_Teachernvarchar2640

Timetable_Add_Or_Dropchar10

Enrol_IDuniqueidentifier160

Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Special_Ed_Programvarchar1500

Support_Servicevarchar1500

Special_Ed_Resourcesvarchar1500

SubmissionDatedate100

EALbit10
vw_Base_Students_EQAO_ONPerson_IDuniqueidentifier160

EQAO_Grade_3_Mathdecimal381

EQAO_Grade_3_Readingdecimal381

EQAO_Grade_3_Writingdecimal381

EQAO_Grade_6_Mathdecimal381

EQAO_Grade_6_Readingdecimal381

EQAO_Grade_6_Writingdecimal381

EQAO_Grade_9_Mathdecimal381
vw_Archive_Achievement_Marks_SKClass_IDuniqueidentifier160

Person_IDuniqueidentifier160

School_IDuniqueidentifier160

School_Yearvarchar100

Schoolvarchar2550

School_Short_Namevarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

DENvarchar80000

Classvarchar100

Sectionvarchar20

Class_Gradevarchar30

Teachernvarchar2640

Termvarchar500

Topicvarchar2550

Markvarchar60

Overridevarchar60

Mark_Last_Modifieddatetime233

Commentvarchar-10

Term_Codevarchar50

Topic_Codevarchar50

Final_Topicbit10

Student_Gradevarchar20

Final_Termbit10

Homeroom_Roomvarchar50

Homeroom_Designationvarchar100

Genderchar10

Aboriginal_Status_Codechar100

Aboriginal_Status_Titlevarchar1500

Class_Titlevarchar2550

Alternate_Teachernvarchar2640

Timetable_Add_Or_Dropchar10

Prov_Aboriginal_Statusvarchar1500
vw_Base_Students_Person_ONPerson_IDuniqueidentifier160

Aboriginal_Self_IDvarchar1500

Country_Of_Birthvarchar1500

Entry_To_Canada_Datedate100

Aboriginal_Type_Entry_Datedate100

First_Languagevarchar1500

Aboriginal_Status_Codevarchar1500
vw_Archive_Achievement_Session_Attendance_ONSchool_Short_Namevarchar100

Class_Codevarchar130

Class_Credit_Valuenumeric52

Student_Class_Statusvarchar70

Semester_Term_Pattern_Namevarchar300

Delivery_Typevarchar500

Type_Of_Coursevarchar500

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Alternate_Teacher_Numbervarchar250

Student_Surnamenvarchar1000

Student_Given_Namenvarchar1000

OENvarchar120

Student_Statusvarchar180

Main_Schoolvarchar1500

Student_Board_Residence_Statusvarchar1500

Genderchar10

Home_Concurrent_Statuschar10

Student_Phone_Numbervarchar400

Student_Emailvarchar2550

Parent_Email_1varchar2550

Parent_Email_2varchar2550

Reporting_Periodvarchar50

Session_Absentvarchar80

Date_Absentdate100

Add_Datedate100

Drop_Datedate100
vw_Base_Students_Spec_EdPerson_IDuniqueidentifier160

Spec_Ed_Statusvarchar80

Exceptionality_1varchar1500

Exceptionality_2varchar1500

Exceptionality_3varchar1500

IEP_Withnvarchar-10

Is_Special_Edbit10

IEPbit10

Special_Ed_Programvarchar1500

Support_Servicevarchar1500

Special_Ed_Resourcesvarchar1500

IPRC_Date_Initialdate100

IPRC_Date_Lastdate100

IPRC_Date_Nextdate100

IPRC_Date_Demitteddate100

Placementvarchar1500
vw_Archive_Achievement_Work_Units_ONSchool_Short_Namevarchar100

Class_Codevarchar130

Class_Credit_Valuenumeric52

Student_Class_Statusvarchar70

Semester_Term_Pattern_Namevarchar300

Delivery_Typevarchar500

Type_Of_Coursevarchar500

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Alternate_Teacher_Numbervarchar250

Student_Surnamenvarchar1000

Student_Given_Namenvarchar1000

OENvarchar120

Student_Statusvarchar180

Main_Schoolvarchar1500

Student_Board_Residence_Statusvarchar1500

Genderchar10

Home_Concurrent_Statuschar10

Student_Phone_Numbervarchar400

Student_Emailvarchar2550

Parent_Email_1varchar2550

Parent_Email_2varchar2550

Titlenvarchar1000

SubmissionDatedate100

Add_Datedate100

Drop_Datedate100

Termvarchar500

Term_Codevarchar50

Markvarchar60
vw_Base_Students_Spec_Ed_All_ExPerson_IDuniqueidentifier160

Spec_Ed_Statusvarchar80

Exceptionalitiesnvarchar-10

IEP_Withnvarchar-10

Is_Special_Edbit10

IEPbit10
vw_Elementary_EQAO_Achievement_ONSchool_Short_Namevarchar100

School_Yearvarchar100

OENvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Student_Current_Gradevarchar30

Genderchar10

Birthdatedate100

Stu_Status_Codevarchar10

Homeroom_Designationvarchar40

Homeroom_Roomvarchar50

Homeroom_Teacher_Numbervarchar250

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

Spec_Ed_Statusvarchar80

IEPbit10

Aboriginal_Self_IDvarchar1500

Aboriginal_Status_Codevarchar1500

Absent_Daysnumeric381

Grade_3_EQAO_Readingreal240

Grade_3_EQAO_Writingreal240

Grade_3_EQAO_Mathreal240

Grade_6_EQAO_Readingreal240

Grade_6_EQAO_Writingreal240

Grade_6_EQAO_Mathreal240

Reading_Markvarchar60

Writing_Markvarchar60

Number_Sense_Markvarchar60

Uses_Of_Spoken_French_Markvarchar60

Responsibility_Markvarchar60

Organization_Markvarchar60

Independent_Work_Markvarchar60

Collaboration_Markvarchar60

Initiative_Markvarchar60

Self_Regulation_Markvarchar60
vw_Codes_Standardization_BaseCode_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
vw_Grade_9_Math_OntarioSchool_Namevarchar2550

OENvarchar120

Sur_Namenvarchar1000

Usual_Namenvarchar1000

Gradevarchar30

Grade_6_EQAO_Readingreal240

Grade_6_EQAO_Mathreal240

Grade_9_Math_Coursevarchar100

Grade_9_Math_Markvarchar300

Grade_9_EQAO_Mathreal240

Literacy_Statuschar10

OSSLTvarchar500

IEPbit10

IEPWithnvarchar-10

Support_Servicevarchar1500

Exceptionality_1varchar1500

School_Short_Namevarchar100

Aboriginal_Self_IDvarchar1500

Aboriginal_Type_Entry_Datedate100
vw_MW_Student_Timetable_WAddDropStart_Datedate100

End_Datedate100

Class_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Current_TTbit10

ContEntry_Active_Datedate100

ContEntry_Completion_Datedate100

ContEntry_Expected_Completion_Datedate100

ContEntry_Intended_Start_Datedate100

Continuous_Entrybit10
vw_Leaver_Report_ABSchool Numbervarchar100

School Namevarchar2550

School Short Namevarchar100

ASNvarchar120

Entry Datedate100

Retirement Datedate100

Destination Typevarchar1500

Destination Schoolvarchar1500

Status Codevarchar10

Status Namevarchar180

Given Namenvarchar1000

Usual Namenvarchar1000

Surnamenvarchar1000

Legal Surnamenvarchar1000

Genderchar10

Current Age (Yrs)int100

Home Phone Lives Withvarchar400

Home Phone Fathervarchar400

Home Phone Mothervarchar400

Given Name Lives Withnvarchar1000

Given Name Fathernvarchar1000

Given Name Mothernvarchar1000

First Diplomavarchar500

Total Creditsdecimal382

Diploma Datedate100

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

Spec Ed Programvarchar1500

Gradevarchar30

Home Schoolchar10
vw_PVNC_Stu_Custom_FieldsSchool_Short_Namevarchar100

HCSchoolchar10

Ministry_Num_Fmtvarchar120

Sur_Namenvarchar1000

Given_Namenvarchar1000

Genderchar10

Gradevarchar30

Birthdatedate100

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Field_Typevarchar500

Field_Namevarchar500

Field_Valuevarchar1000

Board_Definedbit10

Stu_Enrol_IDuniqueidentifier160

Person_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
vw_Base_Classes_ABSchool_Short_Namevarchar100

School_Namevarchar2550

School_Numberchar100

Class_Codevarchar100

Section_Letterchar20

Departmentvarchar1500

Semester_Term_Patternvarchar300

Period_Patternvarchar300

Course_Typevarchar500

Deliveryvarchar500

Credit_Valuenumeric52

Languagevarchar1500

Reportablebit10

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Alternate_Teacher_Numbervarchar250

Occupancyint100

Course_Titlevarchar2550

Class_Roomnvarchar-10

Schedulingbit10

Is_CTS_Master_Classbit10

Is_CTS_Modulebit10

CTS_Master_Class_Codevarchar100

CTS_Master_Class_Sectionchar20

Class_Start_Datedate100

Class_End_Datedate100

Minutes_Per_Daysmallint50

Continuous_Entrybit10

Course_Gradevarchar30

Is_Reportablebit10

Attendance_Last_Taken_Datedate100
vw_Leaver_Report_OntarioSchool Numbervarchar100

School Namevarchar2550

School Short Namevarchar100

OENvarchar120

Entry Datesmalldatetime160

Retirement Datesmalldatetime160

Destination Typevarchar1500

Destination Schoolvarchar1500

Status Codevarchar10

Status Namevarchar180

Given Namenvarchar1000

Usual Namenvarchar1000

Surnamenvarchar1000

Legal Surnamenvarchar1000

Genderchar10

Current Age (Yrs)int100

Home Phone Lives Withvarchar400

Home Phone Fathervarchar400

Home Phone Mothervarchar400

Given Name Lives Withnvarchar1000

Given Name Fathernvarchar1000

Given Name Mothernvarchar1000

OSSLT Statusvarchar140

Community Hours Completednumeric170

First Diplomavarchar500

Total Creditsdecimal382

Diploma Datedate100

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

Spec Ed Programvarchar1500

Gradevarchar30

Instructional Settingvarchar1500

Community Involement Completebit10

Homeroom Designationvarchar40

Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Special_Ed_Resourcesvarchar1500

Support_Servicevarchar1500

OYAPbit10

Cohort_Yearvarchar100
vw_PVNCCDSB_SEOS_Export_Secondary_UpdatedSchool_Short_Namevarchar100

OENvarchar120

LastNamenvarchar1000

FirstNamenvarchar1000

DOBdate100

Sexchar10

Addressvarchar2770

Cityvarchar500

Postal_Codevarchar250

Father_Namenvarchar2040

Father_WorkPhonevarchar400

Mother_Namenvarchar2040

Mother_WorkPhonevarchar400

Home_Phonevarchar400

Gradevarchar30

Homeroom_Teachernvarchar2040

HomeroomNumbervarchar50

HomeroomDesignationvarchar40

Schoolvarchar2550

Midentvarchar100

Exceptionalityvarchar1500

DateLastIPRCdate100

IEPbit10

Placementvarchar1500

SpecializedEquipmentvarchar1500

Absentint100

Lateint100

AdmittedDatedate100

S1CRS1Codevarchar100

S1CRS1TeacherNamenvarchar2040

S1CRS1Titlevarchar2550

S1CRS2Codevarchar100

S1CRS2TeacherNamenvarchar2040

S1CRS2Titlevarchar2550

S1CRS3Codevarchar100

S1CRS3TeacherNamenvarchar2040

S1CRS3Titlevarchar2550

S1CRS4Codevarchar100

S1CRS4TeacherNamenvarchar2040

S1CRS4Titlevarchar2550

S1CRS5Codevarchar100

S1CRS5TeacherNamenvarchar2040

S1CRS5Titlevarchar2550

S1CRS6Codevarchar100

S1CRS6TeacherNamenvarchar2040

S1CRS6Titlevarchar2550

S1CRS7Codevarchar100

S1CRS7TeacherNamenvarchar2040

S1CRS7Titlevarchar2550

S2CRS1Codevarchar100

S2CRS1TeacherNamenvarchar2040

S2CRS1Titlevarchar2550

S2CRS2Codevarchar100

S2CRS2TeacherNamenvarchar2040

S2CRS2Titlevarchar2550

S2CRS3Codevarchar100

S2CRS3TeacherNamenvarchar2040

S2CRS3Titlevarchar2550

S2CRS4Codevarchar100

S2CRS4TeacherNamenvarchar2040

S2CRS4Titlevarchar2550

S2CRS5Codevarchar100

S2CRS5TeacherNamenvarchar2040

S2CRS5Titlevarchar2550

S2CRS6Codevarchar100

S2CRS6TeacherNamenvarchar2040

S2CRS6Titlevarchar2550

S2CRS7Codevarchar100

S2CRS7TeacherNamenvarchar2040

S2CRS7Titlevarchar2550

DiplomaTypevarchar2550

UsualNamenvarchar1000
vw_Base_Clever_EnrolmentsSchool_idvarchar100

Section_idvarchar120

Student_idbigint190
vw_Leaver_Report_Past_OntarioSchool Numbervarchar100

School Namevarchar2550

School Short Namevarchar100

OENvarchar120

Entry Datesmalldatetime160

Retirement Datesmalldatetime160

Destination Typevarchar1500

Destination Schoolvarchar1500

Status Codevarchar10

Status Namevarchar180

Given Namenvarchar1000

Usual Namenvarchar1000

Surnamenvarchar1000

Legal Surnamenvarchar1000

Genderchar10

Current Age (Yrs)int100

Home Phone Lives Withvarchar400

Home Phone Fathervarchar400

Home Phone Mothervarchar400

Given Name Lives Withnvarchar1000

Given Name Fathernvarchar1000

Given Name Mothernvarchar1000

OSSLT Statusvarchar140

Community Hours Completednumeric170

First Diplomavarchar500

Total Creditsdecimal382

Diploma Datedate100

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

Spec Ed Programvarchar1500

Gradevarchar30

Instructional Settingvarchar1500

Community Involement Completebit10

Homeroom Designationvarchar40

Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Special_Ed_Resourcesvarchar1500

Support_Servicevarchar1500

OYAPbit10

Cohort_Yearvarchar100
vw_Student_Timetable_ON_UpdatedSchool_Short_Namevarchar100

Surnamenvarchar1000

Given_Namenvarchar1000

OENvarchar120

SNbigint190

Gradevarchar30

Course_Codevarchar100

Class_Sectionchar20

Course_Numbervarchar100

Course_Gradevarchar30

Course_Titlevarchar2550

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alt_Teacher_Surnamenvarchar1000

Alt_Teacher_Given_Namenvarchar1000

Alt_Teacher_Numbervarchar250

Class_Start_Datedate100

Class_End_Datedate100

Is_Droppedbit10

Is_Next_Yearbit10

Is_Continuous_Entrybit10

Continuous_Entry_Start_Datedate100

Continuous_Entry_Completion_Datedate100

Course_Typevarchar500

Delivery_Typevarchar500

Attendance_Typevarchar500

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

Birthdatedate100

Genderchar10

Aboriginal_Self_IDvarchar1500

Exceptionality_1varchar1500

Exceptionality_2varchar1500

Exceptionality_3varchar1500

Placement_Settingvarchar1500

Entry_Datedate100

Retirement_Datedate100

Sem_Term_Patternvarchar300

Day_Per_Patternvarchar300

Drop_Datedate100

Credit_Attempteddecimal52

Stu_Enrol_IDuniqueidentifier160
vw_Base_Clever_SectionsSchool_idchar100

Section_idvarchar120

Teacher_idvarchar250

Teacher_2_idvarchar250

Course_namevarchar2550

Gradevarchar30
vw_Taking_Stock_ONSchool Numbervarchar100

School Namevarchar2550

School Short Namevarchar100

OENvarchar120

Student Board Residency Statusvarchar1500

Entry Datesmalldatetime160

Origin Typevarchar1500

Origin Schoolvarchar1500

Retirement Datesmalldatetime160

Destination Typevarchar1500

Destination Schoolvarchar1500

Status Codevarchar10

Status Namevarchar180

Given Namenvarchar1000

Usual Namenvarchar1000

Surnamenvarchar1000

Legal Surnamenvarchar1000

Genderchar10

Current Age (Yrs)int100

Home Phone Lives Withvarchar400

Home Phone Fathervarchar400

Home Phone Mothervarchar400

Given Name Lives Withnvarchar1000

Given Name Fathernvarchar1000

Given Name Mothernvarchar1000

OSSLT Statusvarchar140

OSSLT Non Participation Statusvarchar200

Community Hours Completednumeric170

Area of Requirementvarchar2550

First Diplomavarchar500

Total Creditsdecimal382

Diploma Datedate100

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

Spec Ed Programvarchar1500

Gradevarchar30

Instructional Settingvarchar1500

Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Support_Servicevarchar1500

Special_Ed_Resourcesvarchar1500

OYAPbit10

Exceptionality_2varchar1500

Exceptionality_3varchar1500
vw_PVNCCDSB_Transportation_NextYear_V2Student_Numbervarchar250

OEN_Numbervarchar120

Surnamenvarchar1000

Usual_Namenvarchar1000

Gradevarchar30

Birthdatedate100

Genderchar10

Apartment_Numbervarchar100

House_Numbervarchar100

Street_Namevarchar2550

Cityvarchar500

Postal_Codevarchar250

Townshipvarchar500

Home_Phonevarchar400

Attendance_Typevarchar500

School_Numbervarchar100

French_Immersion_Typevarchar1500

Homeroom_Numbervarchar50

Homeroom_Designationvarchar40

Homeroom_Designation_Next_Yearvarchar40

Grade_Next_Yearvarchar30

School_Short_Namevarchar100

Entry_Datedate100

Sitter_Namenvarchar2020

Sitter_House_Numbervarchar100

Sitter_Street_Namevarchar2550

Sitter_Cityvarchar500

Sitter_Postal_Codevarchar250

Sitter_Phone_Numbervarchar400

Mother_Titlenvarchar600

Mother_Given_Namenvarchar1000

Mother_Surnamenvarchar1000

Mothers_Cell_Phonevarchar400

Mother_Emailvarchar2550

Mother_House_Numbervarchar100

Mother_Street_Namevarchar2550

Mother_Cityvarchar500

Mother_Postal_Codevarchar250

Father_Titlenvarchar600

Father_Given_Namenvarchar1000

Father_Surnamenvarchar1000

Father_Cell_Phonevarchar400

Father_Emailvarchar2550

Father_House_Numbervarchar100

Father_Street_Namevarchar2550

Father_Cityvarchar500

Father_Postal_Codevarchar250

Emergency_Contact_Given_Namenvarchar1000

Emergency_Contact_Surnamenvarchar1000

Emergency_Contact_Cell_Phonevarchar400

Lives_Withvarchar1500

Special Custodybit10

PINnvarchar-10
vw_Base_Clever_StaffSchool_idvarchar100

Teacher_idvarchar250

Staff_emailvarchar2550

Titlenvarchar600

Last_namenvarchar1000

Middle_namenvarchar1000

First_namenvarchar1000

School_namevarchar2550

Staff_iduniqueidentifier160

IsTeacherbit10

IsBoardUserbit10
vw_MW_Credit_Req_Area_ProjectedSchool_IDuniqueidentifier160

School_Numbervarchar100

School_Codevarchar100

Person_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Status_IDuniqueidentifier160

mwStatusvarchar10

Student_OENvarchar120

Date_Of_Completionsmalldatetime160

Termvarchar10

Codechar100

Requirement_Area_Codevarchar20

Attempted_Credit_Valuedecimal52

Compulsory_Earned_Credit_Valuedecimal52

Optional_Earned_Credit_Valuedecimal52

Total_Earned_Credit_Valuedecimal62

Granting_Institutionchar100

Surnamenvarchar1000

Usual_Namenvarchar1000

Student_Gradevarchar30

Ministry_Numvarchar120

Category_Groupvarchar1000

Aboriginal_Status_Codechar100

Is_Transcriptbit10
vw_Base_Clever_StudentsSchool_idvarchar100

Student_idbigint190

Student_numbervarchar120

Last_namenvarchar1000

First_namenvarchar1000

Gradevarchar30

Genderchar10

Student_emailvarchar2550

Contact_phonevarchar400

School_namevarchar2550

Stu_Enrol_IDuniqueidentifier160

Contact_Lst_Lst_IDuniqueidentifier160
vw_PVNCCDSB_SEOS_Export_ElementarySchool_Short_Namevarchar100

OENvarchar120

LastNamenvarchar1000

FirstNamenvarchar1000

DOBdate100

Sexchar10

Addressvarchar2770

Cityvarchar500

Postal_Codevarchar250

Father_Namenvarchar2040

Father_WorkPhonevarchar400

Mother_Namenvarchar2040

Mother_WorkPhonevarchar400

Home_Phonevarchar400

Gradevarchar30

Homeroom_Teachernvarchar2040

Schoolvarchar2550

Midentvarchar100

Exceptionalityvarchar1500

DateLastIPRCvarchar80000

IEPvarchar30

Placementvarchar1500

SpecializedEquipmentvarchar1500

Absentdecimal41

Latesmallint50

AdmittedDatevarchar80000

HomeroomNumbervarchar50

HomeroomDesignationvarchar40

UsualNamenvarchar1000
vw_Base_Current_Archive_Achievement_ONSchool_Short_Namevarchar100

Class_Codevarchar130

Class_Credit_Valuenumeric52

Student_Class_Statusvarchar70

Semester_Term_Pattern_Namevarchar300

Delivery_Typevarchar500

Type_Of_Coursevarchar500

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Teacher_Numbervarchar250

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Alternate_Teacher_Numbervarchar250

Student_Surnamenvarchar1000

Student_Given_Namenvarchar1000

OENvarchar120

Student_Statusvarchar180

Main_Schoolvarchar1500

Student_Board_Residence_Statusvarchar1500

Con_Ed_Student_Typevarchar1500

Genderchar10

Home_Concurrent_Statuschar10

Student_Phone_Numbervarchar400

Student_Emailvarchar2550

Parent_Email_1varchar2550

Parent_Email_2varchar2550

Scl_Year_Info_IDuniqueidentifier160

Enrol_IDuniqueidentifier160

Code_IDuniqueidentifier160

Class_IDuniqueidentifier160

List_IDuniqueidentifier160

Add_Datedate100

Drop_Datedate100

Homeroom_Designationvarchar40

Homeroom_Roomvarchar50

Person_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Student_Gradevarchar30

ContEntry_Active_Datedate100

ContEntry_Completion_Datedate100

School_Namevarchar2550

Stu_Info_IDuniqueidentifier160

Calendar_Start_Datesmalldatetime160

Calendar_End_Datesmalldatetime160

School_Yearvarchar100

TT_Class_IDuniqueidentifier160
vw_PVNCCDSB_SEOS_Export_SecondaryOENvarchar120

LastNamenvarchar1000

FirstNamenvarchar1000

DOBdate100

Sexchar10

Addressvarchar2770

Cityvarchar500

Postal_Codevarchar250

Father_Namenvarchar2040

Father_WorkPhonevarchar400

Mother_Namenvarchar2040

Mother_WorkPhonevarchar400

Home_Phonevarchar400

Gradevarchar30

Homeroom_Teachernvarchar2040

HomeroomNumbervarchar50

HomeroomDesignationvarchar40

Schoolvarchar2550

Midentvarchar100

Exceptionalityvarchar1500

DateLastIPRCdate100

IEPbit10

AdmittedDatedate100

Placementvarchar1500

tTotalAbsentint100

tTotalLateint100

SpecializedEquipmentvarchar1500

S1CRS1Codevarchar100

S1CRS1TeacherNamenvarchar2040

S1CRS1Titlevarchar2550

S1CRS1Latesmallint50

S1CRS1Absentsmallint50

S1CRS2Codevarchar100

S1CRS2TeacherNamenvarchar2040

S1CRS2Titlevarchar2550

S1CRS2Latesmallint50

S1CRS2Absentsmallint50

S1CRS3Codevarchar100

S1CRS3TeacherNamenvarchar2040

S1CRS3Titlevarchar2550

S1CRS3Latesmallint50

S1CRS3Absentsmallint50

S1CRS4Codevarchar100

S1CRS4TeacherNamenvarchar2040

S1CRS4Titlevarchar2550

S1CRS4Latesmallint50

S1CRS4Absentsmallint50

S1CRS5Codevarchar100

S1CRS5TeacherNamenvarchar2040

S1CRS5Titlevarchar2550

S1CRS5Latesmallint50

S1CRS5Absentsmallint50

S1CRS6Codevarchar100

S1CRS6TeacherNamenvarchar2040

S1CRS6Titlevarchar2550

S1CRS6Latesmallint50

S1CRS6Absentsmallint50

S2CRS1Codevarchar100

S2CRS1TeacherNamenvarchar2040

S2CRS1Titlevarchar2550

S2CRS1Latesmallint50

S2CRS1Absentsmallint50

S2CRS2Codevarchar100

S2CRS2TeacherNamenvarchar2040

S2CRS2Titlevarchar2550

S2CRS2Latesmallint50

S2CRS2Absentsmallint50

S2CRS3Codevarchar100

S2CRS3TeacherNamenvarchar2040

S2CRS3Titlevarchar2550

S2CRS3Latesmallint50

S2CRS3Absentsmallint50

S2CRS4Codevarchar100

S2CRS4TeacherNamenvarchar2040

S2CRS4Titlevarchar2550

S2CRS4Latesmallint50

S2CRS4Absentsmallint50

S2CRS5Codevarchar100

S2CRS5TeacherNamenvarchar2040

S2CRS5Titlevarchar2550

S2CRS5Latesmallint50

S2CRS5Absentsmallint50

S2CRS6Codevarchar100

S2CRS6TeacherNamenvarchar2040

S2CRS6Titlevarchar2550

S2CRS6Latesmallint50

S2CRS6Absentsmallint50

Attainmentvarchar2550
vw_Base_LockersSchool_Short_Namevarchar100

Locker_Numvarchar500

Availablebit10

Max_Studentssmallint50

Combinationnvarchar400

Locker_Bankvarchar500

Lock_Serial_Numbernvarchar400

Surnamenvarchar1000

Given_Namenvarchar1000

Gradevarchar30

Locker_IDuniqueidentifier160

Lock_IDuniqueidentifier160

Locker_Typeuniqueidentifier160

Lock_Brand_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

School_IDuniqueidentifier160
vw_Elementary_Average_OntarioSchool_Yearvarchar100

Schoolvarchar2550

Sur_Namenvarchar1000

Given_Namenvarchar1000

Gradevarchar20

Termvarchar500

OENvarchar120

DateOfBirthdate100

Roomchar50

Designationvarchar40

StuAverageint100

MW Statusvarchar180

School_Short_Namevarchar100
vw_Base_Student_EnrolmentsSchool_Short_Namevarchar100

School_Numbervarchar100

Ministry_Num_Fmtvarchar120

Stu_Numbervarchar250

Surnamenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Entry_Datedate100

Origin_Type_Codevarchar100

Origin_Typevarchar1500

Origin_School_Numbervarchar100

Origin_Schoolvarchar1500

Retirement_Datedate100

Destination_Type_Codevarchar100

Destination_Typevarchar1500

Destination_School_Numbervarchar100

Destination_Schoolvarchar1500
vw_PVNC_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

Entry_Date_To_Boarddate100

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

Stu_Enrol_IDuniqueidentifier160

Person_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160
vw_Student_Incidents_with_MonthSchool_Short_Namevarchar100

School_Namevarchar2550

Ministry_Numvarchar120

Student_Numbervarchar250

Surnamenvarchar1000

Given_Namenvarchar1000

Incident_Datedate100

Incident_Monthnvarchar600

Incident_Yearnvarchar600

Infractionsnvarchar-10

Consequencenvarchar2000

Durationnumeric52

Notenvarchar-10

Genderchar10

Gradevarchar30

Incident_Notenvarchar-10

Is_Special_Edbit10

Spec_Ed_Statusvarchar80

Exceptionalitiesnvarchar-10
vw_Base_UserViewsview_namevarchar500

User_Namevarchar1500

Rolenchar200

row_restrictionbit10

row_querynvarchar-10

column_querynvarchar-10
vw_Base_TranscriptsTranscript_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Code_Def_IDuniqueidentifier160

School_Short_Namevarchar100

Ministry_Num_Fmtvarchar120

Surnamenvarchar1000

Usual_Namenvarchar1000

Student_Gradevarchar30

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Course_Codechar100

Course_Numberchar100

Course_Titlevarchar2550

Transcript_Datedate100

Markvarchar30

Languagevarchar1500

Course_Typevarchar500

Delivery_Typevarchar500

Credit_Attempteddecimal52

Credit_Earneddecimal52

PLE_Creditsdecimal72

Code_IDuniqueidentifier160

Att_Absentdecimal50

Att_Excuseddecimal50

Att_Latedecimal50

Att_Possibledecimal41

Scl_Year_Info_IDuniqueidentifier160

Achieved_At_Schoolvarchar1500

Birthdatedate100

Person_IDuniqueidentifier160

Mark_Numericsmallint50
vw_Clever_Enrolments_UpdatedSchool_idvarchar100

Section_idvarchar230

Student_idvarchar120
vw_Student_Incidents_PVNCSchool_Short_Namevarchar100

School_Namevarchar2550

Ministry_Numvarchar120

Student_Numbervarchar250

Surnamenvarchar1000

Given_Namenvarchar1000

Birthdatedate100

Incident_Datedate100

Incident_Monthnvarchar600

Incident_Yearnvarchar600

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
vw_Base_UserFieldsUser_Namevarchar1500

view_namevarchar500

field_iduniqueidentifier160

field_namevarchar500

field_type_convvarchar500

Parent_Object_IDint100

user_type_idint100

namesysname2560

max_lengthsmallint50

Column_Ordinalint100

view_iduniqueidentifier160

user_iduniqueidentifier160

Date_Addeddatetime233

Date_Modifiednchar200
vw_History_Credit_SummaryPerson_IDuniqueidentifier160

HCSchoolchar10

Sur_Namenvarchar1000

Given_Namenvarchar1000

Birthdatedate100

Genderchar10

School_Namevarchar2550

School_Numbervarchar100

Student_Numbervarchar250

Compulsory_Creditsdecimal382

Credit_Earneddecimal382

Categoryvarchar1000

OENvarchar120

Gradevarchar30

mwStatusvarchar180

SHSMbit10

School_Short_Namevarchar100

Area_Of_Requirementvarchar2550

Defined_Character_1varchar30

Defined_Character_2varchar30

Defined_Character_3varchar30

Defined_Character_4varchar30
vw_Clever_Schools_UpdatedSchool_idvarchar100

School_namevarchar2550

School_numbervarchar100

State_idvarchar100

Low_Gradechar30

High_Gradechar30

Principalnvarchar2640
vw_MW_Exam_ScheduleSchoolvarchar2550

SchoolNumberchar100

SchoolShortNamevarchar100

CourseCodechar100

ClassSectionchar20

ExamDaychar10

ExamPeriodvarchar10

Semestertinyint30

Termtinyint30

ExamDatedate100

FixedDayint100

FixedPeriodint100

Class_IDuniqueidentifier160
vw_Clever_Staff_UpdatedSchool_idvarchar100

Staff_idvarchar250

Staff_emailvarchar2550

First_namenvarchar1000

Last_namenvarchar1000

Departmentvarchar1500

Titlenvarchar2000

Usernamevarchar2550

Passwordvarchar10

Rolevarchar10
vw_Pathway_Ontario_BaseSchool Numbervarchar100

School Namevarchar2550

OENvarchar120

Student Last Namenvarchar1000

Student Usual Namenvarchar1000

Street Addressvarchar2660

Cityvarchar500

Postal Codevarchar250

Student Email Addressvarchar2550

Student Phone Numbervarchar400

Genderchar10

DOBdate100

Gradevarchar30

Course Start Datedate100

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

Stu_Enrol_IDuniqueidentifier160

School_Short_Namevarchar100

Homeroom_Designationvarchar40

Homeroom_Numbervarchar50

Homeroom_Teacher_Surnamenvarchar1000

Homeroom_Teacher_Given_Namenvarchar1000

Homeroom_Teacher_Numbervarchar250

Homeroom_Alt_Teacher_Surnamenvarchar1000

Homeroom_Alt_Teacher_Given_Namenvarchar1000

Homeroom_Alt_Teacher_Numbervarchar250

OYAPbit10

Is_Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Special_Ed_Resourcesvarchar1500

Exceptionality_1varchar1500

Exceptionality_2varchar1500

Exceptionality_3varchar1500
vw_Clever_Students_UpdatedSchool_idvarchar100

Student_idvarchar120

Student_numberbigint190

State_idvarchar120

Last_namenvarchar1000

Middle_Namenvarchar1000

First_namenvarchar1000

Gradevarchar30

Genderchar10

Graduation yeardate100

DOB- date of birthdate100

racevarchar10

Hispanic_Latinovarchar10

Home_languagevarchar1500

ELL_statusvarchar10

Frl_statusvarchar10

IEP_statusvarchar10

Student_streetvarchar10

Student_cityvarchar10

Student_statevarchar10

student_zipvarchar10

Student_emailvarchar2550

Contact_relationshipvarchar10

Contact_typevarchar10

Contact_namevarchar10

Contact_phonevarchar10

Contact_phone_typevarchar10

Contact_emailvarchar10

Contact_sis_idvarchar10

Usernamevarchar2550

Passwordvarchar10

Unweighted_GPAvarchar10

Weighted_GPAvarchar10

ext*varchar10
vw_PVNCCDSB_Transportation_TLDSBStudent 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_PVNCCDSB_Class_Drop_CountsSchool_Short_Namevarchar100

Course_Codevarchar100

Class_Sectionvarchar20

Course_Gradevarchar30

Teacher_Surnamenvarchar1000

Teacher_GivenNamenvarchar1000

Teacher_Titlenvarchar600

StaffNumberbigint190

Semestertinyint30

Periodtinyint30

Number_Students_Enrolled_On_FirstDayint100

Number_Students_Currently_Enrolledint100

Number_Students_Dropped_Classint100

Class_IDuniqueidentifier160
vw_Adult_Ed_Taking_StockSchool Numbervarchar100

School Namevarchar2550

School Short Namevarchar100

OENvarchar120

Entry Datesmalldatetime160

Retirement Datesmalldatetime160

Destination Typevarchar1500

Destination Schoolvarchar1500

Status Codevarchar10

Status Namevarchar180

Given Namenvarchar1000

Usual Namenvarchar1000

Surnamenvarchar1000

Legal Surnamenvarchar1000

Genderchar10

Current Age (Yrs)int100

Home Phone Lives Withvarchar400

Home Phone Fathervarchar400

Home Phone Mothervarchar400

Given Name Lives Withnvarchar1000

Given Name Fathernvarchar1000

Given Name Mothernvarchar1000

OSSLT Statusvarchar140

Community Hours Completednumeric170

First Diplomavarchar500

Total Creditsdecimal382

Diploma Datedate100

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

Spec Ed Programvarchar1500

Gradevarchar30

Instructional Settingvarchar1500

Community Involement Completebit10

OSSLT Non Participation Statusvarchar200

Homeroom Designationvarchar40

Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Support_Servicevarchar1500

Special_Ed_Resourcesvarchar1500

Calendar Start Datesmalldatetime160

Student Board Residency Statusvarchar1500

Stu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

OYAPbit10

Exceptionality_2varchar1500

Exceptionality_3varchar1500

Cohort_Yearvarchar100
vw_Student_EnrolmentSchool_Short_Namevarchar100

School_Namevarchar2550

Student_Numberbigint190

Ministry_Num_Fmtvarchar120

Surnamenvarchar1000

Given_Namenvarchar1000

Gradevarchar30

Birthdatedate100

Genderchar10

Entry_Datedate100

Enrolment_Reasonvarchar1500

Retirement_Datedate100

Enrolment_Resultvarchar1500

Citizenshipvarchar1500

First_Languagevarchar1500

Student_Enrolment_Statusvarchar180

Home_Schoolbit10

Indian_Registry_Numbervarchar120

Residence_Statusvarchar1500

Band_Of_Residencevarchar1500

Reserve_Of_Residencevarchar1500

Band_Of_Financial_Responsibilityvarchar1500

Is_Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Exceptionality_2varchar1500

Exceptionality_3varchar1500

Stu_Enrol_IDuniqueidentifier160

Person_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160
vw_Clever_Teachers_UpdatedSchool_idvarchar100

Teacher_idvarchar250

Teacher_numbervarchar250

State_teacher_idchar150

Teacher_emailvarchar2550

First_namenvarchar1000

Middle_namenvarchar1000

Last_namenvarchar1000

Titlenvarchar600

Usernamevarchar2550

Passwordvarchar10
vw_Student_Special_Education_FullPerson_IDuniqueidentifier160

Stu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

School_Short_Namevarchar100

Surnamenvarchar1000

Usual_Namenvarchar1000

Birthdatedate100

Genderchar10

Min_Numbervarchar120

Gradevarchar30

Stu_Statusvarchar180

Stu_Status_Codevarchar10

Spec_Ed_Statusvarchar80

Exceptionality_Placement_Numbertinyint30

Exceptionality_Codevarchar100

Exceptionalityvarchar1500

Execptionality_Start_Datedate100

Exceptionality_End_Datedate100

Placementvarchar1500

Placement_Start_Datedate100

Placement_End_Datedate100

Special_Ed_Programvarchar1500

Support_Servicevarchar1500

Special_Ed_Resourcesvarchar1500

IEP_Withnvarchar-10

IEPbit10

Special_Edbit10
vw_Clever_Sections_UpdatedSchool_idchar100

Section_idvarchar230

Teacher_idvarchar250

Teacher_2_idvarchar250

Teacher_3_idvarchar10

Teacher_4_idvarchar10

Teacher_5_idvarchar10

Teacher_6_idvarchar10

Teacher_7_idvarchar10

Teacher_8_idvarchar10

Teacher_9_idvarchar10

Teacher_10_idvarchar10

Namevarchar10

Section_numberchar20

Gradevarchar30

Course_namevarchar100

Course_Numbervarchar10

Course_descriptionvarchar5000

Periodtinyint30

Subjectvarchar10

Term_namevarchar300

Term_startvarchar300

Term_endvarchar300
vw_PVNC_Scheduling_Classes_OntarioSchool_Namevarchar2550

School_Numberchar100

Class_Codevarchar100

Section_Letterchar20

Departmentvarchar1500

Semester_Term_Patternvarchar300

Period_Patternvarchar300

Course_Typevarchar500

Dual_Credit_Course_Typevarchar1500

Deliveryvarchar500

Credit_Valuenumeric52

Languagevarchar1500

Reportablebit10

Teacher_Surnamenvarchar1000

Teacher_Given_Namenvarchar1000

Alternate_Teacher_Surnamenvarchar1000

Alternate_Teacher_Given_Namenvarchar1000

Occupancyint100

School_Short_Namevarchar100

Course_Titlevarchar2550

Dual_Credit_Course_Assocvarchar1720
vw_PVNC_Student_EnrolmentStu_Enrol_IDuniqueidentifier160

IsSchedulingtinyint30

Scl_Year_Info_IDuniqueidentifier160

IsCurrentbit10

School_IDuniqueidentifier160

School_Yearvarchar100

Person_IDuniqueidentifier160

Oenint100

IsHomeSchoolbit10

This_Sch_Entry_Datesmalldatetime160

Retirement_Datesmalldatetime160

Gradechar30

Homeroom_IDuniqueidentifier160

FrenchProgramvarchar1500

mwStatuschar10

StatusTextvarchar300

Accum_Std_Creditsdecimal52

Accum_OAC_Creditsdecimal52

Elem_Entry_Datesmalldatetime160

Sec_Entry_Datesmalldatetime160

Fre_Imm_Minsmallint50

Special_Edbit10

Special_Ed_Statuschar10

English_Language_Learnervarchar500

Short_Namevarchar100

Date_Importeddatetime233
vw_Archive_Achievement_MarksClass_IDuniqueidentifier160

School_Yearvarchar100

Schoolvarchar2550

School_Short_Namevarchar100

Sur_Namenvarchar1000

Given_Namenvarchar1000

Usual_Namenvarchar1000

Ministry_Numvarchar80000

Classvarchar100

Sectionvarchar20

Class_Gradevarchar30

Teachernvarchar2640

Termvarchar500

Topicvarchar2550

Markvarchar60

Overridevarchar60

Mark_Last_Modifieddatetime233

Commentvarchar-10

Person_IDuniqueidentifier160

School_IDuniqueidentifier160

Term_Codevarchar50

Topic_Codevarchar50

Final_Topicbit10

Student_Gradevarchar20

Final_Termbit10

Homeroom_Roomvarchar50

Homeroom_Designationvarchar100

Genderchar10

Aboriginal_Status_Codechar100

Aboriginal_Status_Titlevarchar1500

Surnamenvarchar1000

Class_Titlevarchar2550

Alternate_Teachernvarchar2640

Timetable_Add_Or_Dropchar10

Enrol_IDuniqueidentifier160

Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Special_Ed_Programvarchar1500

Support_Servicevarchar1500

Special_Ed_Resourcesvarchar1500

SubmissionDatedate100
vw_Base_OnlineRegistrationDetailsStu_LegalLastNamenvarchar2560

Stu_LegalFirstNamenvarchar2560

Reg_Gradenvarchar500

Reg_ExpectedEntryDatedatetime233

Reg_DateCreateddatetime233

Rel_IsBaptizednvarchar200

Rel_ParishNamenvarchar2000
vw_PVNCCDSB_Transportation_NextYearOnlyStudent_Numbervarchar250

OEN_Numbervarchar120

Surnamenvarchar1000

Usual_Namenvarchar1000

Gradevarchar30

Birthdatedate100

Genderchar10

Apartment_Numbervarchar100

House_Numbervarchar100

Street_Namevarchar2550

Cityvarchar500

Postal_Codevarchar250

Townshipvarchar500

Home_Phonevarchar400

Attendance_Typevarchar500

School_Numbervarchar100

French_Immersion_Typevarchar1500

Homeroom_Numbervarchar50

Homeroom_Designationvarchar40

Homeroom_Designation_Next_Yearvarchar40

Grade_Next_Yearvarchar30

School_Short_Namevarchar100

Entry_Datedate100

Sitter_Namenvarchar2020

Sitter_House_Numbervarchar100

Sitter_Street_Namevarchar2550

Sitter_Cityvarchar500

Sitter_Postal_Codevarchar250

Sitter_Phone_Numbervarchar400

Mother_Titlenvarchar600

Mother_Given_Namenvarchar1000

Mother_Surnamenvarchar1000

Mothers_Cell_Phonevarchar400

Mother_Emailvarchar2550

Mother_House_Numbervarchar100

Mother_Street_Namevarchar2550

Mother_Cityvarchar500

Mother_Postal_Codevarchar250

Father_Titlenvarchar600

Father_Given_Namenvarchar1000

Father_Surnamenvarchar1000

Father_Cell_Phonevarchar400

Father_Emailvarchar2550

Father_House_Numbervarchar100

Father_Street_Namevarchar2550

Father_Cityvarchar500

Father_Postal_Codevarchar250

Emergency_Contact_Given_Namenvarchar1000

Emergency_Contact_Surnamenvarchar1000

Emergency_Contact_Cell_Phonevarchar400

Lives_Withvarchar1500

Special Custodybit10
vw_History_Total_CreditsPerson_IDuniqueidentifier160

Sur_Namenvarchar1000

Given_Namenvarchar1000

Student_Numbervarchar250

Birthdatedate100

Genderchar10

School_Numbervarchar100

School_Namevarchar2550

OENvarchar120

Gradevarchar30

Total_Creditsdecimal382

Total_Optionaldecimal382

Total_Compulsorydecimal382

mwStatusvarchar180

School_Short_Namevarchar100

Area_Of_Requirementvarchar2550

Defined_Character_1varchar30

Defined_Character_2varchar30

Defined_Character_3varchar30

Defined_Character_4varchar30
vw_Elementary_Achievment_ONTSchool_Yearvarchar100

School_Numbervarchar100

Schoolvarchar2550

OENvarchar120

Sur_Namenvarchar1000

Given_Namenvarchar1000

Genderchar10

Gradevarchar20

Term_Codevarchar50

Topic_Codevarchar50

Termvarchar500

Topicvarchar2550

Markdecimal133

MW Statusvarchar180

Birthdatedate100

Room_Numberchar50

Designationvarchar40

Achieve_Homeroomvarchar50

Achieve_Homeroom_Designationvarchar100

Person_IDuniqueidentifier160

Raw_Markvarchar60

School_Short_Namevarchar100

Is_Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

Exceptionalitiesnvarchar-10

Stu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

Aboriginal_Self_IDvarchar1500
vw_Student_Timetable_PNVCCourse_Codevarchar100

Is_Droppedbit10

Stu_Enrol_IDuniqueidentifier160

class_iduniqueidentifier160

Course_Titlevarchar2550

Scl_Year_Info_IDuniqueidentifier160
vw_Leaver_Report_Base_OntarioSchool Numbervarchar100

School Namevarchar2550

School Short Namevarchar100

OENvarchar120

Entry Datesmalldatetime160

Retirement Datesmalldatetime160

Destination Typevarchar1500

Destination Schoolvarchar1500

Status Codevarchar10

Status Namevarchar180

Given Namenvarchar1000

Usual Namenvarchar1000

Surnamenvarchar1000

Legal Surnamenvarchar1000

Genderchar10

Current Age (Yrs)int100

Home Phone Lives Withvarchar400

Home Phone Fathervarchar400

Home Phone Mothervarchar400

Given Name Lives Withnvarchar1000

Given Name Fathernvarchar1000

Given Name Mothernvarchar1000

OSSLT Statusvarchar140

Community Hours Completednumeric170

First Diplomavarchar500

Total Creditsdecimal382

Diploma Datedate100

Defined Character 1varchar30

Defined Character 2varchar30

Defined Character 3varchar30

Defined Character 4varchar30

Spec Ed Programvarchar1500

Gradevarchar30

Instructional Settingvarchar1500

Community Involement Completebit10

OSSLT Non Participation Statusvarchar200

Homeroom Designationvarchar40

Special_Edbit10

Spec_Ed_Statusvarchar80

IEPbit10

IEP_Withnvarchar-10

Exceptionality_1varchar1500

Support_Servicevarchar1500

Special_Ed_Resourcesvarchar1500

Calendar Start Datedate100

Student Board Residency Statusvarchar1500

Stu_Enrol_IDuniqueidentifier160

Scl_Year_Info_IDuniqueidentifier160

OYAPbit10

Exceptionality_2varchar1500

Exceptionality_3varchar1500

Cohort_Yearvarchar100