student:psat_test_scores_import_10
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| student:psat_test_scores_import_10 [2017/09/04 14:43] – created jstanford | student:psat_test_scores_import_10 [2018/07/24 13:21] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 5: | Line 5: | ||
| ^Source^^^^Target^^Comments^ | ^Source^^^^Target^^Comments^ | ||
| ^Field^Start Position^End Position^Length^Table^Column^ ^ | ^Field^Start Position^End Position^Length^Table^Column^ ^ | ||
| - | |Assessment year|663|666|4| |sch_yr|YYYY| | + | |Assessment year|665|668|4| |sch_yr|YYYY| |
| - | + | |Last Name|113|147|35| |name_l| | | |
| - | |The following fields are imported into the PSAT test scores table for PSAT 8/9:||||||| | + | |First Name|148|182|35| |name_f| | |
| + | |Middle Initial|183|183|1| |name_m|Compare first char| | ||
| + | |Date of Birth|203|212|10|sr_stu_demo|dob|YYYY-MM-DD| | ||
| + | |Sex|184|184|1| |sex| | | ||
| + | |The following fields are imported into the PSAT test scores table for PSAT 10:||||||| | ||
| ^Field^Start Position^End Position^Length^Column^Length^ ^ | ^Field^Start Position^End Position^Length^Column^Length^ ^ | ||
| - | |Year|663|666|4|admin_dt|4| | | + | |Year|665|668|4|admin_dt|4| | |
| - | | + | |Education Level Cd|675|676|1|ed_lvl|1|1-2, |
| + | |Total for Evidence-Based Reading & Writing and Math Section Score|677|680|4|tot_sec_scr|4|320-1520| | ||
| + | |Evidence-Based Reading & Writing Score|681|683|3|read_writ_sec_scr|3|160-760| | ||
| + | |Math Section Score|684|686|3|math_sec_scr|3|160-760| | ||
| + | |Reading Score|687|688|2|verbal_scr|2|8-38| | ||
| + | |Writing Score|689|690|2|write_scr|2|8-38| | ||
| + | |Math Score|691|694|4|math_scr|4|8.0-38.0 in .5 increments| | ||
| + | |Analysis in Science Crosstest Score|695|696|2|sci_cross_scr|2|8-38| | ||
| + | |Analysis in History/SS Cross-test Score|697|698|2|hist_cross_scr|2|8-38| | ||
| + | |Relevant Words in Context Subscore|699|700|2|words_subscr|2|1-15| | ||
| + | |Command of Evidence Subscore|701|702|2|comm_ev_subscr|2|1-15| | ||
| + | |Expression of Idea Subscore|703|704|2|expr_idea_subscr|2|1-15| | ||
| + | |Standard English Conventions Subscore|705|706|2|eng_conv_subscr|2|1-15| | ||
| + | |Heart of Algebra Subscore|707|708|2|heart_alg_subscr|2|1-15| | ||
| + | |Passport to Advanced Mathematics Subscore|709|710|2|adv_math_subscr|2|1-15| | ||
| + | |Problem Solving and Data Analysis Subscore|711|712|2|prob_solv_subscr|2|1-15| | ||
| + | |Selection Index|732|734|3|total|3|24-114| | ||
| + | |Selection Index National Percentile|735|736|2|total_perc|2|0-99| | ||
| + | |Total for Evidence-Based Reading & Writing and Math Section Score Representative Percentile|753|754|2|tot_sec_rep_perc|2|0-99| | ||
| + | |Evidence-Based Reading & Writing Representative Percentile|755|756|2|read_writ_rep_perc|2|0-99| | ||
| + | |Math Section Representative Percentile|757|758|2|math_sec_rep_perc|2|0-99| | ||
| + | |Reading Representative Percentile|759|760|2|verbal_st_perc|2|0-99| | ||
| + | |Writing Representative Percentile|761|762|2|write_st_perc|2|0-99| | ||
| + | |Math Representative Percentile|763|764|2|math_st_perc|2|0-99| | ||
| + | |Analysis in Science Crosstest Representative Percentile|765|766|2|sci_cross_rep_perc|2|0-99| | ||
| + | |Analysis in History/SS Cross-test Representative Percentile|767|768|2|hist_cross_rep_perc|2|0-99| | ||
| + | |Relevant Words in Context Subscore Representative Percentile|769|770|2|words_rep_perc|2|0-99| | ||
| + | |Command of Evidence Subscore Representative Percentile|771|772|2|comm_ev_rep_perc|2|0-99| | ||
| + | |Expression of Idea Subscore Representative Percentile|773|774|2|expr_idea_rep_perc|2|0-99| | ||
| + | |Standard English Conventions Subscore Representative Percentile|775|776|2|eng_conv_rep_perc|2|0-99| | ||
| + | |Heart of Algebra Subscore Representative Percentile|777|778|2|heart_alg_rep_perc|2|0-99| | ||
| + | |Passport to Advanced Mathematic Subscore Representative Percentile|779|780|2|adv_math_rep_perc|2|0-99| | ||
| + | |Problem Solving and Data Analysis Subscore Representative Percentile|781|782|2|prob_solv_rep_perc|2|0-99| | ||
| + | |Total for Evidence-Based Reading & Writing and Math Section Score National Percentile|789|790|2|tot_sec_perc|2|0-99| | ||
| + | |Evidence-Based Reading & Writing National Percentile|791|792|2|read_writ_sec_perc|2|0-99| | ||
| + | |Math Section National Percentile|793|794|2|math_sec_perc|2|0-99| | ||
| + | |Reading National Percentile|795|796|2|verbal_perc|2|0-99| | ||
| + | |Writing National Percentile|797|798|2|write_perc|2|0-99| | ||
| + | |Math National Percentile|799|800|2|math_perc|2|0-99| | ||
| + | |Analysis in Science CrossTest National Percentile|801|802|2|sci_cross_perc|2|0-99| | ||
| + | |Analysis in History/SS Cross-test National Percentile|803|804|2|hist_cross_perc|2|0-99| | ||
| + | |Relevant Words in Context Subscore National Percentile|805|806|2|words_perc|2|0-99| | ||
| + | |Command of Evidence National Representative Percentile|807|808|2|comm_ev_perc|2|0-99| | ||
| + | |Expression of Idea Subscore National Percentile|809|810|2|expr_idea_perc|2|0-99| | ||
| + | |Standard English Conventions Subscore National Percentile|811|812|2|eng_conv_perc|2|0-99| | ||
| + | |Heart of Algebra Subscore National Percentile|813|814|2|heart_alg_perc|2|0-99| | ||
| + | |Passport to Advanced Mathematic Subscore National Percentile|815|816|2|adv_math_perc|2|0-99| | ||
| + | |Problem Solving and Data Analysis Subscore National Percentile|817|818|2|prob_solv_perc|2|0-99| | ||
student/psat_test_scores_import_10.1504536233.txt.gz · Last modified: 2017/09/04 09:43 (external edit)