This table uses the College Board SAT Concordance Tables to translate SAT values from old to new.
- SAT Writing and Critical Reading scores from testing prior to 2016 are required to calculate the converted EWRS scores. When one of the scores is missing, the EWRS score is set to 0 to avoid misreporting.
- A score of 0 is most likely a missing score.
- Students who are enrolled after Fall 2010 are included.
- When the test date is after the census date of the term, the scores are not included.
- Test score that is not ended with '0' is not converted to ERWS or MSS scores.
- The logic on this view was modified on 7/31/18. The code can be found in
REPORT-379 - Change date range logic for UM_SAT_CONCORD Resolved .
| Key | Record.Fieldname | Format | XLAT | Heading Text | Notes |
|---|---|---|---|---|---|
| → | ACAD_CAREER - Academic Career | Char4 | N | Career | |
| → | EMPLID - Empl ID | Char11 | ID | ||
| → | INSTITUTION - Academic Institution | Char5 | Institution | ||
| → | STRM - Term | Char4 | Term | ||
| UM_MAX_SAT_ERWS - Max SAT ERWS | Num5.2 | Max SAT ERWS | Converted score or new ERWS score | ||
| UM_MAX_SAT_MATH - Maximum Sat Math | Num5.2 | Max Sat Math | Old Math score | ||
| UM_MAX_SAT_MSS - Max SAT MSS | Num5.2 | Max SAT MSS | Converted score or new MSS score | ||
| UM_MAX_SAT_VERB - Maximum Sat Verbal | Num5.2 | Max Sat Verbal | Old Verbal score | ||
| UM_MAX_SAT_WRIT - Maximum SAT Write | Num5.2 | Max SAT Write | Old Write score |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.