View Name | Column | Data Type | Size | Scale |
vw_MW_Class_SemOccur | Class_ID | uniqueidentifier | 16 | 0 |
Semester | varchar | 2 | 0 | |
vw_PVNCCDSB_Transportation_NextYear | Student number | varchar | 25 | 0 |
Surname | nvarchar | 100 | 0 | |
Given name | nvarchar | 100 | 0 | |
Grade | varchar | 3 | 0 | |
Apartment number | varchar | 10 | 0 | |
House number | varchar | 10 | 0 | |
Street name | varchar | 255 | 0 | |
City | varchar | 50 | 0 | |
Postal code | varchar | 25 | 0 | |
Phone number | varchar | 40 | 0 | |
Sitter's name | nvarchar | 202 | 0 | |
Sitter's house number | varchar | 10 | 0 | |
Sitter's street name | varchar | 255 | 0 | |
Sitter's city | varchar | 50 | 0 | |
Sitter's postal code | varchar | 25 | 0 | |
Sitter's phone number | varchar | 40 | 0 | |
Birthdate | date | 10 | 0 | |
Gender | char | 1 | 0 | |
Attendance type | varchar | 50 | 0 | |
Township | varchar | 50 | 0 | |
School number | varchar | 10 | 0 | |
French immersion type | varchar | 150 | 0 | |
Homeroom number | varchar | 5 | 0 | |
Homeroom designation | varchar | 4 | 0 | |
Grade next year | varchar | 3 | 0 | |
OEN number | varchar | 12 | 0 | |
School short name | varchar | 10 | 0 | |
Entry date | date | 10 | 0 | |
Mother's title | nvarchar | 60 | 0 | |
Mother's given name | nvarchar | 100 | 0 | |
Mother's surname | nvarchar | 100 | 0 | |
Mother's house number | varchar | 10 | 0 | |
Mother's street name | varchar | 255 | 0 | |
Mother's city | varchar | 50 | 0 | |
Mother's postal code | varchar | 25 | 0 | |
Father's title | nvarchar | 60 | 0 | |
Father's given name | nvarchar | 100 | 0 | |
Father's surname | nvarchar | 100 | 0 | |
Father's house number | varchar | 10 | 0 | |
Father's street name | varchar | 255 | 0 | |
Father's city | varchar | 50 | 0 | |
Father's postal code | varchar | 25 | 0 | |
Homeroom designation next year | varchar | 4 | 0 | |
Lives With | varchar | 150 | 0 | |
Special Custody | bit | 1 | 0 | |
vw_MW_Course_Num_Classes | Code | char | 10 | 0 |
Code_ID | uniqueidentifier | 16 | 0 | |
Num_Classes | int | 10 | 0 | |
Scl_Year_info_ID | uniqueidentifier | 16 | 0 | |
vw_MW_Credit_Req_Area | School_ID | uniqueidentifier | 16 | 0 |
School_Number | varchar | 10 | 0 | |
School_Code | varchar | 10 | 0 | |
Person_ID | uniqueidentifier | 16 | 0 | |
Stu_Enrol_ID | uniqueidentifier | 16 | 0 | |
Status_ID | uniqueidentifier | 16 | 0 | |
mwStatus | varchar | 1 | 0 | |
Student_OEN | varchar | 12 | 0 | |
DateOfCompletion | smalldatetime | 16 | 0 | |
Term | varchar | 1 | 0 | |
Code | char | 10 | 0 | |
Requirement_Area_Code | varchar | 2 | 0 | |
Attempted_Credit_Value | decimal | 5 | 2 | |
Compulsory_Earned_Credit_Value | decimal | 5 | 2 | |
Optional_Earned_Credit_Value | decimal | 5 | 2 | |
Total_Earned_Credit_Value | decimal | 5 | 2 | |
Granting_Institution | char | 10 | 0 | |
Surname | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
Student_Grade | varchar | 3 | 0 | |
Ministry_Num | varchar | 12 | 0 | |
Category_Group | varchar | 100 | 0 | |
Aboriginal_Status_Code | char | 10 | 0 | |
vw_MW_Student_Cal | Scl_Year_Info_ID | uniqueidentifier | 16 | 0 |
Stu_Enrol_ID | uniqueidentifier | 16 | 0 | |
Scl_Cal_Lst_ID | uniqueidentifier | 16 | 0 | |
Cal_Date | date | 10 | 0 | |
DayOfCycle | tinyint | 3 | 0 | |
AttType | char | 1 | 0 | |
Sem_Number | tinyint | 3 | 0 | |
Term_Number | tinyint | 3 | 0 | |
Day_Number | tinyint | 3 | 0 | |
vw_PVNC_Student_Origin_School | School_Short_Name | varchar | 10 | 0 |
origin | varchar | 10 | 0 | |
origin_status | varchar | 18 | 0 | |
School_Name | varchar | 255 | 0 | |
City | varchar | 50 | 0 | |
Homeroom_Designation | varchar | 4 | 0 | |
Homroom_Room_Number | varchar | 5 | 0 | |
Homeroom_Teacher_Surname | nvarchar | 100 | 0 | |
Homeroom_Teacher_Given_Name | nvarchar | 100 | 0 | |
Homeroom_Teacher_Number | varchar | 25 | 0 | |
Ministry_Number | varchar | 12 | 0 | |
Student_Number | bigint | 19 | 0 | |
name | nvarchar | 204 | 0 | |
Grade | varchar | 3 | 0 | |
Birthdate | date | 10 | 0 | |
Stu_Status | varchar | 18 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
Contact_Number | bigint | 19 | 0 | |
Contact_Type | varchar | 255 | 0 | |
contactName | nvarchar | 204 | 0 | |
Contact_Work_Phone_Number | varchar | 40 | 0 | |
Contact_Cell_Phone_Number | varchar | 40 | 0 | |
Contact_Home_Phone_Number | varchar | 40 | 0 | |
Contact_Email_Address | varchar | 255 | 0 | |
Contact_Address | nvarchar | -1 | 0 | |
Emergency_Contact_Number | smallint | 5 | 0 | |
Consent | nvarchar | 200 | 0 | |
ConsentReceivedDate | date | 10 | 0 | |
vw_MW_Student_Cal_NoAttType | Scl_Year_Info_ID | uniqueidentifier | 16 | 0 |
Stu_Enrol_ID | uniqueidentifier | 16 | 0 | |
Cal_Date | date | 10 | 0 | |
DayOfCycle | tinyint | 3 | 0 | |
vw_MW_Student_Cal_WClasses | Stu_Enrol_ID | uniqueidentifier | 16 | 0 |
Scl_Year_Info_ID | uniqueidentifier | 16 | 0 | |
Cal_Date | date | 10 | 0 | |
DayOfCycle | tinyint | 3 | 0 | |
AttType | char | 1 | 0 | |
Class_ID | uniqueidentifier | 16 | 0 | |
Scl_Cal_Lst_ID | uniqueidentifier | 16 | 0 | |
Sem_Number | tinyint | 3 | 0 | |
Term_Number | tinyint | 3 | 0 | |
Day_Number | tinyint | 3 | 0 | |
vw_MW_Student_HalfDay_Att | Scl_Year_Info_ID | uniqueidentifier | 16 | 0 |
Stu_Enrol_ID | uniqueidentifier | 16 | 0 | |
Cal_Date | date | 10 | 0 | |
DayOfCycle | tinyint | 3 | 0 | |
AttType | char | 1 | 0 | |
AM_Reg | char | 1 | 0 | |
PM_Reg | char | 1 | 0 | |
AM_Attend | char | 1 | 0 | |
PM_Attend | char | 1 | 0 | |
AM_Rept | char | 1 | 0 | |
PM_Rept | char | 1 | 0 | |
Sur_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
OEN | varchar | 12 | 0 | |
Grade | varchar | 3 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
School_Name | varchar | 255 | 0 | |
AM_Attendance_Reason_Code | varchar | 50 | 0 | |
AM_Attendance_Reason | varchar | 150 | 0 | |
PM_Attendance_Reason_Code | varchar | 50 | 0 | |
PM_Attendance_Reason | varchar | 150 | 0 | |
Stu_Letters | char | 3 | 0 | |
vw_MW_Student_Period_Attend | Stu_Enrol_ID | uniqueidentifier | 16 | 0 |
Scl_Year_Info_ID | uniqueidentifier | 16 | 0 | |
Cal_Date | date | 10 | 0 | |
DayOfCycle | tinyint | 3 | 0 | |
AttType | char | 1 | 0 | |
Class_ID | uniqueidentifier | 16 | 0 | |
Period_Attend | char | 1 | 0 | |
Attend_Rept | char | 1 | 0 | |
Attend_Reg | char | 1 | 0 | |
Per_Number | tinyint | 3 | 0 | |
Sur_Name | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
OEN | varchar | 12 | 0 | |
Grade | varchar | 3 | 0 | |
Scheduling | bit | 1 | 0 | |
Period_Attend_Title | varchar | 50 | 0 | |
Attendance_Reason_Code | varchar | 50 | 0 | |
Attendance_Reason | varchar | 150 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
Course_Code | varchar | 10 | 0 | |
Class_Section | char | 2 | 0 | |
Sem_Number | tinyint | 3 | 0 | |
Term_Number | tinyint | 3 | 0 | |
Day_Number | tinyint | 3 | 0 | |
Stu_Letters | char | 3 | 0 | |
vw_Base_PVNCCDSB_SEOS_Export | Stu_Enrol_ID | uniqueidentifier | 16 | 0 |
person_id | uniqueidentifier | 16 | 0 | |
OEN | varchar | 12 | 0 | |
LastName | nvarchar | 100 | 0 | |
FirstName | nvarchar | 100 | 0 | |
DOB | date | 10 | 0 | |
Sex | char | 1 | 0 | |
Address | varchar | 277 | 0 | |
City | varchar | 50 | 0 | |
Postal_Code | varchar | 25 | 0 | |
Father_Name | nvarchar | 204 | 0 | |
Father_WorkPhone | varchar | 40 | 0 | |
Mother_Name | nvarchar | 204 | 0 | |
Mother_WorkPhone | varchar | 40 | 0 | |
Home_Phone | varchar | 40 | 0 | |
grade_id | uniqueidentifier | 16 | 0 | |
Grade | varchar | 3 | 0 | |
Homeroom_Teacher | nvarchar | 204 | 0 | |
HomeroomNumber | varchar | 5 | 0 | |
HomeroomDesignation | varchar | 4 | 0 | |
School | varchar | 255 | 0 | |
Mident | varchar | 10 | 0 | |
MapleID | varchar | 25 | 0 | |
Exceptionality | varchar | 150 | 0 | |
DateLastIPRC | date | 10 | 0 | |
IEP | bit | 1 | 0 | |
AdmittedDate | date | 10 | 0 | |
Placement | varchar | 150 | 0 | |
SpecializedEquipment | varchar | 150 | 0 | |
DiplomaType | varchar | 255 | 0 | |
vw_Student_Incidents_All | School_Short_Name | varchar | 10 | 0 |
Ministry_Num | varchar | 12 | 0 | |
Student_Number | varchar | 25 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Incident_Date | date | 10 | 0 | |
Infractions | nvarchar | -1 | 0 | |
Consequence | nvarchar | 200 | 0 | |
Duration | numeric | 5 | 2 | |
Note | nvarchar | -1 | 0 | |
Gender | char | 1 | 0 | |
Grade | varchar | 3 | 0 | |
Incident_Note | nvarchar | -1 | 0 | |
Is_Special_Ed | bit | 1 | 0 | |
Spec_Ed_Status | varchar | 8 | 0 | |
Exceptionalities | nvarchar | -1 | 0 | |
IncidentNumber | nvarchar | 40 | 0 | |
Imposed_By_Role | nvarchar | 14 | 0 | |
Imposed_By_Surname | varchar | 50 | 0 | |
Imposed_By_Given_Name | varchar | 50 | 0 | |
Consequence_Start_Date | date | 10 | 0 | |
Consequence_End_Date | date | 10 | 0 | |
Location | nvarchar | 200 | 0 | |
Timeframe | nvarchar | 200 | 0 | |
Stu_Status | varchar | 18 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
Suspension_Expulsion_Program | nvarchar | 200 | 0 | |
Violent_Incident | bit | 1 | 0 | |
Weapsons_Used | bit | 1 | 0 | |
Police_Reported | bit | 1 | 0 | |
Primary_Infraction | nvarchar | 220 | 0 | |
Secondary_Infractions | nvarchar | -1 | 0 | |
Student_Birthdate | date | 10 | 0 | |
Student_Age_At_Incident | int | 10 | 0 | |
School_Name | varchar | 255 | 0 | |
vw_Student_SHSM_ON | Mident School# | varchar | 10 | 0 |
School Name | varchar | 10 | 0 | |
First Name | nvarchar | 100 | 0 | |
Last Name | nvarchar | 100 | 0 | |
OEN | varchar | 12 | 0 | |
StudentCode | varchar | 25 | 0 | |
Stu_Status | varchar | 18 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
SHSM | varchar | 255 | 0 | |
Pathway | varchar | 100 | 0 | |
Reach Ahead | varchar | 3 | 0 | |
Ontario Skills Passport | varchar | 3 | 0 | |
Experiential Learning | varchar | 3 | 0 | |
Required Certificates and Training Completed | varchar | 3 | 0 | |
Sector-partnered Contextualized experience | varchar | 3 | 0 | |
Innovation, Creativity, and Entrepreneurship | varchar | 3 | 0 | |
Coding | varchar | 3 | 0 | |
Mathematical Literacy | varchar | 3 | 0 | |
SHSM Completion Date | date | 10 | 0 | |
Certificate 1 | varchar | 150 | 0 | |
Certificate 2 | varchar | 150 | 0 | |
Certificate 3 | varchar | 150 | 0 | |
Certificate 4 | varchar | 150 | 0 | |
Certificate 5 | varchar | 150 | 0 | |
Certificate 6 | varchar | 150 | 0 | |
Certificate 7 | varchar | 150 | 0 | |
Certificate 8 | varchar | 150 | 0 | |
Certificate 9 | varchar | 150 | 0 | |
Certificate 10 | varchar | 150 | 0 | |
Grade | varchar | 3 | 0 | |
Gender | char | 1 | 0 | |
Aboriginal_Self_ID | varchar | 150 | 0 | |
Spec_Ed_Status | varchar | 8 | 0 | |
Entry_Date | date | 10 | 0 | |
Retirement_Date | date | 10 | 0 | |
Diploma_Earned | varchar | 255 | 0 | |
Diploma_Date | date | 10 | 0 | |
Total_SHSM_Credits_Earned | decimal | 38 | 2 | |
Total_Major_Earned | decimal | 38 | 2 | |
Total_Major_Required | decimal | 38 | 2 | |
Total_Major_Remaining | decimal | 38 | 2 | |
Total_CoOp_Earned | decimal | 38 | 2 | |
Total_CoOp_Required | decimal | 38 | 2 | |
Total_CoOp_Remaining | decimal | 38 | 2 | |
Total_English_Earned | decimal | 38 | 2 | |
Total_English_Required | decimal | 38 | 2 | |
Total_English_Remaining | decimal | 38 | 2 | |
Total_Math_Earned | decimal | 38 | 2 | |
Total_Math_Required | decimal | 38 | 2 | |
Total_Math_Remaining | decimal | 38 | 2 | |
Total_Other_Earned | decimal | 38 | 2 | |
Total_Other_Required | decimal | 38 | 2 | |
Total_Other_Remaining | decimal | 38 | 2 | |
Mandatory_Certificates_Earned | int | 10 | 0 | |
Total_Mandatory_Certificates | tinyint | 3 | 0 | |
Elective_Certificates_Earned | int | 10 | 0 | |
Total_Elective_Certificates | tinyint | 3 | 0 | |
Board_Resident_Status | varchar | 150 | 0 | |
Is_Special_Ed | bit | 1 | 0 | |
Exceptionalities | nvarchar | -1 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
Community_Hours_Completed | numeric | 19 | 2 | |
Total_Credits | decimal | 38 | 2 | |
OSSLT_Status | varchar | 14 | 0 | |
OSSLT_Non_Participation_Status | varchar | 20 | 0 | |
Instructional_Setting | varchar | 150 | 0 | |
vw_Transcripts_ON_with_IEP | Transcript_ID | uniqueidentifier | 16 | 0 |
Stu_Enrol_ID | uniqueidentifier | 16 | 0 | |
Code_Def_ID | uniqueidentifier | 16 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
OEN | varchar | 12 | 0 | |
Sur_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
Stu_Status | varchar | 18 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
Course_Code | char | 10 | 0 | |
Course_Title | varchar | 255 | 0 | |
Transcript_Date | date | 10 | 0 | |
Mark | char | 2 | 0 | |
Credit_Earned | decimal | 7 | 2 | |
Language | varchar | 150 | 0 | |
Course_Type | varchar | 50 | 0 | |
Delivery_Type | varchar | 50 | 0 | |
Credit_Attempted | decimal | 5 | 2 | |
Is_Special_Ed | bit | 1 | 0 | |
Spec_Ed_Status | varchar | 8 | 0 | |
Exceptionalities | nvarchar | -1 | 0 | |
vw_Student_SHSM_Projected_ON | Mident School# | varchar | 10 | 0 |
School Name | varchar | 10 | 0 | |
First Name | nvarchar | 100 | 0 | |
Last Name | nvarchar | 100 | 0 | |
OEN | varchar | 12 | 0 | |
StudentCode | varchar | 25 | 0 | |
Stu_Status | varchar | 18 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
SHSM | varchar | 255 | 0 | |
Pathway | varchar | 100 | 0 | |
Reach Ahead | varchar | 3 | 0 | |
Ontario Skills Passport | varchar | 3 | 0 | |
Experiential Learning | varchar | 3 | 0 | |
Required Certificates and Training Completed | varchar | 3 | 0 | |
Sector-partnered Contextualized experience | varchar | 3 | 0 | |
Innovation, Creativity, and Entrepreneurship | varchar | 3 | 0 | |
Coding | varchar | 3 | 0 | |
Mathematical Literacy | varchar | 3 | 0 | |
SHSM Completion Date | date | 10 | 0 | |
Certificate 1 | varchar | 150 | 0 | |
Certificate 2 | varchar | 150 | 0 | |
Certificate 3 | varchar | 150 | 0 | |
Certificate 4 | varchar | 150 | 0 | |
Certificate 5 | varchar | 150 | 0 | |
Certificate 6 | varchar | 150 | 0 | |
Certificate 7 | varchar | 150 | 0 | |
Certificate 8 | varchar | 150 | 0 | |
Certificate 9 | varchar | 150 | 0 | |
Certificate 10 | varchar | 150 | 0 | |
Grade | varchar | 3 | 0 | |
Gender | char | 1 | 0 | |
Aboriginal_Self_ID | varchar | 150 | 0 | |
Spec_Ed_Status | varchar | 8 | 0 | |
Entry_Date | date | 10 | 0 | |
Retirement_Date | date | 10 | 0 | |
Diploma_Earned | varchar | 255 | 0 | |
Diploma_Date | date | 10 | 0 | |
Projected_Total_SHSM_Credits_Earned | decimal | 38 | 2 | |
Projected_Total_Major_Earned | decimal | 38 | 2 | |
Total_Major_Required | decimal | 38 | 2 | |
Projected_Total_Major_Remaining | decimal | 38 | 2 | |
Projected_Total_CoOp_Earned | decimal | 38 | 2 | |
Total_CoOp_Required | decimal | 38 | 2 | |
Projected_Total_CoOp_Remaining | decimal | 38 | 2 | |
Projected_Total_English_Earned | decimal | 38 | 2 | |
Total_English_Required | decimal | 38 | 2 | |
Projected_Total_English_Remaining | decimal | 38 | 2 | |
Projected_Total_Math_Earned | decimal | 38 | 2 | |
Total_Math_Required | decimal | 38 | 2 | |
Projected_Total_Math_Remaining | decimal | 38 | 2 | |
Projected_Total_Other_Earned | decimal | 38 | 2 | |
Total_Other_Required | decimal | 38 | 2 | |
Projected_Total_Other_Remaining | decimal | 38 | 2 | |
Mandatory_Certificates_Earned | int | 10 | 0 | |
Total_Mandatory_Certificates | tinyint | 3 | 0 | |
Elective_Certificates_Earned | int | 10 | 0 | |
Total_Elective_Certificates | tinyint | 3 | 0 | |
Board_Resident_Status | varchar | 150 | 0 | |
Is_Special_Ed | bit | 1 | 0 | |
Exceptionalities | nvarchar | -1 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
Community_Hours_Completed | numeric | 19 | 2 | |
Total_Credits | decimal | 38 | 2 | |
OSSLT_Status | varchar | 14 | 0 | |
OSSLT_Non_Participation_Status | varchar | 20 | 0 | |
Instructional_Setting | varchar | 150 | 0 | |
Total_Credits_Projected | decimal | 38 | 2 | |
vw_French_Immersion_Report_ON | Surname | nvarchar | 100 | 0 |
Given_Name | nvarchar | 100 | 0 | |
OEN | varchar | 12 | 0 | |
Gender | char | 1 | 0 | |
Grade | varchar | 3 | 0 | |
Birthdate | date | 10 | 0 | |
School_Mident | varchar | 10 | 0 | |
School_Name | varchar | 255 | 0 | |
HCSchool | char | 1 | 0 | |
Stu_Status | varchar | 18 | 0 | |
French_Immersion_Program | varchar | 150 | 0 | |
End_Date | date | 10 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
ESL | bit | 1 | 0 | |
ELD | bit | 1 | 0 | |
French_Immersion_Minutes | smallint | 5 | 0 | |
Aboriginal_Program | varchar | 150 | 0 | |
Aboriginal_Minutes | smallint | 5 | 0 | |
Special_Ed_Status | varchar | 8 | 0 | |
Next_Year_Grade | varchar | 3 | 0 | |
Homeroom_Room | varchar | 5 | 0 | |
Homeroom_Designation | varchar | 4 | 0 | |
Exceptionalities | nvarchar | -1 | 0 | |
Entry_Date_To_Canada | date | 10 | 0 | |
Country_Of_Birth | varchar | 150 | 0 | |
vw_Base_Students_PVNC | Stu_Enrol_ID | uniqueidentifier | 16 | 0 |
Person_ID | uniqueidentifier | 16 | 0 | |
School_ID | uniqueidentifier | 16 | 0 | |
Contact_Lst_Lst_ID | uniqueidentifier | 16 | 0 | |
Homeroom_ID | uniqueidentifier | 16 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
School_Name | varchar | 255 | 0 | |
Ministry_Num_Fmt | varchar | 12 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
Birthdate | date | 10 | 0 | |
Gender | char | 1 | 0 | |
Grade_ID | uniqueidentifier | 16 | 0 | |
Grade | varchar | 3 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
Stu_Status | varchar | 18 | 0 | |
HCSchool | char | 1 | 0 | |
Scheduling | bit | 1 | 0 | |
School_Number | varchar | 10 | 0 | |
Special_Ed | bit | 1 | 0 | |
Stu_Number | varchar | 25 | 0 | |
vw_French_Immersion_Report_Scheduling_ON | Surname | nvarchar | 100 | 0 |
Given_Name | nvarchar | 100 | 0 | |
OEN | varchar | 12 | 0 | |
Gender | char | 1 | 0 | |
Grade | varchar | 3 | 0 | |
Birthdate | date | 10 | 0 | |
School_Mident | varchar | 10 | 0 | |
School_Name | varchar | 255 | 0 | |
HCSchool | char | 1 | 0 | |
Stu_Status | varchar | 18 | 0 | |
French_Immersion_Program | varchar | 150 | 0 | |
End_Date | date | 10 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
ESL | bit | 1 | 0 | |
ELD | bit | 1 | 0 | |
French_Immersion_Minutes | smallint | 5 | 0 | |
Aboriginal_Program | varchar | 150 | 0 | |
Aboriginal_Minutes | smallint | 5 | 0 | |
Special_Ed_Status | varchar | 8 | 0 | |
Next_Year_Grade | varchar | 3 | 0 | |
Homeroom_Room | varchar | 5 | 0 | |
Homeroom_Designation | varchar | 4 | 0 | |
Exceptionalities | nvarchar | -1 | 0 | |
Entry_Date_To_Canada | date | 10 | 0 | |
Country_Of_Birth | varchar | 150 | 0 | |
vw_Base_Students_PVNC_Elementary | Stu_Enrol_ID | uniqueidentifier | 16 | 0 |
Person_ID | uniqueidentifier | 16 | 0 | |
Contact_Lst_Lst_ID | uniqueidentifier | 16 | 0 | |
Homeroom_ID | uniqueidentifier | 16 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
School_Name | varchar | 255 | 0 | |
Ministry_Num_Fmt | varchar | 12 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
Birthdate | date | 10 | 0 | |
Gender | char | 1 | 0 | |
Grade_ID | uniqueidentifier | 16 | 0 | |
Grade | varchar | 3 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
Stu_Status | varchar | 18 | 0 | |
HCSchool | char | 1 | 0 | |
Scheduling | bit | 1 | 0 | |
School_Number | varchar | 10 | 0 | |
Special_Ed | bit | 1 | 0 | |
Stu_Number | varchar | 25 | 0 | |
vw_Base_PVNCCDSB_SEOS_Export_Secondary | Stu_Enrol_ID | uniqueidentifier | 16 | 0 |
person_id | uniqueidentifier | 16 | 0 | |
Ministry_Num_Fmt | varchar | 12 | 0 | |
LastName | nvarchar | 100 | 0 | |
FirstName | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
DOB | date | 10 | 0 | |
Sex | char | 1 | 0 | |
Address | varchar | 277 | 0 | |
City | varchar | 50 | 0 | |
Postal_Code | varchar | 25 | 0 | |
Father_Name | nvarchar | 204 | 0 | |
Father_WorkPhone | varchar | 40 | 0 | |
Mother_Name | nvarchar | 204 | 0 | |
Mother_WorkPhone | varchar | 40 | 0 | |
Home_Phone | varchar | 40 | 0 | |
grade_id | uniqueidentifier | 16 | 0 | |
Grade | varchar | 3 | 0 | |
Homeroom_ID | uniqueidentifier | 16 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
School | varchar | 255 | 0 | |
school_ID | uniqueidentifier | 16 | 0 | |
school_number | varchar | 10 | 0 | |
MapleID | varchar | 25 | 0 | |
Exceptionality | varchar | 150 | 0 | |
DateLastIPRC | date | 10 | 0 | |
IEP | bit | 1 | 0 | |
AdmittedDate | date | 10 | 0 | |
Placement | varchar | 150 | 0 | |
SpecializedEquipment | varchar | 150 | 0 | |
DiplomaType | varchar | 255 | 0 | |
Homeroom_Teacher | nvarchar | 204 | 0 | |
HomeroomNumber | varchar | 5 | 0 | |
HomeroomDesignation | varchar | 4 | 0 | |
vw_Base_PVNCCDSB_SEOS_Export_Elementary | Stu_Enrol_ID | uniqueidentifier | 16 | 0 |
OEN | varchar | 12 | 0 | |
LastName | nvarchar | 100 | 0 | |
FirstName | nvarchar | 100 | 0 | |
UsualName | nvarchar | 100 | 0 | |
DOB | date | 10 | 0 | |
Sex | char | 1 | 0 | |
Address | varchar | 277 | 0 | |
City | varchar | 50 | 0 | |
Postal_Code | varchar | 25 | 0 | |
Father_Name | nvarchar | 204 | 0 | |
Father_WorkPhone | varchar | 40 | 0 | |
Mother_Name | nvarchar | 204 | 0 | |
Mother_WorkPhone | varchar | 40 | 0 | |
Home_Phone | varchar | 40 | 0 | |
Grade | varchar | 3 | 0 | |
Homeroom_Teacher | nvarchar | 204 | 0 | |
HomeroomNumber | varchar | 5 | 0 | |
HomeroomDesignation | varchar | 4 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
School | varchar | 255 | 0 | |
Mident | varchar | 10 | 0 | |
MapleID | varchar | 25 | 0 | |
Exceptionality | varchar | 150 | 0 | |
DateLastIPRC | date | 10 | 0 | |
IEP | bit | 1 | 0 | |
AdmittedDate | date | 10 | 0 | |
Placement | varchar | 150 | 0 | |
SpecializedEquipment | varchar | 150 | 0 | |
vw_Staff_Status_All | School_Short_Name | varchar | 10 | 0 |
School_Name | varchar | 255 | 0 | |
School_Number | varchar | 10 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Staff_Role | varchar | 255 | 0 | |
Ministry_Number | varchar | 15 | 0 | |
Employee_Number | varchar | 25 | 0 | |
Email_Address | varchar | 255 | 0 | |
City | varchar | 50 | 0 | |
Province | varchar | 50 | 0 | |
Status | varchar | 30 | 0 | |
Status_Code | char | 1 | 0 | |
Home_Phone_Number | varchar | 40 | 0 | |
Cell_Phone_Number | varchar | 40 | 0 | |
vw_Student_Early_Year_Questions_1_2_5_6_ON | School_Short_Name | varchar | 10 | 0 |
OEN | varchar | 12 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
Online_Reg | bit | 1 | 0 | |
Grade | varchar | 3 | 0 | |
Grade_Next_Year | varchar | 3 | 0 | |
Entry_Date | date | 10 | 0 | |
Entered_Into_Maplewood_Date | date | 10 | 0 | |
Origin_code | varchar | 183 | 0 | |
Age_Of_Child | varchar | 150 | 0 | |
Parent_Guardian_Care_FT | bit | 1 | 0 | |
Parent_Guardian_Care_PT | bit | 1 | 0 | |
Unpaid_Care_FT | bit | 1 | 0 | |
Unpaid_Care_PT | bit | 1 | 0 | |
Paid_Care_FT | bit | 1 | 0 | |
Paid_Care_PT | bit | 1 | 0 | |
Licensed_Home_Child_Care_FT | bit | 1 | 0 | |
Licensed_Home_Child_Care_PT | bit | 1 | 0 | |
Licensed_Child_Care_Centre_FT | bit | 1 | 0 | |
Licensed_Child_Care_Centre_PT | bit | 1 | 0 | |
Not_Applicable | bit | 1 | 0 | |
Question2 | nvarchar | 200 | 0 | |
Question5 | varchar | 150 | 0 | |
Question6 | varchar | 150 | 0 | |
vw_Student_Early_Year_Questions_3_4_7_ON | School_Short_Name | varchar | 10 | 0 |
OEN | varchar | 12 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
Online_Reg | bit | 1 | 0 | |
Grade | varchar | 3 | 0 | |
Grade_Next_Year | varchar | 3 | 0 | |
Entry_Date | date | 10 | 0 | |
Entered_Into_Maplewood_Date | date | 10 | 0 | |
Origin_code | varchar | 183 | 0 | |
Question3_Factor1 | varchar | 150 | 0 | |
Question3_Factor2 | varchar | 150 | 0 | |
Question3_Factor3 | varchar | 150 | 0 | |
Question4 | bit | 1 | 0 | |
Question7_Factor1 | varchar | 150 | 0 | |
Question7_Factor2 | varchar | 150 | 0 | |
Question7_Factor3 | varchar | 150 | 0 | |
vw_Student_Enrolment_MB | School_Short_Name | varchar | 10 | 0 |
School_Name | varchar | 255 | 0 | |
Student_Number | bigint | 19 | 0 | |
MET | varchar | 12 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Grade | varchar | 3 | 0 | |
Birthdate | date | 10 | 0 | |
Gender | char | 1 | 0 | |
Entry_Date | date | 10 | 0 | |
Enrolment_Reason | varchar | 150 | 0 | |
Retirement_Date | date | 10 | 0 | |
Enrolment_Result | varchar | 150 | 0 | |
Newcomer_EAL | varchar | 150 | 0 | |
Newcomer_Additional_French_Support | bit | 1 | 0 | |
Language_Program_1 | varchar | 150 | 0 | |
Language_Program_2 | varchar | 150 | 0 | |
Language_Program_3 | varchar | 150 | 0 | |
Language_Program_4 | varchar | 150 | 0 | |
Enrolled_Pupil | bit | 1 | 0 | |
Citizenship | varchar | 150 | 0 | |
First_Language | varchar | 150 | 0 | |
Student_Enrolment_Status | varchar | 18 | 0 | |
Home_School | bit | 1 | 0 | |
Enrolment_Type | varchar | 150 | 0 | |
Residence_Division | varchar | 150 | 0 | |
Foreign_Exhange_Sponsor | varchar | 150 | 0 | |
Indian_Registry_Number | varchar | 12 | 0 | |
Residence_Status | varchar | 150 | 0 | |
Band_Of_Residence | varchar | 150 | 0 | |
Reserve_Of_Residence | varchar | 150 | 0 | |
Band_Of_Financial_Responsibility | varchar | 150 | 0 | |
Aboriginal_Identity_1 | varchar | 150 | 0 | |
Aboriginal_Identity_2 | varchar | 150 | 0 | |
Aboriginal_Identity_3 | varchar | 150 | 0 | |
Abroiginal_Identity_Description | varchar | 25 | 0 | |
Is_Special_Ed | bit | 1 | 0 | |
Spec_Ed_Status | varchar | 8 | 0 | |
IEP | bit | 1 | 0 | |
Stu_Enrol_ID | uniqueidentifier | 16 | 0 | |
Person_ID | uniqueidentifier | 16 | 0 | |
Scl_Year_Info_ID | uniqueidentifier | 16 | 0 | |
vw_Student_Enrolment_ON | School_Short_Name | varchar | 10 | 0 |
School_Name | varchar | 255 | 0 | |
Student_Number | bigint | 19 | 0 | |
OEN | varchar | 12 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Grade | varchar | 3 | 0 | |
Birthdate | date | 10 | 0 | |
Gender | char | 1 | 0 | |
Entry_Date | date | 10 | 0 | |
Enrolment_Reason | varchar | 150 | 0 | |
Retirement_Date | date | 10 | 0 | |
Enrolment_Result | varchar | 150 | 0 | |
Citizenship | varchar | 150 | 0 | |
Resident_Type | varchar | 150 | 0 | |
Country_Of_Birth | varchar | 150 | 0 | |
Base_School | varchar | 150 | 0 | |
Tax_Support | varchar | 150 | 0 | |
First_Language | varchar | 150 | 0 | |
Student_Enrolment_Status | varchar | 18 | 0 | |
Home_School | bit | 1 | 0 | |
Indian_Registry_Number | varchar | 12 | 0 | |
Residence_Status | varchar | 150 | 0 | |
Band_Of_Residence | varchar | 150 | 0 | |
Reserve_Of_Residence | varchar | 150 | 0 | |
Band_Of_Financial_Responsibility | varchar | 150 | 0 | |
Aboriginal_Status_Code | varchar | 150 | 0 | |
Aboriginal_Self_ID | varchar | 150 | 0 | |
Is_Special_Ed | bit | 1 | 0 | |
Spec_Ed_Status | varchar | 8 | 0 | |
IEP | bit | 1 | 0 | |
IEP_With | nvarchar | -1 | 0 | |
Exceptionality_1 | varchar | 150 | 0 | |
Exceptionality_2 | varchar | 150 | 0 | |
Exceptionality_3 | varchar | 150 | 0 | |
ESL | bit | 1 | 0 | |
ELD | bit | 1 | 0 | |
French_Program | varchar | 150 | 0 | |
Payment_Of_Other_Pupils_Fees | varchar | 150 | 0 | |
Stu_Enrol_ID | uniqueidentifier | 16 | 0 | |
Person_ID | uniqueidentifier | 16 | 0 | |
Scl_Year_Info_ID | uniqueidentifier | 16 | 0 | |
vw_Archive_Achievement_Schedule | Class_ID | uniqueidentifier | 16 | 0 |
School_Year | varchar | 10 | 0 | |
School | varchar | 255 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
Class | varchar | 10 | 0 | |
Section | varchar | 2 | 0 | |
Class_Grade | varchar | 3 | 0 | |
Teacher | nvarchar | 264 | 0 | |
Class_Sem | tinyint | 3 | 0 | |
Class_Term | tinyint | 3 | 0 | |
Class_Day | tinyint | 3 | 0 | |
Class_Period | tinyint | 3 | 0 | |
vw_Choices_Summary_ON | School_Short_Name | varchar | 10 | 0 |
Course_Code | char | 10 | 0 | |
Course_Title | varchar | 255 | 0 | |
Course_Grade | char | 3 | 0 | |
Credit_Value | decimal | 5 | 2 | |
Type_Of_Course | varchar | 120 | 0 | |
Department | varchar | 150 | 0 | |
Course_Type | varchar | 50 | 0 | |
Delivery_Type | varchar | 50 | 0 | |
Language | varchar | 150 | 0 | |
Dual_Credit_Course_Type | varchar | 150 | 0 | |
Stu_Count | int | 10 | 0 | |
Stu_Count_Mandatory | int | 10 | 0 | |
Stu_Count_Elective | int | 10 | 0 | |
Stu_Count_Alternate | int | 10 | 0 | |
vw_Class_Achievement_Setup | School_Short_Name | varchar | 10 | 0 |
Course_Code | varchar | 10 | 0 | |
Class_Section | char | 2 | 0 | |
Course_Number | varchar | 10 | 0 | |
Course_Grade | varchar | 3 | 0 | |
Teacher_Surname | nvarchar | 100 | 0 | |
Teacher_Given_Name | nvarchar | 100 | 0 | |
Alt_Teacher_Surname | nvarchar | 100 | 0 | |
Alt_Teacher_Given_Name | nvarchar | 100 | 0 | |
Occupancy | int | 10 | 0 | |
Language | varchar | 150 | 0 | |
Grouped_Classes | nvarchar | -1 | 0 | |
Achievement_Terms | nvarchar | -1 | 0 | |
Achievement_Topics | nvarchar | -1 | 0 | |
Semester_Term_Pattern | nvarchar | -1 | 0 | |
vw_PVNCCDSB_Transportation_STSCO | Student number | varchar | 25 | 0 |
Surname | nvarchar | 100 | 0 | |
Given name | nvarchar | 100 | 0 | |
Grade | varchar | 3 | 0 | |
Apartment number | varchar | 10 | 0 | |
House number | varchar | 10 | 0 | |
Street name | varchar | 255 | 0 | |
City | varchar | 50 | 0 | |
Postal code | varchar | 25 | 0 | |
Phone number | varchar | 40 | 0 | |
Sitter's name | nvarchar | 202 | 0 | |
Sitter's house number | varchar | 10 | 0 | |
Sitter's street name | varchar | 255 | 0 | |
Sitter's city | varchar | 50 | 0 | |
Sitter's postal code | varchar | 25 | 0 | |
Sitter's phone number | varchar | 40 | 0 | |
Birthdate | date | 10 | 0 | |
Gender | char | 1 | 0 | |
Attendance type | varchar | 50 | 0 | |
Township | varchar | 50 | 0 | |
School number | varchar | 10 | 0 | |
French immersion type | varchar | 150 | 0 | |
Homeroom number | varchar | 5 | 0 | |
Homeroom designation | varchar | 4 | 0 | |
Grade next year | varchar | 3 | 0 | |
OEN number | varchar | 12 | 0 | |
School short name | varchar | 10 | 0 | |
Entry date | date | 10 | 0 | |
Mother's title | nvarchar | 60 | 0 | |
Mother's given name | nvarchar | 100 | 0 | |
Mother's surname | nvarchar | 100 | 0 | |
Mother's house number | varchar | 10 | 0 | |
Mother's street name | varchar | 255 | 0 | |
Mother's city | varchar | 50 | 0 | |
Mother's postal code | varchar | 25 | 0 | |
Father's title | nvarchar | 60 | 0 | |
Father's given name | nvarchar | 100 | 0 | |
Father's surname | nvarchar | 100 | 0 | |
Father's house number | varchar | 10 | 0 | |
Father's street name | varchar | 255 | 0 | |
Father's city | varchar | 50 | 0 | |
Father's postal code | varchar | 25 | 0 | |
Homeroom designation next year | varchar | 4 | 0 | |
Lives With | varchar | 150 | 0 | |
Special Custody | bit | 1 | 0 | |
vw_Classes_Days_Taught | Class_ID | uniqueidentifier | 16 | 0 |
School_Short_Name | varchar | 10 | 0 | |
Class | varchar | 13 | 0 | |
Course_Code | varchar | 10 | 0 | |
Course_Number | varchar | 10 | 0 | |
Course_Grade | varchar | 3 | 0 | |
Class_Section | varchar | 2 | 0 | |
Class_Start_Date | date | 10 | 0 | |
Class_End_Date | date | 10 | 0 | |
Days_Taught | int | 10 | 0 | |
vw_PVNCCDSB_Attendance_Rate_HalfDay | School_Short_Name | varchar | 10 | 0 |
Grade | varchar | 3 | 0 | |
Sep_Attend_Pct | decimal | 9 | 6 | |
Oct_Attend_Pct | decimal | 9 | 6 | |
Nov_Attend_Pct | decimal | 9 | 6 | |
Dec_Attend_Pct | decimal | 9 | 6 | |
Jan_Attend_Pct | decimal | 9 | 6 | |
Feb_Attend_Pct | decimal | 9 | 6 | |
Mar_Attend_Pct | decimal | 9 | 6 | |
Apr_Attend_Pct | decimal | 9 | 6 | |
May_Attend_Pct | decimal | 9 | 6 | |
Jun_Attend_Pct | decimal | 9 | 6 | |
S1_Attend_Pct | decimal | 9 | 6 | |
S2_Attend_Pct | decimal | 9 | 6 | |
Attend_Pct | decimal | 9 | 6 | |
Retention_Pct | decimal | 9 | 6 | |
vw_connectEd_Security_User_Permissions | School_Short_Name | varchar | 10 | 0 |
connectEd_User_Name | varchar | 100 | 0 | |
connectEd_Full_Name | varchar | 255 | 0 | |
connectEd_User_Group | varchar | 25 | 0 | |
Staff_Name | varchar | 100 | 0 | |
Student_Surname | varchar | 50 | 0 | |
Student_Given_Name | varchar | 50 | 0 | |
Student_Usual_Name | varchar | 50 | 0 | |
connectEd_Document_Hierarchy | nvarchar | -1 | 0 | |
CanView | bit | 1 | 0 | |
CanAdd | bit | 1 | 0 | |
CanEdit | bit | 1 | 0 | |
CanDelete | bit | 1 | 0 | |
vw_PVNCCDSB_Transportation_Export | Student number | varchar | 25 | 0 |
Surname | nvarchar | 100 | 0 | |
Given name | nvarchar | 100 | 0 | |
Grade | varchar | 3 | 0 | |
Apartment number | varchar | 10 | 0 | |
House number | varchar | 10 | 0 | |
Street name | varchar | 255 | 0 | |
City | varchar | 50 | 0 | |
Postal code | varchar | 25 | 0 | |
Sitter's name | nvarchar | 202 | 0 | |
Sitter's house number | varchar | 10 | 0 | |
Sitter's street name | varchar | 255 | 0 | |
Sitter's city | varchar | 50 | 0 | |
Sitter's postal code | varchar | 25 | 0 | |
Sitter's phone number | varchar | 40 | 0 | |
Birthdate | date | 10 | 0 | |
Gender | char | 1 | 0 | |
Attendance type | varchar | 50 | 0 | |
Township | varchar | 50 | 0 | |
School number | varchar | 10 | 0 | |
French immersion type | varchar | 150 | 0 | |
Homeroom number | varchar | 5 | 0 | |
Homeroom designation | varchar | 4 | 0 | |
Grade next year | varchar | 3 | 0 | |
OEN number | varchar | 12 | 0 | |
School short name | varchar | 10 | 0 | |
Entry date | date | 10 | 0 | |
Mother's title | nvarchar | 60 | 0 | |
Mother's given name | nvarchar | 100 | 0 | |
Mother's surname | nvarchar | 100 | 0 | |
Mother's house number | varchar | 10 | 0 | |
Mother's street name | varchar | 255 | 0 | |
Mother's city | varchar | 50 | 0 | |
Mother's postal code | varchar | 25 | 0 | |
Father's title | nvarchar | 60 | 0 | |
Father's given name | nvarchar | 100 | 0 | |
Father's surname | nvarchar | 100 | 0 | |
Father's house number | varchar | 10 | 0 | |
Father's street name | varchar | 255 | 0 | |
Father's city | varchar | 50 | 0 | |
Father's postal code | varchar | 25 | 0 | |
Homeroom designation next year | varchar | 4 | 0 | |
Lives With | varchar | 150 | 0 | |
Special Custody | bit | 1 | 0 | |
vw_Course_Substitutions_ON | School_Short_Name | varchar | 10 | 0 |
School_Name | varchar | 255 | 0 | |
Scheduling | bit | 1 | 0 | |
Course_Code | varchar | 10 | 0 | |
Course_Number | varchar | 10 | 0 | |
Grade | varchar | 3 | 0 | |
Credit_Value | decimal | 5 | 2 | |
Course_Type | varchar | 50 | 0 | |
Delivery_Type | varchar | 50 | 0 | |
Language | varchar | 150 | 0 | |
Effective_Date | date | 10 | 0 | |
Expiration_Date | date | 10 | 0 | |
Substitution | bit | 1 | 0 | |
Category | nvarchar | -1 | 0 | |
SHSM_Category | nvarchar | -1 | 0 | |
vw_PVNCCSDB_Attendance_Rate_Period | School_Short_Name | varchar | 10 | 0 |
Grade | varchar | 3 | 0 | |
Sep_Attend_Pct | decimal | 9 | 6 | |
Oct_Attend_Pct | decimal | 9 | 6 | |
Nov_Attend_Pct | decimal | 9 | 6 | |
Dec_Attend_Pct | decimal | 9 | 6 | |
Jan_Attend_Pct | decimal | 9 | 6 | |
Feb_Attend_Pct | decimal | 9 | 6 | |
Mar_Attend_Pct | decimal | 9 | 6 | |
Apr_Attend_Pct | decimal | 9 | 6 | |
May_Attend_Pct | decimal | 9 | 6 | |
Jun_Attend_Pct | decimal | 9 | 6 | |
S1_Attend_Pct | decimal | 9 | 6 | |
S2_Attend_Pct | decimal | 9 | 6 | |
Attend_Pct | decimal | 9 | 6 | |
Retention_Pct | decimal | 9 | 6 | |
vw_Courses_ON | School_Short_Name | varchar | 10 | 0 |
Course_Code | varchar | 10 | 0 | |
Course_Number | varchar | 10 | 0 | |
Scheduling | bit | 1 | 0 | |
Required_For_Transcripts | bit | 1 | 0 | |
Course_Title | varchar | 255 | 0 | |
Title_Matches_Code | bit | 1 | 0 | |
Language | varchar | 150 | 0 | |
Weight | char | 1 | 0 | |
Exclude_From_OnSIS | bit | 1 | 0 | |
Show_In_Online_Choices | bit | 1 | 0 | |
Department | varchar | 150 | 0 | |
Grade | char | 3 | 0 | |
Credit_Value | decimal | 5 | 2 | |
Categories | nvarchar | -1 | 0 | |
SHSM_Categories | nvarchar | -1 | 0 | |
SHSM_Program_Association | nvarchar | -1 | 0 | |
Course_Type | varchar | 50 | 0 | |
Dual_Credits_Type | varchar | 150 | 0 | |
Delivery_Type | varchar | 50 | 0 | |
vw_Grade_10_Literacy_Ontario | School_Name | varchar | 255 | 0 |
OEN | varchar | 8000 | 0 | |
Sur_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
Grade | char | 3 | 0 | |
Grade_6_EQAO_Reading | real | 24 | 0 | |
Grade_6_EQAO_Writing | real | 24 | 0 | |
Grade_6_EQAO_Math | real | 24 | 0 | |
Grade_9_English_Course | varchar | 10 | 0 | |
Grade_9_English_Mark | varchar | 30 | 0 | |
Grade_9_Geography_Course | varchar | 10 | 0 | |
Grade_9_Geography_Mark | varchar | 30 | 0 | |
Grade_9_Science_Course | varchar | 10 | 0 | |
Grade_9_Science_Mark | varchar | 30 | 0 | |
Grade_10_English_Course | varchar | 10 | 0 | |
Grade_10_English_Mark | varchar | 30 | 0 | |
Spring_OCA_Q1_Result | varchar | 10 | 0 | |
Spring_OCA_Q2_Result | varchar | 10 | 0 | |
Spring_OCA_Q3_Result | varchar | 10 | 0 | |
Spring_OCA_Q4_Result | varchar | 10 | 0 | |
Spring_OCA_Q5_Result | varchar | 10 | 0 | |
Literacy_Status | char | 1 | 0 | |
OSSLT | varchar | 50 | 0 | |
IEP | bit | 1 | 0 | |
IEPWith | nvarchar | -1 | 0 | |
Support_Service | varchar | 150 | 0 | |
Exceptionality_1 | varchar | 150 | 0 | |
Achieved | bit | 1 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
vw_PVNC_French_Immersion_Report_All_ON | Surname | nvarchar | 100 | 0 |
Given_Name | nvarchar | 100 | 0 | |
OEN | varchar | 12 | 0 | |
Gender | char | 1 | 0 | |
Grade | varchar | 3 | 0 | |
Birthdate | date | 10 | 0 | |
School_Mident | varchar | 10 | 0 | |
School_Name | varchar | 255 | 0 | |
HCSchool | char | 1 | 0 | |
Stu_Status | varchar | 18 | 0 | |
Sec_Entry_Date | smalldatetime | 16 | 0 | |
Entry_Date | date | 10 | 0 | |
Retirement_Date | date | 10 | 0 | |
French_Immersion_Program | varchar | 150 | 0 | |
End_Date | date | 10 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
ESL | bit | 1 | 0 | |
ELD | bit | 1 | 0 | |
French_Immersion_Minutes | smallint | 5 | 0 | |
Aboriginal_Program | varchar | 150 | 0 | |
Aboriginal_Minutes | smallint | 5 | 0 | |
Special_Ed_Status | varchar | 8 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
Next_Year_Grade | varchar | 3 | 0 | |
Homeroom_Room | varchar | 5 | 0 | |
Homeroom_Designation | varchar | 4 | 0 | |
Sched_Homeroom_ID | uniqueidentifier | 16 | 0 | |
Stu_Enrol_ID | uniqueidentifier | 16 | 0 | |
Contact_Lst_Lst_ID | uniqueidentifier | 16 | 0 | |
Exceptionalities | nvarchar | -1 | 0 | |
Entry_Date_To_Canada | date | 10 | 0 | |
Country_Of_Birth | varchar | 150 | 0 | |
vw_Homeroom_Additional_Staff_connectEd_Accounts | School_Short_Name | nvarchar | -1 | 0 |
Homeroom_Room_Number | nvarchar | -1 | 0 | |
Homeroom_Designation | nvarchar | -1 | 0 | |
Primary_Teacher_Title | nvarchar | -1 | 0 | |
Primary_Teacher_Surname | nvarchar | -1 | 0 | |
Primary_Teacher_Given_Name | nvarchar | -1 | 0 | |
Primary_Teacher_Staff_Number | varchar | 25 | 0 | |
Additional_Staff_Type | varchar | 5 | 0 | |
Additional_Staff_Title | nvarchar | -1 | 0 | |
Additional_Staff_Surname | nvarchar | -1 | 0 | |
Additional_Staff_Given_Name | nvarchar | -1 | 0 | |
Additional_Staff_Staff_Number | varchar | 25 | 0 | |
Additional_Staff_Account_Name | nvarchar | -1 | 0 | |
Additional_Staff_User_Name | nvarchar | -1 | 0 | |
Additional_Staff_User_Type | nvarchar | -1 | 0 | |
Additional_Staff_Member_Active | varchar | 15 | 0 | |
vw_Homerooms_Occupancy | School_Short_Name | varchar | 10 | 0 |
Homeroom_Designation | varchar | 4 | 0 | |
Homeroom_Number | varchar | 5 | 0 | |
Grade | varchar | 3 | 0 | |
Occupancy | int | 10 | 0 | |
Teacher_Sur_Name | nvarchar | 100 | 0 | |
Teacher_Given_Name | nvarchar | 100 | 0 | |
Teacher_Surname | nvarchar | 100 | 0 | |
Alternate_Teacher_Surname | nvarchar | 100 | 0 | |
Alternate_Teacher_Given_Name | nvarchar | 100 | 0 | |
Total_Occupancy | smallint | 5 | 0 | |
School_Number | varchar | 10 | 0 | |
vw_NonStudentPayments | SchoolNumber | char | 10 | 0 |
SchoolShortName | varchar | 10 | 0 | |
PaymentDate | date | 10 | 0 | |
Payer | nvarchar | 200 | 0 | |
TransactionType | varchar | 25 | 0 | |
FeeType | varchar | 100 | 0 | |
Amount | decimal | 10 | 2 | |
PaymentType | varchar | 50 | 0 | |
RevenueAccountNumber | varchar | 50 | 0 | |
AccountNumber | varchar | 50 | 0 | |
PaymentTypeAccountNumber | varchar | 25 | 0 | |
ReceiptNumber | varchar | 25 | 0 | |
ReferenceNumber | varchar | 25 | 0 | |
Operator | nvarchar | 204 | 0 | |
Comment | nvarchar | -1 | 0 | |
vw_OnlineRegistration_SubmissionStatus | DateRecieved | datetime | 23 | 3 |
RequestPDFUrl | nvarchar | -1 | 0 | |
FormID | nvarchar | 50 | 0 | |
ResponseSetID | nvarchar | 50 | 0 | |
SchoolBSID | nvarchar | 50 | 0 | |
SchoolName | nvarchar | 256 | 0 | |
RequestVerificationSignature | nvarchar | 256 | 0 | |
RequestVerificationDate | datetime | 23 | 3 | |
Error | nvarchar | -1 | 0 | |
RequestId | uniqueidentifier | 16 | 0 | |
vw_PVNCCDSB_OnLineRegistration | Reg_Grade | nvarchar | 50 | 0 |
Reg_ExpectedEntryDate | datetime | 23 | 3 | |
Scl_BSID | nvarchar | 50 | 0 | |
Scl_Name | nvarchar | 256 | 0 | |
Stu_LegalLastName | nvarchar | 256 | 0 | |
stu_LegalFirstName | nvarchar | 256 | 0 | |
Stu_Gender | nvarchar | 30 | 0 | |
Stu_OLRegSuccess | bit | 1 | 0 | |
IsDeleted | bit | 1 | 0 | |
Reg_RequestedHomeSchool | nvarchar | 200 | 0 | |
vw_PVNC_Student_Contacts | Stu_Enrol_ID | uniqueidentifier | 16 | 0 |
Contact_Lst_ID | uniqueidentifier | 16 | 0 | |
Contact_Info_ID | uniqueidentifier | 16 | 0 | |
Person_Role_ID | uniqueidentifier | 16 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
Homeroom_Designation | varchar | 4 | 0 | |
Homroom_Room_Number | varchar | 5 | 0 | |
Ministry_Number | varchar | 12 | 0 | |
Student_Number | bigint | 19 | 0 | |
Student_Surname | nvarchar | 100 | 0 | |
Student_Given_Name | nvarchar | 100 | 0 | |
Student_Usual_Name | nvarchar | 100 | 0 | |
Grade | varchar | 3 | 0 | |
Birthdate | date | 10 | 0 | |
Stu_Status | varchar | 18 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
HCSchool | char | 1 | 0 | |
Contact_Number | bigint | 19 | 0 | |
Contact_Type | varchar | 255 | 0 | |
Contact_Surname | nvarchar | 100 | 0 | |
Contact_Given_Name | nvarchar | 100 | 0 | |
Contact_Work_Phone_Number | varchar | 40 | 0 | |
Contact_Cell_Phone_Number | varchar | 40 | 0 | |
Contact_Home_Phone_Number | varchar | 40 | 0 | |
Contact_Email_Address | varchar | 255 | 0 | |
Contact_Address | nvarchar | -1 | 0 | |
Scl_Year_Info_ID | uniqueidentifier | 16 | 0 | |
Emergency_Contact_Number | smallint | 5 | 0 | |
vw_OSBIE_Incidents_ON | School_Short_Name | varchar | 10 | 0 |
School_Name | varchar | 255 | 0 | |
Incident_Date | date | 10 | 0 | |
Report_Date | date | 10 | 0 | |
Student_Name | varchar | 60 | 0 | |
Description | nvarchar | 1000 | 0 | |
Sport_Description | varchar | 100 | 0 | |
vw_PVNCCDSB_Deep_Learning | OEN | varchar | 12 | 0 |
Lastname | nvarchar | 100 | 0 | |
Firstname | nvarchar | 100 | 0 | |
School_Year | varchar | 10 | 0 | |
Class | varchar | 7 | 0 | |
Mark | varchar | 6 | 0 | |
Term | varchar | 255 | 0 | |
Topic | varchar | 255 | 0 | |
G3_Reading | real | 24 | 0 | |
G3_Writing | real | 24 | 0 | |
G3_Math | real | 24 | 0 | |
G6_Reading | real | 24 | 0 | |
G6_Writing | real | 24 | 0 | |
G6_Math | real | 24 | 0 | |
vw_PVNCCDSB_Coop_NextYear | first_name | nvarchar | 100 | 0 |
last_name | nvarchar | 100 | 0 | |
varchar | 115 | 0 | ||
student_num | varchar | 12 | 0 | |
Grade | varchar | 3 | 0 | |
phone | varchar | 40 | 0 | |
year_started | int | 10 | 0 | |
birth_date | date | 10 | 0 | |
gender | char | 1 | 0 | |
address_street_1 | varchar | 266 | 0 | |
address_street_2 | varchar | 1 | 0 | |
address_city | varchar | 50 | 0 | |
address_province | varchar | 2 | 0 | |
address_country | varchar | 6 | 0 | |
address_post | varchar | 25 | 0 | |
teacher_first | nvarchar | 100 | 0 | |
preferred_name | varchar | 1 | 0 | |
teacher_last | nvarchar | 100 | 0 | |
teacher_phone | varchar | 26 | 0 | |
teacher_num | varchar | 25 | 0 | |
board_num | varchar | 6 | 0 | |
school_num | varchar | 10 | 0 | |
semeseter | varchar | 4 | 0 | |
vw_PublicWorks_Export | Student_Global_ID | varchar | 12 | 0 |
Student_Local_ID | varchar | 25 | 0 | |
Student_First_Name | nvarchar | 100 | 0 | |
Student_Middle_Name | nvarchar | 100 | 0 | |
Student_Last_Name | nvarchar | 100 | 0 | |
Student_DOB | date | 10 | 0 | |
Student_Building_Name | varchar | 255 | 0 | |
Student_Building_IRN | varchar | 10 | 0 | |
Student_Grade | varchar | 3 | 0 | |
Homeroom_Teachers_First_Name | nvarchar | 100 | 0 | |
Homeroom_Teachers_Last_Name | nvarchar | 100 | 0 | |
Parent_First_Name | nvarchar | 100 | 0 | |
Parent_Last_Name | nvarchar | 100 | 0 | |
Parent_Phone_Number | varchar | 40 | 0 | |
Parent_Address_Street | varchar | 255 | 0 | |
Parent_Address_City | varchar | 50 | 0 | |
Parent_Address_State | varchar | 50 | 0 | |
Parent_Address_Zip | varchar | 25 | 0 | |
Parent_Email_Address | varchar | 255 | 0 | |
Student_Building_Code | int | 10 | 0 | |
Student_IEP | int | 10 | 0 | |
Student_ED | int | 10 | 0 | |
Student_LEP | int | 10 | 0 | |
Student_Migrant | int | 10 | 0 | |
504 | int | 10 | 0 | |
vw_Period_Attendance_Code_Totals | School_Short_Name | varchar | 10 | 0 |
Attendance_Date | date | 10 | 0 | |
Period | tinyint | 3 | 0 | |
Attendance_Code | char | 1 | 0 | |
Attendance_Code_Title | varchar | 50 | 0 | |
Student_Count | int | 10 | 0 | |
vw_PVNC_OnSIS_DataCheck | OEN | varchar | 12 | 0 |
Surname | nvarchar | 100 | 0 | |
GivenName | nvarchar | 100 | 0 | |
Status | varchar | 18 | 0 | |
School_Name | varchar | 255 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
Grade | char | 3 | 0 | |
Entry_Date | date | 10 | 0 | |
Enrolment_Reason | varchar | 150 | 0 | |
Retirement_Date | date | 10 | 0 | |
Enrolment_Result | varchar | 150 | 0 | |
Citizenship | varchar | 150 | 0 | |
Resident_Type | varchar | 150 | 0 | |
Country_Of_Birth | varchar | 150 | 0 | |
First_Language | varchar | 150 | 0 | |
Home_School | bit | 1 | 0 | |
Base_School | varchar | 150 | 0 | |
Entry_Date_To_Board | date | 10 | 0 | |
This_Sch_Entry_Date | smalldatetime | 16 | 0 | |
Elem_Entry_Date | smalldatetime | 16 | 0 | |
Sec_Entry_Date | smalldatetime | 16 | 0 | |
Residence_Status | varchar | 150 | 0 | |
Aboriginal_Self_ID | varchar | 150 | 0 | |
IEP | bit | 1 | 0 | |
IsScheduling | bit | 1 | 0 | |
IsCurrent | bit | 1 | 0 | |
School_Year | varchar | 10 | 0 | |
FrenchProgram | varchar | 150 | 0 | |
vw_School_Information | School_BSID | char | 10 | 0 |
School_Name | varchar | 255 | 0 | |
School_Code | varchar | 10 | 0 | |
Address_Line_1 | varchar | 277 | 0 | |
Address_Line_2 | varchar | 27 | 0 | |
City | varchar | 50 | 0 | |
Province | varchar | 50 | 0 | |
Postal_Code | varchar | 8000 | 0 | |
School_Type | varchar | 4 | 0 | |
Phone_Number | varchar | 26 | 0 | |
Fax_Number | varchar | 26 | 0 | |
Email_Account | varchar | 255 | 0 | |
Principal | nvarchar | 202 | 0 | |
vw_Codes_Standardization_Base_Incl_Oth_Course_Info | Code_ID | uniqueidentifier | 16 | 0 |
Code_Def_ID | uniqueidentifier | 16 | 0 | |
Scl_Year_Info_ID | uniqueidentifier | 16 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
Course_Code | varchar | 10 | 0 | |
Course_Number | varchar | 10 | 0 | |
Course_Title | varchar | 255 | 0 | |
Grade | char | 3 | 0 | |
Credit_Value | decimal | 5 | 2 | |
Course_Type | varchar | 50 | 0 | |
Delivery_Type | varchar | 50 | 0 | |
Language | varchar | 150 | 0 | |
Categories | nvarchar | -1 | 0 | |
Dual_Credit_ID | uniqueidentifier | 16 | 0 | |
Special_Indicator | bit | 1 | 0 | |
Modified_Curriculum | bit | 1 | 0 | |
Alternative_Expectation | bit | 1 | 0 | |
Interdisciplinary_Studies | bit | 1 | 0 | |
Is_Board_Defined | bit | 1 | 0 | |
Effective_Date | date | 10 | 0 | |
Expiration_Date | date | 10 | 0 | |
GPA | bit | 1 | 0 | |
Other_Info_Credit_Recovery | bit | 1 | 0 | |
Other_Info_Ministry_Developed | bit | 1 | 0 | |
vw_Staff_Export_Synrevoice | School_Short_Name | varchar | 10 | 0 |
School_Name | varchar | 255 | 0 | |
School_Number | varchar | 10 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Staff_Role | varchar | 255 | 0 | |
Ministry_Number | varchar | 15 | 0 | |
Employee_Number | varchar | 25 | 0 | |
Email_Address | varchar | 255 | 0 | |
City | varchar | 50 | 0 | |
Province | varchar | 50 | 0 | |
Status | varchar | 30 | 0 | |
Status_Code | char | 1 | 0 | |
Home_Phone_Number | varchar | 40 | 0 | |
Cell_Phone_Number | varchar | 40 | 0 | |
vw_Codes_Standardization_ON_Incl_Oth_Course_Info | School_Short_Name | varchar | 10 | 0 |
Course_Code | varchar | 10 | 0 | |
Course_Number | varchar | 10 | 0 | |
Course_Title | varchar | 255 | 0 | |
Grade | char | 3 | 0 | |
Credit_Value | decimal | 5 | 2 | |
Course_Type | varchar | 50 | 0 | |
Dual_Credits_Type | varchar | 150 | 0 | |
Delivery_Type | varchar | 50 | 0 | |
Language | varchar | 150 | 0 | |
Categories | nvarchar | -1 | 0 | |
SHSM_Categories | nvarchar | -1 | 0 | |
SHSM_Program_Association | nvarchar | -1 | 0 | |
Special_Indicator | bit | 1 | 0 | |
Modified_Curriculum | bit | 1 | 0 | |
Alternative_Expectation | bit | 1 | 0 | |
Interdisciplinary_Studies | bit | 1 | 0 | |
Is_Board_Defined | bit | 1 | 0 | |
Effective_Date | date | 10 | 0 | |
Expiration_Date | date | 10 | 0 | |
GPA | bit | 1 | 0 | |
Other_Info_Credit_Recovery | bit | 1 | 0 | |
Other_Info_Ministry_Developed | bit | 1 | 0 | |
vw_Student_Counts_By_School | School_Short_Name | varchar | 10 | 0 |
School_Name | varchar | 255 | 0 | |
School_Number | varchar | 10 | 0 | |
This Year and Next | int | 10 | 0 | |
This Year Only | int | 10 | 0 | |
Next Year Only | int | 10 | 0 | |
Deleted | int | 10 | 0 | |
Past | int | 10 | 0 | |
Current Students | int | 10 | 0 | |
Projected Students | int | 10 | 0 | |
Difference | int | 10 | 0 | |
vw_Transcript_Substitutions_ON | School_Name | varchar | 255 | 0 |
OEN | varchar | 8000 | 0 | |
Sur_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
Grade | char | 3 | 0 | |
Date Of Completion | smalldatetime | 16 | 0 | |
Course Code | char | 10 | 0 | |
Credit Value | decimal | 5 | 2 | |
Substitution Flag | bit | 1 | 0 | |
Substition Categories | nvarchar | -1 | 0 | |
Student_Status | char | 1 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
vw_PVNC_SecondaryStudentContacts | OEN | varchar | 12 | 0 |
School_Short_Name | varchar | 10 | 0 | |
Course_Code | varchar | 10 | 0 | |
Class_Section | char | 2 | 0 | |
Teacher_Surname | nvarchar | 100 | 0 | |
Teacher_Given_Name | nvarchar | 100 | 0 | |
Sem_Term_Pattern | varchar | 30 | 0 | |
Class_End_Date | date | 10 | 0 | |
Is_Dropped | bit | 1 | 0 | |
Student_Surname | nvarchar | 100 | 0 | |
Student_Usual_Name | nvarchar | 100 | 0 | |
Stu_Status | varchar | 18 | 0 | |
Contact_Type | varchar | 255 | 0 | |
Contact_Number | bigint | 19 | 0 | |
Contact_Home_Phone_Number | varchar | 40 | 0 | |
Contact_Cell_Phone_Number | varchar | 40 | 0 | |
Contact_Surname | nvarchar | 100 | 0 | |
Contact_Given_Name | nvarchar | 100 | 0 | |
Contact_Email_Address | varchar | 255 | 0 | |
vw_PVNC_Student_Contacts_IEP | Stu_Enrol_ID | uniqueidentifier | 16 | 0 |
Contact_Lst_ID | uniqueidentifier | 16 | 0 | |
Contact_Info_ID | uniqueidentifier | 16 | 0 | |
Person_Role_ID | uniqueidentifier | 16 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
Special_Ed | bit | 1 | 0 | |
Homeroom_Designation | varchar | 4 | 0 | |
Homroom_Room_Number | varchar | 5 | 0 | |
Homeroom_Teacher_Surname | nvarchar | 100 | 0 | |
Homeroom_Teacher_Given_Name | nvarchar | 100 | 0 | |
Homeroom_Teacher_Number | varchar | 25 | 0 | |
Ministry_Number | varchar | 12 | 0 | |
Student_Number | bigint | 19 | 0 | |
Student_Surname | nvarchar | 100 | 0 | |
Student_Given_Name | nvarchar | 100 | 0 | |
Student_Usual_Name | nvarchar | 100 | 0 | |
Grade | varchar | 3 | 0 | |
Birthdate | date | 10 | 0 | |
Stu_Status | varchar | 18 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
Contact_Number | bigint | 19 | 0 | |
Contact_Type | varchar | 255 | 0 | |
Contact_Surname | nvarchar | 100 | 0 | |
Contact_Given_Name | nvarchar | 100 | 0 | |
Contact_Work_Phone_Number | varchar | 40 | 0 | |
Contact_Cell_Phone_Number | varchar | 40 | 0 | |
Contact_Home_Phone_Number | varchar | 40 | 0 | |
Contact_Email_Address | varchar | 255 | 0 | |
Contact_Address | nvarchar | -1 | 0 | |
Scl_Year_Info_ID | uniqueidentifier | 16 | 0 | |
Emergency_Contact_Number | varchar | 40 | 0 | |
vw_PVNC_Pathway_Ontario_not_Past | School_Short_Name | varchar | 10 | 0 |
School Name | varchar | 255 | 0 | |
OEN | varchar | 12 | 0 | |
Student Last Name | nvarchar | 100 | 0 | |
Student Usual Name | nvarchar | 100 | 0 | |
Gender | char | 1 | 0 | |
DOB | date | 10 | 0 | |
Grade | varchar | 3 | 0 | |
Course Start Date | smalldatetime | 16 | 0 | |
Course End Date | smalldatetime | 16 | 0 | |
Course Code | char | 10 | 0 | |
Mark | varchar | 10 | 0 | |
Credit Value | decimal | 5 | 2 | |
Course Type | varchar | 50 | 0 | |
Is Transcript Record | int | 10 | 0 | |
Issuing_School | varchar | 150 | 0 | |
SHSM Program | varchar | 255 | 0 | |
SHSM Completion Date | smalldatetime | 16 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
Stu_Status | varchar | 18 | 0 | |
OYAP | bit | 1 | 0 | |
Is_Special_Ed | bit | 1 | 0 | |
Spec_Ed_Status | varchar | 8 | 0 | |
IEP | bit | 1 | 0 | |
Exceptionality_1 | varchar | 150 | 0 | |
vw_PVNC_Student_Contacts_with_CASL | Stu_Enrol_ID | uniqueidentifier | 16 | 0 |
Contact_Lst_ID | uniqueidentifier | 16 | 0 | |
Contact_Info_ID | uniqueidentifier | 16 | 0 | |
Person_Role_ID | uniqueidentifier | 16 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
Homeroom_Designation | varchar | 4 | 0 | |
Homroom_Room_Number | varchar | 5 | 0 | |
Homeroom_Teacher_Surname | nvarchar | 100 | 0 | |
Homeroom_Teacher_Given_Name | nvarchar | 100 | 0 | |
Homeroom_Teacher_Number | varchar | 25 | 0 | |
Ministry_Number | varchar | 12 | 0 | |
Student_Number | bigint | 19 | 0 | |
Student_Surname | nvarchar | 100 | 0 | |
Student_Given_Name | nvarchar | 100 | 0 | |
Student_Usual_Name | nvarchar | 100 | 0 | |
Grade | varchar | 3 | 0 | |
Birthdate | date | 10 | 0 | |
Stu_Status | varchar | 18 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
Contact_Number | bigint | 19 | 0 | |
Contact_Type | varchar | 255 | 0 | |
Contact_Surname | nvarchar | 100 | 0 | |
Contact_Given_Name | nvarchar | 100 | 0 | |
Contact_Work_Phone_Number | varchar | 40 | 0 | |
Contact_Cell_Phone_Number | varchar | 40 | 0 | |
Contact_Home_Phone_Number | varchar | 40 | 0 | |
Contact_Email_Address | varchar | 255 | 0 | |
Contact_Address | nvarchar | -1 | 0 | |
Scl_Year_Info_ID | uniqueidentifier | 16 | 0 | |
Emergency_Contact_Number | smallint | 5 | 0 | |
Title_Eng | nvarchar | 200 | 0 | |
ConsentReceivedDate | date | 10 | 0 | |
vw_Archive_Attendance_Equivalent_Full_Day_Totals | Person_ID | uniqueidentifier | 16 | 0 |
Grade | varchar | 2 | 0 | |
School_ID | uniqueidentifier | 16 | 0 | |
School_Year | varchar | 10 | 0 | |
Absent | numeric | 38 | 1 | |
Late | int | 10 | 0 | |
Suspended | int | 10 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
School_Name | varchar | 255 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
Gender | char | 1 | 0 | |
Ministry_Num_Fmt | varchar | 12 | 0 | |
Stu_Number | varchar | 25 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
Stu_Status | varchar | 18 | 0 | |
vw_PVNCCDSB_Stu_Custom_Fields | School_Short_Name | varchar | 10 | 0 |
HCSchool | char | 1 | 0 | |
Ministry_Num_Fmt | varchar | 12 | 0 | |
Sur_Name | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Gender | char | 1 | 0 | |
Grade | varchar | 3 | 0 | |
Stu_Status | varchar | 18 | 0 | |
Stu_Status_Code | varchar | 1 | 0 | |
Field_Type | varchar | 50 | 0 | |
Field_Name | varchar | 50 | 0 | |
Field_Value | varchar | 100 | 0 | |
Board_Defined | bit | 1 | 0 | |
Stu_Enrol_ID | uniqueidentifier | 16 | 0 | |
Homeroom_Teacher_Number | varchar | 25 | 0 | |
Homeroom_Teacher_Surname | nvarchar | 100 | 0 | |
Homeroom_Teacher_Given_Name | nvarchar | 100 | 0 | |
Homeroom_Alt_Teacher_Number | varchar | 25 | 0 | |
Homeroom_Alt_Teacher_Surname | nvarchar | 100 | 0 | |
Homeroom_Alt_Teacher_Given_Name | nvarchar | 100 | 0 | |
Origin_School | varchar | 150 | 0 | |
Destination_School | varchar | 150 | 0 | |
Stu_Number | varchar | 25 | 0 | |
Person_ID | uniqueidentifier | 16 | 0 | |
vw_Archive_HalfDay_Attendance_Student_Totals | School_Name | varchar | 255 | 0 |
School_Short_Name | varchar | 10 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
Grade | varchar | 2 | 0 | |
Homeroom_Designation | varchar | 10 | 0 | |
Homeroom_Room | varchar | 5 | 0 | |
Homeroom_Teacher_Surname | nvarchar | 100 | 0 | |
Homeroom_Teacher_Given_Name | nvarchar | 100 | 0 | |
School_Year | varchar | 10 | 0 | |
Special_Ed | bit | 1 | 0 | |
Spec_Ed_Status | varchar | 8 | 0 | |
IEP | bit | 1 | 0 | |
IEP_With | nvarchar | -1 | 0 | |
Exceptionality_1 | varchar | 150 | 0 | |
Support_Service | varchar | 150 | 0 | |
Special_Ed_Resources | varchar | 150 | 0 | |
A_Total | int | 10 | 0 | |
B_Total | int | 10 | 0 | |
C_Total | int | 10 | 0 | |
D_Total | int | 10 | 0 | |
E_Total | int | 10 | 0 | |
F_Total | int | 10 | 0 | |
G_Total | int | 10 | 0 | |
H_Total | int | 10 | 0 | |
I_Total | int | 10 | 0 | |
J_Total | int | 10 | 0 | |
K_Total | int | 10 | 0 | |
L_Total | int | 10 | 0 | |
M_Total | int | 10 | 0 | |
N_Total | int | 10 | 0 | |
O_Total | int | 10 | 0 | |
Q_Total | int | 10 | 0 | |
R_Total | int | 10 | 0 | |
S_Total | int | 10 | 0 | |
T_Total | int | 10 | 0 | |
U_Total | int | 10 | 0 | |
V_Total | int | 10 | 0 | |
W_Total | int | 10 | 0 | |
X_Total | int | 10 | 0 | |
Y_Total | int | 10 | 0 | |
Z_Total | int | 10 | 0 | |
Not_Enrolled_Total | int | 10 | 0 | |
Ministry_Num | varchar | 12 | 0 | |
vw_PVNCCDSB_Bus_Needs_Med_Conditions | Ministry_Num_Fmt | varchar | 12 | 0 |
Stu_Number | varchar | 25 | 0 | |
Sur_Name | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Gender | char | 1 | 0 | |
Grade | varchar | 3 | 0 | |
Stu_Status | varchar | 18 | 0 | |
School_Short_Name | varchar | 10 | 0 | |
Field_Value | varchar | 100 | 0 | |
HCSchool | char | 1 | 0 | |
vw_Archive_Period_Attendance_Student_Totals | School_Name | varchar | 255 | 0 |
School_Short_Name | varchar | 10 | 0 | |
Surname | nvarchar | 100 | 0 | |
Given_Name | nvarchar | 100 | 0 | |
Usual_Name | nvarchar | 100 | 0 | |
Grade | varchar | 2 | 0 | |
Homeroom_Designation | varchar | 10 | 0 | |
Homeroom_Room | varchar | 5 | 0 | |
Homeroom_Teacher_Surname | nvarchar | 100 | 0 | |
Homeroom_Teacher_Given_Name | nvarchar | 100 | 0 | |
School_Year | varchar | 10 | 0 | |
Special_Ed | bit | 1 | 0 | |
Spec_Ed_Status | varchar | 8 | 0 | |
IEP | bit | 1 | 0 | |
IEP_With | nvarchar | -1 | 0 | |
Exceptionality_1 | varchar | 150 | 0 | |
Support_Service | varchar | 150 | 0 | |
Special_Ed_Resources | varchar | 150 | 0 | |
A_Total | int | 10 | 0 | |
B_Total | int | 10 | 0 | |
C_Total | int | 10 | 0 | |
D_Total | int | 10 | 0 | |
E_Total | int | 10 | 0 | |
F_Total | int | 10 | 0 | |
G_Total | int | 10 | 0 | |
H_Total | int | 10 | 0 | |
I_Total | int | 10 | 0 | |
J_Total | int | 10 | 0 | |
K_Total | int | 10 | 0 | |
L_Total | int | 10 | 0 | |
M_Total | int | 10 | 0 | |
N_Total | int | 10 | 0 | |
O_Total | int | 10 | 0 | |
Q_Total | int | 10 | 0 | |
R_Total | int | 10 | 0 | |
S_Total | int | 10 | 0 | |
T_Total | int | 10 | 0 | |
U_Total | int | 10 | 0 | |
V_Total | int | 10 | 0 | |
W_Total | int | 10 | 0 | |
X_Total | int | 10 | 0 | |
Y_Total | int | 10 | 0 | |
Z_Total | int | 10 | 0 | |
Cancelled_Total | int | 10 | 0 | |
Not_Enrolled_Total | int | 10 | 0 | |
Ministry_Num | varchar | 12 | 0 | |
vw_base_transportation_export | School_Short_Name | varchar | 10 | 0 |
school_Name | varchar | 255 | 0 | |
School number | varchar | 10 | 0 | |
Ministry number | varchar | 12 | 0 | |
Student number | varchar | 25 | 0 | |
First name | nvarchar | 100 | 0 | |
Middle_Name | nvarchar | 100 | 0 | |
Last name | nvarchar | 100 | 0 | |
Gender | char | 1 | 0 | |
Birthday | date | 10 |