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	0
	Status	char	1	0
	stu_status	varchar	18	0
	Grade	varchar	3	0
	Student Cohort	varchar	150	0
	CriticalWorkerTier	varchar	50	0
	Homeroom	varchar	12	0
	Apartment	varchar	10	0
	Street number	varchar	10	0
	Street name	varchar	255	0
	City	varchar	50	0
	Postal Code	varchar	25	0
	PO Box	varchar	17	0
	province	varchar	50	0
	Country	varchar	50	0
	Township	varchar	50	0
	Student Emergency Code	varchar	100	0
	RR_Number	varchar	5	0
	Address_Group	varchar	20	0
	Legal_Land_Description	varchar	121	0
	Additional Information	nvarchar	-1	0
	Mailing_Address_line_1	nvarchar	512	0
	Mailing_Address_line_2	varchar	50	0
	Mailing_Address_line_3	varchar	50	0
	Student phone number	varchar	40	0
	Student Special Custody Note	nvarchar	-1	0
	Future Apartment	varchar	10	0
	Future Street number	varchar	10	0
	Future Street name	varchar	255	0
	Future City	varchar	50	0
	Future Postal Code	varchar	25	0
	Future PO Box	varchar	17	0
	Future Province	varchar	50	0
	Future Country	varchar	50	0
	Future Address Effective Date	date	10	0
	Contact Order 1 name	nvarchar	202	0
	Contact Order 1 Type	varchar	255	0
	Contact order 1 Legal Guardian	bit	1	0
	Contact order 1 Custodian	bit	1	0
	Contact 1 Custody Note	nvarchar	-1	0
	Contact order 1 emergency contact	tinyint	3	0
	Contact Order 1 home phone	varchar	40	0
	Contact Order 1 cell phone	varchar	40	0
	Contact Order 1 employer	varchar	255	0
	Contact Order 1 employer phone	varchar	40	0
	Contact Order 1 Email	varchar	255	0
	Contact Order 1 Apartment	varchar	10	0
	Contact Order 1 Street number	varchar	10	0
	Contact Order 1 Street name	varchar	255	0
	Contact Order 1 City	varchar	50	0
	Contact Order 1 Postal Code	varchar	25	0
	Contact Order 1 PO Box	varchar	17	0
	Contact Order 1 province	varchar	50	0
	Contact Order 1 Country	varchar	50	0
	Contact Order 1 Emergency Code	varchar	100	0
	Contact Order 2 name	nvarchar	202	0
	Contact Order 2 Type	varchar	255	0
	Contact order 2 Legal Guardian	bit	1	0
	Contact order 2 Custodian	bit	1	0
	Contact 2 Custody Note	nvarchar	-1	0
	Contact order 2 emergency contact	tinyint	3	0
	Contact Order 2 home phone	varchar	40	0
	Contact Order 2 cell phone	varchar	40	0
	Contact Order 2 employer	varchar	255	0
	Contact Order 2 employer phone	varchar	40	0
	Contact Order 2 Email	varchar	255	0
	Contact Order 2 Apartment	varchar	10	0
	Contact Order 2 Street number	varchar	10	0
	Contact Order 2 Street name	varchar	255	0
	Contact Order 2 City	varchar	50	0
	Contact Order 2 Postal Code	varchar	25	0
	Contact Order 2 PO Box	varchar	17	0
	Contact Order 2 province	varchar	50	0
	Contact Order 2 Country	varchar	50	0
	Contact Order 2 Emergency Code	varchar	100	0
	Special Custody	bit	1	0
	Lives With	varchar	163	0
	Sitter's Name	nvarchar	202	0
	Sitter home phone	varchar	40	0
	Sitter cell phone	varchar	40	0
	Sitter employer	varchar	255	0
	Sitter employer phone	varchar	40	0
	Sitter Email	varchar	255	0
	Father_Surname	nvarchar	100	0
	Father_Given_Name	nvarchar	100	0
	Father_Cell_Phone_Number	varchar	40	0
	Mother_Surname	nvarchar	100	0
	Mother_Given_Name	nvarchar	100	0
	Mother_Cell_Phone_Number	varchar	40	0
	Emergency_Contact_Surname	nvarchar	100	0
	Emergency_Contact_Given_Name	nvarchar	100	0
	Emergency_Contact_Home_Phone_Number	varchar	40	0
	Emergency_Contact_Email	varchar	255	0
	Sitter Apartment	varchar	10	0
	Sitter Street number	varchar	10	0
	Sitter Street name	varchar	255	0
	Sitter City	varchar	50	0
	Sitter Postal Code	varchar	25	0
	Sitter PO Box	varchar	17	0
	Sitter province	varchar	50	0
	Sitter Country	varchar	50	0
	Sitter Emergency Code	varchar	100	0
	Current Pick Up Apartment	varchar	10	0
	Current Pick Up Street number	varchar	10	0
	Current Pick Up Street name	varchar	255	0
	Current Pick Up City	varchar	50	0
	Current Pick Up Postal Code	varchar	25	0
	Current Pick Up PO Box	varchar	17	0
	Current Pick Up province	varchar	50	0
	Current Pick Up Country	varchar	50	0
	Current Drop Off Apartment	varchar	10	0
	Current Drop Off Street number	varchar	10	0
	Current Drop Off Street name	varchar	255	0
	Current Drop Off City	varchar	50	0
	Current Drop Off Postal Code	varchar	25	0
	Current Drop Off PO Box	varchar	17	0
	Current Drop Off province	varchar	50	0
	Current Drop Off Country	varchar	50	0
	Entry date	date	10	0
	Retirement/transfer date	date	10	0
	Medical notes	nvarchar	-1	0
	Special Ed Code	char	10	0
	Program Code	varchar	150	0
	Grant Type 1	char	10	0
	Grant Type 2	char	10	0
	Grant Type 3	char	10	0
	Enrollment Type 1	char	10	0
	Enrollment Type 2	char	10	0
	Enrollment Type 3	char	10	0
	French Program	varchar	150	0
	Main school (holder of OSR)	varchar	150	0
	Student board residence status	varchar	150	0
	Transportation Special Custody	varchar	3	0
	Next Year Grade	varchar	3	0
	Next Year School Number	varchar	10	0
	Student Email	varchar	255	0
	Transportation_Reason	varchar	10	0
vw_Classes_Ontario_Base	School_Name	varchar	255	0
	School_Number	char	10	0
	Class_Code	varchar	10	0
	Section_Letter	char	2	0
	Department	varchar	150	0
	Semester_Term_Pattern	varchar	30	0
	Period_Pattern	varchar	30	0
	Course_Type	varchar	50	0
	Dual_Credit_Course_Type	varchar	150	0
	Delivery	varchar	50	0
	Credit_Value	numeric	5	2
	Language	varchar	150	0
	Reportable	bit	1	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Occupancy	int	10	0
	School_Short_Name	varchar	10	0
	Course_Title	varchar	255	0
	Dual_Credit_Course_Assoc	varchar	172	0
	Class_Room	nvarchar	-1	0
	Scheduling	bit	1	0
	Class_Start_Date	date	10	0
	Class_End_Date	date	10	0
	Minutes_Per_Day	smallint	5	0
	Continuous_Entry	bit	1	0
	Num_Lessons_Work_Units	smallint	5	0
	Num_Sessions	tinyint	3	0
	Course_Grade	varchar	3	0
	Is_Reportable	bit	1	0
	Attendance_Last_Taken_Date	date	10	0
	Course_Offering_Type	varchar	150	0
	OnSisCode	varchar	16	0
vw_Codes_Standardization	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
	Is_Board_Defined	bit	1	0
	Effective_Date	date	10	0
	Expiration_Date	date	10	0
	GPA	bit	1	0
vw_Codes_Standardization_ON	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
vw_Con_Ed_Student_ON	School_Short_Name	varchar	10	0
	OEN	varchar	12	0
	Stu_Status	varchar	18	0
	Surname	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Con_Ed_Student_Type	varchar	150	0
	Home_School_Short_Name	varchar	10	0
	Home_School_Attendance_Type	varchar	50	0
	Home_School_SAL_Attendance_Type	varchar	50	0
vw_Current_Student_Status	School_Name	varchar	255	0
	OEN	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
	HCSchool	char	1	0
	Grade_Next_Year	char	3	0
	School_Short_Name	varchar	10	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	School_City	varchar	50	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Number	varchar	5	0
	Homeroom_Designation_Next_Year	varchar	4	0
	Homeroom_Number_Next_Year	varchar	5	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	Entry_Date	date	10	0
	Retirement_Date	date	10	0
	Stu_Number	varchar	25	0
	Stu_Number_Value	bigint	19	0
	Usual_Name	nvarchar	100	0
	Birthdate	date	10	0
	Internal_School_ID	int	10	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
	Homeroom_Teacher_Number_Next_Year	varchar	25	0
	Homeroom_Teacher_Surname_Next_Year	nvarchar	100	0
	Homeroom_Teacher_Given_Name_Next_Year	nvarchar	100	0
	First_Language	varchar	150	0
	Entered_Into_Maplewood_Date	date	10	0
	connectEd_User_Name	varchar	100	0
	Citizenship	varchar	150	0
vw_EQAO_Accommodations_ON	School_Short_Name	varchar	10	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	OEN	varchar	12	0
	Student_Number	bigint	19	0
	Grade	varchar	3	0
	Exceptionalities	nvarchar	-1	0
	Accomodations	nvarchar	-1	0
vw_FNMI_Students_AB	School_Name	varchar	255	0
	School_Short_Name	varchar	10	0
	ASN	varchar	12	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Grade	varchar	3	0
	Homeroom_Room	char	5	0
	Homeroom_Designation	varchar	4	0
	PASI_FNMI_Declaration	varchar	150	0
	Enrolment_Type_Code	char	10	0
	Aboriginal_Status	varchar	150	0
	ESL_Code	char	10	0
	Exceptionality_1	varchar	150	0
	Gender	char	1	0
	Birthdate	date	10	0
	HCSchool	char	1	0
	Stu_Status	varchar	18	0
	Stu_Status_Code	varchar	1	0
	Band_Of_Residence	varchar	150	0
	Reserve_Of_Residence	varchar	150	0
	Treaty_Num	varchar	12	0
vw_ONSIS_validation_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
	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_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
	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_ONSIS_validation_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
	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_Graduation_Diploma_Verification_ON	School_Short_Name	varchar	10	0
	OEN	varchar	12	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Legal_Surname	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Middle_Name	nvarchar	100	0
	Birthdate	date	10	0
	Gender	char	1	0
	StartGrade9InOntario	bit	1	0
	CohortYear	varchar	10	0
	Grade	varchar	3	0
	RetirementDate	date	10	0
	FirstDiplomaOrCertificate	varchar	255	0
	FirstDiplomaOrCerticateDate	date	10	0
	SecondDiplomaOrCertificate	varchar	255	0
	SecondDiplomaOrCertificateDate	date	10	0
	Total_Compulsory	decimal	38	2
	Total_Optional	decimal	38	2
	Total_Credits	decimal	38	2
	Area_Of_Requirement	varchar	255	0
	Main_School	varchar	150	0
	Board_Resident_Status	varchar	150	0
	Stu_Status	varchar	18	0
	Stu_Status_Code	varchar	1	0
	Entry_Date	date	10	0
	Entry_To_Secondary_Date	date	10	0
	Retirement_Date	date	10	0
	Community_Hours_Completed	bit	1	0
	Community_Hours	decimal	6	2
	Literacy_Complete	bit	1	0
	Literacy_Status	varchar	14	0
	OYAP	bit	1	0
	Ontario_Scholar	bit	1	0
	SHSM	varchar	255	0
	Pathway	varchar	100	0
	OEN_Fmt	varchar	12	0
	Aboriginal_Self_ID	varchar	150	0
	Is_Special_Ed	bit	1	0
	Spec_Ed_Status	varchar	8	0
	Placement	varchar	150	0
	Compulsory_Credits_Remaining	decimal	38	2
	SHSM_Compulsory_Credits_Remaining	decimal	38	2
vw_Student_Cohort	School_Short_Name	varchar	10	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Ministry_Num_Fmt	varchar	12	0
	Grade	varchar	3	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	Birthdate	date	10	0
	Gender	char	1	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	Entry_Date	date	10	0
	Retirement_Date	date	10	0
	Cohort__Code	char	10	0
	Cohort_Name_ENG	varchar	150	0
	Cohort_Name_FRE	varchar	150	0
vw_Residency_Status_ON	School_Short_Name	varchar	10	0
	School_Number	varchar	10	0
	OEN	varchar	12	0
	Board_Resident_Status	varchar	150	0
	Stu_Status	varchar	18	0
	Origin_Type	varchar	150	0
	Origin_School	varchar	150	0
	Grade	varchar	3	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Gender	char	1	0
	Citizenship	varchar	150	0
	Entry_Date_To_Canada	date	10	0
	Aboriginal_Self_ID	varchar	150	0
	HCSchool	char	1	0
	Country_Of_Birth	varchar	150	0
	First_Language	varchar	150	0
vw_Sample_Transportation_Export	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
	Last name	nvarchar	100	0
	Gender	char	1	0
	Birthday	date	10	0
	Status	char	1	0
	Grade	varchar	3	0
	Homeroom	varchar	12	0
	Apartment	varchar	10	0
	Street number	varchar	10	0
	Street name	varchar	255	0
	City	varchar	50	0
	Postal Code	varchar	25	0
	PO Box	varchar	17	0
	Province	varchar	50	0
	Township	varchar	50	0
	Legal_Land_Description	varchar	121	0
	Student phone number	varchar	40	0
	Mailing address line 1	nvarchar	512	0
	Mailing address line 2	varchar	50	0
	Mailing address line 3	varchar	50	0
	Mother's name	nvarchar	202	0
	Mother home phone	varchar	40	0
	Mother cell phone	varchar	40	0
	Mother employer	varchar	255	0
	Mother employer phone	varchar	40	0
	Father name	nvarchar	202	0
	Father home phone	varchar	40	0
	Father cell phone	varchar	40	0
	Father employer	varchar	255	0
	Father employer phone	varchar	40	0
	Special Custody	bit	1	0
	Custodian	varchar	163	0
	Lives With	varchar	163	0
	Legal Guardian	varchar	163	0
	Emergency Contact	nvarchar	202	0
	Emergency Contact Name	varchar	40	0
	Sitter Name	nvarchar	202	0
	Sitter Phone	varchar	40	0
	PU Apt Num	varchar	10	0
	PU House Num	varchar	10	0
	PU Street	varchar	255	0
	PU City	varchar	50	0
	PU Township	varchar	50	0
	PU Postal	varchar	25	0
	DO Apt Num	varchar	10	0
	DO House Num	varchar	10	0
	DO Street	varchar	255	0
	DO City	varchar	50	0
	DO Township	varchar	50	0
	DO Postal	varchar	25	0
	Entry date	date	10	0
	Retirement/transfer date	date	10	0
	Medical notes	nvarchar	-1	0
	Special Ed Code	char	10	0
	Emergency Code	varchar	1	0
	Grant Type 1	char	10	0
	Grant Type 2	char	10	0
	Grant Type 3	char	10	0
	Enrollment Type 1	char	10	0
	Enrollment Type 2	char	10	0
	Enrollment Type 3	char	10	0
vw_SAL_Students_ON	School_Short_Name	varchar	10	0
	OEN	varchar	12	0
	Stu_Status	varchar	18	0
	Sur_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Birthdate	date	10	0
	Current_Age	int	10	0
	Grade	varchar	3	0
	FTE	decimal	3	2
	SAL_Attendance_Type	varchar	150	0
	SAL_Status	varchar	150	0
	SAL_Start_Date	date	10	0
	SAL_End_Date	date	10	0
	SAL_Exit_Type	varchar	150	0
	Component_1_Title	varchar	150	0
	Component_1_Start_Date	date	10	0
	Component_1_End_Date	date	10	0
	Component_2_Title	varchar	150	0
	Component_2_Start_Date	date	10	0
	Component_2_End_Date	date	10	0
	Component_3_Title	varchar	150	0
	Component_3_Start_Date	date	10	0
	Component_3_End_Date	date	10	0
	Stu_Enrol_ID	uniqueidentifier	16	0
