{
  "fields": [{"id":"_id","type":"int"},{"id":"Project Name","type":"text","info":{"notes":"Project name assigned by the Data Integration Unit to each data integration project.\r\n","type_override":"text","frictionless_dict":[{"type":"string","name":"Project Name"}]}},{"id":"Source(s) of information in the dataset","type":"text","info":{"notes":"The origin of the data included in the dataset. \r\n","type_override":"text","frictionless_dict":[{"type":"string","name":"Source(s) of information in the dataset"}]}},{"id":"Dataset Name","type":"text","info":{"notes":"The title or name given to the dataset.\r\n","type_override":"text","frictionless_dict":[{"type":"string","name":"Dataset Name"}]}},{"id":"Variable Name","type":"text","info":{"notes":"The name assigned to each variable or field in the dataset. \r\n","type_override":"text","frictionless_dict":[{"type":"string","name":"Variable Name"}]}},{"id":"Definition","type":"text","info":{"notes":"An explanation of what each variable represents.\r\n","type_override":"text","frictionless_dict":[{"type":"string","name":"Definition"}]}},{"id":"Description of Dataset","type":"text","info":{"notes":"The description of the dataset's purpose (for example, linking or matching).\r\n","type_override":"text","frictionless_dict":[{"type":"string","name":"Description of Dataset"}]}},{"id":"PI Database","type":"text","info":{"notes":"The database location of the coded information.\r\n","type_override":"text","frictionless_dict":[{"type":"string","name":"PI Database"}]}},{"id":"Start Date","type":"date","info":{"notes":"The start date captured by the dataset, as posted in the ministry notices of collection of personal information. \r\n","type_override":"date","frictionless_dict":[{"type":"date","name":"Start Date"}]}},{"id":"End Date","type":"date","info":{"notes":"The end date captured by the dataset, as posted in the ministry notices of collection of personal information. \r\n","type_override":"date","frictionless_dict":[{"type":"date","name":"End Date"}]}},{"id":"Additional Comments","type":"text","info":{"notes":"Any extra information that might be useful for understanding the variable. ","type_override":"text","frictionless_dict":[{"type":"string","name":"Additional Comments"}]}}],
  "records": [
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [144,"SNP","AccessOAP","AccessOAP_Person","program","program name","ID information for Record Matching from AccessOAP","ID","2010-01-01","2024-12-31",null],
    [145,"SNP","AccessOAP","AccessOAP_Person","source","stream name","ID information for Record Matching from AccessOAP","ID","2010-01-01","2024-12-31",null],
    [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",null],
    [147,"SNP","AccessOAP","AccessOAP_Person","first_name","first name","ID information for Record Matching from AccessOAP","ID","2010-01-01","2024-12-31",null],
    [148,"SNP","AccessOAP","AccessOAP_Person","middle_name","middle name","ID information for Record Matching from AccessOAP","ID","2010-01-01","2024-12-31",null],
    [149,"SNP","AccessOAP","AccessOAP_Person","last_name","last name","ID information for Record Matching from AccessOAP","ID","2010-01-01","2024-12-31",null],
    [150,"SNP","AccessOAP","AccessOAP_Person","dob","date of birth","ID information for Record Matching from AccessOAP","ID","2010-01-01","2024-12-31",null],
    [151,"SNP","AccessOAP","AccessOAP_Person","gender","gender of clients","ID information for Record Matching from AccessOAP","ID","2010-01-01","2024-12-31",null],
    [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",null],
    [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",null],
    [154,"SNP","AccessOAP","AccessOAP_Person","address_unit","unit number","ID information for Record Matching from AccessOAP","ID","2010-01-01","2024-12-31",null],
    [155,"SNP","AccessOAP","AccessOAP_Person","postal_code","postal_code","ID information for Record Matching from AccessOAP","ID","2010-01-01","2024-12-31",null],
    [156,"SNP","AccessOAP","AccessOAP_Person","city","city","ID information for Record Matching from AccessOAP","ID","2010-01-01","2024-12-31",null],
    [157,"SNP","AccessOAP","AccessOAP_Interaction","program","program name","Coded information for Linking from AccessOAP","Coded","2010-01-01","2024-12-31",null],
    [158,"SNP","AccessOAP","AccessOAP_Interaction","source","stream name","Coded information for Linking from AccessOAP","Coded","2010-01-01","2024-12-31",null],
    [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",null],
    [160,"SNP","AccessOAP","AccessOAP_Interaction","interaction_id","identifier of the interaction","Coded information for Linking from AccessOAP","Coded","2010-01-01","2024-12-31",null],
    [161,"SNP","AccessOAP","AccessOAP_Interaction","interaction_type","type of interaction","Coded information for Linking from AccessOAP","Coded","2010-01-01","2024-12-31",null],
    [162,"SNP","AccessOAP","AccessOAP_Interaction","service","service type","Coded information for Linking from AccessOAP","Coded","2010-01-01","2024-12-31",null],
    [163,"SNP","AccessOAP","AccessOAP_Interaction","status","status of the interaction","Coded information for Linking from AccessOAP","Coded","2010-01-01","2024-12-31",null],
    [164,"SNP","AccessOAP","AccessOAP_Interaction","stage","stage of the interaction","Coded information for Linking from AccessOAP","Coded","2010-01-01","2024-12-31",null],
    [165,"SNP","AccessOAP","AccessOAP_Interaction","date","date","Coded information for Linking from AccessOAP","Coded","2010-01-01","2024-12-31",null],
    [166,"SNP","AccessOAP","AccessOAP_Interaction","value","amount ($)","Coded information for Linking from AccessOAP","Coded","2010-01-01","2024-12-31",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [187,"SNP","Special Services at Home (SSAH)","SSAH_Interaction","date","date","Coded information for Linking from SSAH","Coded","2010-01-01","2024-12-31",null],
    [188,"SNP","Special Services at Home (SSAH)","SSAH_Interaction","value","amount ($)","Coded information for Linking from SSAH","Coded","2010-01-01","2024-12-31",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [212,"SNP","PassportONE","Passport_Person","program","program name","ID information for Record Matching from PassportONE","ID","2010-01-01","2024-12-31",null],
    [213,"SNP","PassportONE","Passport_Person","source","stream name","ID information for Record Matching from PassportONE","ID","2010-01-01","2024-12-31",null],
    [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",null],
    [215,"SNP","PassportONE","Passport_Person","first_name","first name","ID information for Record Matching from PassportONE","ID","2010-01-01","2024-12-31",null],
    [216,"SNP","PassportONE","Passport_Person","middle_name","middle name","ID information for Record Matching from PassportONE","ID","2010-01-01","2024-12-31",null],
    [217,"SNP","PassportONE","Passport_Person","last_name","last name","ID information for Record Matching from PassportONE","ID","2010-01-01","2024-12-31",null],
    [218,"SNP","PassportONE","Passport_Person","dob","date of birth","ID information for Record Matching from PassportONE","ID","2010-01-01","2024-12-31",null],
    [219,"SNP","PassportONE","Passport_Person","gender","gender of clients","ID information for Record Matching from PassportONE","ID","2010-01-01","2024-12-31",null],
    [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",null],
    [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",null],
    [222,"SNP","PassportONE","Passport_Person","address_unit","unit number","ID information for Record Matching from PassportONE","ID","2010-01-01","2024-12-31",null],
    [223,"SNP","PassportONE","Passport_Person","postal_code","postal_code","ID information for Record Matching from PassportONE","ID","2010-01-01","2024-12-31",null],
    [224,"SNP","PassportONE","Passport_Person","city","city","ID information for Record Matching from PassportONE","ID","2010-01-01","2024-12-31",null],
    [225,"SNP","PassportONE","Passport_Interaction","program","program name","Coded information for Linking from PassportONE","Coded","2010-01-01","2024-12-31",null],
    [226,"SNP","PassportONE","Passport_Interaction","source","stream name","Coded information for Linking from PassportONE","Coded","2010-01-01","2024-12-31",null],
    [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",null],
    [228,"SNP","PassportONE","Passport_Interaction","interaction_id","identifier of the interaction","Coded information for Linking from PassportONE","Coded","2010-01-01","2024-12-31",null],
    [229,"SNP","PassportONE","Passport_Interaction","interaction_type","type of interaction","Coded information for Linking from PassportONE","Coded","2010-01-01","2024-12-31",null],
    [230,"SNP","PassportONE","Passport_Interaction","service","service type","Coded information for Linking from PassportONE","Coded","2010-01-01","2024-12-31",null],
    [231,"SNP","PassportONE","Passport_Interaction","status","status of the interaction","Coded information for Linking from PassportONE","Coded","2010-01-01","2024-12-31",null],
    [232,"SNP","PassportONE","Passport_Interaction","stage","stage of the interaction","Coded information for Linking from PassportONE","Coded","2010-01-01","2024-12-31",null],
    [233,"SNP","PassportONE","Passport_Interaction","date","date","Coded information for Linking from PassportONE","Coded","2010-01-01","2024-12-31",null],
    [234,"SNP","PassportONE","Passport_Interaction","value","amount ($)","Coded information for Linking from PassportONE","Coded","2010-01-01","2024-12-31",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [259,"SNP","Social Assistance Management System (SAMS)","SAMS_Interaction","value","amount ($)","Coded information for Linking from SAMS","Coded","2010-01-01","2024-12-31",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null],
    [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",null]
]}