Maximum student assessment percentile for grade 05 ELA/reading. The loader casts k12_assessment.assessment_score to float, calculates PERCENT_RANK within school_year_ending, assessment_name, normalized subject, and target grade, excludes NESA_AA/NSCAS ALT and null scores, then takes the student’s maximum.
Close
October 19, 2026
Pr 04 Writing Assessment
Maximum student assessment percentile for grade 04 writing. The loader casts k12_assessment.assessment_score to float, calculates PERCENT_RANK within school_year_ending, assessment_name, normalized subject, and target grade, excludes NESA_AA/NSCAS ALT and null scores, then takes the student’s maximum.
October 19, 2026
Pr 04 Math Assessment
Maximum student assessment percentile for grade 04 math. The loader casts k12_assessment.assessment_score to float, calculates PERCENT_RANK within school_year_ending, assessment_name, normalized subject, and target grade, excludes NESA_AA/NSCAS ALT and null scores, then takes the student’s maximum.
October 19, 2026
Pr 04 Ela Or Reading Assessment
Maximum student assessment percentile for grade 04 ELA/reading. The loader casts k12_assessment.assessment_score to float, calculates PERCENT_RANK within school_year_ending, assessment_name, normalized subject, and target grade, excludes NESA_AA/NSCAS ALT and null scores, then takes the student’s maximum.
October 19, 2026
Pr 03 Math Assessment
Maximum student assessment percentile for grade 03 math. The loader casts k12_assessment.assessment_score to float, calculates PERCENT_RANK within school_year_ending, assessment_name, normalized subject, and target grade, excludes NESA_AA/NSCAS ALT and null scores, then takes the student’s maximum.
October 19, 2026
Pr 03 Ela Or Reading Assessment
Maximum student assessment percentile for grade 03 ELA/reading. The loader casts k12_assessment.assessment_score to float, calculates PERCENT_RANK within school_year_ending, assessment_name, normalized subject, and target grade, excludes NESA_AA/NSCAS ALT and null scores, then takes the student’s maximum.
October 19, 2026
Nswers Id
Unique cross-system NSWERS student identifier. Carried from source records or membership assignments and used as the student-level join key.
October 19, 2026
Over 64
Age-band flag for each enrolled postsecondary term; 1 when Match Warehouse age at reference_date satisfies: age is greater than 64 years, otherwise 0.
October 19, 2026
Between 40 64
Age-band flag for each enrolled postsecondary term; 1 when Match Warehouse age at reference_date satisfies: age is at least 40 and no more than 64 years, otherwise 0.
October 19, 2026
Between 25 39
Age-band flag for each enrolled postsecondary term; 1 when Match Warehouse age at reference_date satisfies: age is at least 25 and less than 40 years, otherwise 0.
October 19, 2026
Between 20 24
Age-band flag for each enrolled postsecondary term; 1 when Match Warehouse age at reference_date satisfies: age is at least 20 and less than 25 years, otherwise 0.
October 19, 2026
Between 18 19
Age-band flag for each enrolled postsecondary term; 1 when Match Warehouse age at reference_date satisfies: age is at least 18 and less than 20 years, otherwise 0.
October 19, 2026
Under 18
Age-band flag for each enrolled postsecondary term; 1 when Match Warehouse age at reference_date satisfies: age is less than 18 years, otherwise 0.
October 19, 2026
Under 17.7
Age-band flag for each enrolled postsecondary term; 1 when Match Warehouse age at reference_date satisfies: age is less than 17.7 years, otherwise 0.
October 19, 2026
Reference Type
Identifies the reference date as a term start; the loader writes term_start.
October 19, 2026
Reference Date
Postsecondary term start_date passed to the Match Warehouse age service.
October 19, 2026
Ope Id
Office of Postsecondary Education identifier joined from the institution-campus lookup.
October 19, 2026
Source
Postsecondary term code for the enrollment whose term start date is used as the age reference.
October 19, 2026
Nswers Id
Unique cross-system NSWERS student identifier. Carried from source records or membership assignments and used as the student-level join key.
October 19, 2026
Value
Outcome rate for the outcome/cohort/year/geography: qualifying outcome-member count divided by cohort-member count.
October 19, 2026
Id
Geographic entity identifier from the wh_student_geo column named by type; numeric identifiers are cast to text.
October 19, 2026
Type
Geographic dimension used for aggregation. Values are drawn from the loader’s fixed list of wh_student_geo columns.
October 19, 2026
Year
Academic year of the cohort membership records used in the denominator and numerator.