vw_AB_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
	Last name	nvarchar	100	0
	Gender	char	1	0
	Birthday	date	10	0
	Status	char	1	0
	Grade	varchar	3	0
	Homeroom	varchar	12	0
	Apartment	varchar	10	0
	Street number	varchar	10	0
	Street name	varchar	255	0
	City	varchar	50	0
	Postal Code	varchar	25	0
	PO Box	varchar	17	0
	province	varchar	50	0
	Township	varchar	50	0
	Legal_Land_Description	varchar	121	0
	Student phone number	varchar	40	0
	Mailing address line 1	nvarchar	512	0
	Mailing address line 2	varchar	50	0
	Mailing address line 3	varchar	50	0
	Mother's name	nvarchar	202	0
	Mother home phone	varchar	40	0
	Mother cell phone	varchar	40	0
	Mother employer	varchar	255	0
	Mother employer phone	varchar	40	0
	Father name	nvarchar	202	0
	Father home phone	varchar	40	0
	Father cell phone	varchar	40	0
	Father employer	varchar	255	0
	Father employer phone	varchar	40	0
	Special Custody	bit	1	0
	Custodian	varchar	163	0
	Lives With	varchar	163	0
	Legal Guardian	varchar	163	0
	Emergency Contact	nvarchar	202	0
	Emergency Contact Name	varchar	40	0
	Sitter Name	nvarchar	202	0
	Sitter Phone	varchar	40	0
	PU Apt Num	varchar	10	0
	PU House Num	varchar	10	0
	PU Street	varchar	255	0
	PU City	varchar	50	0
	PU Township	varchar	50	0
	PU Postal	varchar	25	0
	DO Apt Num	varchar	10	0
	DO House Num	varchar	10	0
	DO Street	varchar	255	0
	DO City	varchar	50	0
	DO Township	varchar	50	0
	DO Postal	varchar	25	0
	Entry date	date	10	0
	Retirement/transfer date	date	10	0
	Medical notes	nvarchar	-1	0
	Special Ed Code	char	10	0
	Emergency Code	varchar	1	0
	Grant Type 1	char	10	0
	Grant Type 2	char	10	0
	Grant Type 3	char	10	0
	Enrollment Type 1	char	10	0
	Enrollment Type 2	char	10	0
	Enrollment Type 3	char	10	0
vw_School_Board_Wide_Assessment	Surname	nvarchar	100	0
	Usual Name	nvarchar	100	0
	Test	varchar	50	0
	Subject	varchar	50	0
	Strand	varchar	50	0
	Timeframe	varchar	50	0
	Grade	varchar	3	0
	School Name	varchar	255	0
	OEN	varchar	12	0
	Test_Def_ID	uniqueidentifier	16	0
	Mark	varchar	10	0
	Stu_Status	varchar	18	0
	Stu_Status_Code	varchar	1	0
	Closed_School	int	10	0
	Homeroon_Room	char	5	0
	Homeroom_Designation	varchar	4	0
	Birthdate	date	10	0
	School_Short_Name	varchar	10	0
	Gender	char	1	0
	Person_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	Homeroom_Teacher_Surname	nvarchar	100	0
	Homeroom_Teacher_Given_Name	nvarchar	100	0
	Homeroom_Teacher_Number	varchar	25	0
	Homeroom_Alt_Teacher_Surname	nvarchar	100	0
	Homeroom_Alt_Teacher_Given_Name	nvarchar	100	0
	Homeroom_Alt_Teacher_Number	varchar	25	0
	Next_Year_Homeroon_Room	char	5	0
	Next_Year_Homeroom_Designation	varchar	4	0
	Next_Year_Homeroom_Teacher_Surname	nvarchar	100	0
	Next_Year_Homeroom_Teacher_Given_Name	nvarchar	100	0
	Next_Year_Homeroom_Teacher_Number	varchar	25	0
	Aboriginal_Status_Code	varchar	150	0
	Origin_Type	varchar	150	0
	Origin_School	varchar	150	0
vw_School_Board_Wide_Assessment_MB	Surname	nvarchar	100	0
	Usual Name	nvarchar	100	0
	Test	varchar	50	0
	Subject	varchar	50	0
	Strand	varchar	50	0
	Timeframe	varchar	50	0
	Grade	varchar	3	0
	School Name	varchar	255	0
	MET	varchar	12	0
	Test_Def_ID	uniqueidentifier	16	0
	Mark	varchar	10	0
	Stu_Status	varchar	18	0
	Stu_Status_Code	varchar	1	0
	Closed_School	int	10	0
	Homeroon_Room	char	5	0
	Homeroom_Designation	varchar	4	0
	Birthdate	date	10	0
	School_Short_Name	varchar	10	0
	Gender	char	1	0
	Aboriginal_Status_Code	varchar	150	0
	EAL	bit	1	0
	Homeroom_Teacher_Surname	nvarchar	100	0
	Homeroom_Teacher_Given_Name	nvarchar	100	0
	Homeroom_Teacher_Number	varchar	25	0
	Homeroom_Alt_Teacher_Surname	nvarchar	100	0
	Homeroom_Alt_Teacher_Given_Name	nvarchar	100	0
	Homeroom_Alt_Teacher_Number	varchar	25	0
	Next_Year_Homeroon_Room	char	5	0
	Next_Year_Homeroom_Designation	varchar	4	0
	Next_Year_Homeroom_Teacher_Surname	nvarchar	100	0
	Next_Year_Homeroom_Teacher_Given_Name	nvarchar	100	0
	Next_Year_Homeroom_Teacher_Number	varchar	25	0
	Aboriginal_Identity_1	varchar	150	0
vw_Secondary_Class_Attendance_ON	Class_ID	uniqueidentifier	16	0
	School_ID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	School_Short_Name	varchar	10	0
	OEN	varchar	12	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	FNMI	varchar	150	0
	Spec_Ed_Status	varchar	8	0
	Exceptionality_1	varchar	150	0
	Sem_Number	tinyint	3	0
	Term_Number	tinyint	3	0
	Class	varchar	13	0
	TT_Rank	bigint	19	0
	Times_Absent	int	10	0
	Stu_Status_Code	varchar	1	0
	Stu_Status	varchar	18	0
	Times_Late	int	10	0
	Usual_Name	nvarchar	100	0
	Student_Grade	varchar	3	0
	Gender	char	1	0
	Main_School	varchar	150	0
	Times_Att_Code_S	int	10	0
vw_Secondary_Learning_Skills_Achievement_ON	School_Year	varchar	10	0
	School_Short_Name	varchar	10	0
	OEN	varchar	12	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Grade	varchar	3	0
	Gender	char	1	0
	Course_Code	varchar	10	0
	School_Completed_In	varchar	10	0
	Term	varchar	50	0
	Final_Mark	varchar	6	0
	Spoken_French_Mark	varchar	6	0
	Responsibility_Mark	varchar	6	0
	Organization_Mark	varchar	6	0
	Independent_Work_Mark	varchar	6	0
	Collaboration_Mark	varchar	6	0
	Initiative_Mark	varchar	6	0
	Self_Regulation_Mark	varchar	6	0
vw_Security_Audit_Reports_Accounts	Account name	nvarchar	200	0
	Authentication type	nvarchar	100	0
	Primary group	nvarchar	200	0
	Additional Groups (can be multiple)	nvarchar	200	0
	People (can be multiple)	nvarchar	340	0
	School (can be multiple)	nvarchar	-1	0
	SiteFunctionNameEnglish	nvarchar	100	0
	Target sites	nvarchar	510	0
	Permission types	nvarchar	100	0
	Site type	nvarchar	100	0
	Target site	nvarchar	510	0
	Target groups	nvarchar	510	0
	Password never expires	bit	1	0
	Cannot change password	bit	1	0
	Must change password	bit	1	0
	Account locked out	bit	1	0
	Account active	bit	1	0
	Auto activation date (yes/ no)	varchar	3	0
	Auto activation date (Date)	date	10	0
	Account never expires	int	10	0
	Account expiry date	date	10	0
	Permissions assigned to user but not the group	bit	1	0
vw_Secondary_Timetable_Add_Drops	School_Short_Name	varchar	10	0
	School_Name	varchar	255	0
	Ministry_Num	varchar	12	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Grade	varchar	3	0
	Course_Code	varchar	10	0
	Class_Section	varchar	2	0
	Add_Drop_Date	date	10	0
	AddOrDrop	varchar	8	0
	AddDropPerformedBy_Surname	nvarchar	100	0
	AddDropPerformedBy_Given_Name	nvarchar	100	0
	Class_ID	uniqueidentifier	16	0
	Stu_Number	varchar	25	0
	Stu_Number_Value	bigint	19	0
	Last_Modified	datetime2	19	0
vw_Security_Audit_Reports_Group	Group name	nvarchar	200	0
	Default Authentication type	nvarchar	100	0
	Site type	nvarchar	100	0
	Default target site	nvarchar	510	0
	SiteFunctionName, Data access	nvarchar	100	0
	List permissions, Data access	bit	1	0
	SiteFunctionName, Account management	nvarchar	100	0
	List permissions, Account management	bit	1	0
	Password never expires	bit	1	0
	Cannot change password	bit	1	0
	Must change password	bit	1	0
	Account locked out	bit	1	0
	Account active	bit	1	0
	Auto activation date (yes/ no)	varchar	3	0
	Auto activation date (Date)	date	10	0
	Account never expires	int	10	0
	Account expiry date	date	10	0
vw_Special_Ed_Stu_Exceptionalities	Person_ID	uniqueidentifier	16	0
	Sur_Name	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Birthdate	date	10	0
	Gender	char	1	0
	Person_Number	varchar	25	0
	HCSchool	char	1	0
	School_Name	varchar	255	0
	School_Number	varchar	10	0
	Exceptionality1	varchar	150	0
	Exceptionality2	varchar	150	0
	Exceptionality3	varchar	150	0
	OEN	varchar	12	0
	Grade	varchar	3	0
	MWStatus	varchar	18	0
	ExceptionalityCode1	char	10	0
	ExceptionalityCode2	char	10	0
	ExceptionalityCode3	char	10	0
	Special_Ed_Program	varchar	150	0
	Support_Service	varchar	150	0
	Placement	varchar	150	0
	Placement_Date	date	10	0
	Surname	nvarchar	100	0
	School_Short_Name	varchar	10	0
	Is_Spec_Ed_Active	bit	1	0
	Special_Ed_Resources	varchar	150	0
	Special_Ed	bit	1	0
	Placement_End_Date	date	10	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Room	varchar	5	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
vw_Security_Audit_Reports_GroupWithAccounts	Account name	nvarchar	200	0
	Authentication type	nvarchar	100	0
	Primary group	nvarchar	200	0
	Additional Groups (can be multiple)	nvarchar	200	0
	PersonId	uniqueidentifier	16	0
	People (can be multiple)	nvarchar	340	0
	School (can be multiple)	nvarchar	-1	0
	Target sites	nvarchar	510	0
	Permission types	nvarchar	100	0
	Site type	nvarchar	100	0
	Target site	nvarchar	510	0
	Target groups	nvarchar	510	0
	Password never expires	bit	1	0
	Cannot change password	bit	1	0
	Must change password	bit	1	0
	Account locked out	bit	1	0
	Account active	bit	1	0
	Auto activation date (yes/ no)	varchar	3	0
	Auto activation date (Date)	date	10	0
	Account never expires	int	10	0
	Account expiry date	date	10	0
vw_Staff_Timetable	Staff_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	School_Short_Name	varchar	10	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Ministry_Number	varchar	15	0
	Staff_Number	varchar	25	0
	RegistrationNumber	varchar	15	0
	Role	varchar	255	0
	Status_Code	varchar	1	0
	Status	varchar	18	0
	Birthdate	date	10	0
	Gender	char	1	0
	This_School_Date	date	10	0
	Transfer_Date	date	10	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Room	varchar	5	0
	Is_Homeroom_Alternate_Teacher	int	10	0
	Is_Homeroom_Other_Staff	int	10	0
	Course_Code	varchar	10	0
	Class_Section	char	2	0
	Course_Number	varchar	10	0
	Course_Grade	varchar	3	0
	Course_Title	varchar	255	0
	Is_Alternate_Teacher	int	10	0
	Is_Other_Staff	int	10	0
	Class_Start_Date	date	10	0
	Class_End_Date	date	10	0
	Is_Next_Year	bit	1	0
	Is_CTS_Module	bit	1	0
	Is_Continuous_Entry	bit	1	0
	Is_Flex_Class	bit	1	0
	Course_Type	varchar	50	0
	Delivery_Type	varchar	50	0
vw_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	nvarchar	-1	0
	Field_Name	nvarchar	-1	0
	Field_Value	nvarchar	-1	0
	Board_Defined	bit	1	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Person_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
vw_Compulsory_Credit_Achieved	School_Number	varchar	10	0
	School_Code	varchar	10	0
	Person_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	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
vw_Student_Choices	School_Short_Name	varchar	10	0
	Ministry_Num_Fmt	varchar	12	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Stu_Status_Code	varchar	1	0
	Stu_Status	varchar	18	0
	Defined_Character_1	varchar	3	0
	Defined_Character_2	varchar	3	0
	Defined_Character_3	varchar	3	0
	Defined_Character_4	varchar	3	0
	This_Year_Grade	varchar	3	0
	Next_Year_Grade	char	3	0
	Course_Code	varchar	10	0
	Course_Title	varchar	255	0
	Choice_Type	varchar	50	0
	Choice_Required	bit	1	0
	Sort_Order	smallint	5	0
	Assigned_To_Class	bit	1	0
	Credit_Value	decimal	5	2
	Total_Credit_Earned	decimal	38	2
vw_Transportation_Program_ADSB	StudentNumber	varchar	25	0
	Surname	nvarchar	100	0
	GivenName	nvarchar	100	0
	LegalSortName	nvarchar	340	0
	HouseNumber	varchar	10	0
	Street	varchar	255	0
	City	varchar	50	0
	PostalCode	varchar	25	0
	Province	varchar	50	0
	BirthDate	date	10	0
	SchoolShortName	varchar	10	0
	Grade	char	3	0
	Program	varchar	4	0
	TPUPHouseNumber	varchar	10	0
	TPUPStreet	varchar	255	0
	TPUPCity	varchar	50	0
	TPUPPostalCode	varchar	25	0
	TPUPProvince	varchar	50	0
	TDOFFHouseNumber	varchar	10	0
	TDOFFStreet	varchar	255	0
	TDOFFCity	varchar	50	0
	TDOFFPostalCode	varchar	25	0
	TDOFFProvince	varchar	50	0
	Contact1Name	nvarchar	340	0
	Contact1Phone	varchar	40	0
	Contact2Name	nvarchar	340	0
	Contact2Phone	varchar	40	0
vw_Student_Contacts_All	Stu_Enrol_ID	uniqueidentifier	16	0
	person_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	tinyint	3	0
vw_Transportation_Program_ADSB_NextYear	StudentNumber	varchar	25	0
	Surname	nvarchar	100	0
	GivenName	nvarchar	100	0
	HouseNumber	varchar	10	0
	Street	varchar	255	0
	City	varchar	50	0
	PostalCode	varchar	25	0
	Province	varchar	50	0
	BirthDate	date	10	0
	SchoolShortName	varchar	10	0
	SchedulingGrade	char	3	0
	Program	varchar	4	0
	TPUPHouseNumber	varchar	10	0
	TPUPStreet	varchar	255	0
	TPUPCity	varchar	50	0
	TDOFFHouseNumber	varchar	10	0
	TDOFFStreet	varchar	255	0
	TDOFFCity	varchar	50	0
	Contact1Name	nvarchar	340	0
	Contact1Phone	varchar	40	0
	Contact2Name	nvarchar	340	0
	Contact2Phone	varchar	40	0
	MinistryNumber	nvarchar	-1	0
vw_PVNC_Contacts_Custody	School_Short_Name	varchar	10	0
	Ministry_Number	varchar	12	0
	Student_Number	bigint	19	0
	Student_Surname	nvarchar	100	0
	Student_Usual_Name	nvarchar	100	0
	Grade	varchar	3	0
	Stu_Status	varchar	18	0
	Contact_Number	bigint	19	0
	Contact_Type	varchar	255	0
	Contact_Surname	nvarchar	100	0
	Contact_Given_Name	nvarchar	100	0
	Contact_Email_Address	varchar	255	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	Emergency_Contact_Number	smallint	5	0
	Special_Custody	bit	1	0
	LivesWith	uniqueidentifier	16	0
	Lives_With	varchar	150	0
vw_Student_Homerooms	School_Short_Name	varchar	10	0
	Min_Num	varchar	12	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Grade	varchar	3	0
	Stu_Status_Code	varchar	1	0
	HCSchool	char	1	0
	Scheduling	bit	1	0
	Homeroom_Room_Number	varchar	5	0
	Homeroom_Designation	varchar	4	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Gender	char	1	0
	Stu_Letters	varchar	3	0
