Maximum ACT composite score from the highest-confidence k12_act match (confidence at least 0.95) or grade-11 ACT records in k12_assessment.
October 19, 2026
Maximum ACT composite score from the highest-confidence k12_act match (confidence at least 0.95) or grade-11 ACT records in k12_assessment.
October 19, 2026
Maximum student assessment percentile for grade 11 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
Maximum student assessment percentile for grade 11 science. 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
Maximum student assessment percentile for grade 11 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
Maximum student assessment percentile for grade 11 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
Maximum student assessment percentile for grade 11 Composite. 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
Maximum student assessment percentile for grade 08 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
Maximum student assessment percentile for grade 08 science. 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
Maximum student assessment percentile for grade 08 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
Maximum student assessment percentile for grade 08 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
Maximum student assessment percentile for grade 07 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
Maximum student assessment percentile for grade 07 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
Maximum student assessment percentile for grade 06 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
Maximum student assessment percentile for grade 06 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
Maximum student assessment percentile for grade 05 science. 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
Maximum student assessment percentile for grade 05 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
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.
October 19, 2026
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
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
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
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
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
Unique cross-system NSWERS student identifier. Carried from source records or membership assignments and used as the student-level join key.
October 19, 2026
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
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.
