User Tools

Site Tools


student:psat_test_scores_import_8_9

This is an old revision of the document!


PSAT Test Scores Import (October 2015 and forward) - PSAT 8/9

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

SourceTargetComments
FieldStart PositionEnd PositionLengthTableColumn
Assessment year6636664 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 8/9:
FieldStart PositionEnd PositionLengthColumnLength
Year6636664admin_dt4
Education Level Cd6736742*ed_lvl234, 14, 15, 2, 4, 5, 35
Total for Evidence-Based Reading & Writing and Math Section Score6756784tot_sec_scr4240-1440
Evidence-Based Reading & Writing Score6796813read_writ_sec_scr3120-720
Math Section Score6826843math_sec_scr3127-720
Reading Score6856862verbal_scr26-36
Writing Score6876882write_scr26-36
Math Score6896924math_scr46.0-36.0 in .5 increments
Analysis in Science Crosstest Score6936942sci_cross_scr26-36
Analysis in History/SS Cross-test Score6956962hist_cross_scr26-36
Relevant Words in Context Subscore6976982words_subscr21-15
Command of Evidence Subscore6997002comm_ev_subscr21-15
Expression of Idea Subscore7017022expr_idea_subscr21-15
Standard English Conventions Subscore7037042eng_conv_subscr21-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

student/psat_test_scores_import_8_9.1504534546.txt.gz · Last modified: 2017/09/04 09:15 (external edit)