This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
student:act_test_scores_import [2017/09/04 01:43] – jstanford | student: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 |
|**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 8: | Line 8: | ||
|**Middle Initia**l|44|44|1|sr_st_enroll|name_m|Compare 1st char| | |**Middle Initia**l|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| | |**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.| | + | |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** (expanded)|155|162|8|sr_st_demo|dob|YYYYMMDD| | ||
|**Date of Birth**|101|106|6|sr_st_demo|dob|MMDDYY| | |**Date of Birth**|101|106|6|sr_st_demo|dob|MMDDYY| | ||
|**Gender**|87|88|2|sr_st_demo|sex|Year ID=15 and later: | |**Gender**|87|88|2|sr_st_demo|sex|Year ID=15 and later: | ||
|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 |
|**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 | + | |**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| |