This is an old revision of the document!
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 recordMMDDYYYY 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