vw_RCCDSB_Transportation_Export	OEN_Number	varchar	12	0
	Student_Surname	nvarchar	100	0
	Student_Given_Name	nvarchar	100	0
	School_Short_Name	varchar	10	0
	Entry_Date	date	10	0
	Retirement_Date	date	10	0
	Is_Active	bit	1	0
	Is_PreReg	bit	1	0
	Grade	varchar	3	0
	Gender	char	1	0
	Birthdate	date	10	0
	Homeroom_Number	varchar	5	0
	French_Language_Program	varchar	150	0
	Student_Home_Phone_Number	varchar	40	0
	Student_House_Number	varchar	10	0
	Student_Street_Name	varchar	255	0
	Student_City	varchar	50	0
	Student_Postal_Code	varchar	25	0
	Student_Province	varchar	50	0
	Student_Apartment_Number	varchar	10	0
	Student_PO_Box	varchar	10	0
	Lives_With	varchar	150	0
	Father_Surname	nvarchar	100	0
	Father_Given_Name	nvarchar	100	0
	Father_Home_Phone	varchar	40	0
	Father_Employer_Phone	varchar	40	0
	Father_Cell_Phone	varchar	40	0
	Father_Email_Address	varchar	255	0
	Father_House_Number	varchar	10	0
	Father_Street_Name	varchar	255	0
	Father_City	varchar	50	0
	Father_Postal_Code	varchar	25	0
	Father_Province	varchar	50	0
	Father_Apartment_Number	varchar	10	0
	Father_PO_Box	varchar	10	0
	Mother_Surname	nvarchar	100	0
	Mother_Given_Name	nvarchar	100	0
	Mother_Home_Phone	varchar	40	0
	Mother_Employer_Phone	varchar	40	0
	Mother_Cell_Phone	varchar	40	0
	Mother_Email_Address	varchar	255	0
	Mother_House_Number	varchar	10	0
	Mother_Street_Name	varchar	255	0
	Mother_City	varchar	50	0
	Mother_Postal_Code	varchar	25	0
	Mother_Province	varchar	50	0
	Mother_Apartment_Number	varchar	10	0
	Mother_PO_Box	varchar	10	0
	Guardian_Surname	nvarchar	100	0
	Guardian_Given_Name	nvarchar	100	0
	Guardian_Home_Phone	varchar	40	0
	Guardian_Employer_Phone	varchar	40	0
	Guardian_Cell_Phone	varchar	40	0
	Guardian_Email_Address	varchar	255	0
	Pickup_Contact_Type	varchar	255	0
	Pickup_House_Number	varchar	10	0
	Pickup_Street_Name	varchar	255	0
	Pickup_City	varchar	50	0
	Pickup_Postal_Code	varchar	25	0
	Pickup_Province	varchar	50	0
	Pickup_Apartment_Number	varchar	10	0
	Dropoff_Contact_Type	varchar	255	0
	Dropoff_House_Number	varchar	10	0
	Dropoff_Street_Name	varchar	255	0
	Dropoff_City	varchar	50	0
	Dropoff_Postal_Code	varchar	25	0
	Dropoff_Province	varchar	50	0
	Dropoff_Apartment_Number	varchar	10	0
	Sitter_Surname	nvarchar	100	0
	Sitter_Given_Name	nvarchar	100	0
	Sitter_Home_Phone	varchar	40	0
	Sitter_Employer_Phone	varchar	40	0
	Sitter_Cell_Phone	varchar	40	0
	Sitter_Email_Address	varchar	255	0
vw_Student_Incidents	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
vw_Edsembli_Student_Count	School_Short_Name	nvarchar	256	0
	StudentCount	int	10	0
vw_Student_Internal_Transfers	School_Short_Name	varchar	10	0
	Ministry_Number	varchar	12	0
	Stu_Number	varchar	25	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Stu_Status	varchar	18	0
	Stu_Status_Code	varchar	1	0
	HCSchool	char	1	0
	Grade	varchar	3	0
	Entry_Date	date	10	0
	Retirement_Date	date	10	0
	Transfer_Type_Code	char	1	0
	Transfer_Type_Title	varchar	50	0
	Transfer_SubType	varchar	22	0
	Start_Date	date	10	0
	End_Date	date	10	0
	Original_Value	varchar	255	0
	New_Value	varchar	255	0
vw_Student_Timetable	School_Short_Name	varchar	10	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Ministry_Num_Fmt	varchar	12	0
	Stu_Number_Value	bigint	19	0
	Grade	varchar	3	0
	Course_Code	varchar	10	0
	Class_Section	char	2	0
	Course_Number	varchar	10	0
	Course_Grade	varchar	3	0
	Course_Title	varchar	255	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alt_Teacher_Surname	nvarchar	100	0
	Alt_Teacher_Given_Name	nvarchar	100	0
	Alt_Teacher_Number	varchar	25	0
	Class_Start_Date	date	10	0
	Class_End_Date	date	10	0
	Is_Dropped	bit	1	0
	Is_Next_Year	bit	1	0
	Is_CTS_Module	bit	1	0
	Is_Continuous_Entry	bit	1	0
	Is_Flex_Class	bit	1	0
	Continuous_Entry_Start_Date	date	10	0
	Continuous_Entry_Completion_Date	date	10	0
	Course_Type	varchar	50	0
	Delivery_Type	varchar	50	0
	Attendance_Type	varchar	50	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	Birthdate	date	10	0
	Gender	char	1	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	Entry_Date	date	10	0
	Retirement_Date	date	10	0
	Sem_Term_Pattern	varchar	30	0
	Day_Per_Pattern	varchar	30	0
	Drop_Date	date	10	0
	Credit_Attempted	decimal	5	2
vw_Base_Clever_Schools_Updated	School_id	varchar	10	0
	School_name	varchar	255	0
	School_number	varchar	10	0
	State_id	varchar	10	0
	Low_Grade	char	3	0
	High_Grade	char	3	0
	Principal	nvarchar	264	0
vw_Student_Timetable_Conflicts	School_Short_Name	varchar	10	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Stu_Status_Code	varchar	1	0
	Scheduling	bit	1	0
	Class_Code	varchar	10	0
	Section_Letter	char	2	0
	Course_Title	varchar	255	0
	Sem_Number	tinyint	3	0
	Term_Number	tinyint	3	0
	Day_Number	tinyint	3	0
	Per_Number	tinyint	3	0
vw_Base_Clever_Enrolments_Updated	School_id	varchar	10	0
	Section_id	varchar	12	0
	Student_id	bigint	19	0
vw_Student_Transportation_List_ON	OEN_Number	varchar	12	0
	Student_Number	varchar	25	0
	Given_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Sur_Name	nvarchar	100	0
	Birthdate	date	10	0
	School_Short_Name	varchar	10	0
	Grade_Current	varchar	3	0
	Grade_Next_Year	varchar	3	0
	Gender	char	1	0
	Father_Given_Name	nvarchar	100	0
	Father_Surname	nvarchar	100	0
	Father_Cell_Number	varchar	40	0
	Father_Work_Number	varchar	40	0
	Mother_Given_Name	nvarchar	100	0
	Mother_Surname	nvarchar	100	0
	Mother_Cell_Number	varchar	40	0
	Mother_Work_Number	varchar	40	0
	Emergency_Contact_Given_Name	nvarchar	100	0
	Emergency_Contact_Surname	nvarchar	100	0
	Emergency_Contact_Home_Number	varchar	40	0
	House_Number	varchar	10	0
	Apartment_Number	varchar	10	0
	Street_Name	varchar	255	0
	Township	varchar	50	0
	Postal_Code	varchar	25	0
	RR_Number	varchar	5	0
	City	varchar	50	0
	Student_Home_Number	varchar	40	0
	French_Immersion_Program	char	10	0
	Exceptionality_1	varchar	150	0
	Exceptionality_2	varchar	150	0
	Exceptionality_3	varchar	150	0
	Entry_Date	date	10	0
	Retirement_Date	date	10	0
	School_Number	varchar	10	0
	Homeroom_Designation_Current	varchar	4	0
	Custody_Notes	nvarchar	-1	0
vw_PVNCCDSB_Coop_CurrentYear	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_Base_Clever_Staff_Updated	School_id	varchar	10	0
	Staff_id	varchar	25	0
	Staff_email	varchar	255	0
	First_name	nvarchar	100	0
	Last_name	nvarchar	100	0
	Department	varchar	150	0
	Title	nvarchar	60	0
	Username	varchar	1	0
	Password	varchar	1	0
	Role	nvarchar	200	0
vw_Timetable_Repeats	School_Short_Name	varchar	10	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Grade	varchar	3	0
	Ministry_Num_Fmt	varchar	12	0
	Course_Code	varchar	10	0
	Class_Section	char	2	0
	Is_Repeat	bit	1	0
	Previous_Course_Code	char	10	0
	Previous_Completion_Date	date	10	0
	Previous_Credit	decimal	5	2
	Previous_Mark	varchar	3	0
vw_Base_Clever_Students_Updated	School_id	varchar	10	0
	Student_id	bigint	19	0
	Student_number	varchar	12	0
	State_id	varchar	10	0
	Last_name	nvarchar	100	0
	Middle_Name	nvarchar	100	0
	First_name	nvarchar	100	0
	Grade	varchar	3	0
	Gender	char	1	0
	Graduation year	date	10	0
	DOB- date of birth	date	10	0
	race	varchar	1	0
	Hispanic_Latino	varchar	1	0
	Home_language	varchar	150	0
	ELL_status	varchar	1	0
	Frl_status	varchar	1	0
	IEP_status	varchar	3	0
	Student_street	varchar	255	0
	Student_city	varchar	50	0
	Student_state	varchar	50	0
	Student_email	varchar	255	0
	Contact_relationship	varchar	255	0
	Contact_type	varchar	255	0
	Contact_name	nvarchar	202	0
	Contact_phone	varchar	40	0
	Contact_phone_type	nvarchar	200	0
	Contact_email	varchar	255	0
	Contact_sis_id	uniqueidentifier	16	0
	Username	varchar	1	0
	Password	varchar	1	0
	Unweighted GPA	varchar	1	0
	Weighted_GPA	varchar	1	0
	ext*	varchar	1	0
vw_Transcript_Substitutions_Current_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
	School_Short_Name	varchar	10	0
vw_Base_Clever_Teachers_Updated	School_id	varchar	10	0
	Teacher_id	varchar	25	0
	Teacher_number	varchar	25	0
	State_teacher_id	char	15	0
	Teacher_email	varchar	255	0
	First_name	nvarchar	100	0
	Middle_name	nvarchar	100	0
	Last_name	nvarchar	100	0
	Title	nvarchar	60	0
	Username	varchar	1	0
	Password	varchar	1	0
vw_Classes_Current_AB	School_Short_Name	varchar	10	0
	School_Name	varchar	255	0
	School_Number	char	10	0
	Class_Code	varchar	10	0
	Section_Letter	char	2	0
	Department	varchar	150	0
	Semester_Term_Pattern	varchar	30	0
	Period_Pattern	varchar	30	0
	Course_Type	varchar	50	0
	Delivery	varchar	50	0
	Credit_Value	numeric	5	2
	Language	varchar	150	0
	Reportable	bit	1	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Number	varchar	25	0
	Occupancy	int	10	0
	Course_Title	varchar	255	0
	Class_Room	nvarchar	-1	0
	Is_CTS_Master_Class	bit	1	0
	Is_CTS_Module	bit	1	0
	CTS_Master_Class_Code	varchar	10	0
	CTS_Master_Class_Section	char	2	0
	Class_Start_Date	date	10	0
	Class_End_Date	date	10	0
	Minutes_Per_Day	smallint	5	0
	Continuous_Entry	bit	1	0
	Course_Grade	varchar	3	0
	Is_Reportable	bit	1	0
	Attendance_Last_Taken_Date	date	10	0
vw_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
	Last name	nvarchar	100	0
	Gender	char	1	0
	Birthday	date	10	0
	Status	char	1	0
	Grade	varchar	3	0
	Student Cohort	varchar	150	0
	Homeroom	varchar	12	0
	Apartment	varchar	10	0
	Street number	varchar	10	0
	Street name	varchar	255	0
	City	varchar	50	0
	Postal Code	varchar	25	0
	PO Box	varchar	17	0
	province	varchar	50	0
	Country	varchar	50	0
	Township	varchar	50	0
	Legal_Land_Description	varchar	121	0
	Student phone number	varchar	40	0
	Student Special Custody Note	nvarchar	-1	0
	Future Apartment	varchar	10	0
	Future Street number	varchar	10	0
	Future Street name	varchar	255	0
	Future City	varchar	50	0
	Future Postal Code	varchar	25	0
	Future PO Box	varchar	17	0
	Future Province	varchar	50	0
	Future Country	varchar	50	0
	Future Address Effective Date	date	10	0
	Contact Order 1 name	nvarchar	202	0
	Contact Order 1 Type	varchar	255	0
	Contact order 1 Legal Guardian	bit	1	0
	Contact order 1 Custodian	bit	1	0
	Contact 1 Custody Note	nvarchar	-1	0
	Contact order 1 emergency contact	tinyint	3	0
	Contact Order 1 home phone	varchar	40	0
	Contact Order 1 cell phone	varchar	40	0
	Contact Order 1 employer	varchar	255	0
	Contact Order 1 employer phone	varchar	40	0
	Contact Order 1 Email	varchar	255	0
	Contact Order 1 Apartment	varchar	10	0
	Contact Order 1 Street number	varchar	10	0
	Contact Order 1 Street name	varchar	255	0
	Contact Order 1 City	varchar	50	0
	Contact Order 1 Postal Code	varchar	25	0
	Contact Order 1 PO Box	varchar	17	0
	Contact Order 1 province	varchar	50	0
	Contact Order 1 Country	varchar	50	0
	Contact Order 1 Emergency Code	varchar	100	0
	Contact Order 2 name	nvarchar	202	0
	Contact Order 2 Type	varchar	255	0
	Contact order 2 Legal Guardian	bit	1	0
	Contact order 2 Custodian	bit	1	0
	Contact 2 Custody Note	nvarchar	-1	0
	Contact order 2 emergency contact	tinyint	3	0
	Contact Order 2 home phone	varchar	40	0
	Contact Order 2 cell phone	varchar	40	0
	Contact Order 2 employer	varchar	255	0
	Contact Order 2 employer phone	varchar	40	0
	Contact Order 2 Email	varchar	255	0
	Contact Order 2 Apartment	varchar	10	0
	Contact Order 2 Street number	varchar	10	0
	Contact Order 2 Street name	varchar	255	0
	Contact Order 2 City	varchar	50	0
	Contact Order 2 Postal Code	varchar	25	0
	Contact Order 2 PO Box	varchar	17	0
	Contact Order 2 province	varchar	50	0
	Contact Order 2 Country	varchar	50	0
	Contact Order 2 Emergency Code	varchar	100	0
	Special Custody	bit	1	0
	Lives With	varchar	163	0
	Sitter's Name	nvarchar	202	0
	Sitter home phone	varchar	40	0
	Sitter cell phone	varchar	40	0
	Sitter employer	varchar	255	0
	Sitter employer phone	varchar	40	0
	Sitter Email	varchar	255	0
	Sitter Apartment	varchar	10	0
	Sitter Street number	varchar	10	0
	Sitter Street name	varchar	255	0
	Sitter City	varchar	50	0
	Sitter Postal Code	varchar	25	0
	Sitter PO Box	varchar	17	0
	Sitter province	varchar	50	0
	Sitter Country	varchar	50	0
	Sitter Emergency Code	varchar	100	0
	Current Pick Up Apartment	varchar	10	0
	Current Pick Up Street number	varchar	10	0
	Current Pick Up Street name	varchar	255	0
	Current Pick Up City	varchar	50	0
	Current Pick Up Postal Code	varchar	25	0
	Current Pick Up PO Box	varchar	17	0
	Current Pick Up province	varchar	50	0
	Current Pick Up Country	varchar	50	0
	Current Drop Off Apartment	varchar	10	0
	Current Drop Off Street number	varchar	10	0
	Current Drop Off Street name	varchar	255	0
	Current Drop Off City	varchar	50	0
	Current Drop Off Postal Code	varchar	25	0
	Current Drop Off PO Box	varchar	17	0
	Current Drop Off province	varchar	50	0
	Current Drop Off Country	varchar	50	0
	Entry date	date	10	0
	Retirement/transfer date	date	10	0
	Medical notes	nvarchar	-1	0
	Special Ed Code	char	10	0
	Grant Type 1	char	10	0
	Grant Type 2	char	10	0
	Grant Type 3	char	10	0
	Enrollment Type 1	char	10	0
	Enrollment Type 2	char	10	0
	Enrollment Type 3	char	10	0
	Next Year Grade	varchar	3	0
	Next Year School Number	varchar	10	0
	Student Email	varchar	255	0
vw_Base_Clever_Sections_Updated	School_id	char	10	0
	Section_id	varchar	12	0
	Teacher_id	varchar	25	0
	Teacher_2_id	varchar	25	0
	Teacher_3_id	varchar	1	0
	Teacher_4_id	varchar	1	0
	Name	nvarchar	202	0
	Section_number	smallint	5	0
	Grade	varchar	3	0
	Course_name	varchar	255	0
	Course_Number	smallint	5	0
	Course_description	varchar	500	0
	Period	tinyint	3	0
	Subject	varchar	150	0
	Term_name	varchar	30	0
	Term_start	date	10	0
	Term_end	date	10	0
