EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Personfirst_namefirst nameID information for Record Matching from Ontario Education Data Warehouse (OEDW)ID2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Personlast_namelast nameID information for Record Matching from Ontario Education Data Warehouse (OEDW)ID2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Persondate_of_birthdate of birthID information for Record Matching from Ontario Education Data Warehouse (OEDW)ID2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Personpostal_code_of_student_addresspostal code of student address as of october 31 of academic yearID information for Record Matching from Ontario Education Data Warehouse (OEDW)ID2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Personacademic_yearacademic yearID information for Record Matching from Ontario Education Data Warehouse (OEDW)ID2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionacademic_yearacademic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionschool_boardchild's school boardCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionstudents_grade_of_enrollmentchild's grade of enrollment in academic year of analysisCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionage_as_of_december_31_of_the_academic_year_elementarychild's age as of december 31 of the academic year of analysisCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionage_as_of_december_31_of_the_academic_year_secondarychild's age as of december 31 of the academic year of analysisCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionlanguage_first_spokenfirst language spoken by the childCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionspecial_education_programs_and_or_services_flagchild receives special education programs or services in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionschool_levelchild's school levelCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionspecial_education_students_by_exceptionality_elementarychild's exceptionality in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionspecial_education_students_by_exceptionality_secondarychild's exceptionality in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionreceipt_of_an_individual_education_plan_elementarychild receives an individual education plan in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionreceipt_of_an_individual_education_plan_secondarychild receives an individual education plan in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrollment_in_job_skill_program_dcchild is enrolled in a dual credit course in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrollment_in_job_skill_program_coopchild is enrolled in a co-op course in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrollment_in_job_skill_program_shsmchild is enrolled in an shsm program in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionparticipation_in_the_ontario_youth_apprenticeship_programparticipation in the ontario youth apprenticeship programCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrollment_in_grade_11_or_12_regular_enrolment_not_coursechild is enrolled in grade 11 or 12 Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrollment_in_job_skills_program_allchild is enrolled in any job skills program in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionnumber_of_instructional_days_attendedchild's attendance of instructional days in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionnumber_of_days_absentchild's number of absences in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionnumber_of_instructional_days_in_the_yearnumber of instructional days in the yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionnongrade_based_mobility_elementarychild has changed schools within the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionnongrade_based_mobility_secondarychild has changed schools within the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionsuspensionsnumber of suspensions child has received within the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionexpulsionsnumber of expulsions child has received within the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionrange_of_suspensionsrange of suspensions received by the child in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionrange_of_expulsionsrange of expulsions received by the child in the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_alternative_noncreditcourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_business_studiescourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_canadian_and_world_studies_cours_de_comptences_linguistiqucourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_computers_interdisciplinary_studiescourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_cooperative_education_and_experiential_learningcourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_englishcourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_frenchcourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_general_educationcourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_guidance_and_career_educationcourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_health_and_physical_educationcourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_mathematicscourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_native_studiescourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_ontario_english_literacy_coursecourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_sciencecourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_sign_classical_and_international_languagescourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_social_sciences_and_the_humanitiescourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_technological_educationcourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_subject_area_the_artscourse enrollment by subject area (number of courses a child is enrolled in this subject area)Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_eng1dpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_eng1ppassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_eng1lpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_fra1dpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_fra1ppassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_fra1lpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_mpm1dpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_mfm1ppassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_mat1lpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_snc1dpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_snc1ppassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_snc1lpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_eng2dpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_eng2ppassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_eng2lpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_fra2dpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_fra2ppassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_fra2lpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_mpm2dpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_mfm2ppassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_mat2lpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_snc2dpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_snc2ppassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_snc2lpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionpassed_compulsory_course_mth1wpassed compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_eng1dcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_eng1pcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_eng1lcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_fra1dcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_fra1pcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_fra1lcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_mpm1dcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_mfm1pcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_mat1lcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_snc1dcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_snc1pcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_snc1lcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_eng2dcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_eng2pcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_eng2lcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_fra2dcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_fra2pcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_fra2lcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_mpm2dcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_mfm2pcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_mat2lcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_snc2dcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_snc2pcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_snc2lcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionenrolment_compulsory_course_mth1wcourse enrollment compulsory courseCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactioncohort_year_grade_9_credit_accumulationcohort year of child for credit accumulationCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactioncohort_year_grade_10_credit_accumulationcohort year of child for credit accumulationCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactioncohort_year_grade_11_credit_accumulationcohort year of child for credit accumulationCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactioncohort_grade_9_credit_accumulationcohort grade of child for credit accumulationCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactioncohort_grade_10_credit_accumulationcohort grade of child for credit accumulationCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactioncohort_grade_11_credit_accumulationcohort grade of child for credit accumulationCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactioncredit_accumulation_grade_9_8_or_more_creditsnumber of credits the child has accumulated by the end of the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactioncredit_accumulation_grade_10_16_or_more_creditsnumber of credits the child has accumulated by the end of the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactioncredit_accumulation_grade_11_23_or_more_creditsnumber of credits the child has accumulated by the end of the academic yearCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactioncohort_year_4cohort year of child for 4-year graduation rateCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactioncohort_year_5cohort year of child for 5-year graduation rateCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactiongraduated_in_4_yearsgraduated in 4 years flagCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactiongraduated_in_5_yearsgraduated in 5 years flagCoded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionsecondary_school_diploma_4child has received an ontario secondary school diploma during the academic year within 4 years of starting grade 9Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionsecondary_school_diploma_5child has received an ontario secondary school diploma during the academic year within 5 years of starting grade 9Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionsecondary_school_certificate_4child has received an ontario secondary school certificate during the academic year within 4 years of starting grade 9Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCOntario Education Data Warehouse (OEDW)EDU_Interactionsecondary_school_certificate_5child has received an ontario secondary school certificate during the academic year within 5 years of starting grade 9Coded information for Linking from Ontario Education Data Warehouse (OEDW)Coded2017-10-312023-10-31 EDU-OHCEducation Quality and Accountability Office (EQAO)EQAO_Interactioneqao_grade_3_readingeqao grade 3 reading resultsCoded information for Linking from Education Quality and Accountability Office (EQAO)Coded2017-10-312023-10-31 EDU-OHCEducation Quality and Accountability Office (EQAO)EQAO_Interactioneqao_grade_3_writingeqao grade 3 writing resultsCoded information for Linking from Education Quality and Accountability Office (EQAO)Coded2017-10-312023-10-31 EDU-OHCEducation Quality and Accountability Office (EQAO)EQAO_Interactioneqao_grade_3_matheqao grade 3 math resultsCoded information for Linking from Education Quality and Accountability Office (EQAO)Coded2017-10-312023-10-31 EDU-OHCEducation Quality and Accountability Office (EQAO)EQAO_Interactioneqao_grade_6_readingeqao grade 6 reading resultsCoded information for Linking from Education Quality and Accountability Office (EQAO)Coded2017-10-312023-10-31 EDU-OHCEducation Quality and Accountability Office (EQAO)EQAO_Interactioneqao_grade_6_writingeqao grade 6 writing resultsCoded information for Linking from Education Quality and Accountability Office (EQAO)Coded2017-10-312023-10-31 EDU-OHCEducation Quality and Accountability Office (EQAO)EQAO_Interactioneqao_grade_6_matheqao grade 6 math resultsCoded information for Linking from Education Quality and Accountability Office (EQAO)Coded2017-10-312023-10-31 EDU-OHCEducation Quality and Accountability Office (EQAO)EQAO_Interactioneqao_grade_9_academic_matheqao grade 9 academic math resultsCoded information for Linking from Education Quality and Accountability Office (EQAO)Coded2017-10-312023-10-31 EDU-OHCEducation Quality and Accountability Office (EQAO)EQAO_Interactioneqao_grade_9_applied_matheqao grade 9 applied math resultsCoded information for Linking from Education Quality and Accountability Office (EQAO)Coded2017-10-312023-10-31 EDU-OHCEducation Quality and Accountability Office (EQAO)EQAO_Interactioneqao_grade_9_matheqao grade 9 math results (combined)Coded information for Linking from Education Quality and Accountability Office (EQAO)Coded2017-10-312023-10-31 EDU-OHCEducation Quality and Accountability Office (EQAO)EQAO_Interactionosslt_first_time_eligiblesuccessful completion of the osslt for students who were first time eligible in the academic yearCoded information for Linking from Education Quality and Accountability Office (EQAO)Coded2017-10-312023-10-31 EDU-OHCEducation Quality and Accountability Office (EQAO)EQAO_Interactionosslt_previously_eligiblesuccessful completion of the osslt for students who were previously eligible in the academic yearCoded information for Linking from Education Quality and Accountability Office (EQAO)Coded2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Personfirst_namefirst nameID information for Record Matching from Child Protection Information Network (CPIN)ID2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Personlast_namechild's last nameID information for Record Matching from Child Protection Information Network (CPIN)ID2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Personbirth_datechild's date of birthID information for Record Matching from Child Protection Information Network (CPIN)ID2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Personpostal_codepostal code of child's placement as of october 31 of academic yearID information for Record Matching from Child Protection Information Network (CPIN)ID2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Personacademic_yearacademic yearID information for Record Matching from Child Protection Information Network (CPIN)ID2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Interactionlocation_codechild's children's aid societyCoded information for Linking from Child Protection Information Network (CPIN)Coded2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Interactionbusiness_case_typechild's case typeCoded information for Linking from Child Protection Information Network (CPIN)Coded2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Interactiongender_en_namechild's gender identityCoded information for Linking from Child Protection Information Network (CPIN)Coded2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Interactionpopulation_group_en_descchild's raceCoded information for Linking from Child Protection Information Network (CPIN)Coded2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Interactionethnic_origin_tab_en_descchild's raceCoded information for Linking from Child Protection Information Network (CPIN)Coded2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Interactionplacement_type_en_descchild's placement typeCoded information for Linking from Child Protection Information Network (CPIN)Coded2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Interactionlevel_codechild's identification as at risk of human trafficking at investigationCoded information for Linking from Child Protection Information Network (CPIN)Coded2017-10-312023-10-31The Human Trafficking Eligibility Spectrum types were introduced in 2021. EDU-OHCChild Protection Information Network (CPIN)CPIN_Interactionht_flagflag indicating child's identification as at risk of human traffickingCoded information for Linking from Child Protection Information Network (CPIN)Coded2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Interactiondays_in_carecumulative number of days the child has spent in out-of-home careCoded information for Linking from Child Protection Information Network (CPIN)Coded2017-10-312023-10-31 EDU-OHCChild Protection Information Network (CPIN)CPIN_Interactionacademic_yearacademic yearCoded information for Linking from Child Protection Information Network (CPIN)Coded2017-10-312023-10-31 SNPAccessOAPAccessOAP_Personprogramprogram nameID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Personsourcestream nameID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Personmember_idunique identifier assigned to each clientID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Personfirst_namefirst nameID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Personmiddle_namemiddle nameID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Personlast_namelast nameID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Persondobdate of birthID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Persongendergender of clientsID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Personadddress_street_numstreet name and numberID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Personaddress_streetstreet name and numberID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Personaddress_unitunit numberID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Personpostal_codepostal_codeID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_PersoncitycityID information for Record Matching from AccessOAPID2010-01-012024-12-31 SNPAccessOAPAccessOAP_Interactionprogramprogram nameCoded information for Linking from AccessOAPCoded2010-01-012024-12-31 SNPAccessOAPAccessOAP_Interactionsourcestream nameCoded information for Linking from AccessOAPCoded2010-01-012024-12-31 SNPAccessOAPAccessOAP_Interactionmember_idunique identifier assigned to each clientCoded information for Linking from AccessOAPCoded2010-01-012024-12-31 SNPAccessOAPAccessOAP_Interactioninteraction_ididentifier of the interactionCoded information for Linking from AccessOAPCoded2010-01-012024-12-31 SNPAccessOAPAccessOAP_Interactioninteraction_typetype of interactionCoded information for Linking from AccessOAPCoded2010-01-012024-12-31 SNPAccessOAPAccessOAP_Interactionserviceservice typeCoded information for Linking from AccessOAPCoded2010-01-012024-12-31 SNPAccessOAPAccessOAP_Interactionstatusstatus of the interactionCoded information for Linking from AccessOAPCoded2010-01-012024-12-31 SNPAccessOAPAccessOAP_Interactionstagestage of the interactionCoded information for Linking from AccessOAPCoded2010-01-012024-12-31 SNPAccessOAPAccessOAP_InteractiondatedateCoded information for Linking from AccessOAPCoded2010-01-012024-12-31 SNPAccessOAPAccessOAP_Interactionvalueamount ($)Coded information for Linking from AccessOAPCoded2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Personsourcestream nameID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Personmember_idunique identifier assigned to each clientID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Personfirst_namefirst nameID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Personmiddle_namemiddle nameID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Personlast_namelast nameID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Persondobdate of birthID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Persongendergender of clientsID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Personadddress_street_numstreet name and numberID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Personaddress_streetstreet name and numberID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Personaddress_unitunit numberID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Personpostal_codepostal codeID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_PersoncitycityID information for Record Matching from SSAHID2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Interactionprogramprogram nameCoded information for Linking from SSAHCoded2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Interactionsourcestream nameCoded information for Linking from SSAHCoded2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Interactionmember_idunique identifier assigned to each clientCoded information for Linking from SSAHCoded2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Interactioninteraction_ididentifier of the interactionCoded information for Linking from SSAHCoded2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Interactioninteraction_typetype of interactionCoded information for Linking from SSAHCoded2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Interactionserviceservice typeCoded information for Linking from SSAHCoded2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Interactionstatusstatus of the interactionCoded information for Linking from SSAHCoded2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Interactionstagestage of the interactionCoded information for Linking from SSAHCoded2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_InteractiondatedateCoded information for Linking from SSAHCoded2010-01-012024-12-31 SNPSpecial Services at Home (SSAH)SSAH_Interactionvalueamount ($)Coded information for Linking from SSAHCoded2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Personprogramprogram nameID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Personsourcestream nameID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Personmember_idunique identifier assigned to each clientID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Personfirst_namefirst nameID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Personmiddle_namemiddle nameID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Personlast_namelast nameID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Persondobdate of birthID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Persongendergender of clientsID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Personadddress_street_numstreet name and numberID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Personaddress_streetstreet name and numberID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Personaddress_unitunit numberID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Personpostal_codepostal_codeID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_PersoncitycityID information for Record Matching from DSCISID2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Interactionprogramprogram nameCoded information for Linking from DSCISCoded2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Interactionsourcestream nameCoded information for Linking from DSCISCoded2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Interactionmember_idunique identifier assigned to each clientCoded information for Linking from DSCISCoded2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Interactioninteraction_ididentifier of the interactionCoded information for Linking from DSCISCoded2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Interactioninteraction_typetype of interactionCoded information for Linking from DSCISCoded2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Interactionserviceservice typeCoded information for Linking from DSCISCoded2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Interactionstatusstatus of the interactionCoded information for Linking from DSCISCoded2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Interactionstagestage of the interactionCoded information for Linking from DSCISCoded2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_InteractiondatedateCoded information for Linking from DSCISCoded2010-01-012024-12-31 SNPDevelopmental Services Consolidated Information System (DSCIS)DSCIS_Interactionvalueamount ($)Coded information for Linking from DSCISCoded2010-01-012024-12-31 SNPPassportONEPassport_Personprogramprogram nameID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Personsourcestream nameID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Personmember_idunique identifier assigned to each clientID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Personfirst_namefirst nameID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Personmiddle_namemiddle nameID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Personlast_namelast nameID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Persondobdate of birthID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Persongendergender of clientsID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Personadddress_street_numstreet name and numberID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Personaddress_streetstreet name and numberID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Personaddress_unitunit numberID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Personpostal_codepostal_codeID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_PersoncitycityID information for Record Matching from PassportONEID2010-01-012024-12-31 SNPPassportONEPassport_Interactionprogramprogram nameCoded information for Linking from PassportONECoded2010-01-012024-12-31 SNPPassportONEPassport_Interactionsourcestream nameCoded information for Linking from PassportONECoded2010-01-012024-12-31 SNPPassportONEPassport_Interactionmember_idunique identifier assigned to each clientCoded information for Linking from PassportONECoded2010-01-012024-12-31 SNPPassportONEPassport_Interactioninteraction_ididentifier of the interactionCoded information for Linking from PassportONECoded2010-01-012024-12-31 SNPPassportONEPassport_Interactioninteraction_typetype of interactionCoded information for Linking from PassportONECoded2010-01-012024-12-31 SNPPassportONEPassport_Interactionserviceservice typeCoded information for Linking from PassportONECoded2010-01-012024-12-31 SNPPassportONEPassport_Interactionstatusstatus of the interactionCoded information for Linking from PassportONECoded2010-01-012024-12-31 SNPPassportONEPassport_Interactionstagestage of the interactionCoded information for Linking from PassportONECoded2010-01-012024-12-31 SNPPassportONEPassport_InteractiondatedateCoded information for Linking from PassportONECoded2010-01-012024-12-31 SNPPassportONEPassport_Interactionvalueamount ($)Coded information for Linking from PassportONECoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Personprogramprogram nameID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Personsourcestream nameID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Personmember_idunique identifier assigned to each clientID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Personfirst_namefirst nameID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Personmiddle_namemiddle nameID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Personlast_namelast nameID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Personsecond_last_namesecond last nameID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Persondobdate of birthID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Persongendergender of clientsID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Personadddress_street_numstreet name and numberID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Personaddress_streetstreet name and numberID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Personaddress_unitunit numberID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Personpostal_codepostal codeID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_PersoncitycityID information for Record Matching from SAMSID2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionprogramprogram nameCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionsourcestream nameCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionmember_idunique identifier assigned to each clientCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactioninteraction_ididentifier of the interactionCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactioninteraction_typetype of interactionCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionserviceservice typeCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionstatusstatus of the interactionCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionstagestage of the interactionCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionfromdate of start of the serviceCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactiontodate of service terminationCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionvalueamount ($)Coded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionintegrated_case_ididentifier for data collection/do not useCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactioncase_ididentifier for data collection/do not useCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionaccommodation_codetype of accomodationCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactiondisability_reason_codedisability reasonCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionfamily_structure_codefamily structureCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionfamily_sizefamily sizeCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionmember_role_coderole of the individualCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionmarital_status_codemarital statusCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactioneducation_level_codeeducation levelCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionmember_disability_reason_codedisability typeCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionicd9_code1code1Coded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionicd9_code2code2Coded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionfamily_violence_indicatorviolence indicatorCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactionmember_disability_codemember disability codeCoded information for Linking from SAMSCoded2010-01-012024-12-31 SNPSocial Assistance Management System (SAMS)SAMS_Interactiondisabled_inddisability indicatorCoded information for Linking from SAMSCoded2010-01-012024-12-31 CW-SAChild Protection Information Network (CPIN)CPIN_Personname_type_en_descname type description (e.g. registered, alias)ID information for Record Matching from CPINID2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Personfirst_namefirst name (many names can be recorded for a person)ID information for Record Matching from CPINID2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Personother_firstnameother first nameID information for Record Matching from CPINID2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Personlast_namelast nameID information for Record Matching from CPINID2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Persongender_en_namegender nameID information for Record Matching from CPINID2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Personmember_referenceunique reference number assigned by the system to a concern role record.ID information for Record Matching from CPINID2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Personupper_first_nameupper-case first nameID information for Record Matching from CPINID2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Personupper_last_nameupper-case last nameID information for Record Matching from CPINID2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Interactionbirth_datedate of birth of child/youth in careCoded information for Linking from CPINCoded2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Interactiondischarge_datedate a child is discharged from careCoded information for Linking from CPINCoded2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Interactiondischarge_reason_en_descthe reason for discharge of the childCoded information for Linking from CPINCoded2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Interactionbusiness_case_type_en_desccase type code descriptionCoded information for Linking from CPINCoded2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Interactionindigenous_flagindicator to denote whether the person is indigenousCoded information for Linking from CPINCoded2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Interactionvys_rys_flagindicates if case was a VYS or RYS case typeCoded information for Linking from CPINCoded2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Interactionccsy_flagindicates if case was a CCSY case typeCoded information for Linking from CPINCoded2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Interactionrsg_flagindicates if case was a RSG case typeCoded information for Linking from CPINCoded2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Personcity_namecityID information for Record Matching from CPINID2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Personpostal_codepostal codeID information for Record Matching from CPINID2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Interactionsegmentcohort yearCoded information for Linking from CPINCoded2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Personmember_referenceunique reference number assigned by the system to a concern role recordID information for Record Matching from CPINID2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_InteractiongendergenderCoded information for Linking from CPINCoded2018-04-012025-03-31 CW-SAChild Protection Information Network (CPIN)CPIN_Personage_left_cwcalculated age that the child or youth was discharged (exited child welfare program)ID information for Record Matching from CPINID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmember_idan integer that uniquely identifies an applicant/recipient (participant). this id number is not re-used and remains with the member for his/her lifetime, even if they join and leave assistance any number of times. this number is generated when the member is first created at intake (or upon conversion from cims, sdmt). it is a foreign key on most member-centric tables (e.g., income, assets, participation agreement, etc.) the member_id is an internal value, referred in SAMS as concernroleidCoded information for Linking from CPINCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionextract_monthidentifies the year and month being reportedCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionprogramprogram for which the benefit unit is currently being assessed or paid benefitsCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmember_unit_count1 indicates the member is active within the product delivery case and case_unit_count = 1Coded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmember_roleindicates the role of the member in the benefit unit. Coded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmember_genderidentifies whether the member is male/female or not statedCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmember_ageage of member as of the extract_monthCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionicd9_primaryprimary diagnosis of individual, corresponding to the international classification of diseases version 9 (icd-9) codeCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionicd9_secondarysecondary diagnosis of individual, corresponding to the international classification of diseases version 9 (icd-9) codeCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmember_disabilitygroups the member's ICD9 disability codes into categories for reportingCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionimmigration_statusstatus the member holds within Canada as stated by immigration, refugees and citizenship CanadaCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionsponsored_indicatoridentifies if member is a sponsored immigrant or notCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionrefugee_claimant_indicatorindicates if member is a refugee claimant or not.Coded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactioneducation_levelthe highest level of education achieved by the memberCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactioneducation_student_statusdocuments whether the member is currently in schoolCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmember_earningsemployment income (net of deductions) reported by the memberCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmember_self_employmentamount member earned as business income or farm income is recorded hereCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfamily_structureindicates the family structure (under social assistance) -- couple with children(/dependants other than spouse), couple without children, singles with children or singles without childrenCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfamily_sizenumber of persons on social assistance in the benefit unit (including applicant, spouse, dependent adults, and children)Coded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionage_youngest_childage of the youngest child in the benefit unitCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionaccommodation_typeidentifies the type of housing/lodging the recipient lives in (includes sdmt codes for converted cases)Coded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactioninstitution_typethe type of facility the individual resides inCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionsda_officeservice delivery adminstrative (SDA) offices for the case/memberCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionsdaif OW, corresponds to the CMSM/DSSAB. if ODSP, corresponds to the region.Coded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmunicipalitymunicipality in which the recipient livesCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactiongender_identityself-identified genderCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionracial_identityself-identified raceCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionvisible_minorityself-identified as visible minorityCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionlanguage_of_choiceself-identified language of choiceCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionindigenous_identityself-identified as indigenous personCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionintegrated_case_idunique id (internal to SAMS) Coded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactioncase_idinternal id of product delivery case (PDC). a client can have several PDC cases at the same time: one program case and one or more additional benefit cases. a closed case can be reopened (reinstated) or a new case can be createdCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmember_idan integer that uniquely identifies an applicant/recipient (participant). this id number is not re-used and remains with the member for his/her lifetime, even if they join and leave assistance any number of times. this number is generated when the member is first created at intake (or upon conversion from cims, sdmt). it is a foreign key on most member-centric tables (e.g., income, assets, participation agreement, etc.) the member_id is an internal value, referred in SAMS as concernroleidCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionprogram_fundingwhich program the funding is coming from (OW, ODSP, ODB)Coded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactioncase_amounttotal amount the case received in the monthCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Personmember_amounttotal amount the member received in the monthID information for Record Matching from SAMSID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Personmember_firstnamefirst nameID information for Record Matching from SAMSID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Personmember_lastnamelast nameID information for Record Matching from SAMSID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Personmember_citycityID information for Record Matching from SAMSID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Personmember_postalcodepostal codeID information for Record Matching from SAMSID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Personmember_birth_datebirth dateID information for Record Matching from SAMSID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Personfirst_gendergender as of the first SA dateID information for Record Matching from SAMSID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfirst_sa_paymentamount of first SA paymentCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfirst_sa_datefirst month of receiving SACoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Personfirst_sa_programfirst SA programID information for Record Matching from SAMSID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionlast_sa_programlatest SA programCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactiontotal_paymenttotal amount of payments that member receivedCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionnum_payments_monthsnumber of months that member received SA paymentsCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionavg_month_paymentaverage monthly SA paymentCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfirst_family_structurefamily structure as of the first SA dateCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfirst_sda_officeSDA office as of the first SA dateCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfirst_sdaCMSM/DSSAB/region as of the first SA dateCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfirst_municipalitymunicipality as of the first SA dateCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfirst_family_sizefamily size as of the first SA dateCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfirst_member_rolemember role as of the first SA dateCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfirst_immigration_statusimmigration status as of the first SA dateCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionicd9_primaryprimary ICD9 diagnosis as of the first SA dateCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionicd9_secondarysecondary ICD9 diagnosis as of the first SA dateCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmember_disabilitymember disability as of the first SA dateCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionfirst_education_leveleducation level as of the first SA dateCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Interactionmember_idan integer that uniquely identifies an applicant/recipientCoded information for Linking from SAMSCoded2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Personfirst_fore_namefirst nameID information for Record Matching from SAMSID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Personother_fore_nameother first nameID information for Record Matching from SAMSID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_PersonsurnamesurnameID information for Record Matching from SAMSID2018-04-012025-03-31 CW-SASocial Assistance Management System (SAMS)SA_Personnametype_descname type (e.g. registered, alias)ID information for Record Matching from SAMSID2018-04-012025-03-31