This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
student:psat_test_scores_import_8_9 [2017/09/04 13:47] – created jstanford | student:psat_test_scores_import_8_9 [2018/07/24 13:21] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
======PSAT Test Scores Import (October 2015 and forward) - PSAT 8/9====== | ======PSAT Test Scores Import (October 2015 and forward) - PSAT 8/9====== | ||
- | The following fields are matched with the student records to ensure that the correct | + | The following fields are matched with the student records to ensure that the student’s |
+ | |||
+ | ^Source^^^^Target^^Comments^ | ||
+ | ^Field^Start Position^End Position^Length^Table^Column^ ^ | ||
+ | |Assessment year|663|666|4| |sch_yr|YYYY| | ||
+ | |Last Name|113|147|35| |name_l| | | ||
+ | |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 8/ | ||
+ | ^Field^Start Position^End Position^Length^Column^Length^ ^ | ||
+ | |Year|663|666|4|admin_dt|4| | | ||
+ | |Education Level Cd|673|674|2|ed_lvl|2|34, | ||
+ | |Total for Evidence-Based Reading & Writing and Math Section Score|675|678|4|tot_sec_scr|4|240-1440| | ||
+ | |Evidence-Based Reading & Writing Score|679|681|3|read_writ_sec_scr|3|120-720| | ||
+ | |Math Section Score|682|684|3|math_sec_scr|3|127-720| | ||
+ | |Reading Score|685|686|2|verbal_scr|2|6-36| | ||
+ | |Writing Score|687|688|2|write_scr|2|6-36| | ||
+ | |Math Score|689|692|4|math_scr|4|6.0-36.0 in .5 increments| | ||
+ | |Analysis in Science Crosstest Score|693|694|2|sci_cross_scr|2|6-36| | ||
+ | |Analysis in History/SS Cross-test Score|695|696|2|hist_cross_scr|2|6-36| | ||
+ | |Relevant Words in Context Subscore|697|698|2|words_subscr|2|1-15| | ||
+ | |Command of Evidence Subscore|699|700|2|comm_ev_subscr|2|1-15| | ||
+ | |Expression of Idea Subscore|701|702|2|expr_idea_subscr|2|1-15| | ||
+ | |Standard English Conventions Subscore|703|704|2|eng_conv_subscr|2|1-15| | ||
+ | |Heart of Algebra Subscore|705|706|2|heart_alg_subscr|2|1-15| | ||
+ | |Problem Solving and Data Analysis Subscore|707|708|2|prob_solv_subscr|2|1-15| | ||
+ | |Total for Evidence-Based Reading & Writing and Math Section Score Representative Percentile|751|752|2|tot_sec_rep_perc|2|0-99| | ||
+ | |Evidence-Based Reading & Writing Representative Percentile|753|754|2|read_writ_rep_perc|2|0-99| | ||
+ | |Math Section Representative Percentile|755|756|2|math_sec_rep_perc|2|0-99| | ||
+ | |Reading Representative Percentile|757|758|2|verbal_st_perc|2|0-99| | ||
+ | |Writing Representative Percentile|759|760|2|write_st_perc|2|0-99| | ||
+ | |Math Representative Percentile|761|762|2|math_st_perc|2|0-99| | ||
+ | |Analysis in Science Crosstest Representative Percentile|763|764|2|sci_cross_rep_perc|2|0-99| | ||
+ | |Analysis in History/SS Cross-test Representative Percentile|765|766|2|hist_cross_rep_perc|2|0-99| | ||
+ | |Relevant Words in Context Subscore Representative Percentile|767|768|2|words_rep_perc|2|0-99| | ||
+ | |Command of Evidence Subscore Representative Percentile|769|770|2|comm_ev_rep_perc|2|0-99| | ||
+ | |Expression of Idea Subscore Representative Percentile|771|772|2|expr_idea_rep_perc|2|0-99| | ||
+ | |Standard English Conventions Subscore Representative Percentile|773|774|2|eng_conv_rep_perc|2|0-99| | ||
+ | |Heart of Algebra Subscore Representative Percentile|775|776|2|heart_alg_rep_perc|2|0-99| | ||
+ | |Problem Solving and Data Analysis Subscore Representative Percentile|779|780|2|prob_solv_rep_perc|2|0-99| | ||
+ | |Total for Evidence-Based Reading & Writing and Math Section Score National Percentile|787|788|2|tot_sec_perc|2|0-99| | ||
+ | |Evidence-Based Reading & Writing National Percentile|789|790|2|read_writ_sec_perc|2|0-99| | ||
+ | |Math Section National Percentile|791|792|2|math_sec_perc|2|0-99| | ||
+ | |Reading National Percentile|793|794|2|verbal_perc|2|0-99| | ||
+ | |Writing National Percentile|795|796|2|write_perc|2|0-99| | ||
+ | |Math National Percentile|797|798|2|math_perc|2|0-99| | ||
+ | |Analysis in Science CrossTest National Percentile|799|800|2|sci_cross_perc|2|0-99| | ||
+ | |Analysis in History/SS Cross-test National Percentile|801|802|2|hist_cross_perc|2|0-99| | ||
+ | |Relevant Words in Context Subscore National Percentile|803|804|2|words_perc|2|0-99| | ||
+ | |Command of Evidence National Representative Percentile|805|806|2|comm_ev_perc|2|0-99| | ||
+ | |Expression of Idea Subscore National Percentile|807|808|2|expr_idea_perc|2|0-99| | ||
+ | |Standard English Conventions Subscore National Percentile |809|810|2|eng_conv_perc|2|0-99| | ||
+ | |Heart of Algebra Subscore National Percentile|811|812|2|heart_alg_perc|2|0-99| | ||
+ | |Problem Solving and Data Analysis Subscore National Percentile|815|816|2|prob_solv_perc|2|0-99| |