Detailed Information Regarding SAT Redesign Technical Changes
| Column Grouping | Column Name | Source is: A=agency only, A/S=agency or school A/S/SL=agency or school or self A/SL=agency or self | 2016=based on scores from 2016 and prior tests, 2017=based on scores from tests in the new redesigned SAT 2019=based on scores from tests in the new redesigned SAT, AND the latest ACT/SAT concordance tables | Contains |
| 1 | STU_SAT_V_SCR_NBR | A/S | 2016 | Max SAT VE |
| 1 | STU_SAT_M_SCR_NBR | A/S | 2016 | Max SAT MA |
| 1 | STU_SAT_W_SCR_NBR | A/S | 2016 | Max SAT W |
| 1 | STU_ACT_TO_SAT_MAX_NBR | A/S | 2016 | Max ACT CO converted to SAT (2016) |
| 1 | STU_SAT_CALC_COMPOSITE_NBR | A/S | 2016 | Max SAT calculated composite (total Math+Verbal, either from a 2016(MA+VE) score, or from a 2017(MSS+ERWS) score translated to a 2016 score |
| 1 | STU_DRVD_SAT_COMPOSITE_NBR | A/S | 2016 | Max of STU_ACT_TO_SAT_MAX_NBR and STU_SAT_CALC_COMPOSITE_NBR |
| 1 | STU_DRVD_SAT_OR_ACT_CNV_IND | A/S | 2016 | if STU_DRVD_SAT_COMPOSITE_NBR = STU_SAT_CALC_COMPOSITE_NBR from a 2016 score this field will contain SAT2016, if calculated from a 2017 SAT score it will contain SAT2017, if = STU_ACT_TO_SAT_MAX_NBR then it contains ACT |
| 2 | STU_AGNCY_SAT_V_SCR_NBR | A | 2016 | Max SAT VE |
| 2 | STU_AGNCY_SAT_M_SCR_NBR | A | 2016 | Max SAT MA |
| 2 | STU_AGNCY_SAT_W_SCR_NBR | A | 2016 | Max SAT W |
| 2 | STU_AGNCY_ACT_TO_SAT_MAX_NBR | A | 2016 | Max ACT CO converted to SAT (2016) |
| 2 | STU_AGNCY_SAT_CALC_CMPST_NBR | A | 2016 | Max SAT calculated composite (total Math+Verbal, either from a 2016 (MA+VE) score, or from a 2017 (MSS+ERWS) score translated to a 2016 score |
| 2 | STU_AGNCY_DRVD_SAT_CMPST_NBR | A | 2016 | Max of STU_AGNCY_ACT_TO_SAT_MAX_NBR and STU_SAT_CALC_COMPOSITE_NBR |
| 2 | STU_AGNCY_DRVD_SAT_ACT_CNV_IND | A | 2016 | if STU_AGNCY_DRVD_SAT_CMPST_NBR = STU_AGNCY_SAT_CALC_CMPST_NBR from a 2016 score then this contains SAT2016, if calculated from a 2017 SAT score it contains SAT2017 , if = STU_AGNCY_ACT_TO_SAT_MAX_NBR it contains ACT |
| 3 | STU_SAT_ERWS_SCR_NBR | A/S | 2017 | Max SAT ERWS score |
| 3 | STU_SAT_MSS_SCR_NBR | A/S | 2017 | Max SAT MSS score |
| 3 | STU_2017_ACT2SAT_MAX_NBR | A/S | 2017 | Max ACT CO converted to SAT (2017) |
| 3 | STU_2017_SAT_CALC_NBR | A/S | 2017 | Max SAT calculated composite (total Math+Verbal), either from a 2017 (MSS+ERWS) score, or from a 2016 (MA+VE) score translated to a 2017 score |
| 3 | STU_2017_DRVD_SAT_CMPST_NBR | A/S | 2017 | Max of STU_2017_ACT2SAT_MAX_NBR and STU_2017_SAT_CALC_NBR |
| 3 | STU_2017_DRVD_SRC_CNV_IND | A/S | 2017 | if STU_2017_DRVD_SAT_CMPST_NBR = STU_2017_SAT_CALC_NBR calculated form a 2016 score this contains SAT2016, if STU_2017_SAT_CALC_NBR is directly from a 2017 score it contains SAT2017 , if = STU_2017_ACT2SAT_MAX_NBR it contains ACT |
| 5 | STU_2019_ACT2SAT_MAX_NBR | A/S | 2019 | Max ACT CO (using 2019 ACT-SAT crosswalk) converted to SAT (2017) |
| 5 | STU_2019_SAT_CALC_NBR | A/S | 2019 | Max SAT calculated composite (total Math+Verbal), either from a 2017 (MSS+ERWS) score, or from a 2016 (MA+VE) score translated to a 2017 score |
| 5 | STU_2019_DRVD_SAT_CMPST_NBR | A/S | 2019 | Max of STU_2019_ACT2SAT_MAX_NBR and STU_2019_SAT_CALC_NBR |
| 5 | STU_2019_DRVD_SRC_CNV_IND | A/S | 2019 | if STU_2017_DRVD_SAT_CMPST_NBR = STU_2017_SAT_CALC_NBR calculated form a 2016 score this contains SAT2016, if STU_2017_SAT_CALC_NBR is directly from a 2017 score it contains SAT2017 , if = STU_2019_ACT2SAT_MAX_NBR it contains ACT |
| 4 | STU_AGNCY_SAT_ERWS_SCR_NBR | A | 2017 | Max SAT ERWS score |
| 4 | STU_AGNCY_SAT_MSS_SCR_NBR | A | 2017 | Max SAT MSS score |
| 4 | STU_AGNCY2017_ACT2SAT_MAX_NBR | A | 2017 | Max ACT CO converted to SAT (2017) |
| 4 | STU_AGNCY2017_SAT_CALC_NBR | A | 2017 | Max SAT calculated composite (total Math+Verbal), either from a 2017(MSS+ERWS) score, or from a 2016(MA+VE) score translated to a 2017 score |
| 4 | STU_AGNCY2017_DRV_SATCMPST_NBR | A | 2017 | Max of STU_AGNCY2017_ACT2SAT_MAX_NBR and STU_AGNCY2017_SAT_CALC_NBR |
| 4 | STU_AGNCY2017_DRVD_SRC_CNV_IND | A | 2017 | if STU_AGNCY2017_DRV_SATCMPST_NBR = STU_AGNCY2017_SAT_CALC_NBR calculated from a 2016 score it contains SAT2016, if STU_AGNCY2017_SAT_CALC_NBR is directly from a 2017 score it contains SAT2017 , if = STU_AGNCY2017_ACT2SAT_MAX_NBR then it contains ACT |
| 6 | STU_AGNCY2019_ACT2SAT_MAX_NBR | A | 2019 | Max ACT CO (using 2019 ACT-SAT crosswalk) converted to SAT (2017) |
| 6 | STU_AGNCY2019_SAT_CALC_NBR | A | 2019 | Max SAT calculated composite (total Math+Verbal), either from a 2017(MSS+ERWS) score, or from a 2016(MA+VE) score translated to a 2017 score |
| 6 | STU_AGNCY2019_DRV_SATCMPST_NBR | A | 2019 | Max of STU_AGNCY2019_ACT2SAT_MAX_NBR and STU_AGNCY2019_SAT_CALC_NBR |
| 6 | STU_AGNCY2019_DRVD_SRC_CNV_IND | A | 2019 | if STU_AGNCY2019_DRV_SATCMPST_NBR = STU_AGNCY2019_SAT_CALC_NBR calculated from a 2016 score it contains SAT2016, if STU_AGNCY2019_SAT_CALC_NBR is directly from a 2017 score it contains SAT2017 , if = STU_AGNCY2019_ACT2SAT_MAX_NBR then it contains ACT |
| 9 | STU_AGSLSC_2019_ACT2SAT_MAXNBR | A/S/SL | 2019 | Max ACT CO (using 2019 ACT-SAT crosswalk) converted to SAT (2017), plus recent concordance |
| 9 | STU_AGSLSC_2019_SAT_CALC_NBR | A/S/SL | 2019 | Max SAT calculated composite (total Math+Verbal), either from a 2017(MSS+ERWS) score, or from a 2016(MA+VE) score translated to a 2017 score |
| 9 | STU_AGSLSC_2019_SATCO_NBR | A/S/SL | 2019 | Max of STU_AGSLSC_2019_ACT2SAT_MAXNBR and STU_AGSLSC_2019_SAT_CALC_NBR |
| 9 | STU_AGSLSC_2019_SRC_CNV_IND | A/S/SL | 2019 | if STU_AGSLSC_2019_SATCO_NBR = STU_AGSLSC_2019_SAT_CALC_NBR calculated from a 2016 score it contains SAT2016, if STU_AGSLSC_2019_SAT_CALC_NBR is directly from a 2017 score it contains SAT2017 , if = STU_AGSLSC_2019_ACT2SAT_MAX_NBR then it contains ACT |
| 10 | STU_AGSL_2019_ACT2SAT_MAX_NBR | A/SL | 2019 | Max ACT CO (using 2019 ACT-SAT crosswalk) converted to SAT (2017), plus recent concordance |
| 10 | STU_AGSL_2019_SAT_CALC_NBR | A/SL | 2019 | Max SAT calculated composite (total Math+Verbal), either from a 2017(MSS+ERWS) score, or from a 2016(MA+VE) score translated to a 2017 score |
| 10 | STU_AGSL_2019_SATCO_NBR | A/SL | 2019 | Max of STU_AGSL_2019_ACT2SAT_MAXNBR and STU_AGSL_2019_SAT_CALC_NBR |
| 10 | STU_AGSL_2019_DRVD_SRC_CNV_IND | A/SL | 2019 | if STU_AGSL_2019_SATCO_NBR = STU_AGSL_2019_SAT_CALC_NBR calculated from a 2016 score it contains SAT2016, if STU_AGSL_2019_SAT_CALC_NBR is directly from a 2017 score it contains SAT2017 , if = STU_AGSL_2019_ACT2SAT_MAX_NBR then it contains ACT |
| 7 | STU_DRVD_RPT_ACT2SAT_NBR | A/S | comes from group 5 | |
| 7 | STU_DRVD_RPT_SAT_CALC_NBR | A/S | comes from group 5 | |
| 7 | STU_DRVD_RPT_SAT_CMPST_NBR | A/S | comes from group 5 | |
| 7 | STU_DRVD_RPT_SRC_CNV_IND | A/S | comes from group 5 | |
| 8 | STU_ DRVD_AGNCYRPT_ACT2SAT_NBR | A | comes from group 6 | |
| 8 | STU_ DRVD_AGNCYRPT_SATCALC_NBR | A | comes from group 6 | |
| 8 | STU_DRVD_AGNCYRPT_SATCMPST_NBR | A | comes from group 6 | |
| 8 | STU_ DRVD_AGNCYRPT_SRC_CNV_IND | A | comes from group 6 | |
| STU_DRVD_SAT_ERWS_SCR_NBR | A/S | 2017 | Max SAT ERWS or old SAT V converted to 2017 scale | |
| STU_DRVD_SAT_ERWS_SOURCE | A/S | 2017 | Source of the derived ERWS (SAT 2016 or SAT 2017) | |
| STU_DRVD_SAT_MSS_SCR_NBR | A/S | 2017 | Max SAT MSS or old SAT M converted to 2017 scale | |
| STU_DRVD_SAT_MSS_SOURCE | A/S | 2017 | Source of the derived MSS (SAT 2016 or SAT 2017) | |
| Columns in groups 1,3,5,7 contain scores received from the agency or from the students high school | ||||
| Columns in groups 2,4,6,8 contain scores received from the agency only | ||||
| Columns in group 9 are from agency or school or self-reported | ||||
| Columns in group 10 are from agency or self-reported | ||||
| Columns in groups 1&2 contain scores based on 2016 SAT values (, so either the score was from a 2016 or earlier test, or from a 2017 test that was converted back to 2016 scores | ||||
| Columns in groups 3,4 contain scores based on 2017 SAT values (, so either the score was from a 2017 or later test, or from a 2016 test that was converted to 2017 scores) | ||||
| Columns in groups 5,6,9,10 contain scores based on 2017 SAT values and latest ACT/SAT concordance | ||||
| Columns in group 7 contain the agency or school scores that are appropriate to the students cohort. If they were ever enrolled prior to Summer 2017 at any institution, the scores will be the 2016 based scores | ||||
| If the student was enrolled or had an application at any institution for 2017 summer or later, the scores wil be the 2017 based scores | ||||
| Columns in group 8 contain the agency only scores that are appropriate to the students cohort. If they were ever enrolled prior to Summer 2017 at any institution, the scores will be the 2016 based scores | ||||
| If the student was enrolled or had an application at any institution for 2017 summer or later, the scores wil be the 2017 based scores | ||||
| All translations from 2016 to 2017 or 2017 to 2016 are based on the Math+Verbal total from the same test. That is we take the max MA and the max VE from the old SAT and calculate a composite. | ||||
| We take the max MSS and max ERWS from the new SAT and calculate a composite. | ||||
| Then we translate the MA+VE total to a 2017 based number. And we translate the MSS+ERWS to a 2016 based number. | ||||
| So, we have a possible 2016 SAT composite, a 2017 composite that is translated to a 2016 composite. And a 2017 composite, and a 2016 composite translated to a 2017 composite. | ||||
| Note that the 2019 fields in groups 5 and 6 only differ from the 2017 fields in how the ACT composite score is converted to an SATI composite scale. Basically, the 2019 fields use a different ACT-SATI composite crosswalk, versus the 2017 fields. | ||||