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 Reading + 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 |