User Tools

Site Tools


student:act_test_scores_import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
student:act_test_scores_import [2017/09/04 01:44] jstanfordstudent:act_test_scores_import [2018/07/24 13:21] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ======ACT Test Scores Import====== ======ACT Test Scores Import======
  
-^Source^^^^Target^^^ +^Source^^^^Target^^Comments
-^Field^Start^End^Length^Table^Column^Comments^+^Field^Start Position^End Position^Length^Table^Column^ ^
 |**Year ID**|1|2|2|sr_st_enroll|sch_yr|Computed (e.g., 18=2018)| |**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| |      |**Last Name**|3|27|25|sr_st_enroll|name_l| |     
Line 13: Line 13:
 |**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| |**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:||||||| |The following fields are imported into the ACT test scores table:|||||||
-^Field^Start^End^Length^Column^Length^Comments^+^Field^Start Position^End Position^Length^Column^Length^Comments^
 |**Student ID**| | | |stu_id|6|Computed| |**Student ID**| | | |stu_id|6|Computed|
 |**Test Date**|227|232|6|admin_dt|6|YYYYMM (e.g., 201709)| |**Test Date**|227|232|6|admin_dt|6|YYYYMM (e.g., 201709)|
Line 43: Line 43:
 |**Natl Norm Writing** (**Year ID**=16 and later)|793|795|3|nat_norm_wrt|3|01-100| |**Natl Norm Writing** (**Year ID**=16 and later)|793|795|3|nat_norm_wrt|3|01-100|
 |**Writing Domain - Ideas and Analysis** (**Year ID**=15 and later)|796|797|2|wrt_domain_idea|2|02-12| |**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 - 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 - 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| |**Writing Domain - Language Use and Conventions** (**Year ID**=15 and later)|802|803|2|wrt_domain_lang|2|02-12|
student/act_test_scores_import.1504489475.txt.gz · Last modified: 2017/09/03 20:44 (external edit)