This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
student:sat_test_scores_import_before_oct2015 [2017/09/04 17:39] – created jstanford | student: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 | + | |Test Date|140|147|8|admin_dt|8|Change from record MMDDYYYY |
- | |||||||| | + | |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 |
- | + | |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 | + | |
- | 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 | + |