_id Project Name Source(s) of information in the dataset Dataset Name Variable Name Definition Description of Dataset PI Database Start Date End Date Additional Comments 1 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Person first_name first name ID information for Record Matching from Ontario Education Data Warehouse (OEDW) ID 2017-10-31 2023-10-31 2 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Person last_name last name ID information for Record Matching from Ontario Education Data Warehouse (OEDW) ID 2017-10-31 2023-10-31 3 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Person date_of_birth date of birth ID information for Record Matching from Ontario Education Data Warehouse (OEDW) ID 2017-10-31 2023-10-31 4 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Person postal_code_of_student_address postal code of student address as of october 31 of academic year ID information for Record Matching from Ontario Education Data Warehouse (OEDW) ID 2017-10-31 2023-10-31 5 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Person academic_year academic year ID information for Record Matching from Ontario Education Data Warehouse (OEDW) ID 2017-10-31 2023-10-31 6 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction academic_year academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 7 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction school_board child's school board Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 8 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction students_grade_of_enrollment child's grade of enrollment in academic year of analysis Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 9 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction age_as_of_december_31_of_the_academic_year_elementary child's age as of december 31 of the academic year of analysis Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 10 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction age_as_of_december_31_of_the_academic_year_secondary child's age as of december 31 of the academic year of analysis Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 11 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction language_first_spoken first language spoken by the child Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 12 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction special_education_programs_and_or_services_flag child receives special education programs or services in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 13 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction school_level child's school level Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 14 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction special_education_students_by_exceptionality_elementary child's exceptionality in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 15 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction special_education_students_by_exceptionality_secondary child's exceptionality in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 16 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction receipt_of_an_individual_education_plan_elementary child receives an individual education plan in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 17 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction receipt_of_an_individual_education_plan_secondary child receives an individual education plan in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 18 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrollment_in_job_skill_program_dc child is enrolled in a dual credit course in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 19 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrollment_in_job_skill_program_coop child is enrolled in a co-op course in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 20 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrollment_in_job_skill_program_shsm child is enrolled in an shsm program in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 21 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction participation_in_the_ontario_youth_apprenticeship_program participation in the ontario youth apprenticeship program Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 22 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrollment_in_grade_11_or_12_regular_enrolment_not_course child is enrolled in grade 11 or 12 Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 23 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrollment_in_job_skills_program_all child is enrolled in any job skills program in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 24 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction number_of_instructional_days_attended child's attendance of instructional days in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 25 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction number_of_days_absent child's number of absences in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 26 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction number_of_instructional_days_in_the_year number of instructional days in the year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 27 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction nongrade_based_mobility_elementary child has changed schools within the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 28 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction nongrade_based_mobility_secondary child has changed schools within the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 29 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction suspensions number of suspensions child has received within the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 30 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction expulsions number of expulsions child has received within the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 31 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction range_of_suspensions range of suspensions received by the child in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 32 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction range_of_expulsions range of expulsions received by the child in the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 33 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_alternative_noncredit course 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) Coded 2017-10-31 2023-10-31 34 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_business_studies course 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) Coded 2017-10-31 2023-10-31 35 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_canadian_and_world_studies_cours_de_comptences_linguistiqu course 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) Coded 2017-10-31 2023-10-31 36 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_computers_interdisciplinary_studies course 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) Coded 2017-10-31 2023-10-31 37 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_cooperative_education_and_experiential_learning course 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) Coded 2017-10-31 2023-10-31 38 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_english course 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) Coded 2017-10-31 2023-10-31 39 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_french course 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) Coded 2017-10-31 2023-10-31 40 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_general_education course 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) Coded 2017-10-31 2023-10-31 41 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_guidance_and_career_education course 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) Coded 2017-10-31 2023-10-31 42 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_health_and_physical_education course 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) Coded 2017-10-31 2023-10-31 43 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_mathematics course 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) Coded 2017-10-31 2023-10-31 44 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_native_studies course 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) Coded 2017-10-31 2023-10-31 45 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_ontario_english_literacy_course course 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) Coded 2017-10-31 2023-10-31 46 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_science course 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) Coded 2017-10-31 2023-10-31 47 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_sign_classical_and_international_languages course 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) Coded 2017-10-31 2023-10-31 48 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_social_sciences_and_the_humanities course 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) Coded 2017-10-31 2023-10-31 49 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_technological_education course 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) Coded 2017-10-31 2023-10-31 50 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_subject_area_the_arts course 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) Coded 2017-10-31 2023-10-31 51 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_eng1d passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 52 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_eng1p passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 53 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_eng1l passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 54 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_fra1d passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 55 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_fra1p passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 56 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_fra1l passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 57 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_mpm1d passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 58 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_mfm1p passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 59 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_mat1l passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 60 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_snc1d passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 61 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_snc1p passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 62 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_snc1l passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 63 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_eng2d passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 64 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_eng2p passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 65 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_eng2l passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 66 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_fra2d passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 67 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_fra2p passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 68 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_fra2l passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 69 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_mpm2d passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 70 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_mfm2p passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 71 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_mat2l passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 72 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_snc2d passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 73 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_snc2p passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 74 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_snc2l passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 75 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction passed_compulsory_course_mth1w passed compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 76 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_eng1d course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 77 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_eng1p course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 78 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_eng1l course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 79 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_fra1d course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 80 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_fra1p course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 81 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_fra1l course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 82 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_mpm1d course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 83 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_mfm1p course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 84 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_mat1l course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 85 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_snc1d course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 86 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_snc1p course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 87 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_snc1l course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 88 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_eng2d course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 89 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_eng2p course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 90 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_eng2l course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 91 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_fra2d course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 92 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_fra2p course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 93 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_fra2l course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 94 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_mpm2d course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 95 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_mfm2p course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 96 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_mat2l course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 97 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_snc2d course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 98 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_snc2p course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 99 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_snc2l course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 100 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction enrolment_compulsory_course_mth1w course enrollment compulsory course Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 101 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction cohort_year_grade_9_credit_accumulation cohort year of child for credit accumulation Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 102 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction cohort_year_grade_10_credit_accumulation cohort year of child for credit accumulation Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 103 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction cohort_year_grade_11_credit_accumulation cohort year of child for credit accumulation Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 104 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction cohort_grade_9_credit_accumulation cohort grade of child for credit accumulation Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 105 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction cohort_grade_10_credit_accumulation cohort grade of child for credit accumulation Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 106 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction cohort_grade_11_credit_accumulation cohort grade of child for credit accumulation Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 107 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction credit_accumulation_grade_9_8_or_more_credits number of credits the child has accumulated by the end of the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 108 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction credit_accumulation_grade_10_16_or_more_credits number of credits the child has accumulated by the end of the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 109 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction credit_accumulation_grade_11_23_or_more_credits number of credits the child has accumulated by the end of the academic year Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 110 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction cohort_year_4 cohort year of child for 4-year graduation rate Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 111 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction cohort_year_5 cohort year of child for 5-year graduation rate Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 112 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction graduated_in_4_years graduated in 4 years flag Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 113 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction graduated_in_5_years graduated in 5 years flag Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 114 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction secondary_school_diploma_4 child has received an ontario secondary school diploma during the academic year within 4 years of starting grade 9 Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 115 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction secondary_school_diploma_5 child has received an ontario secondary school diploma during the academic year within 5 years of starting grade 9 Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 116 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction secondary_school_certificate_4 child has received an ontario secondary school certificate during the academic year within 4 years of starting grade 9 Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 117 EDU-OHC Ontario Education Data Warehouse (OEDW) EDU_Interaction secondary_school_certificate_5 child has received an ontario secondary school certificate during the academic year within 5 years of starting grade 9 Coded information for Linking from Ontario Education Data Warehouse (OEDW) Coded 2017-10-31 2023-10-31 118 EDU-OHC Education Quality and Accountability Office (EQAO) EQAO_Interaction eqao_grade_3_reading eqao grade 3 reading results Coded information for Linking from Education Quality and Accountability Office (EQAO) Coded 2017-10-31 2023-10-31 119 EDU-OHC Education Quality and Accountability Office (EQAO) EQAO_Interaction eqao_grade_3_writing eqao grade 3 writing results Coded information for Linking from Education Quality and Accountability Office (EQAO) Coded 2017-10-31 2023-10-31 120 EDU-OHC Education Quality and Accountability Office (EQAO) EQAO_Interaction eqao_grade_3_math eqao grade 3 math results Coded information for Linking from Education Quality and Accountability Office (EQAO) Coded 2017-10-31 2023-10-31 121 EDU-OHC Education Quality and Accountability Office (EQAO) EQAO_Interaction eqao_grade_6_reading eqao grade 6 reading results Coded information for Linking from Education Quality and Accountability Office (EQAO) Coded 2017-10-31 2023-10-31 122 EDU-OHC Education Quality and Accountability Office (EQAO) EQAO_Interaction eqao_grade_6_writing eqao grade 6 writing results Coded information for Linking from Education Quality and Accountability Office (EQAO) Coded 2017-10-31 2023-10-31 123 EDU-OHC Education Quality and Accountability Office (EQAO) EQAO_Interaction eqao_grade_6_math eqao grade 6 math results Coded information for Linking from Education Quality and Accountability Office (EQAO) Coded 2017-10-31 2023-10-31 124 EDU-OHC Education Quality and Accountability Office (EQAO) EQAO_Interaction eqao_grade_9_academic_math eqao grade 9 academic math results Coded information for Linking from Education Quality and Accountability Office (EQAO) Coded 2017-10-31 2023-10-31 125 EDU-OHC Education Quality and Accountability Office (EQAO) EQAO_Interaction eqao_grade_9_applied_math eqao grade 9 applied math results Coded information for Linking from Education Quality and Accountability Office (EQAO) Coded 2017-10-31 2023-10-31 126 EDU-OHC Education Quality and Accountability Office (EQAO) EQAO_Interaction eqao_grade_9_math eqao grade 9 math results (combined) Coded information for Linking from Education Quality and Accountability Office (EQAO) Coded 2017-10-31 2023-10-31 127 EDU-OHC Education Quality and Accountability Office (EQAO) EQAO_Interaction osslt_first_time_eligible successful completion of the osslt for students who were first time eligible in the academic year Coded information for Linking from Education Quality and Accountability Office (EQAO) Coded 2017-10-31 2023-10-31 128 EDU-OHC Education Quality and Accountability Office (EQAO) EQAO_Interaction osslt_previously_eligible successful completion of the osslt for students who were previously eligible in the academic year Coded information for Linking from Education Quality and Accountability Office (EQAO) Coded 2017-10-31 2023-10-31 129 EDU-OHC Child Protection Information Network (CPIN) CPIN_Person first_name first name ID information for Record Matching from Child Protection Information Network (CPIN) ID 2017-10-31 2023-10-31 130 EDU-OHC Child Protection Information Network (CPIN) CPIN_Person last_name child's last name ID information for Record Matching from Child Protection Information Network (CPIN) ID 2017-10-31 2023-10-31 131 EDU-OHC Child Protection Information Network (CPIN) CPIN_Person birth_date child's date of birth ID information for Record Matching from Child Protection Information Network (CPIN) ID 2017-10-31 2023-10-31 132 EDU-OHC Child Protection Information Network (CPIN) CPIN_Person postal_code postal code of child's placement as of october 31 of academic year ID information for Record Matching from Child Protection Information Network (CPIN) ID 2017-10-31 2023-10-31 133 EDU-OHC Child Protection Information Network (CPIN) CPIN_Person academic_year academic year ID information for Record Matching from Child Protection Information Network (CPIN) ID 2017-10-31 2023-10-31 134 EDU-OHC Child Protection Information Network (CPIN) CPIN_Interaction location_code child's children's aid society Coded information for Linking from Child Protection Information Network (CPIN) Coded 2017-10-31 2023-10-31 135 EDU-OHC Child Protection Information Network (CPIN) CPIN_Interaction business_case_type child's case type Coded information for Linking from Child Protection Information Network (CPIN) Coded 2017-10-31 2023-10-31 136 EDU-OHC Child Protection Information Network (CPIN) CPIN_Interaction gender_en_name child's gender identity Coded information for Linking from Child Protection Information Network (CPIN) Coded 2017-10-31 2023-10-31 137 EDU-OHC Child Protection Information Network (CPIN) CPIN_Interaction population_group_en_desc child's race Coded information for Linking from Child Protection Information Network (CPIN) Coded 2017-10-31 2023-10-31 138 EDU-OHC Child Protection Information Network (CPIN) CPIN_Interaction ethnic_origin_tab_en_desc child's race Coded information for Linking from Child Protection Information Network (CPIN) Coded 2017-10-31 2023-10-31 139 EDU-OHC Child Protection Information Network (CPIN) CPIN_Interaction placement_type_en_desc child's placement type Coded information for Linking from Child Protection Information Network (CPIN) Coded 2017-10-31 2023-10-31 140 EDU-OHC Child Protection Information Network (CPIN) CPIN_Interaction level_code child's identification as at risk of human trafficking at investigation Coded information for Linking from Child Protection Information Network (CPIN) Coded 2017-10-31 2023-10-31 The Human Trafficking Eligibility Spectrum types were introduced in 2021. 141 EDU-OHC Child Protection Information Network (CPIN) CPIN_Interaction ht_flag flag indicating child's identification as at risk of human trafficking Coded information for Linking from Child Protection Information Network (CPIN) Coded 2017-10-31 2023-10-31 142 EDU-OHC Child Protection Information Network (CPIN) CPIN_Interaction days_in_care cumulative number of days the child has spent in out-of-home care Coded information for Linking from Child Protection Information Network (CPIN) Coded 2017-10-31 2023-10-31 143 EDU-OHC Child Protection Information Network (CPIN) CPIN_Interaction academic_year academic year Coded information for Linking from Child Protection Information Network (CPIN) Coded 2017-10-31 2023-10-31 144 SNP AccessOAP AccessOAP_Person program program name ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 145 SNP AccessOAP AccessOAP_Person source stream name ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 146 SNP AccessOAP AccessOAP_Person member_id unique identifier assigned to each client ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 147 SNP AccessOAP AccessOAP_Person first_name first name ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 148 SNP AccessOAP AccessOAP_Person middle_name middle name ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 149 SNP AccessOAP AccessOAP_Person last_name last name ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 150 SNP AccessOAP AccessOAP_Person dob date of birth ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 151 SNP AccessOAP AccessOAP_Person gender gender of clients ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 152 SNP AccessOAP AccessOAP_Person adddress_street_num street name and number ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 153 SNP AccessOAP AccessOAP_Person address_street street name and number ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 154 SNP AccessOAP AccessOAP_Person address_unit unit number ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 155 SNP AccessOAP AccessOAP_Person postal_code postal_code ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 156 SNP AccessOAP AccessOAP_Person city city ID information for Record Matching from AccessOAP ID 2010-01-01 2024-12-31 157 SNP AccessOAP AccessOAP_Interaction program program name Coded information for Linking from AccessOAP Coded 2010-01-01 2024-12-31 158 SNP AccessOAP AccessOAP_Interaction source stream name Coded information for Linking from AccessOAP Coded 2010-01-01 2024-12-31 159 SNP AccessOAP AccessOAP_Interaction member_id unique identifier assigned to each client Coded information for Linking from AccessOAP Coded 2010-01-01 2024-12-31 160 SNP AccessOAP AccessOAP_Interaction interaction_id identifier of the interaction Coded information for Linking from AccessOAP Coded 2010-01-01 2024-12-31 161 SNP AccessOAP AccessOAP_Interaction interaction_type type of interaction Coded information for Linking from AccessOAP Coded 2010-01-01 2024-12-31 162 SNP AccessOAP AccessOAP_Interaction service service type Coded information for Linking from AccessOAP Coded 2010-01-01 2024-12-31 163 SNP AccessOAP AccessOAP_Interaction status status of the interaction Coded information for Linking from AccessOAP Coded 2010-01-01 2024-12-31 164 SNP AccessOAP AccessOAP_Interaction stage stage of the interaction Coded information for Linking from AccessOAP Coded 2010-01-01 2024-12-31 165 SNP AccessOAP AccessOAP_Interaction date date Coded information for Linking from AccessOAP Coded 2010-01-01 2024-12-31 166 SNP AccessOAP AccessOAP_Interaction value amount ($) Coded information for Linking from AccessOAP Coded 2010-01-01 2024-12-31 167 SNP Special Services at Home (SSAH) SSAH_Person source stream name ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 168 SNP Special Services at Home (SSAH) SSAH_Person member_id unique identifier assigned to each client ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 169 SNP Special Services at Home (SSAH) SSAH_Person first_name first name ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 170 SNP Special Services at Home (SSAH) SSAH_Person middle_name middle name ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 171 SNP Special Services at Home (SSAH) SSAH_Person last_name last name ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 172 SNP Special Services at Home (SSAH) SSAH_Person dob date of birth ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 173 SNP Special Services at Home (SSAH) SSAH_Person gender gender of clients ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 174 SNP Special Services at Home (SSAH) SSAH_Person adddress_street_num street name and number ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 175 SNP Special Services at Home (SSAH) SSAH_Person address_street street name and number ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 176 SNP Special Services at Home (SSAH) SSAH_Person address_unit unit number ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 177 SNP Special Services at Home (SSAH) SSAH_Person postal_code postal code ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 178 SNP Special Services at Home (SSAH) SSAH_Person city city ID information for Record Matching from SSAH ID 2010-01-01 2024-12-31 179 SNP Special Services at Home (SSAH) SSAH_Interaction program program name Coded information for Linking from SSAH Coded 2010-01-01 2024-12-31 180 SNP Special Services at Home (SSAH) SSAH_Interaction source stream name Coded information for Linking from SSAH Coded 2010-01-01 2024-12-31 181 SNP Special Services at Home (SSAH) SSAH_Interaction member_id unique identifier assigned to each client Coded information for Linking from SSAH Coded 2010-01-01 2024-12-31 182 SNP Special Services at Home (SSAH) SSAH_Interaction interaction_id identifier of the interaction Coded information for Linking from SSAH Coded 2010-01-01 2024-12-31 183 SNP Special Services at Home (SSAH) SSAH_Interaction interaction_type type of interaction Coded information for Linking from SSAH Coded 2010-01-01 2024-12-31 184 SNP Special Services at Home (SSAH) SSAH_Interaction service service type Coded information for Linking from SSAH Coded 2010-01-01 2024-12-31 185 SNP Special Services at Home (SSAH) SSAH_Interaction status status of the interaction Coded information for Linking from SSAH Coded 2010-01-01 2024-12-31 186 SNP Special Services at Home (SSAH) SSAH_Interaction stage stage of the interaction Coded information for Linking from SSAH Coded 2010-01-01 2024-12-31 187 SNP Special Services at Home (SSAH) SSAH_Interaction date date Coded information for Linking from SSAH Coded 2010-01-01 2024-12-31 188 SNP Special Services at Home (SSAH) SSAH_Interaction value amount ($) Coded information for Linking from SSAH Coded 2010-01-01 2024-12-31 189 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person program program name ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 190 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person source stream name ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 191 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person member_id unique identifier assigned to each client ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 192 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person first_name first name ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 193 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person middle_name middle name ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 194 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person last_name last name ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 195 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person dob date of birth ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 196 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person gender gender of clients ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 197 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person adddress_street_num street name and number ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 198 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person address_street street name and number ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 199 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person address_unit unit number ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 200 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person postal_code postal_code ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 201 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Person city city ID information for Record Matching from DSCIS ID 2010-01-01 2024-12-31 202 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Interaction program program name Coded information for Linking from DSCIS Coded 2010-01-01 2024-12-31 203 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Interaction source stream name Coded information for Linking from DSCIS Coded 2010-01-01 2024-12-31 204 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Interaction member_id unique identifier assigned to each client Coded information for Linking from DSCIS Coded 2010-01-01 2024-12-31 205 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Interaction interaction_id identifier of the interaction Coded information for Linking from DSCIS Coded 2010-01-01 2024-12-31 206 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Interaction interaction_type type of interaction Coded information for Linking from DSCIS Coded 2010-01-01 2024-12-31 207 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Interaction service service type Coded information for Linking from DSCIS Coded 2010-01-01 2024-12-31 208 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Interaction status status of the interaction Coded information for Linking from DSCIS Coded 2010-01-01 2024-12-31 209 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Interaction stage stage of the interaction Coded information for Linking from DSCIS Coded 2010-01-01 2024-12-31 210 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Interaction date date Coded information for Linking from DSCIS Coded 2010-01-01 2024-12-31 211 SNP Developmental Services Consolidated Information System (DSCIS) DSCIS_Interaction value amount ($) Coded information for Linking from DSCIS Coded 2010-01-01 2024-12-31 212 SNP PassportONE Passport_Person program program name ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 213 SNP PassportONE Passport_Person source stream name ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 214 SNP PassportONE Passport_Person member_id unique identifier assigned to each client ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 215 SNP PassportONE Passport_Person first_name first name ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 216 SNP PassportONE Passport_Person middle_name middle name ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 217 SNP PassportONE Passport_Person last_name last name ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 218 SNP PassportONE Passport_Person dob date of birth ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 219 SNP PassportONE Passport_Person gender gender of clients ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 220 SNP PassportONE Passport_Person adddress_street_num street name and number ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 221 SNP PassportONE Passport_Person address_street street name and number ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 222 SNP PassportONE Passport_Person address_unit unit number ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 223 SNP PassportONE Passport_Person postal_code postal_code ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 224 SNP PassportONE Passport_Person city city ID information for Record Matching from PassportONE ID 2010-01-01 2024-12-31 225 SNP PassportONE Passport_Interaction program program name Coded information for Linking from PassportONE Coded 2010-01-01 2024-12-31 226 SNP PassportONE Passport_Interaction source stream name Coded information for Linking from PassportONE Coded 2010-01-01 2024-12-31 227 SNP PassportONE Passport_Interaction member_id unique identifier assigned to each client Coded information for Linking from PassportONE Coded 2010-01-01 2024-12-31 228 SNP PassportONE Passport_Interaction interaction_id identifier of the interaction Coded information for Linking from PassportONE Coded 2010-01-01 2024-12-31 229 SNP PassportONE Passport_Interaction interaction_type type of interaction Coded information for Linking from PassportONE Coded 2010-01-01 2024-12-31 230 SNP PassportONE Passport_Interaction service service type Coded information for Linking from PassportONE Coded 2010-01-01 2024-12-31 231 SNP PassportONE Passport_Interaction status status of the interaction Coded information for Linking from PassportONE Coded 2010-01-01 2024-12-31 232 SNP PassportONE Passport_Interaction stage stage of the interaction Coded information for Linking from PassportONE Coded 2010-01-01 2024-12-31 233 SNP PassportONE Passport_Interaction date date Coded information for Linking from PassportONE Coded 2010-01-01 2024-12-31 234 SNP PassportONE Passport_Interaction value amount ($) Coded information for Linking from PassportONE Coded 2010-01-01 2024-12-31 235 SNP Social Assistance Management System (SAMS) SAMS_Person program program name ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 236 SNP Social Assistance Management System (SAMS) SAMS_Person source stream name ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 237 SNP Social Assistance Management System (SAMS) SAMS_Person member_id unique identifier assigned to each client ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 238 SNP Social Assistance Management System (SAMS) SAMS_Person first_name first name ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 239 SNP Social Assistance Management System (SAMS) SAMS_Person middle_name middle name ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 240 SNP Social Assistance Management System (SAMS) SAMS_Person last_name last name ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 241 SNP Social Assistance Management System (SAMS) SAMS_Person second_last_name second last name ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 242 SNP Social Assistance Management System (SAMS) SAMS_Person dob date of birth ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 243 SNP Social Assistance Management System (SAMS) SAMS_Person gender gender of clients ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 244 SNP Social Assistance Management System (SAMS) SAMS_Person adddress_street_num street name and number ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 245 SNP Social Assistance Management System (SAMS) SAMS_Person address_street street name and number ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 246 SNP Social Assistance Management System (SAMS) SAMS_Person address_unit unit number ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 247 SNP Social Assistance Management System (SAMS) SAMS_Person postal_code postal code ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 248 SNP Social Assistance Management System (SAMS) SAMS_Person city city ID information for Record Matching from SAMS ID 2010-01-01 2024-12-31 249 SNP Social Assistance Management System (SAMS) SAMS_Interaction program program name Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 250 SNP Social Assistance Management System (SAMS) SAMS_Interaction source stream name Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 251 SNP Social Assistance Management System (SAMS) SAMS_Interaction member_id unique identifier assigned to each client Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 252 SNP Social Assistance Management System (SAMS) SAMS_Interaction interaction_id identifier of the interaction Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 253 SNP Social Assistance Management System (SAMS) SAMS_Interaction interaction_type type of interaction Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 254 SNP Social Assistance Management System (SAMS) SAMS_Interaction service service type Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 255 SNP Social Assistance Management System (SAMS) SAMS_Interaction status status of the interaction Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 256 SNP Social Assistance Management System (SAMS) SAMS_Interaction stage stage of the interaction Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 257 SNP Social Assistance Management System (SAMS) SAMS_Interaction from date of start of the service Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 258 SNP Social Assistance Management System (SAMS) SAMS_Interaction to date of service termination Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 259 SNP Social Assistance Management System (SAMS) SAMS_Interaction value amount ($) Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 260 SNP Social Assistance Management System (SAMS) SAMS_Interaction integrated_case_id identifier for data collection/do not use Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 261 SNP Social Assistance Management System (SAMS) SAMS_Interaction case_id identifier for data collection/do not use Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 262 SNP Social Assistance Management System (SAMS) SAMS_Interaction accommodation_code type of accomodation Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 263 SNP Social Assistance Management System (SAMS) SAMS_Interaction disability_reason_code disability reason Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 264 SNP Social Assistance Management System (SAMS) SAMS_Interaction family_structure_code family structure Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 265 SNP Social Assistance Management System (SAMS) SAMS_Interaction family_size family size Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 266 SNP Social Assistance Management System (SAMS) SAMS_Interaction member_role_code role of the individual Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 267 SNP Social Assistance Management System (SAMS) SAMS_Interaction marital_status_code marital status Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 268 SNP Social Assistance Management System (SAMS) SAMS_Interaction education_level_code education level Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 269 SNP Social Assistance Management System (SAMS) SAMS_Interaction member_disability_reason_code disability type Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 270 SNP Social Assistance Management System (SAMS) SAMS_Interaction icd9_code1 code1 Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 271 SNP Social Assistance Management System (SAMS) SAMS_Interaction icd9_code2 code2 Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 272 SNP Social Assistance Management System (SAMS) SAMS_Interaction family_violence_indicator violence indicator Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 273 SNP Social Assistance Management System (SAMS) SAMS_Interaction member_disability_code member disability code Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 274 SNP Social Assistance Management System (SAMS) SAMS_Interaction disabled_ind disability indicator Coded information for Linking from SAMS Coded 2010-01-01 2024-12-31 275 CW-SA Child Protection Information Network (CPIN) CPIN_Person name_type_en_desc name type description (e.g. registered, alias) ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 276 CW-SA Child Protection Information Network (CPIN) CPIN_Person first_name first name (many names can be recorded for a person) ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 277 CW-SA Child Protection Information Network (CPIN) CPIN_Person other_firstname other first name ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 278 CW-SA Child Protection Information Network (CPIN) CPIN_Person last_name last name ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 279 CW-SA Child Protection Information Network (CPIN) CPIN_Person gender_en_name gender name ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 280 CW-SA Child Protection Information Network (CPIN) CPIN_Person member_reference unique reference number assigned by the system to a concern role record. ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 281 CW-SA Child Protection Information Network (CPIN) CPIN_Person upper_first_name upper-case first name ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 282 CW-SA Child Protection Information Network (CPIN) CPIN_Person upper_last_name upper-case last name ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 283 CW-SA Child Protection Information Network (CPIN) CPIN_Interaction birth_date date of birth of child/youth in care Coded information for Linking from CPIN Coded 2018-04-01 2025-03-31 284 CW-SA Child Protection Information Network (CPIN) CPIN_Interaction discharge_date date a child is discharged from care Coded information for Linking from CPIN Coded 2018-04-01 2025-03-31 285 CW-SA Child Protection Information Network (CPIN) CPIN_Interaction discharge_reason_en_desc the reason for discharge of the child Coded information for Linking from CPIN Coded 2018-04-01 2025-03-31 286 CW-SA Child Protection Information Network (CPIN) CPIN_Interaction business_case_type_en_desc case type code description Coded information for Linking from CPIN Coded 2018-04-01 2025-03-31 287 CW-SA Child Protection Information Network (CPIN) CPIN_Interaction indigenous_flag indicator to denote whether the person is indigenous Coded information for Linking from CPIN Coded 2018-04-01 2025-03-31 288 CW-SA Child Protection Information Network (CPIN) CPIN_Interaction vys_rys_flag indicates if case was a VYS or RYS case type Coded information for Linking from CPIN Coded 2018-04-01 2025-03-31 289 CW-SA Child Protection Information Network (CPIN) CPIN_Interaction ccsy_flag indicates if case was a CCSY case type Coded information for Linking from CPIN Coded 2018-04-01 2025-03-31 290 CW-SA Child Protection Information Network (CPIN) CPIN_Interaction rsg_flag indicates if case was a RSG case type Coded information for Linking from CPIN Coded 2018-04-01 2025-03-31 291 CW-SA Child Protection Information Network (CPIN) CPIN_Person city_name city ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 292 CW-SA Child Protection Information Network (CPIN) CPIN_Person postal_code postal code ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 293 CW-SA Child Protection Information Network (CPIN) CPIN_Interaction segment cohort year Coded information for Linking from CPIN Coded 2018-04-01 2025-03-31 294 CW-SA Child Protection Information Network (CPIN) CPIN_Person member_reference unique reference number assigned by the system to a concern role record ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 295 CW-SA Child Protection Information Network (CPIN) CPIN_Interaction gender gender Coded information for Linking from CPIN Coded 2018-04-01 2025-03-31 296 CW-SA Child Protection Information Network (CPIN) CPIN_Person age_left_cw calculated age that the child or youth was discharged (exited child welfare program) ID information for Record Matching from CPIN ID 2018-04-01 2025-03-31 297 CW-SA Social Assistance Management System (SAMS) SA_Interaction member_id an 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 concernroleid Coded information for Linking from CPIN Coded 2018-04-01 2025-03-31 298 CW-SA Social Assistance Management System (SAMS) SA_Interaction extract_month identifies the year and month being reported Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 299 CW-SA Social Assistance Management System (SAMS) SA_Interaction program program for which the benefit unit is currently being assessed or paid benefits Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 300 CW-SA Social Assistance Management System (SAMS) SA_Interaction member_unit_count 1 indicates the member is active within the product delivery case and case_unit_count = 1 Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 301 CW-SA Social Assistance Management System (SAMS) SA_Interaction member_role indicates the role of the member in the benefit unit. Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 302 CW-SA Social Assistance Management System (SAMS) SA_Interaction member_gender identifies whether the member is male/female or not stated Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 303 CW-SA Social Assistance Management System (SAMS) SA_Interaction member_age age of member as of the extract_month Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 304 CW-SA Social Assistance Management System (SAMS) SA_Interaction icd9_primary primary diagnosis of individual, corresponding to the international classification of diseases version 9 (icd-9) code Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 305 CW-SA Social Assistance Management System (SAMS) SA_Interaction icd9_secondary secondary diagnosis of individual, corresponding to the international classification of diseases version 9 (icd-9) code Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 306 CW-SA Social Assistance Management System (SAMS) SA_Interaction member_disability groups the member's ICD9 disability codes into categories for reporting Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 307 CW-SA Social Assistance Management System (SAMS) SA_Interaction immigration_status status the member holds within Canada as stated by immigration, refugees and citizenship Canada Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 308 CW-SA Social Assistance Management System (SAMS) SA_Interaction sponsored_indicator identifies if member is a sponsored immigrant or not Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 309 CW-SA Social Assistance Management System (SAMS) SA_Interaction refugee_claimant_indicator indicates if member is a refugee claimant or not. Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 310 CW-SA Social Assistance Management System (SAMS) SA_Interaction education_level the highest level of education achieved by the member Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 311 CW-SA Social Assistance Management System (SAMS) SA_Interaction education_student_status documents whether the member is currently in school Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 312 CW-SA Social Assistance Management System (SAMS) SA_Interaction member_earnings employment income (net of deductions) reported by the member Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 313 CW-SA Social Assistance Management System (SAMS) SA_Interaction member_self_employment amount member earned as business income or farm income is recorded here Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 314 CW-SA Social Assistance Management System (SAMS) SA_Interaction family_structure indicates the family structure (under social assistance) -- couple with children(/dependants other than spouse), couple without children, singles with children or singles without children Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 315 CW-SA Social Assistance Management System (SAMS) SA_Interaction family_size number of persons on social assistance in the benefit unit (including applicant, spouse, dependent adults, and children) Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 316 CW-SA Social Assistance Management System (SAMS) SA_Interaction age_youngest_child age of the youngest child in the benefit unit Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 317 CW-SA Social Assistance Management System (SAMS) SA_Interaction accommodation_type identifies the type of housing/lodging the recipient lives in (includes sdmt codes for converted cases) Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 318 CW-SA Social Assistance Management System (SAMS) SA_Interaction institution_type the type of facility the individual resides in Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 319 CW-SA Social Assistance Management System (SAMS) SA_Interaction sda_office service delivery adminstrative (SDA) offices for the case/member Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 320 CW-SA Social Assistance Management System (SAMS) SA_Interaction sda if OW, corresponds to the CMSM/DSSAB. if ODSP, corresponds to the region. Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 321 CW-SA Social Assistance Management System (SAMS) SA_Interaction municipality municipality in which the recipient lives Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 322 CW-SA Social Assistance Management System (SAMS) SA_Interaction gender_identity self-identified gender Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 323 CW-SA Social Assistance Management System (SAMS) SA_Interaction racial_identity self-identified race Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 324 CW-SA Social Assistance Management System (SAMS) SA_Interaction visible_minority self-identified as visible minority Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 325 CW-SA Social Assistance Management System (SAMS) SA_Interaction language_of_choice self-identified language of choice Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 326 CW-SA Social Assistance Management System (SAMS) SA_Interaction indigenous_identity self-identified as indigenous person Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 327 CW-SA Social Assistance Management System (SAMS) SA_Interaction integrated_case_id unique id (internal to SAMS) Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 328 CW-SA Social Assistance Management System (SAMS) SA_Interaction case_id internal 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 created Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 329 CW-SA Social Assistance Management System (SAMS) SA_Interaction member_id an 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 concernroleid Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 330 CW-SA Social Assistance Management System (SAMS) SA_Interaction program_funding which program the funding is coming from (OW, ODSP, ODB) Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 331 CW-SA Social Assistance Management System (SAMS) SA_Interaction case_amount total amount the case received in the month Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 332 CW-SA Social Assistance Management System (SAMS) SA_Person member_amount total amount the member received in the month ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31 333 CW-SA Social Assistance Management System (SAMS) SA_Person member_firstname first name ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31 334 CW-SA Social Assistance Management System (SAMS) SA_Person member_lastname last name ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31 335 CW-SA Social Assistance Management System (SAMS) SA_Person member_city city ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31 336 CW-SA Social Assistance Management System (SAMS) SA_Person member_postalcode postal code ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31 337 CW-SA Social Assistance Management System (SAMS) SA_Person member_birth_date birth date ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31 338 CW-SA Social Assistance Management System (SAMS) SA_Person first_gender gender as of the first SA date ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31 339 CW-SA Social Assistance Management System (SAMS) SA_Interaction first_sa_payment amount of first SA payment Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 340 CW-SA Social Assistance Management System (SAMS) SA_Interaction first_sa_date first month of receiving SA Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 341 CW-SA Social Assistance Management System (SAMS) SA_Person first_sa_program first SA program ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31 342 CW-SA Social Assistance Management System (SAMS) SA_Interaction last_sa_program latest SA program Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 343 CW-SA Social Assistance Management System (SAMS) SA_Interaction total_payment total amount of payments that member received Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 344 CW-SA Social Assistance Management System (SAMS) SA_Interaction num_payments_months number of months that member received SA payments Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 345 CW-SA Social Assistance Management System (SAMS) SA_Interaction avg_month_payment average monthly SA payment Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 346 CW-SA Social Assistance Management System (SAMS) SA_Interaction first_family_structure family structure as of the first SA date Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 347 CW-SA Social Assistance Management System (SAMS) SA_Interaction first_sda_office SDA office as of the first SA date Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 348 CW-SA Social Assistance Management System (SAMS) SA_Interaction first_sda CMSM/DSSAB/region as of the first SA date Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 349 CW-SA Social Assistance Management System (SAMS) SA_Interaction first_municipality municipality as of the first SA date Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 350 CW-SA Social Assistance Management System (SAMS) SA_Interaction first_family_size family size as of the first SA date Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 351 CW-SA Social Assistance Management System (SAMS) SA_Interaction first_member_role member role as of the first SA date Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 352 CW-SA Social Assistance Management System (SAMS) SA_Interaction first_immigration_status immigration status as of the first SA date Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 353 CW-SA Social Assistance Management System (SAMS) SA_Interaction icd9_primary primary ICD9 diagnosis as of the first SA date Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 354 CW-SA Social Assistance Management System (SAMS) SA_Interaction icd9_secondary secondary ICD9 diagnosis as of the first SA date Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 355 CW-SA Social Assistance Management System (SAMS) SA_Interaction member_disability member disability as of the first SA date Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 356 CW-SA Social Assistance Management System (SAMS) SA_Interaction first_education_level education level as of the first SA date Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 357 CW-SA Social Assistance Management System (SAMS) SA_Interaction member_id an integer that uniquely identifies an applicant/recipient Coded information for Linking from SAMS Coded 2018-04-01 2025-03-31 358 CW-SA Social Assistance Management System (SAMS) SA_Person first_fore_name first name ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31 359 CW-SA Social Assistance Management System (SAMS) SA_Person other_fore_name other first name ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31 360 CW-SA Social Assistance Management System (SAMS) SA_Person surname surname ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31 361 CW-SA Social Assistance Management System (SAMS) SA_Person nametype_desc name type (e.g. registered, alias) ID information for Record Matching from SAMS ID 2018-04-01 2025-03-31