Add this page to your book 
Remove this page from your book 
Manage book (
Help This is an old revision of the document!
ACT Test Scores Import
| 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., 201609) 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.