vw_Classes_Ontario	School_Name	varchar	255	0
	School_Number	char	10	0
	Class_Code	varchar	10	0
	Section_Letter	char	2	0
	Department	varchar	150	0
	Semester_Term_Pattern	varchar	30	0
	Period_Pattern	varchar	30	0
	Course_Type	varchar	50	0
	Dual_Credit_Course_Type	varchar	150	0
	Delivery	varchar	50	0
	Credit_Value	numeric	5	2
	Language	varchar	150	0
	Reportable	bit	1	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Occupancy	int	10	0
	School_Short_Name	varchar	10	0
	Course_Title	varchar	255	0
	Dual_Credit_Course_Assoc	varchar	172	0
	Class_Room	nvarchar	-1	0
	Class_Start_Date	date	10	0
	Class_End_Date	date	10	0
	Minutes_Per_Day	smallint	5	0
	Continuous_Entry	bit	1	0
	Num_Lessons_Work_Units	smallint	5	0
	Num_Sessions	tinyint	3	0
	Course_Grade	varchar	3	0
	Is_Reportable	bit	1	0
	Attendance_Last_Taken_Date	date	10	0
	Course_Offering_Type	varchar	150	0
vw_Edsembli_Student_Count_Detail	School_Short_Name	nvarchar	256	0
	Person_Id	uniqueidentifier	16	0
	Studentnumber	varchar	25	0
vw_Classes_Ontario_Scheduling	School_Name	varchar	255	0
	School_Number	char	10	0
	Class_Code	varchar	10	0
	Section_Letter	char	2	0
	Department	varchar	150	0
	Semester_Term_Pattern	varchar	30	0
	Period_Pattern	varchar	30	0
	Course_Type	varchar	50	0
	Dual_Credit_Course_Type	varchar	150	0
	Delivery	varchar	50	0
	Credit_Value	numeric	5	2
	Language	varchar	150	0
	Reportable	bit	1	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Occupancy	int	10	0
	School_Short_Name	varchar	10	0
	Course_Title	varchar	255	0
	Dual_Credit_Course_Assoc	varchar	172	0
	Class_Room	nvarchar	-1	0
	Course_Grade	varchar	3	0
	Is_Reportable	bit	1	0
	Course_Offering_Type	varchar	150	0
vw_Destiny_export	LastName	nvarchar	100	0
	FirstName	nvarchar	100	0
	MiddleName	nvarchar	100	0
	StudentID ASN	varchar	12	0
	Email	varchar	255	0
	Gender	char	1	0
	Birthday	date	10	0
	Grade	varchar	3	0
	PatronID ASN	varchar	12	0
	Homeroom	varchar	12	0
	SchoolID	varchar	10	0
	GraduationYear	date	10	0
vw_IntPartner_PSTGI_Grade_Summary	School_Short_Name	varchar	10	0
	School_Number	varchar	10	0
	School_Name	varchar	255	0
	Grade	varchar	3	0
	Special_Ed	bit	1	0
	French_Program	varchar	150	0
	Stu_Status	varchar	18	0
	Occupancy_Count	int	10	0
vw_Classes_Scheduling_AB	School_Short_Name	varchar	10	0
	School_Name	varchar	255	0
	School_Number	char	10	0
	Class_Code	varchar	10	0
	Section_Letter	char	2	0
	Department	varchar	150	0
	Semester_Term_Pattern	varchar	30	0
	Period_Pattern	varchar	30	0
	Course_Type	varchar	50	0
	Delivery	varchar	50	0
	Credit_Value	numeric	5	2
	Language	varchar	150	0
	Reportable	bit	1	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Number	varchar	25	0
	Occupancy	int	10	0
	Course_Title	varchar	255	0
	Class_Room	nvarchar	-1	0
	Is_CTS_Master_Class	bit	1	0
	Is_CTS_Module	bit	1	0
	CTS_Master_Class_Code	varchar	10	0
	CTS_Master_Class_Section	char	2	0
	Course_Grade	varchar	3	0
	Is_Reportable	bit	1	0
vw_SeeSaw_Export_Student	Student Name	nvarchar	202	0
	Student ID	varchar	25	0
	Student Email	varchar	255	0
vw_IntPartner_PSTGI_Homeroom_Summary	School_Short_Name	varchar	10	0
	School_Number	varchar	10	0
	School_Name	varchar	255	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Room	varchar	5	0
	Teacher_Number	varchar	25	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Number	varchar	25	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Grade	varchar	3	0
	Special_Ed	bit	1	0
	Special_Ed_Program	varchar	150	0
	French_Program	varchar	150	0
	Occupancy_Count	int	10	0
vw_Current_Student_Status_ON	School_Name	varchar	255	0
	OEN	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
	HCSchool	char	1	0
	Grade_Next_Year	char	3	0
	School_Short_Name	varchar	10	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	School_City	varchar	50	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Number	varchar	5	0
	Homeroom_Designation_Next_Year	varchar	4	0
	Homeroom_Number_Next_Year	varchar	5	0
	Main_Holder_Of_OSR	varchar	150	0
	Entry_Date	date	10	0
	Retirement_Date	date	10	0
	Stu_Number	varchar	25	0
	Stu_Number_Value	bigint	19	0
	Usual_Name	nvarchar	100	0
	Birthdate	date	10	0
	Internal_School_ID	int	10	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
	Homeroom_Teacher_Number_Next_Year	varchar	25	0
	Homeroom_Teacher_Surname_Next_Year	nvarchar	100	0
	Homeroom_Teacher_Given_Name_Next_Year	nvarchar	100	0
	Country_Of_Birth	varchar	150	0
	Province_Of_Birth	varchar	150	0
	First_Language	varchar	150	0
	Student_Board_Residency_Status	varchar	150	0
	Instructional_Setting	varchar	150	0
	Person_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Entered_Into_Maplewood_Date	date	10	0
	connectEd_User_Name	varchar	100	0
	Student_Religion	varchar	150	0
	Mother_Religion	varchar	150	0
	Father_Religion	varchar	150	0
	Citizenship	varchar	150	0
	Registration_Source	varchar	200	0
vw_SeeSaw_Export_Teacher	Teacher Email	varchar	255	0
	Teacher First Name	nvarchar	100	0
	Teacher Last Name	nvarchar	100	0
	Class Name	varchar	12	0
	Grade Level	varchar	3	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	nvarchar	-1	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_Base_Address_Parts	Emerg_Cont_Num	tinyint	3	0
	Contact_Lst_Lst_ID	uniqueidentifier	16	0
	Person_Role_ID	uniqueidentifier	16	0
	Contact_Lst_ID	uniqueidentifier	16	0
	Contact_Info_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	int	10	0
	First_Line_Address	nvarchar	512	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
	Province	varchar	50	0
	PO_Box	varchar	10	0
	Emergency_Code	varchar	100	0
	RR_Number	varchar	5	0
	Address_Group	varchar	20	0
	Quarter	varchar	2	0
	Lot	varchar	5	0
	Township	varchar	50	0
	Concession	varchar	50	0
	Meridian	varchar	10	0
	Legal_Land_Description	varchar	121	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_Base_Addresses	Contact_Info_ID	uniqueidentifier	16	0
	ComposedAddress	nvarchar	-1	0
vw_Lockers	School_Short_Name	varchar	10	0
	Locker_Num	varchar	50	0
	Available	bit	1	0
	Max_Students	smallint	5	0
	Locker_Bank	varchar	50	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Grade	varchar	3	0
vw_Families_In_Division	School Name	varchar	255	0
	School Short Name	varchar	10	0
	Family Name	nvarchar	100	0
	Family Address	nvarchar	-1	0
	Number Students Attending This School	int	10	0
	Oldest Sibling Surname	nvarchar	100	0
	Oldest Sibling Given Name	nvarchar	100	0
	Oldest Sibling Usual Name	nvarchar	100	0
	Oldest Sibling Student Number	bigint	19	0
	HouseholdID	uniqueidentifier	16	0
	Student_Sur_name	nvarchar	100	0
	student_Given_name	nvarchar	100	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_Base_Archive_Achievement	Class_ID	uniqueidentifier	16	0
	Enrol_ID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	School_ID	uniqueidentifier	16	0
	Topic_ID	uniqueidentifier	16	0
	Term_ID	uniqueidentifier	16	0
	List_ID	uniqueidentifier	16	0
	School_Year	varchar	10	0
	School	varchar	255	0
	School_Short_Name	varchar	10	0
	Student_Grade	varchar	2	0
	Course_Code	varchar	10	0
	Course_Grade	varchar	3	0
	Class_Section	varchar	2	0
	Class_Title	varchar	255	0
	Homeroom_Room	varchar	5	0
	Homeroom_Designation	varchar	10	0
	Term	varchar	50	0
	Term_Code	varchar	5	0
	Final_Term	bit	1	0
	Topic	varchar	255	0
	Topic_Code	varchar	5	0
	Final_Topic	bit	1	0
	Mark	varchar	6	0
	Override	varchar	6	0
	Mark_Last_Modified	datetime	23	3
	SubmissionDate	date	10	0
vw_Pathway_Ontario	School Number	varchar	10	0
	School Name	varchar	255	0
	OEN	varchar	12	0
	Student Last Name	nvarchar	100	0
	Student Usual Name	nvarchar	100	0
	Street Address	varchar	266	0
	City	varchar	50	0
	Postal Code	varchar	25	0
	Student Email Address	varchar	255	0
	Student Phone Number	varchar	40	0
	Gender	char	1	0
	DOB	date	10	0
	Grade	varchar	3	0
	Course Start Date	date	10	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
	School_Short_Name	varchar	10	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Number	varchar	5	0
	Homeroom_Teacher_Surname	nvarchar	100	0
	Homeroom_Teacher_Given_Name	nvarchar	100	0
	Homeroom_Teacher_Number	varchar	25	0
	Homeroom_Alt_Teacher_Surname	nvarchar	100	0
	Homeroom_Alt_Teacher_Given_Name	nvarchar	100	0
	Homeroom_Alt_Teacher_Number	varchar	25	0
	OYAP	bit	1	0
	Is_Special_Ed	bit	1	0
	Spec_Ed_Status	varchar	8	0
	IEP	bit	1	0
	IEP_With	nvarchar	-1	0
	Special_Ed_Resources	varchar	150	0
	Exceptionality_1	varchar	150	0
	Exceptionality_2	varchar	150	0
	Exceptionality_3	varchar	150	0
vw_PVNC_Scheduling_Cohort	Student_Number	varchar	25	0
	OEN_Number	varchar	12	0
	Surname	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Grade	varchar	3	0
	Birthdate	date	10	0
	Gender	char	1	0
	Defined Character 2	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
	Township	varchar	50	0
	Home_Phone	varchar	40	0
	Attendance_Type	varchar	50	0
	School_Number	varchar	10	0
	French_Immersion_Type	varchar	150	0
	Homeroom_Number	varchar	5	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Designation_Next_Year	varchar	4	0
	Grade_Next_Year	varchar	3	0
	School_Short_Name	varchar	10	0
	Entry_Date	date	10	0
	Sitter_Name	nvarchar	202	0
	Sitter_House_Number	varchar	10	0
	Sitter_Street_Name	varchar	255	0
	Sitter_City	varchar	50	0
	Sitter_Postal_Code	varchar	25	0
	Sitter_Phone_Number	varchar	40	0
	Mother_Title	nvarchar	60	0
	Mother_Given_Name	nvarchar	100	0
	Mother_Surname	nvarchar	100	0
	Mothers_Cell_Phone	varchar	40	0
	Mother_Email	varchar	255	0
	Mother_House_Number	varchar	10	0
	Mother_Street_Name	varchar	255	0
	Mother_City	varchar	50	0
	Mother_Postal_Code	varchar	25	0
	Father_Title	nvarchar	60	0
	Father_Given_Name	nvarchar	100	0
	Father_Surname	nvarchar	100	0
	Father_Cell_Phone	varchar	40	0
	Father_Email	varchar	255	0
	Father_House_Number	varchar	10	0
	Father_Street_Name	varchar	255	0
	Father_City	varchar	50	0
	Father_Postal_Code	varchar	25	0
	Emergency_Contact_Given_Name	nvarchar	100	0
	Emergency_Contact_Surname	nvarchar	100	0
	Emergency_Contact_Cell_Phone	varchar	40	0
	Lives_With	varchar	150	0
	Special Custody	bit	1	0
vw_PVNCCDSB_Class_Drop_Counts	School_Short_Name	varchar	10	0
	Course_Code	varchar	10	0
	Class_Section	varchar	2	0
	Course_Grade	varchar	3	0
	Teacher_Surname	nvarchar	100	0
	Teacher_GivenName	nvarchar	100	0
	Teacher_Title	nvarchar	60	0
	StaffNumber	bigint	19	0
	Semester	tinyint	3	0
	Period	tinyint	3	0
	Number_Students_Enrolled_On_FirstDay	int	10	0
	Number_Students_Currently_Enrolled	int	10	0
	Number_Students_Dropped_Class	int	10	0
	Class_ID	uniqueidentifier	16	0
vw_Base_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
vw_PVNCCDSB_Transportation_Export_V2	Student_Number	varchar	25	0
	OEN_Number	varchar	12	0
	Surname	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Grade	varchar	3	0
	Birthdate	date	10	0
	Gender	char	1	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
	Township	varchar	50	0
	Home_Phone	varchar	40	0
	Attendance_Type	varchar	50	0
	School_Number	varchar	10	0
	French_Immersion_Type	varchar	150	0
	Homeroom_Number	varchar	5	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Designation_Next_Year	varchar	4	0
	Grade_Next_Year	varchar	3	0
	School_Short_Name	varchar	10	0
	Entry_Date	date	10	0
	Sitter_Name	nvarchar	202	0
	Sitter_House_Number	varchar	10	0
	Sitter_Street_Name	varchar	255	0
	Sitter_City	varchar	50	0
	Sitter_Postal_Code	varchar	25	0
	Sitter_Phone_Number	varchar	40	0
	Mother_Title	nvarchar	60	0
	Mother_Given_Name	nvarchar	100	0
	Mother_Surname	nvarchar	100	0
	Mothers_Cell_Phone	varchar	40	0
	Mother_Email	varchar	255	0
	Mother_House_Number	varchar	10	0
	Mother_Street_Name	varchar	255	0
	Mother_City	varchar	50	0
	Mother_Postal_Code	varchar	25	0
	Father_Title	nvarchar	60	0
	Father_Given_Name	nvarchar	100	0
	Father_Surname	nvarchar	100	0
	Father_Cell_Phone	varchar	40	0
	Father_Email	varchar	255	0
	Father_House_Number	varchar	10	0
	Father_Street_Name	varchar	255	0
	Father_City	varchar	50	0
	Father_Postal_Code	varchar	25	0
	Emergency_Contact_Given_Name	nvarchar	100	0
	Emergency_Contact_Surname	nvarchar	100	0
	Emergency_Contact_Cell_Phone	varchar	40	0
	Lives_With	varchar	150	0
	Special Custody	bit	1	0
	PIN	nvarchar	-1	0
vw_Student_Choices_ON	School_Short_Name	varchar	10	0
	OEN	varchar	12	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Stu_Status_Code	varchar	1	0
	Stu_Status	varchar	18	0
	Defined_Character_1	varchar	3	0
	Defined_Character_2	varchar	3	0
	Defined_Character_3	varchar	3	0
	Defined_Character_4	varchar	3	0
	This_Year_Grade	varchar	3	0
	Next_Year_Grade	char	3	0
	Course_Code	varchar	10	0
	Course_Title	varchar	255	0
	Choice_Type	varchar	50	0
	Choice_Required	bit	1	0
	Sort_Order	smallint	5	0
	Assigned_To_Class	bit	1	0
	Credit_Value	decimal	5	2
	Total_Credit_Earned	decimal	38	2
	Type_Of_Course	varchar	120	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	nvarchar	-1	0
	HCSchool	char	1	0
vw_Base_Assessment	Person_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Test_Def_ID	uniqueidentifier	16	0
	Test_Version_ID	uniqueidentifier	16	0
	Test	varchar	50	0
	Subject	varchar	50	0
	Strand	varchar	50	0
	Timeframe	varchar	50	0
	Mark	real	24	0
	Mark_Level	char	10	0
	Mark_Fmt	varchar	10	0
	Test_Identifier	varchar	20	0
	Subject_Identifier	varchar	20	0
	Strand_Identifier	varchar	20	0
vw_Student_Enrolment_SK	School_Short_Name	varchar	10	0
	School_Name	varchar	255	0
	Student_Number	bigint	19	0
	DEN	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
	EAL_Proficiency_Level	varchar	150	0
	EAL_Start_Date	date	10	0
	Citizenship	varchar	150	0
	Resident_Type	varchar	150	0
	Country_Of_Birth	varchar	150	0
	First_Language	varchar	150	0
	Second_Language	varchar	150	0
	Base_School	bit	1	0
	Student_Enrolment_Status	varchar	18	0
	Place_Of_Origin	varchar	150	0
	Previous_Province_State	varchar	150	0
	Tuition_Status	varchar	150	0
	Exchange_Program_Name	varchar	150	0
	Home_School	bit	1	0
	Program	varchar	150	0
	Prekindergarten_Ministry_Designated	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	varchar	150	0
	Stu_Enrol_ID	uniqueidentifier	16	0
