User Tools

Site Tools


student:sat_test_scores_import_before_oct2015

Differences

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

Link to this comparison view

Next revision
Previous revision
student:sat_test_scores_import_before_oct2015 [2017/09/04 17:39] – created jstanfordstudent:sat_test_scores_import_before_oct2015 [2018/07/24 13:21] (current) – external edit 127.0.0.1
Line 13: Line 13:
 |The following fields are imported into the sr_sat_tst_scrs table:||||||| |The following fields are imported into the sr_sat_tst_scrs table:|||||||
 ^Field^Start Position^End Position^Length^Column^Length^ ^ ^Field^Start Position^End Position^Length^Column^Length^ ^
-|Test Date|140|147|8|admin_dt|8|Change from recordMMDDYYYY  to DBYYYYMMDD format| +|Test Date|140|147|8|admin_dt|8|Change from record MMDDYYYY 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 Reading + 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 Score 151 153 3 verbal_scr 3 200-800 +|Reading State Percentile|617|618|2|verbal_st_pctl|2|01-99| 
-Math Score 154 156 3 math_scr 3 200-800 +|Math National Percentile|619|620|2|math_natl_pctl|2|01-99| 
-Writing Score 157 159 3 write_scr 3 200-800 +|Math State Percentile|621|622|2|math_state_pctl|2|01-99| 
-Essay Subscore 160 161 2 essay_scr 2 00-12 +|Writing National Percentile|623|624|2|wrt_natl_pctl|2|01-99| 
-Writing Multiple +|Writing State Percentile|625|626|2|wrt_state_pctl|2|01-99|  
-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+
student/sat_test_scores_import_before_oct2015.1504546740.txt.gz · Last modified: 2017/09/04 12:39 (external edit)