This is an old revision of the document!
Source | Target | |||||
---|---|---|---|---|---|---|
Field | Start | End | Length | Table | Column | Comments |
Year ID | 1 | 2 | 2 | sr_st_enroll | sch_yr | Computed (e.g., 18=2018) |
Last Name | 3 | 27 | 25 | sr_st_enroll | name_l | |
First Name | 28 | 43 | 16 | sr_st_enroll | name_f | |
Middle Initial | 44 | 44 | 1 | sr_st_enroll | name_m | Compare 1st char |
SSN (Year ID < 15) | 91 | 99 | 9 | sr_st_enroll | state_stu_id | Target not necessarily SSN |
blank or ACT ID (Year ID=15 and later) | 91 | 99 | 9 | Can be blank, or type a dash (-) in position 91 for ACT ID. | ||
Date of Birth (expanded) | 155 | 162 | 8 | sr_st_demo | dob | YYYYMMDD |
Date of Birth | 101 | 106 | 6 | sr_st_demo | dob | MMDDYY |
Gender | 87 | 88 | 2 | sr_st_demo | sex | Year ID=15 and later:position 87: (4 for male, 6 for female); position 88: male or female |
The following fields are imported into the ACT test scores table: | ||||||
Field | Start | End | Length | Column | Length | Comments |
Student ID | stu_id | 6 | Computed | |||
Test Date | 227 | 232 | 6 | admin_dt | 6 | YYYYMM (e.g., 201709) |
Composite Scale Score | 269 | 270 | 2 | comp_scr | 2 | 01-36 |
Natl Norm Comp (Year ID < 16) | 781 | 782 | 2 | natl_perc_bnd_blw | 2 | 0-99 |
Natl Norm Comp (Year ID=16 and later) | 1041 | 1043 | 3 | natl_perc_bnd_blw | 3 | 001-100 |
Sum of Scale Scores | 272 | 274 | 3 | total | 4 | |
Test Location 249 249 1 test 1 Blank, F, S, Z, D Grade Level 89 90 2 grd_lvl 2 07-12 2 of 3 TxEIS Student - ACT Test Scores Import Source Target English Scale Score 261 262 2 eng_scr 2 01-36 Math Scale Score 263 264 2 math_scr 2 01-36 Reading Scale Score 265 266 2 read_scr 2 01-36 Science Scale Score 267 268 2 sci_scr 2 01-36 Combined English/ Writing Score (Year ID < 2015) 163 164 2 comb_scr 2 01-36 Combined English/ Writing Score (Year ID=15 and later) 163 164 2 blank Writing Subscore (Year ID < 15) 165 166 2 wrt_scr 2 02-12 Writing Subscore (Year ID=15)* 791 792 2 wrt_scr 2 01-36 Writing Subscore (Year ID=2016 and later) 804 805 2 wrt_scr 2 02-12 Natl Norm Eng (Year ID=15) 773 774 2 nat_norm_engl 2 01-99 Natl Norm Eng (Year ID=16 and later) 1029 1031 3 nat_norm_engl 3 001-100 Natl Norm Read (Year ID < 16) 777 778 2 nat_norm_read 2 01-99 Natl Norm Read (Year ID=16 and later) 1035 1037 3 nat_norm_read 3 001-100 Natl Norm Sci (Year ID < 16) 779 780 2 nat_norm_sci 2 01-99 Natl Norm Sci (Year ID=16 and later) 1038 1040 3 nat_norm_sci 3 001-100 Natl Norm Eng/ Wrt (Year ID < 15) 167 168 2 nat_norm_ comb 2 01-99 Natl Norm Eng/ Wrt (Year ID=15 and later) 167 168 2 blank Natl Norm Writing (Year ID < 15) 169 170 2 nat_norm_wrt 2 01-99 3 of 3 TxEIS Student - ACT Test Scores Import Source Target Natl Norm Writing (Year ID=15) 804 805 2 nat_norm_wrt 2 01-99 Natl Norm Writing (Year ID=16 and later) 793 795 3 nat_norm_wrt 3 001-100 Writing Domain - Ideas and Analysis (Year ID=15 and later) 796 797 2 wrt_domain_ idea 2 02-12 Writing Domain - Development and Support (Year ID=15 and later) 798 799 2 wrt_domain_ dev 2 02-12 Writing Domain - Organization (Year ID=15 and later) 800 801 2 wrt_domain_ org 2 02-12 Writing Domain - Language Use and Conventions (Year ID=15 and later) 802 803 2 wrt_domain_ lang 2 02-12 * The Writing Subscore (Year ID=15) is the scaled sum of the four Writing Domain scores (08-48) and reported on a 1-36 scale obtained through a scaling and equating process. NOTE: For Year ID=16, the file length must be 1050. For Year ID=15, the file length can be 821 or 1050. For Year ID < 15, the file length must be 783.