vw_PVNC_Student_Enrolment	Stu_Enrol_ID	uniqueidentifier	16	0
	IsScheduling	bit	1	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	IsCurrent	bit	1	0
	School_ID	uniqueidentifier	16	0
	School_Year	varchar	10	0
	Person_ID	uniqueidentifier	16	0
	Oen	int	10	0
	IsHomeSchool	bit	1	0
	This_Sch_Entry_Date	smalldatetime	16	0
	Retirement_Date	smalldatetime	16	0
	Grade	char	3	0
	Homeroom_ID	uniqueidentifier	16	0
	FrenchProgram	varchar	150	0
	mwStatus	char	1	0
	StatusText	varchar	30	0
	Accum_Std_Credits	decimal	5	2
	Accum_OAC_Credits	decimal	5	2
	Elem_Entry_Date	smalldatetime	16	0
	Sec_Entry_Date	smalldatetime	16	0
	Fre_Imm_Min	smallint	5	0
	Special_Ed	bit	1	0
	Special_Ed_Status	char	1	0
	English_Language_Learner	varchar	50	0
	Short_Name	varchar	10	0
	Date_Imported	datetime	23	3
vw_Base_Classes	Class_ID	uniqueidentifier	16	0
	Course_ID	uniqueidentifier	16	0
	OnSisCode	varchar	16	0
	Code_ID	uniqueidentifier	16	0
	School_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	School_Short_Name	varchar	10	0
	School_Name	varchar	255	0
	School_Number	char	10	0
	Class_Code	varchar	10	0
	Section_Letter	char	2	0
	Department	varchar	150	0
	Semester_Term_Pattern	varchar	30	0
	Period_Pattern	varchar	30	0
	Course_Type	varchar	50	0
	Delivery	varchar	50	0
	Credit_Value	numeric	5	2
	Language	varchar	150	0
	Reportable	bit	1	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Number	varchar	25	0
	Occupancy	int	10	0
	Course_Title	varchar	255	0
	Class_Room	nvarchar	-1	0
	Scheduling	bit	1	0
	Class_Start_Date	date	10	0
	Class_End_Date	date	10	0
	Minutes_Per_Day	smallint	5	0
	Continuous_Entry	bit	1	0
	Num_Lessons_Work_Units	smallint	5	0
	Num_Sessions	tinyint	3	0
	Course_Grade	varchar	3	0
	Is_Reportable	bit	1	0
	Attendance_Last_Taken_Date	date	10	0
vw_Student_Enrolments_SK	School_Short_Name	varchar	10	0
	School_Number	varchar	10	0
	PEN	varchar	12	0
	Stu_Number	varchar	25	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Entry_Date	date	10	0
	Entry_Reason_Code	varchar	10	0
	Entry_Reason	varchar	150	0
	Origin_School_Number	varchar	10	0
	Origin_School	varchar	150	0
	Retirement_Date	date	10	0
	Enrolment_Result_Code	varchar	10	0
	Enrolment_Result	varchar	150	0
	Destination_School_Number	varchar	10	0
	Destination_School	varchar	150	0
vw_PVNC_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
	Birthdate	date	10	0
	Stu_Status	varchar	18	0
	Stu_Status_Code	varchar	1	0
	Field_Type	varchar	50	0
	Field_Name	varchar	50	0
	Field_Value	nvarchar	-1	0
	Board_Defined	bit	1	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Person_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
vw_Base_Clever_Schools	School_id	varchar	10	0
	School_name	varchar	255	0
	School_number	varchar	10	0
	School_address	varchar	308	0
	School_city	varchar	50	0
	School_state	varchar	50	0
	School_zip	varchar	8000	0
vw_Student_Special_Education_Full_ON	Person_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	School_Short_Name	varchar	10	0
	Surname	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Birthdate	date	10	0
	Gender	char	1	0
	OEN	varchar	12	0
	Grade	varchar	3	0
	Stu_Status	varchar	18	0
	Stu_Status_Code	varchar	1	0
	Spec_Ed_Status	varchar	8	0
	Exceptionality_Placement_Number	tinyint	3	0
	Exceptionality_Code	varchar	10	0
	Exceptionality	varchar	150	0
	Execptionality_Start_Date	date	10	0
	Exceptionality_End_Date	date	10	0
	Placement	varchar	150	0
	Placement_Start_Date	date	10	0
	Placement_End_Date	date	10	0
	Special_Ed_Program	varchar	150	0
	Support_Service	varchar	150	0
	Special_Ed_Resources	varchar	150	0
	IEP_With	nvarchar	-1	0
	Residency	varchar	150	0
vw_PVNC_Scheduling_Classes_Ontario	School_Name	varchar	255	0
	School_Number	char	10	0
	Class_Code	varchar	10	0
	Section_Letter	char	2	0
	Department	varchar	150	0
	Semester_Term_Pattern	varchar	30	0
	Period_Pattern	varchar	30	0
	Course_Type	varchar	50	0
	Dual_Credit_Course_Type	varchar	150	0
	Delivery	varchar	50	0
	Credit_Value	numeric	5	2
	Language	varchar	150	0
	Reportable	bit	1	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Occupancy	int	10	0
	School_Short_Name	varchar	10	0
	Course_Title	varchar	255	0
	Dual_Credit_Course_Assoc	varchar	172	0
vw_Base_Current_Students_Households	HouseholdAddressInfoID	uniqueidentifier	16	0
	OldestSiblingPersonID	uniqueidentifier	16	0
	YoungestSiblingPersonID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	FamilyName	nvarchar	100	0
	OldestSiblingsContactInfoID	uniqueidentifier	16	0
vw_Student_Timetable_ON	School_Short_Name	varchar	10	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	OEN	varchar	12	0
	Grade	varchar	3	0
	Course_Code	varchar	10	0
	Class_Section	char	2	0
	Course_Number	varchar	10	0
	Course_Grade	varchar	3	0
	Course_Title	varchar	255	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alt_Teacher_Surname	nvarchar	100	0
	Alt_Teacher_Given_Name	nvarchar	100	0
	Alt_Teacher_Number	varchar	25	0
	Class_Start_Date	date	10	0
	Class_End_Date	date	10	0
	Is_Dropped	bit	1	0
	Is_Next_Year	bit	1	0
	Is_Continuous_Entry	bit	1	0
	Continuous_Entry_Start_Date	date	10	0
	Continuous_Entry_Completion_Date	date	10	0
	Course_Type	varchar	50	0
	Delivery_Type	varchar	50	0
	Attendance_Type	varchar	50	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	Birthdate	date	10	0
	Gender	char	1	0
	Aboriginal_Self_ID	varchar	150	0
	Exceptionality_1	varchar	150	0
	Exceptionality_2	varchar	150	0
	Exceptionality_3	varchar	150	0
	Placement_Setting	varchar	150	0
	Entry_Date	date	10	0
	Retirement_Date	date	10	0
	Sem_Term_Pattern	varchar	30	0
	Day_Per_Pattern	varchar	30	0
	Drop_Date	date	10	0
	Credit_Attempted	decimal	5	2
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_Base_Homerooms	Homeroom_ID	uniqueidentifier	16	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Room	varchar	5	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Number	varchar	25	0
vw_Transcript_Repeats	School_Short_Name	varchar	10	0
	Min_Num	varchar	12	0
	Surname	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Stu_Status	varchar	18	0
	Stu_Status_Code	varchar	1	0
	Is_Exact_Code_Match	bit	1	0
	Course_Code	char	10	0
	Mark	varchar	3	0
	Transcript_Date	date	10	0
	Credit_Earned	decimal	5	2
	Delivery_Type	varchar	50	0
	Repeat_Course_Code	char	10	0
	Repeat_Mark	varchar	3	0
	Repeat_Date	date	10	0
	Repeat_Credit_Earned	decimal	5	2
	Repeat_Delivery_Type	varchar	50	0
vw_Base_Religion	Person_ID	uniqueidentifier	16	0
	StudentReligionEnglish	varchar	150	0
	StudentReligionFrench	varchar	150	0
	StudentParish	varchar	150	0
	MotherReligionEnglish	varchar	150	0
	MotherReligionFrench	varchar	150	0
	MotherParish	varchar	150	0
	FatherReligionEnglish	varchar	150	0
	FatherReligionFrench	varchar	150	0
	FatherParish	varchar	150	0
	GuardianReligionEnglish	varchar	150	0
	GuardianReligionFrench	varchar	150	0
	GuardianParish	varchar	150	0
	BaptismDate	smalldatetime	16	0
	BaptismParish	varchar	150	0
	BaptismSchool	varchar	150	0
	ConfirmationDate	smalldatetime	16	0
	ConfirmationParish	varchar	150	0
	ConfirmationSchool	varchar	150	0
	FirstEucharistDate	smalldatetime	16	0
	FirstEucharistParish	varchar	150	0
	FirstEucharistSchool	varchar	150	0
	FirstReconciliationDate	smalldatetime	16	0
	FirstReconciliationParish	varchar	150	0
	FirstReconciliationSchool	varchar	150	0
vw_Transcripts	Transcript_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Code_Def_ID	uniqueidentifier	16	0
	School_Short_Name	varchar	10	0
	Min_Num	varchar	12	0
	Surname	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_Number	char	10	0
	Course_Title	varchar	255	0
	Transcript_Date	date	10	0
	Mark	varchar	3	0
	Language	varchar	150	0
	Course_Type	varchar	50	0
	Delivery_Type	varchar	50	0
	Credit_Attempted	decimal	5	2
	Credit_Earned	decimal	5	2
	Student_Grade	varchar	3	0
	Achieved_At_School	varchar	150	0
	Mark_Numeric	smallint	5	0
vw_Base_Staff	Staff_ID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	Contact_Lst_Lst_ID	uniqueidentifier	16	0
	School_Short_Name	varchar	10	0
	School_Name	varchar	255	0
	Staff_Number	varchar	25	0
	Ministry_Number	varchar	15	0
	Title	nvarchar	60	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Gender	char	1	0
	Birthdate	date	10	0
	Role	varchar	255	0
	IsTeacher	bit	1	0
	Employment	varchar	50	0
	Status_Code	varchar	1	0
	Status	varchar	18	0
	Teaching_Since_Date	date	10	0
	This_Board_Date	date	10	0
	This_School_Date	date	10	0
	Transfer_Date	date	10	0
	RegistrationNumber	varchar	15	0
vw_Transcripts_ON	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	varchar	3	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
	Att_Absent	decimal	5	0
	Att_Excused	decimal	5	0
	Att_Late	decimal	5	0
	Att_Possible	decimal	4	1
	Dual_Credit_Type	varchar	150	0
	Dual_Credit_Institution	varchar	150	0
	Dual_Credit_Course_Code	varchar	50	0
	Student_Grade	varchar	3	0
	Achieved_At_School	varchar	150	0
	Birthdate	date	10	0
	Aboriginal_Self_ID	varchar	150	0
	Mark_Numeric	smallint	5	0
vw_Base_Students	Stu_Enrol_ID	uniqueidentifier	16	0
	Stu_Info_ID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	School_ID	uniqueidentifier	16	0
	Scl_Year_Info_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	varchar	12	0
	Ministry_Num_Fmt	varchar	12	0
	Sur_Name	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Middle_Name	nvarchar	100	0
	Usual_Name_Fmt	nvarchar	100	0
	Birthdate	date	10	0
	Gender	char	1	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
	School_Type	char	1	0
	Legal_Name	nvarchar	100	0
	Legal_Name_Fmt	nvarchar	100	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	Surname	nvarchar	100	0
	Special_Ed	bit	1	0
	Person_Status_ID	uniqueidentifier	16	0
	Entry_Date	date	10	0
	Retirement_Date	date	10	0
	Stu_Number	varchar	25	0
	Stu_Number_Value	bigint	19	0
	Entered_Into_Maplewood_Date	date	10	0
	Stu_Letters	char	3	0
	School_Year	varchar	10	0
vw_Archive_Achievement	School_Year	varchar	10	0
	School	varchar	255	0
	School_Short_Name	varchar	10	0
	Sur_Name	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Ministry_Num	varchar	8000	0
	Class	varchar	10	0
	Section	varchar	2	0
	Teacher	nvarchar	264	0
	Term	varchar	50	0
	Topic	varchar	255	0
	Mark	varchar	6	0
	Override	varchar	6	0
	Mark_Last_Modified	datetime	23	3
	Comment	varchar	-1	0
	Class_Sem	tinyint	3	0
	Class_Term	tinyint	3	0
	Class_Day	tinyint	3	0
	Class_Period	tinyint	3	0
	Class_Grade	varchar	3	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
	Special_Ed_Program	varchar	150	0
	Support_Service	varchar	150	0
	Special_Ed_Resources	varchar	150	0
vw_PVNC_Student_Contacts_Scheduling	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_Base_Students_Contact_Email	Contact_Lst_Lst_ID	uniqueidentifier	16	0
	Person_Role_ID	uniqueidentifier	16	0
	Seq_Num	bigint	19	0
	Email_Address	varchar	255	0
	Contact_Lst_ID	uniqueidentifier	16	0
	Contact_Info_ID	uniqueidentifier	16	0
vw_Archive_Achievement_Correspondence_Lessons_ON	School_Short_Name	varchar	10	0
	Class_Code	varchar	13	0
	Class_Credit_Value	numeric	5	2
	Student_Class_Status	varchar	7	0
	Semester_Term_Pattern_Name	varchar	30	0
	Delivery_Type	varchar	50	0
	Type_Of_Course	varchar	50	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Number	varchar	25	0
	Student_Surname	nvarchar	100	0
	Student_Given_Name	nvarchar	100	0
	OEN	varchar	12	0
	Student_Status	varchar	18	0
	Main_School	varchar	150	0
	Student_Board_Residence_Status	varchar	150	0
	Con_Ed_Student_Type	varchar	150	0
	Gender	char	1	0
	Home_Concurrent_Status	char	1	0
	Student_Phone_Number	varchar	40	0
	Student_Email	varchar	255	0
	Parent_Email_1	varchar	255	0
	Parent_Email_2	varchar	255	0
	Lessons_Completed	varchar	255	0
	Mark	varchar	6	0
	SubmissionDate	date	10	0
	Add_Date	date	10	0
	Drop_Date	date	10	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Room	varchar	5	0
	ContEntry_Active_Date	date	10	0
	ContEntry_Completion_Date	date	10	0
vw_Base_Students_Contact_Phone	Contact_Lst_Lst_ID	uniqueidentifier	16	0
	Person_Role_ID	uniqueidentifier	16	0
	Phone_Type_ID	uniqueidentifier	16	0
	Whole_Number	varchar	40	0
	Contact_Lst_ID	uniqueidentifier	16	0
	Contact_Info_ID	uniqueidentifier	16	0
	Seq_Num	bigint	19	0
vw_Archive_Achievement_Marks_MB	Class_ID	uniqueidentifier	16	0
	School_Year	varchar	10	0
	School	varchar	255	0
	School_Short_Name	varchar	10	0
	Sur_Name	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Ministry_Num	varchar	8000	0
	Class	varchar	10	0
	Section	varchar	2	0
	Class_Grade	varchar	3	0
	Teacher	nvarchar	264	0
	Term	varchar	50	0
	Topic	varchar	255	0
	Mark	varchar	6	0
	Override	varchar	6	0
	Mark_Last_Modified	datetime	23	3
	Comment	varchar	-1	0
	Person_ID	uniqueidentifier	16	0
	School_ID	uniqueidentifier	16	0
	Term_Code	varchar	5	0
	Topic_Code	varchar	5	0
	Final_Topic	bit	1	0
	Student_Grade	varchar	2	0
	Final_Term	bit	1	0
	Homeroom_Room	varchar	5	0
	Homeroom_Designation	varchar	10	0
	Gender	char	1	0
	Aboriginal_Status_Code	char	10	0
	Aboriginal_Status_Title	varchar	150	0
	Surname	nvarchar	100	0
	Class_Title	varchar	255	0
	Alternate_Teacher	nvarchar	264	0
	Timetable_Add_Or_Drop	char	1	0
	Enrol_ID	uniqueidentifier	16	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
	Special_Ed_Program	varchar	150	0
	Support_Service	varchar	150	0
	Special_Ed_Resources	varchar	150	0
	SubmissionDate	date	10	0
	EAL	bit	1	0
vw_Base_Students_EQAO_ON	Person_ID	uniqueidentifier	16	0
	EQAO_Grade_3_Math	decimal	38	1
	EQAO_Grade_3_Reading	decimal	38	1
	EQAO_Grade_3_Writing	decimal	38	1
	EQAO_Grade_6_Math	decimal	38	1
	EQAO_Grade_6_Reading	decimal	38	1
	EQAO_Grade_6_Writing	decimal	38	1
	EQAO_Grade_9_Math	decimal	38	1
