Report Data Views and Data Definitions

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

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