Unique cross-system NSWERS student identifier. Carried from source records or membership assignments and used as the student-level join key.
Highest CTE level in Agriculture, Food and Natural Resources for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Architecture and Construction for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Arts, Audio/Video Technology and Communications for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Business Management and Administration for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Education and Training for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Energy and Engineering for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Finance for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Foundational for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Government and Public Administration for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Health Science for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Hospitality and Tourism for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Human Services for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Information Technology for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Law, Public Safety, Corrections and Security for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Manufacturing for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Marketing for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
Highest CTE level in Transportation, Distribution and Logistics for expected-high-school-graduation-year cohort members. k12_programs career_education_programs_code maps to the category; CE0001 maps to participant (1), CE0003 to concentrator (2), and other/missing values to 0.
1 when any CTE category is participant level 1 or when any_cte_concentration is 1; otherwise 0.
1 when any CTE category has concentrator level 2; otherwise 0.
Count of k12_programs rows for the student. Despite the column name, the loader uses COUNT(*) over program records, not a distinct course count.