vw_Archive_Achievement_Marks_SK	Class_ID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	School_ID	uniqueidentifier	16	0
	School_Year	varchar	10	0
	School	varchar	255	0
	School_Short_Name	varchar	10	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	DEN	varchar	8000	0
	Class	varchar	10	0
	Section	varchar	2	0
	Class_Grade	varchar	3	0
	Teacher	nvarchar	264	0
	Term	varchar	50	0
	Topic	varchar	255	0
	Mark	varchar	6	0
	Override	varchar	6	0
	Mark_Last_Modified	datetime	23	3
	Comment	varchar	-1	0
	Term_Code	varchar	5	0
	Topic_Code	varchar	5	0
	Final_Topic	bit	1	0
	Student_Grade	varchar	2	0
	Final_Term	bit	1	0
	Homeroom_Room	varchar	5	0
	Homeroom_Designation	varchar	10	0
	Gender	char	1	0
	Aboriginal_Status_Code	char	10	0
	Aboriginal_Status_Title	varchar	150	0
	Class_Title	varchar	255	0
	Alternate_Teacher	nvarchar	264	0
	Timetable_Add_Or_Drop	char	1	0
	Prov_Aboriginal_Status	varchar	150	0
vw_Base_Students_Person_ON	Person_ID	uniqueidentifier	16	0
	Aboriginal_Self_ID	varchar	150	0
	Country_Of_Birth	varchar	150	0
	Entry_To_Canada_Date	date	10	0
	Aboriginal_Type_Entry_Date	date	10	0
	First_Language	varchar	150	0
	Aboriginal_Status_Code	varchar	150	0
vw_Archive_Achievement_Session_Attendance_ON	School_Short_Name	varchar	10	0
	Class_Code	varchar	13	0
	Class_Credit_Value	numeric	5	2
	Student_Class_Status	varchar	7	0
	Semester_Term_Pattern_Name	varchar	30	0
	Delivery_Type	varchar	50	0
	Type_Of_Course	varchar	50	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Number	varchar	25	0
	Student_Surname	nvarchar	100	0
	Student_Given_Name	nvarchar	100	0
	OEN	varchar	12	0
	Student_Status	varchar	18	0
	Main_School	varchar	150	0
	Student_Board_Residence_Status	varchar	150	0
	Gender	char	1	0
	Home_Concurrent_Status	char	1	0
	Student_Phone_Number	varchar	40	0
	Student_Email	varchar	255	0
	Parent_Email_1	varchar	255	0
	Parent_Email_2	varchar	255	0
	Reporting_Period	varchar	5	0
	Session_Absent	varchar	8	0
	Date_Absent	date	10	0
	Add_Date	date	10	0
	Drop_Date	date	10	0
vw_Base_Students_Spec_Ed	Person_ID	uniqueidentifier	16	0
	Spec_Ed_Status	varchar	8	0
	Exceptionality_1	varchar	150	0
	Exceptionality_2	varchar	150	0
	Exceptionality_3	varchar	150	0
	IEP_With	nvarchar	-1	0
	Is_Special_Ed	bit	1	0
	IEP	bit	1	0
	Special_Ed_Program	varchar	150	0
	Support_Service	varchar	150	0
	Special_Ed_Resources	varchar	150	0
	IPRC_Date_Initial	date	10	0
	IPRC_Date_Last	date	10	0
	IPRC_Date_Next	date	10	0
	IPRC_Date_Demitted	date	10	0
	Placement	varchar	150	0
vw_Archive_Achievement_Work_Units_ON	School_Short_Name	varchar	10	0
	Class_Code	varchar	13	0
	Class_Credit_Value	numeric	5	2
	Student_Class_Status	varchar	7	0
	Semester_Term_Pattern_Name	varchar	30	0
	Delivery_Type	varchar	50	0
	Type_Of_Course	varchar	50	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Number	varchar	25	0
	Student_Surname	nvarchar	100	0
	Student_Given_Name	nvarchar	100	0
	OEN	varchar	12	0
	Student_Status	varchar	18	0
	Main_School	varchar	150	0
	Student_Board_Residence_Status	varchar	150	0
	Gender	char	1	0
	Home_Concurrent_Status	char	1	0
	Student_Phone_Number	varchar	40	0
	Student_Email	varchar	255	0
	Parent_Email_1	varchar	255	0
	Parent_Email_2	varchar	255	0
	Title	nvarchar	100	0
	SubmissionDate	date	10	0
	Add_Date	date	10	0
	Drop_Date	date	10	0
	Term	varchar	50	0
	Term_Code	varchar	5	0
	Mark	varchar	6	0
vw_Base_Students_Spec_Ed_All_Ex	Person_ID	uniqueidentifier	16	0
	Spec_Ed_Status	varchar	8	0
	Exceptionalities	nvarchar	-1	0
	IEP_With	nvarchar	-1	0
	Is_Special_Ed	bit	1	0
	IEP	bit	1	0
vw_Elementary_EQAO_Achievement_ON	School_Short_Name	varchar	10	0
	School_Year	varchar	10	0
	OEN	varchar	12	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Student_Current_Grade	varchar	3	0
	Gender	char	1	0
	Birthdate	date	10	0
	Stu_Status_Code	varchar	1	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Room	varchar	5	0
	Homeroom_Teacher_Number	varchar	25	0
	Homeroom_Teacher_Surname	nvarchar	100	0
	Homeroom_Teacher_Given_Name	nvarchar	100	0
	Spec_Ed_Status	varchar	8	0
	IEP	bit	1	0
	Aboriginal_Self_ID	varchar	150	0
	Aboriginal_Status_Code	varchar	150	0
	Absent_Days	numeric	38	1
	Grade_3_EQAO_Reading	real	24	0
	Grade_3_EQAO_Writing	real	24	0
	Grade_3_EQAO_Math	real	24	0
	Grade_6_EQAO_Reading	real	24	0
	Grade_6_EQAO_Writing	real	24	0
	Grade_6_EQAO_Math	real	24	0
	Reading_Mark	varchar	6	0
	Writing_Mark	varchar	6	0
	Number_Sense_Mark	varchar	6	0
	Uses_Of_Spoken_French_Mark	varchar	6	0
	Responsibility_Mark	varchar	6	0
	Organization_Mark	varchar	6	0
	Independent_Work_Mark	varchar	6	0
	Collaboration_Mark	varchar	6	0
	Initiative_Mark	varchar	6	0
	Self_Regulation_Mark	varchar	6	0
vw_Codes_Standardization_Base	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
vw_Grade_9_Math_Ontario	School_Name	varchar	255	0
	OEN	varchar	12	0
	Sur_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Grade	varchar	3	0
	Grade_6_EQAO_Reading	real	24	0
	Grade_6_EQAO_Math	real	24	0
	Grade_9_Math_Course	varchar	10	0
	Grade_9_Math_Mark	varchar	30	0
	Grade_9_EQAO_Math	real	24	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
	School_Short_Name	varchar	10	0
	Aboriginal_Self_ID	varchar	150	0
	Aboriginal_Type_Entry_Date	date	10	0
vw_MW_Student_Timetable_WAddDrop	Start_Date	date	10	0
	End_Date	date	10	0
	Class_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Current_TT	bit	1	0
	ContEntry_Active_Date	date	10	0
	ContEntry_Completion_Date	date	10	0
	ContEntry_Expected_Completion_Date	date	10	0
	ContEntry_Intended_Start_Date	date	10	0
	Continuous_Entry	bit	1	0
vw_Leaver_Report_AB	School Number	varchar	10	0
	School Name	varchar	255	0
	School Short Name	varchar	10	0
	ASN	varchar	12	0
	Entry Date	date	10	0
	Retirement Date	date	10	0
	Destination Type	varchar	150	0
	Destination School	varchar	150	0
	Status Code	varchar	1	0
	Status Name	varchar	18	0
	Given Name	nvarchar	100	0
	Usual Name	nvarchar	100	0
	Surname	nvarchar	100	0
	Legal Surname	nvarchar	100	0
	Gender	char	1	0
	Current Age (Yrs)	int	10	0
	Home Phone Lives With	varchar	40	0
	Home Phone Father	varchar	40	0
	Home Phone Mother	varchar	40	0
	Given Name Lives With	nvarchar	100	0
	Given Name Father	nvarchar	100	0
	Given Name Mother	nvarchar	100	0
	First Diploma	varchar	50	0
	Total Credits	decimal	38	2
	Diploma Date	date	10	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	Spec Ed Program	varchar	150	0
	Grade	varchar	3	0
	Home School	char	1	0
vw_PVNC_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
	Birthdate	date	10	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
	Person_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
vw_Base_Classes_AB	School_Short_Name	varchar	10	0
	School_Name	varchar	255	0
	School_Number	char	10	0
	Class_Code	varchar	10	0
	Section_Letter	char	2	0
	Department	varchar	150	0
	Semester_Term_Pattern	varchar	30	0
	Period_Pattern	varchar	30	0
	Course_Type	varchar	50	0
	Delivery	varchar	50	0
	Credit_Value	numeric	5	2
	Language	varchar	150	0
	Reportable	bit	1	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Number	varchar	25	0
	Occupancy	int	10	0
	Course_Title	varchar	255	0
	Class_Room	nvarchar	-1	0
	Scheduling	bit	1	0
	Is_CTS_Master_Class	bit	1	0
	Is_CTS_Module	bit	1	0
	CTS_Master_Class_Code	varchar	10	0
	CTS_Master_Class_Section	char	2	0
	Class_Start_Date	date	10	0
	Class_End_Date	date	10	0
	Minutes_Per_Day	smallint	5	0
	Continuous_Entry	bit	1	0
	Course_Grade	varchar	3	0
	Is_Reportable	bit	1	0
	Attendance_Last_Taken_Date	date	10	0
vw_Leaver_Report_Ontario	School Number	varchar	10	0
	School Name	varchar	255	0
	School Short Name	varchar	10	0
	OEN	varchar	12	0
	Entry Date	smalldatetime	16	0
	Retirement Date	smalldatetime	16	0
	Destination Type	varchar	150	0
	Destination School	varchar	150	0
	Status Code	varchar	1	0
	Status Name	varchar	18	0
	Given Name	nvarchar	100	0
	Usual Name	nvarchar	100	0
	Surname	nvarchar	100	0
	Legal Surname	nvarchar	100	0
	Gender	char	1	0
	Current Age (Yrs)	int	10	0
	Home Phone Lives With	varchar	40	0
	Home Phone Father	varchar	40	0
	Home Phone Mother	varchar	40	0
	Given Name Lives With	nvarchar	100	0
	Given Name Father	nvarchar	100	0
	Given Name Mother	nvarchar	100	0
	OSSLT Status	varchar	14	0
	Community Hours Completed	numeric	17	0
	First Diploma	varchar	50	0
	Total Credits	decimal	38	2
	Diploma Date	date	10	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	Spec Ed Program	varchar	150	0
	Grade	varchar	3	0
	Instructional Setting	varchar	150	0
	Community Involement Complete	bit	1	0
	Homeroom Designation	varchar	4	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
	Special_Ed_Resources	varchar	150	0
	Support_Service	varchar	150	0
	OYAP	bit	1	0
	Cohort_Year	varchar	10	0
vw_PVNCCDSB_SEOS_Export_Secondary_Updated	School_Short_Name	varchar	10	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	varchar	3	0
	Homeroom_Teacher	nvarchar	204	0
	HomeroomNumber	varchar	5	0
	HomeroomDesignation	varchar	4	0
	School	varchar	255	0
	Mident	varchar	10	0
	Exceptionality	varchar	150	0
	DateLastIPRC	date	10	0
	IEP	bit	1	0
	Placement	varchar	150	0
	SpecializedEquipment	varchar	150	0
	Absent	int	10	0
	Late	int	10	0
	AdmittedDate	date	10	0
	S1CRS1Code	varchar	10	0
	S1CRS1TeacherName	nvarchar	204	0
	S1CRS1Title	varchar	255	0
	S1CRS2Code	varchar	10	0
	S1CRS2TeacherName	nvarchar	204	0
	S1CRS2Title	varchar	255	0
	S1CRS3Code	varchar	10	0
	S1CRS3TeacherName	nvarchar	204	0
	S1CRS3Title	varchar	255	0
	S1CRS4Code	varchar	10	0
	S1CRS4TeacherName	nvarchar	204	0
	S1CRS4Title	varchar	255	0
	S1CRS5Code	varchar	10	0
	S1CRS5TeacherName	nvarchar	204	0
	S1CRS5Title	varchar	255	0
	S1CRS6Code	varchar	10	0
	S1CRS6TeacherName	nvarchar	204	0
	S1CRS6Title	varchar	255	0
	S1CRS7Code	varchar	10	0
	S1CRS7TeacherName	nvarchar	204	0
	S1CRS7Title	varchar	255	0
	S2CRS1Code	varchar	10	0
	S2CRS1TeacherName	nvarchar	204	0
	S2CRS1Title	varchar	255	0
	S2CRS2Code	varchar	10	0
	S2CRS2TeacherName	nvarchar	204	0
	S2CRS2Title	varchar	255	0
	S2CRS3Code	varchar	10	0
	S2CRS3TeacherName	nvarchar	204	0
	S2CRS3Title	varchar	255	0
	S2CRS4Code	varchar	10	0
	S2CRS4TeacherName	nvarchar	204	0
	S2CRS4Title	varchar	255	0
	S2CRS5Code	varchar	10	0
	S2CRS5TeacherName	nvarchar	204	0
	S2CRS5Title	varchar	255	0
	S2CRS6Code	varchar	10	0
	S2CRS6TeacherName	nvarchar	204	0
	S2CRS6Title	varchar	255	0
	S2CRS7Code	varchar	10	0
	S2CRS7TeacherName	nvarchar	204	0
	S2CRS7Title	varchar	255	0
	DiplomaType	varchar	255	0
	UsualName	nvarchar	100	0
vw_Base_Clever_Enrolments	School_id	varchar	10	0
	Section_id	varchar	12	0
	Student_id	bigint	19	0
vw_Leaver_Report_Past_Ontario	School Number	varchar	10	0
	School Name	varchar	255	0
	School Short Name	varchar	10	0
	OEN	varchar	12	0
	Entry Date	smalldatetime	16	0
	Retirement Date	smalldatetime	16	0
	Destination Type	varchar	150	0
	Destination School	varchar	150	0
	Status Code	varchar	1	0
	Status Name	varchar	18	0
	Given Name	nvarchar	100	0
	Usual Name	nvarchar	100	0
	Surname	nvarchar	100	0
	Legal Surname	nvarchar	100	0
	Gender	char	1	0
	Current Age (Yrs)	int	10	0
	Home Phone Lives With	varchar	40	0
	Home Phone Father	varchar	40	0
	Home Phone Mother	varchar	40	0
	Given Name Lives With	nvarchar	100	0
	Given Name Father	nvarchar	100	0
	Given Name Mother	nvarchar	100	0
	OSSLT Status	varchar	14	0
	Community Hours Completed	numeric	17	0
	First Diploma	varchar	50	0
	Total Credits	decimal	38	2
	Diploma Date	date	10	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	Spec Ed Program	varchar	150	0
	Grade	varchar	3	0
	Instructional Setting	varchar	150	0
	Community Involement Complete	bit	1	0
	Homeroom Designation	varchar	4	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
	Special_Ed_Resources	varchar	150	0
	Support_Service	varchar	150	0
	OYAP	bit	1	0
	Cohort_Year	varchar	10	0
vw_Student_Timetable_ON_Updated	School_Short_Name	varchar	10	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	OEN	varchar	12	0
	SN	bigint	19	0
	Grade	varchar	3	0
	Course_Code	varchar	10	0
	Class_Section	char	2	0
	Course_Number	varchar	10	0
	Course_Grade	varchar	3	0
	Course_Title	varchar	255	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alt_Teacher_Surname	nvarchar	100	0
	Alt_Teacher_Given_Name	nvarchar	100	0
	Alt_Teacher_Number	varchar	25	0
	Class_Start_Date	date	10	0
	Class_End_Date	date	10	0
	Is_Dropped	bit	1	0
	Is_Next_Year	bit	1	0
	Is_Continuous_Entry	bit	1	0
	Continuous_Entry_Start_Date	date	10	0
	Continuous_Entry_Completion_Date	date	10	0
	Course_Type	varchar	50	0
	Delivery_Type	varchar	50	0
	Attendance_Type	varchar	50	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	Birthdate	date	10	0
	Gender	char	1	0
	Aboriginal_Self_ID	varchar	150	0
	Exceptionality_1	varchar	150	0
	Exceptionality_2	varchar	150	0
	Exceptionality_3	varchar	150	0
	Placement_Setting	varchar	150	0
	Entry_Date	date	10	0
	Retirement_Date	date	10	0
	Sem_Term_Pattern	varchar	30	0
	Day_Per_Pattern	varchar	30	0
	Drop_Date	date	10	0
	Credit_Attempted	decimal	5	2
	Stu_Enrol_ID	uniqueidentifier	16	0
vw_Base_Clever_Sections	School_id	char	10	0
	Section_id	varchar	12	0
	Teacher_id	varchar	25	0
	Teacher_2_id	varchar	25	0
	Course_name	varchar	255	0
	Grade	varchar	3	0
