Add this page to your book 
Remove this page from your book 
Manage book (
Help This is an old revision of the document!
SAT Test Scores Import (prior to October 2015)
Any import file prior to October 2015 will have a length of 1168 or 1174.
| Source | Target | Comments | ||||
|---|---|---|---|---|---|---|
| Field | Start Position | End Position | Length | Table | Column | |
| Last Name | 7 | 21 | 15 | sr_stu_enroll | name_l | |
| First Name | 22 | 33 | 12 | sr_stu_enroll | name_f | |
| Middle Initial | 34 | 34 | 1 | sr_stu_enroll | name_m | Compare first char |
| Sex | 35 | 35 | 1 | |||
| Date of Birth | 36 | 41 | 6 | MMDDYY | ||
| Test Date | 140 | 147 | 8 | sr_stu_enroll | sch_yr | Convert to 4 char |
| The following fields are imported into the sr_sat_tst_scrs table: | ||||||
| Field | Start Position | End Position | Length | Column | Length | |
| Test Date | 140 | 147 | 8 | admin_dt | 8 | Change from record MMDDYYYY to DBYYYYMMDD format |
Reading Score 151 153 3 verbal_scr 3 200-800 Math Score 154 156 3 math_scr 3 200-800 Writing Score 157 159 3 write_scr 3 200-800 Essay Subscore 160 161 2 essay_scr 2 00-12 Writing Multiple Choice Subscore 162 163 2 mc_scr 2 20-80 total 4 Compute Reaing + Math + Writing Education Level 148 148 1 ed_lvl 1 0-7, 9 Reading National Percentile 615 616 2 verbal_natl_pctl 2 01-99 Reading State Percentile 617 618 2 verbal_st_pctl 2 01-99 Math National Percentile 619 620 2 math_natl_pctl 2 01-99 Math State Percentile 621 622 2 math_state_pctl 2 01-99 Writing National Percentile 623 624 2 wrt_natl_pctl 2 01-99 Writing State Percentile 625 626 2 wrt_state_pctl 2 01-99