User Tools

Site Tools


student:psat_test_scores_import_10

PSAT Test Scores Import (October 2015 and forward) - PSAT 10

The following fields are matched with the student records to ensure that the student’s correct records are stored for PSAT 10:

SourceTargetComments
FieldStart PositionEnd PositionLengthTableColumn
Assessment year6656684 sch_yrYYYY
Last Name11314735 name_l
First Name14818235 name_f
Middle Initial1831831 name_mCompare first char
Date of Birth20321210sr_stu_demodobYYYY-MM-DD
Sex1841841 sex
The following fields are imported into the PSAT test scores table for PSAT 10:
FieldStart PositionEnd PositionLengthColumnLength
Year6656684admin_dt4
Education Level Cd6756761ed_lvl11-2, 4-7, blank
Total for Evidence-Based Reading & Writing and Math Section Score6776804tot_sec_scr4320-1520
Evidence-Based Reading & Writing Score6816833read_writ_sec_scr3160-760
Math Section Score6846863math_sec_scr3160-760
Reading Score6876882verbal_scr28-38
Writing Score6896902write_scr28-38
Math Score6916944math_scr48.0-38.0 in .5 increments
Analysis in Science Crosstest Score6956962sci_cross_scr28-38
Analysis in History/SS Cross-test Score6976982hist_cross_scr28-38
Relevant Words in Context Subscore6997002words_subscr21-15
Command of Evidence Subscore7017022comm_ev_subscr21-15
Expression of Idea Subscore7037042expr_idea_subscr21-15
Standard English Conventions Subscore7057062eng_conv_subscr21-15
Heart of Algebra Subscore7077082heart_alg_subscr21-15
Passport to Advanced Mathematics Subscore7097102adv_math_subscr21-15
Problem Solving and Data Analysis Subscore7117122prob_solv_subscr21-15
Selection Index7327343total324-114
Selection Index National Percentile7357362total_perc20-99
Total for Evidence-Based Reading & Writing and Math Section Score Representative Percentile7537542tot_sec_rep_perc20-99
Evidence-Based Reading & Writing Representative Percentile7557562read_writ_rep_perc20-99
Math Section Representative Percentile7577582math_sec_rep_perc20-99
Reading Representative Percentile7597602verbal_st_perc20-99
Writing Representative Percentile7617622write_st_perc20-99
Math Representative Percentile7637642math_st_perc20-99
Analysis in Science Crosstest Representative Percentile7657662sci_cross_rep_perc20-99
Analysis in History/SS Cross-test Representative Percentile7677682hist_cross_rep_perc20-99
Relevant Words in Context Subscore Representative Percentile7697702words_rep_perc20-99
Command of Evidence Subscore Representative Percentile7717722comm_ev_rep_perc20-99
Expression of Idea Subscore Representative Percentile7737742expr_idea_rep_perc20-99
Standard English Conventions Subscore Representative Percentile7757762eng_conv_rep_perc20-99
Heart of Algebra Subscore Representative Percentile7777782heart_alg_rep_perc20-99
Passport to Advanced Mathematic Subscore Representative Percentile7797802adv_math_rep_perc20-99
Problem Solving and Data Analysis Subscore Representative Percentile7817822prob_solv_rep_perc20-99
Total for Evidence-Based Reading & Writing and Math Section Score National Percentile7897902tot_sec_perc20-99
Evidence-Based Reading & Writing National Percentile7917922read_writ_sec_perc20-99
Math Section National Percentile7937942math_sec_perc20-99
Reading National Percentile7957962verbal_perc20-99
Writing National Percentile7977982write_perc20-99
Math National Percentile7998002math_perc20-99
Analysis in Science CrossTest National Percentile8018022sci_cross_perc20-99
Analysis in History/SS Cross-test National Percentile8038042hist_cross_perc20-99
Relevant Words in Context Subscore National Percentile8058062words_perc20-99
Command of Evidence National Representative Percentile8078082comm_ev_perc20-99
Expression of Idea Subscore National Percentile8098102expr_idea_perc20-99
Standard English Conventions Subscore National Percentile8118122eng_conv_perc20-99
Heart of Algebra Subscore National Percentile8138142heart_alg_perc20-99
Passport to Advanced Mathematic Subscore National Percentile8158162adv_math_perc20-99
Problem Solving and Data Analysis Subscore National Percentile8178182prob_solv_perc20-99
student/psat_test_scores_import_10.txt · Last modified: 2018/07/24 12:21 (external edit)