vw_Taking_Stock_ON	School Number	varchar	10	0
	School Name	varchar	255	0
	School Short Name	varchar	10	0
	OEN	varchar	12	0
	Student Board Residency Status	varchar	150	0
	Entry Date	smalldatetime	16	0
	Origin Type	varchar	150	0
	Origin School	varchar	150	0
	Retirement Date	smalldatetime	16	0
	Destination Type	varchar	150	0
	Destination School	varchar	150	0
	Status Code	varchar	1	0
	Status Name	varchar	18	0
	Given Name	nvarchar	100	0
	Usual Name	nvarchar	100	0
	Surname	nvarchar	100	0
	Legal Surname	nvarchar	100	0
	Gender	char	1	0
	Current Age (Yrs)	int	10	0
	Home Phone Lives With	varchar	40	0
	Home Phone Father	varchar	40	0
	Home Phone Mother	varchar	40	0
	Given Name Lives With	nvarchar	100	0
	Given Name Father	nvarchar	100	0
	Given Name Mother	nvarchar	100	0
	OSSLT Status	varchar	14	0
	OSSLT Non Participation Status	varchar	20	0
	Community Hours Completed	numeric	17	0
	Area of Requirement	varchar	255	0
	First Diploma	varchar	50	0
	Total Credits	decimal	38	2
	Diploma Date	date	10	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	Spec Ed Program	varchar	150	0
	Grade	varchar	3	0
	Instructional Setting	varchar	150	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
	OYAP	bit	1	0
	Exceptionality_2	varchar	150	0
	Exceptionality_3	varchar	150	0
vw_PVNCCDSB_Transportation_NextYear_V2	Student_Number	varchar	25	0
	OEN_Number	varchar	12	0
	Surname	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Grade	varchar	3	0
	Birthdate	date	10	0
	Gender	char	1	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
	Township	varchar	50	0
	Home_Phone	varchar	40	0
	Attendance_Type	varchar	50	0
	School_Number	varchar	10	0
	French_Immersion_Type	varchar	150	0
	Homeroom_Number	varchar	5	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Designation_Next_Year	varchar	4	0
	Grade_Next_Year	varchar	3	0
	School_Short_Name	varchar	10	0
	Entry_Date	date	10	0
	Sitter_Name	nvarchar	202	0
	Sitter_House_Number	varchar	10	0
	Sitter_Street_Name	varchar	255	0
	Sitter_City	varchar	50	0
	Sitter_Postal_Code	varchar	25	0
	Sitter_Phone_Number	varchar	40	0
	Mother_Title	nvarchar	60	0
	Mother_Given_Name	nvarchar	100	0
	Mother_Surname	nvarchar	100	0
	Mothers_Cell_Phone	varchar	40	0
	Mother_Email	varchar	255	0
	Mother_House_Number	varchar	10	0
	Mother_Street_Name	varchar	255	0
	Mother_City	varchar	50	0
	Mother_Postal_Code	varchar	25	0
	Father_Title	nvarchar	60	0
	Father_Given_Name	nvarchar	100	0
	Father_Surname	nvarchar	100	0
	Father_Cell_Phone	varchar	40	0
	Father_Email	varchar	255	0
	Father_House_Number	varchar	10	0
	Father_Street_Name	varchar	255	0
	Father_City	varchar	50	0
	Father_Postal_Code	varchar	25	0
	Emergency_Contact_Given_Name	nvarchar	100	0
	Emergency_Contact_Surname	nvarchar	100	0
	Emergency_Contact_Cell_Phone	varchar	40	0
	Lives_With	varchar	150	0
	Special Custody	bit	1	0
	PIN	nvarchar	-1	0
vw_Base_Clever_Staff	School_id	varchar	10	0
	Teacher_id	varchar	25	0
	Staff_email	varchar	255	0
	Title	nvarchar	60	0
	Last_name	nvarchar	100	0
	Middle_name	nvarchar	100	0
	First_name	nvarchar	100	0
	School_name	varchar	255	0
	Staff_id	uniqueidentifier	16	0
	IsTeacher	bit	1	0
	IsBoardUser	bit	1	0
vw_MW_Credit_Req_Area_Projected	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
	Date_Of_Completion	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	6	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
	Is_Transcript	bit	1	0
vw_Base_Clever_Students	School_id	varchar	10	0
	Student_id	bigint	19	0
	Student_number	varchar	12	0
	Last_name	nvarchar	100	0
	First_name	nvarchar	100	0
	Grade	varchar	3	0
	Gender	char	1	0
	Student_email	varchar	255	0
	Contact_phone	varchar	40	0
	School_name	varchar	255	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Contact_Lst_Lst_ID	uniqueidentifier	16	0
vw_PVNCCDSB_SEOS_Export_Elementary	School_Short_Name	varchar	10	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	varchar	3	0
	Homeroom_Teacher	nvarchar	204	0
	School	varchar	255	0
	Mident	varchar	10	0
	Exceptionality	varchar	150	0
	DateLastIPRC	varchar	8000	0
	IEP	varchar	3	0
	Placement	varchar	150	0
	SpecializedEquipment	varchar	150	0
	Absent	decimal	4	1
	Late	smallint	5	0
	AdmittedDate	varchar	8000	0
	HomeroomNumber	varchar	5	0
	HomeroomDesignation	varchar	4	0
	UsualName	nvarchar	100	0
vw_Base_Current_Archive_Achievement_ON	School_Short_Name	varchar	10	0
	Class_Code	varchar	13	0
	Class_Credit_Value	numeric	5	2
	Student_Class_Status	varchar	7	0
	Semester_Term_Pattern_Name	varchar	30	0
	Delivery_Type	varchar	50	0
	Type_Of_Course	varchar	50	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Teacher_Number	varchar	25	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Number	varchar	25	0
	Student_Surname	nvarchar	100	0
	Student_Given_Name	nvarchar	100	0
	OEN	varchar	12	0
	Student_Status	varchar	18	0
	Main_School	varchar	150	0
	Student_Board_Residence_Status	varchar	150	0
	Con_Ed_Student_Type	varchar	150	0
	Gender	char	1	0
	Home_Concurrent_Status	char	1	0
	Student_Phone_Number	varchar	40	0
	Student_Email	varchar	255	0
	Parent_Email_1	varchar	255	0
	Parent_Email_2	varchar	255	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	Enrol_ID	uniqueidentifier	16	0
	Code_ID	uniqueidentifier	16	0
	Class_ID	uniqueidentifier	16	0
	List_ID	uniqueidentifier	16	0
	Add_Date	date	10	0
	Drop_Date	date	10	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Room	varchar	5	0
	Person_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Student_Grade	varchar	3	0
	ContEntry_Active_Date	date	10	0
	ContEntry_Completion_Date	date	10	0
	School_Name	varchar	255	0
	Stu_Info_ID	uniqueidentifier	16	0
	Calendar_Start_Date	smalldatetime	16	0
	Calendar_End_Date	smalldatetime	16	0
	School_Year	varchar	10	0
	TT_Class_ID	uniqueidentifier	16	0
vw_PVNCCDSB_SEOS_Export_Secondary	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	varchar	3	0
	Homeroom_Teacher	nvarchar	204	0
	HomeroomNumber	varchar	5	0
	HomeroomDesignation	varchar	4	0
	School	varchar	255	0
	Mident	varchar	10	0
	Exceptionality	varchar	150	0
	DateLastIPRC	date	10	0
	IEP	bit	1	0
	AdmittedDate	date	10	0
	Placement	varchar	150	0
	tTotalAbsent	int	10	0
	tTotalLate	int	10	0
	SpecializedEquipment	varchar	150	0
	S1CRS1Code	varchar	10	0
	S1CRS1TeacherName	nvarchar	204	0
	S1CRS1Title	varchar	255	0
	S1CRS1Late	smallint	5	0
	S1CRS1Absent	smallint	5	0
	S1CRS2Code	varchar	10	0
	S1CRS2TeacherName	nvarchar	204	0
	S1CRS2Title	varchar	255	0
	S1CRS2Late	smallint	5	0
	S1CRS2Absent	smallint	5	0
	S1CRS3Code	varchar	10	0
	S1CRS3TeacherName	nvarchar	204	0
	S1CRS3Title	varchar	255	0
	S1CRS3Late	smallint	5	0
	S1CRS3Absent	smallint	5	0
	S1CRS4Code	varchar	10	0
	S1CRS4TeacherName	nvarchar	204	0
	S1CRS4Title	varchar	255	0
	S1CRS4Late	smallint	5	0
	S1CRS4Absent	smallint	5	0
	S1CRS5Code	varchar	10	0
	S1CRS5TeacherName	nvarchar	204	0
	S1CRS5Title	varchar	255	0
	S1CRS5Late	smallint	5	0
	S1CRS5Absent	smallint	5	0
	S1CRS6Code	varchar	10	0
	S1CRS6TeacherName	nvarchar	204	0
	S1CRS6Title	varchar	255	0
	S1CRS6Late	smallint	5	0
	S1CRS6Absent	smallint	5	0
	S2CRS1Code	varchar	10	0
	S2CRS1TeacherName	nvarchar	204	0
	S2CRS1Title	varchar	255	0
	S2CRS1Late	smallint	5	0
	S2CRS1Absent	smallint	5	0
	S2CRS2Code	varchar	10	0
	S2CRS2TeacherName	nvarchar	204	0
	S2CRS2Title	varchar	255	0
	S2CRS2Late	smallint	5	0
	S2CRS2Absent	smallint	5	0
	S2CRS3Code	varchar	10	0
	S2CRS3TeacherName	nvarchar	204	0
	S2CRS3Title	varchar	255	0
	S2CRS3Late	smallint	5	0
	S2CRS3Absent	smallint	5	0
	S2CRS4Code	varchar	10	0
	S2CRS4TeacherName	nvarchar	204	0
	S2CRS4Title	varchar	255	0
	S2CRS4Late	smallint	5	0
	S2CRS4Absent	smallint	5	0
	S2CRS5Code	varchar	10	0
	S2CRS5TeacherName	nvarchar	204	0
	S2CRS5Title	varchar	255	0
	S2CRS5Late	smallint	5	0
	S2CRS5Absent	smallint	5	0
	S2CRS6Code	varchar	10	0
	S2CRS6TeacherName	nvarchar	204	0
	S2CRS6Title	varchar	255	0
	S2CRS6Late	smallint	5	0
	S2CRS6Absent	smallint	5	0
	Attainment	varchar	255	0
vw_Base_Lockers	School_Short_Name	varchar	10	0
	Locker_Num	varchar	50	0
	Available	bit	1	0
	Max_Students	smallint	5	0
	Combination	nvarchar	40	0
	Locker_Bank	varchar	50	0
	Lock_Serial_Number	nvarchar	40	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Grade	varchar	3	0
	Locker_ID	uniqueidentifier	16	0
	Lock_ID	uniqueidentifier	16	0
	Locker_Type	uniqueidentifier	16	0
	Lock_Brand_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	School_ID	uniqueidentifier	16	0
vw_Elementary_Average_Ontario	School_Year	varchar	10	0
	School	varchar	255	0
	Sur_Name	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Grade	varchar	2	0
	Term	varchar	50	0
	OEN	varchar	12	0
	DateOfBirth	date	10	0
	Room	char	5	0
	Designation	varchar	4	0
	StuAverage	int	10	0
	MW Status	varchar	18	0
	School_Short_Name	varchar	10	0
vw_Base_Student_Enrolments	School_Short_Name	varchar	10	0
	School_Number	varchar	10	0
	Ministry_Num_Fmt	varchar	12	0
	Stu_Number	varchar	25	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Entry_Date	date	10	0
	Origin_Type_Code	varchar	10	0
	Origin_Type	varchar	150	0
	Origin_School_Number	varchar	10	0
	Origin_School	varchar	150	0
	Retirement_Date	date	10	0
	Destination_Type_Code	varchar	10	0
	Destination_Type	varchar	150	0
	Destination_School_Number	varchar	10	0
	Destination_School	varchar	150	0
vw_PVNC_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
	Entry_Date_To_Board	date	10	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
	Stu_Enrol_ID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
vw_Student_Incidents_with_Month	School_Short_Name	varchar	10	0
	School_Name	varchar	255	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
	Incident_Month	nvarchar	60	0
	Incident_Year	nvarchar	60	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
vw_Base_UserViews	view_name	varchar	50	0
	User_Name	varchar	150	0
	Role	nchar	20	0
	row_restriction	bit	1	0
	row_query	nvarchar	-1	0
	column_query	nvarchar	-1	0
vw_Base_Transcripts	Transcript_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Code_Def_ID	uniqueidentifier	16	0
	School_Short_Name	varchar	10	0
	Ministry_Num_Fmt	varchar	12	0
	Surname	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Student_Grade	varchar	3	0
	Stu_Status	varchar	18	0
	Stu_Status_Code	varchar	1	0
	Course_Code	char	10	0
	Course_Number	char	10	0
	Course_Title	varchar	255	0
	Transcript_Date	date	10	0
	Mark	varchar	3	0
	Language	varchar	150	0
	Course_Type	varchar	50	0
	Delivery_Type	varchar	50	0
	Credit_Attempted	decimal	5	2
	Credit_Earned	decimal	5	2
	PLE_Credits	decimal	7	2
	Code_ID	uniqueidentifier	16	0
	Att_Absent	decimal	5	0
	Att_Excused	decimal	5	0
	Att_Late	decimal	5	0
	Att_Possible	decimal	4	1
	Scl_Year_Info_ID	uniqueidentifier	16	0
	Achieved_At_School	varchar	150	0
	Birthdate	date	10	0
	Person_ID	uniqueidentifier	16	0
	Mark_Numeric	smallint	5	0
vw_Clever_Enrolments_Updated	School_id	varchar	10	0
	Section_id	varchar	23	0
	Student_id	varchar	12	0
vw_Student_Incidents_PVNC	School_Short_Name	varchar	10	0
	School_Name	varchar	255	0
	Ministry_Num	varchar	12	0
	Student_Number	varchar	25	0
	Surname	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Birthdate	date	10	0
	Incident_Date	date	10	0
	Incident_Month	nvarchar	60	0
	Incident_Year	nvarchar	60	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
vw_Base_UserFields	User_Name	varchar	150	0
	view_name	varchar	50	0
	field_id	uniqueidentifier	16	0
	field_name	varchar	50	0
	field_type_conv	varchar	50	0
	Parent_Object_ID	int	10	0
	user_type_id	int	10	0
	name	sysname	256	0
	max_length	smallint	5	0
	Column_Ordinal	int	10	0
	view_id	uniqueidentifier	16	0
	user_id	uniqueidentifier	16	0
	Date_Added	datetime	23	3
	Date_Modified	nchar	20	0
vw_History_Credit_Summary	Person_ID	uniqueidentifier	16	0
	HCSchool	char	1	0
	Sur_Name	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Birthdate	date	10	0
	Gender	char	1	0
	School_Name	varchar	255	0
	School_Number	varchar	10	0
	Student_Number	varchar	25	0
	Compulsory_Credits	decimal	38	2
	Credit_Earned	decimal	38	2
	Category	varchar	100	0
	OEN	varchar	12	0
	Grade	varchar	3	0
	mwStatus	varchar	18	0
	SHSM	bit	1	0
	School_Short_Name	varchar	10	0
	Area_Of_Requirement	varchar	255	0
	Defined_Character_1	varchar	3	0
	Defined_Character_2	varchar	3	0
	Defined_Character_3	varchar	3	0
	Defined_Character_4	varchar	3	0
vw_Clever_Schools_Updated	School_id	varchar	10	0
	School_name	varchar	255	0
	School_number	varchar	10	0
	State_id	varchar	10	0
	Low_Grade	char	3	0
	High_Grade	char	3	0
	Principal	nvarchar	264	0
vw_MW_Exam_Schedule	School	varchar	255	0
	SchoolNumber	char	10	0
	SchoolShortName	varchar	10	0
	CourseCode	char	10	0
	ClassSection	char	2	0
	ExamDay	char	1	0
	ExamPeriod	varchar	1	0
	Semester	tinyint	3	0
	Term	tinyint	3	0
	ExamDate	date	10	0
	FixedDay	int	10	0
	FixedPeriod	int	10	0
	Class_ID	uniqueidentifier	16	0
vw_Clever_Staff_Updated	School_id	varchar	10	0
	Staff_id	varchar	25	0
	Staff_email	varchar	255	0
	First_name	nvarchar	100	0
	Last_name	nvarchar	100	0
	Department	varchar	150	0
	Title	nvarchar	200	0
	Username	varchar	255	0
	Password	varchar	1	0
	Role	varchar	1	0
vw_Pathway_Ontario_Base	School Number	varchar	10	0
	School Name	varchar	255	0
	OEN	varchar	12	0
	Student Last Name	nvarchar	100	0
	Student Usual Name	nvarchar	100	0
	Street Address	varchar	266	0
	City	varchar	50	0
	Postal Code	varchar	25	0
	Student Email Address	varchar	255	0
	Student Phone Number	varchar	40	0
	Gender	char	1	0
	DOB	date	10	0
	Grade	varchar	3	0
	Course Start Date	date	10	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
	Stu_Enrol_ID	uniqueidentifier	16	0
	School_Short_Name	varchar	10	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Number	varchar	5	0
	Homeroom_Teacher_Surname	nvarchar	100	0
	Homeroom_Teacher_Given_Name	nvarchar	100	0
	Homeroom_Teacher_Number	varchar	25	0
	Homeroom_Alt_Teacher_Surname	nvarchar	100	0
	Homeroom_Alt_Teacher_Given_Name	nvarchar	100	0
	Homeroom_Alt_Teacher_Number	varchar	25	0
	OYAP	bit	1	0
	Is_Special_Ed	bit	1	0
	Spec_Ed_Status	varchar	8	0
	IEP	bit	1	0
	IEP_With	nvarchar	-1	0
	Special_Ed_Resources	varchar	150	0
	Exceptionality_1	varchar	150	0
	Exceptionality_2	varchar	150	0
	Exceptionality_3	varchar	150	0
vw_Clever_Students_Updated	School_id	varchar	10	0
	Student_id	varchar	12	0
	Student_number	bigint	19	0
	State_id	varchar	12	0
	Last_name	nvarchar	100	0
	Middle_Name	nvarchar	100	0
	First_name	nvarchar	100	0
	Grade	varchar	3	0
	Gender	char	1	0
	Graduation year	date	10	0
	DOB- date of birth	date	10	0
	race	varchar	1	0
	Hispanic_Latino	varchar	1	0
	Home_language	varchar	150	0
	ELL_status	varchar	1	0
	Frl_status	varchar	1	0
	IEP_status	varchar	1	0
	Student_street	varchar	1	0
	Student_city	varchar	1	0
	Student_state	varchar	1	0
	student_zip	varchar	1	0
	Student_email	varchar	255	0
	Contact_relationship	varchar	1	0
	Contact_type	varchar	1	0
	Contact_name	varchar	1	0
	Contact_phone	varchar	1	0
	Contact_phone_type	varchar	1	0
	Contact_email	varchar	1	0
	Contact_sis_id	varchar	1	0
	Username	varchar	255	0
	Password	varchar	1	0
	Unweighted_GPA	varchar	1	0
	Weighted_GPA	varchar	1	0
	ext*	varchar	1	0
vw_PVNCCDSB_Transportation_TLDSB	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_PVNCCDSB_Class_Drop_Counts	School_Short_Name	varchar	10	0
	Course_Code	varchar	10	0
	Class_Section	varchar	2	0
	Course_Grade	varchar	3	0
	Teacher_Surname	nvarchar	100	0
	Teacher_GivenName	nvarchar	100	0
	Teacher_Title	nvarchar	60	0
	StaffNumber	bigint	19	0
	Semester	tinyint	3	0
	Period	tinyint	3	0
	Number_Students_Enrolled_On_FirstDay	int	10	0
	Number_Students_Currently_Enrolled	int	10	0
	Number_Students_Dropped_Class	int	10	0
	Class_ID	uniqueidentifier	16	0
vw_Adult_Ed_Taking_Stock	School Number	varchar	10	0
	School Name	varchar	255	0
	School Short Name	varchar	10	0
	OEN	varchar	12	0
	Entry Date	smalldatetime	16	0
	Retirement Date	smalldatetime	16	0
	Destination Type	varchar	150	0
	Destination School	varchar	150	0
	Status Code	varchar	1	0
	Status Name	varchar	18	0
	Given Name	nvarchar	100	0
	Usual Name	nvarchar	100	0
	Surname	nvarchar	100	0
	Legal Surname	nvarchar	100	0
	Gender	char	1	0
	Current Age (Yrs)	int	10	0
	Home Phone Lives With	varchar	40	0
	Home Phone Father	varchar	40	0
	Home Phone Mother	varchar	40	0
	Given Name Lives With	nvarchar	100	0
	Given Name Father	nvarchar	100	0
	Given Name Mother	nvarchar	100	0
	OSSLT Status	varchar	14	0
	Community Hours Completed	numeric	17	0
	First Diploma	varchar	50	0
	Total Credits	decimal	38	2
	Diploma Date	date	10	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	Spec Ed Program	varchar	150	0
	Grade	varchar	3	0
	Instructional Setting	varchar	150	0
	Community Involement Complete	bit	1	0
	OSSLT Non Participation Status	varchar	20	0
	Homeroom Designation	varchar	4	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
	Calendar Start Date	smalldatetime	16	0
	Student Board Residency Status	varchar	150	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	OYAP	bit	1	0
	Exceptionality_2	varchar	150	0
	Exceptionality_3	varchar	150	0
	Cohort_Year	varchar	10	0
vw_Student_Enrolment	School_Short_Name	varchar	10	0
	School_Name	varchar	255	0
	Student_Number	bigint	19	0
	Ministry_Num_Fmt	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
	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
	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
	Stu_Enrol_ID	uniqueidentifier	16	0
	Person_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
vw_Clever_Teachers_Updated	School_id	varchar	10	0
	Teacher_id	varchar	25	0
	Teacher_number	varchar	25	0
	State_teacher_id	char	15	0
	Teacher_email	varchar	255	0
	First_name	nvarchar	100	0
	Middle_name	nvarchar	100	0
	Last_name	nvarchar	100	0
	Title	nvarchar	60	0
	Username	varchar	255	0
	Password	varchar	1	0
vw_Student_Special_Education_Full	Person_ID	uniqueidentifier	16	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	School_Short_Name	varchar	10	0
	Surname	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Birthdate	date	10	0
	Gender	char	1	0
	Min_Number	varchar	12	0
	Grade	varchar	3	0
	Stu_Status	varchar	18	0
	Stu_Status_Code	varchar	1	0
	Spec_Ed_Status	varchar	8	0
	Exceptionality_Placement_Number	tinyint	3	0
	Exceptionality_Code	varchar	10	0
	Exceptionality	varchar	150	0
	Execptionality_Start_Date	date	10	0
	Exceptionality_End_Date	date	10	0
	Placement	varchar	150	0
	Placement_Start_Date	date	10	0
	Placement_End_Date	date	10	0
	Special_Ed_Program	varchar	150	0
	Support_Service	varchar	150	0
	Special_Ed_Resources	varchar	150	0
	IEP_With	nvarchar	-1	0
	IEP	bit	1	0
	Special_Ed	bit	1	0
vw_Clever_Sections_Updated	School_id	char	10	0
	Section_id	varchar	23	0
	Teacher_id	varchar	25	0
	Teacher_2_id	varchar	25	0
	Teacher_3_id	varchar	1	0
	Teacher_4_id	varchar	1	0
	Teacher_5_id	varchar	1	0
	Teacher_6_id	varchar	1	0
	Teacher_7_id	varchar	1	0
	Teacher_8_id	varchar	1	0
	Teacher_9_id	varchar	1	0
	Teacher_10_id	varchar	1	0
	Name	varchar	1	0
	Section_number	char	2	0
	Grade	varchar	3	0
	Course_name	varchar	10	0
	Course_Number	varchar	1	0
	Course_description	varchar	500	0
	Period	tinyint	3	0
	Subject	varchar	1	0
	Term_name	varchar	30	0
	Term_start	varchar	30	0
	Term_end	varchar	30	0
vw_PVNC_Scheduling_Classes_Ontario	School_Name	varchar	255	0
	School_Number	char	10	0
	Class_Code	varchar	10	0
	Section_Letter	char	2	0
	Department	varchar	150	0
	Semester_Term_Pattern	varchar	30	0
	Period_Pattern	varchar	30	0
	Course_Type	varchar	50	0
	Dual_Credit_Course_Type	varchar	150	0
	Delivery	varchar	50	0
	Credit_Value	numeric	5	2
	Language	varchar	150	0
	Reportable	bit	1	0
	Teacher_Surname	nvarchar	100	0
	Teacher_Given_Name	nvarchar	100	0
	Alternate_Teacher_Surname	nvarchar	100	0
	Alternate_Teacher_Given_Name	nvarchar	100	0
	Occupancy	int	10	0
	School_Short_Name	varchar	10	0
	Course_Title	varchar	255	0
	Dual_Credit_Course_Assoc	varchar	172	0
vw_PVNC_Student_Enrolment	Stu_Enrol_ID	uniqueidentifier	16	0
	IsScheduling	tinyint	3	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	IsCurrent	bit	1	0
	School_ID	uniqueidentifier	16	0
	School_Year	varchar	10	0
	Person_ID	uniqueidentifier	16	0
	Oen	int	10	0
	IsHomeSchool	bit	1	0
	This_Sch_Entry_Date	smalldatetime	16	0
	Retirement_Date	smalldatetime	16	0
	Grade	char	3	0
	Homeroom_ID	uniqueidentifier	16	0
	FrenchProgram	varchar	150	0
	mwStatus	char	1	0
	StatusText	varchar	30	0
	Accum_Std_Credits	decimal	5	2
	Accum_OAC_Credits	decimal	5	2
	Elem_Entry_Date	smalldatetime	16	0
	Sec_Entry_Date	smalldatetime	16	0
	Fre_Imm_Min	smallint	5	0
	Special_Ed	bit	1	0
	Special_Ed_Status	char	1	0
	English_Language_Learner	varchar	50	0
	Short_Name	varchar	10	0
	Date_Imported	datetime	23	3
vw_Archive_Achievement_Marks	Class_ID	uniqueidentifier	16	0
	School_Year	varchar	10	0
	School	varchar	255	0
	School_Short_Name	varchar	10	0
	Sur_Name	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Ministry_Num	varchar	8000	0
	Class	varchar	10	0
	Section	varchar	2	0
	Class_Grade	varchar	3	0
	Teacher	nvarchar	264	0
	Term	varchar	50	0
	Topic	varchar	255	0
	Mark	varchar	6	0
	Override	varchar	6	0
	Mark_Last_Modified	datetime	23	3
	Comment	varchar	-1	0
	Person_ID	uniqueidentifier	16	0
	School_ID	uniqueidentifier	16	0
	Term_Code	varchar	5	0
	Topic_Code	varchar	5	0
	Final_Topic	bit	1	0
	Student_Grade	varchar	2	0
	Final_Term	bit	1	0
	Homeroom_Room	varchar	5	0
	Homeroom_Designation	varchar	10	0
	Gender	char	1	0
	Aboriginal_Status_Code	char	10	0
	Aboriginal_Status_Title	varchar	150	0
	Surname	nvarchar	100	0
	Class_Title	varchar	255	0
	Alternate_Teacher	nvarchar	264	0
	Timetable_Add_Or_Drop	char	1	0
	Enrol_ID	uniqueidentifier	16	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
	Special_Ed_Program	varchar	150	0
	Support_Service	varchar	150	0
	Special_Ed_Resources	varchar	150	0
	SubmissionDate	date	10	0
vw_Base_OnlineRegistrationDetails	Stu_LegalLastName	nvarchar	256	0
	Stu_LegalFirstName	nvarchar	256	0
	Reg_Grade	nvarchar	50	0
	Reg_ExpectedEntryDate	datetime	23	3
	Reg_DateCreated	datetime	23	3
	Rel_IsBaptized	nvarchar	20	0
	Rel_ParishName	nvarchar	200	0
vw_PVNCCDSB_Transportation_NextYearOnly	Student_Number	varchar	25	0
	OEN_Number	varchar	12	0
	Surname	nvarchar	100	0
	Usual_Name	nvarchar	100	0
	Grade	varchar	3	0
	Birthdate	date	10	0
	Gender	char	1	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
	Township	varchar	50	0
	Home_Phone	varchar	40	0
	Attendance_Type	varchar	50	0
	School_Number	varchar	10	0
	French_Immersion_Type	varchar	150	0
	Homeroom_Number	varchar	5	0
	Homeroom_Designation	varchar	4	0
	Homeroom_Designation_Next_Year	varchar	4	0
	Grade_Next_Year	varchar	3	0
	School_Short_Name	varchar	10	0
	Entry_Date	date	10	0
	Sitter_Name	nvarchar	202	0
	Sitter_House_Number	varchar	10	0
	Sitter_Street_Name	varchar	255	0
	Sitter_City	varchar	50	0
	Sitter_Postal_Code	varchar	25	0
	Sitter_Phone_Number	varchar	40	0
	Mother_Title	nvarchar	60	0
	Mother_Given_Name	nvarchar	100	0
	Mother_Surname	nvarchar	100	0
	Mothers_Cell_Phone	varchar	40	0
	Mother_Email	varchar	255	0
	Mother_House_Number	varchar	10	0
	Mother_Street_Name	varchar	255	0
	Mother_City	varchar	50	0
	Mother_Postal_Code	varchar	25	0
	Father_Title	nvarchar	60	0
	Father_Given_Name	nvarchar	100	0
	Father_Surname	nvarchar	100	0
	Father_Cell_Phone	varchar	40	0
	Father_Email	varchar	255	0
	Father_House_Number	varchar	10	0
	Father_Street_Name	varchar	255	0
	Father_City	varchar	50	0
	Father_Postal_Code	varchar	25	0
	Emergency_Contact_Given_Name	nvarchar	100	0
	Emergency_Contact_Surname	nvarchar	100	0
	Emergency_Contact_Cell_Phone	varchar	40	0
	Lives_With	varchar	150	0
	Special Custody	bit	1	0
vw_History_Total_Credits	Person_ID	uniqueidentifier	16	0
	Sur_Name	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Student_Number	varchar	25	0
	Birthdate	date	10	0
	Gender	char	1	0
	School_Number	varchar	10	0
	School_Name	varchar	255	0
	OEN	varchar	12	0
	Grade	varchar	3	0
	Total_Credits	decimal	38	2
	Total_Optional	decimal	38	2
	Total_Compulsory	decimal	38	2
	mwStatus	varchar	18	0
	School_Short_Name	varchar	10	0
	Area_Of_Requirement	varchar	255	0
	Defined_Character_1	varchar	3	0
	Defined_Character_2	varchar	3	0
	Defined_Character_3	varchar	3	0
	Defined_Character_4	varchar	3	0
vw_Elementary_Achievment_ONT	School_Year	varchar	10	0
	School_Number	varchar	10	0
	School	varchar	255	0
	OEN	varchar	12	0
	Sur_Name	nvarchar	100	0
	Given_Name	nvarchar	100	0
	Gender	char	1	0
	Grade	varchar	2	0
	Term_Code	varchar	5	0
	Topic_Code	varchar	5	0
	Term	varchar	50	0
	Topic	varchar	255	0
	Mark	decimal	13	3
	MW Status	varchar	18	0
	Birthdate	date	10	0
	Room_Number	char	5	0
	Designation	varchar	4	0
	Achieve_Homeroom	varchar	5	0
	Achieve_Homeroom_Designation	varchar	10	0
	Person_ID	uniqueidentifier	16	0
	Raw_Mark	varchar	6	0
	School_Short_Name	varchar	10	0
	Is_Special_Ed	bit	1	0
	Spec_Ed_Status	varchar	8	0
	IEP	bit	1	0
	Exceptionalities	nvarchar	-1	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	Aboriginal_Self_ID	varchar	150	0
vw_Student_Timetable_PNVC	Course_Code	varchar	10	0
	Is_Dropped	bit	1	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	class_id	uniqueidentifier	16	0
	Course_Title	varchar	255	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
vw_Leaver_Report_Base_Ontario	School Number	varchar	10	0
	School Name	varchar	255	0
	School Short Name	varchar	10	0
	OEN	varchar	12	0
	Entry Date	smalldatetime	16	0
	Retirement Date	smalldatetime	16	0
	Destination Type	varchar	150	0
	Destination School	varchar	150	0
	Status Code	varchar	1	0
	Status Name	varchar	18	0
	Given Name	nvarchar	100	0
	Usual Name	nvarchar	100	0
	Surname	nvarchar	100	0
	Legal Surname	nvarchar	100	0
	Gender	char	1	0
	Current Age (Yrs)	int	10	0
	Home Phone Lives With	varchar	40	0
	Home Phone Father	varchar	40	0
	Home Phone Mother	varchar	40	0
	Given Name Lives With	nvarchar	100	0
	Given Name Father	nvarchar	100	0
	Given Name Mother	nvarchar	100	0
	OSSLT Status	varchar	14	0
	Community Hours Completed	numeric	17	0
	First Diploma	varchar	50	0
	Total Credits	decimal	38	2
	Diploma Date	date	10	0
	Defined Character 1	varchar	3	0
	Defined Character 2	varchar	3	0
	Defined Character 3	varchar	3	0
	Defined Character 4	varchar	3	0
	Spec Ed Program	varchar	150	0
	Grade	varchar	3	0
	Instructional Setting	varchar	150	0
	Community Involement Complete	bit	1	0
	OSSLT Non Participation Status	varchar	20	0
	Homeroom Designation	varchar	4	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
	Calendar Start Date	date	10	0
	Student Board Residency Status	varchar	150	0
	Stu_Enrol_ID	uniqueidentifier	16	0
	Scl_Year_Info_ID	uniqueidentifier	16	0
	OYAP	bit	1	0
	Exceptionality_2	varchar	150	0
	Exceptionality_3	varchar	150	0
	Cohort_Year	varchar	10	0