User Tools

Site Tools


student:psat_test_scores_import_10

This is an old revision of the document!


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 year6636664 sch_yrYYYY
The following fields are imported into the PSAT test scores table for PSAT 8/9:
FieldStart PositionEnd PositionLengthColumnLength
Year6636664admin_dt4

Field Start End Length Table Column Comments Assessment year 665 668 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 10: Field Start End Length Column Length Comments Year 665 668 4 admin_dt 4 Education Level Cd 675 676 1 *ed_lvl 1 1-2, 4-7, blank 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 2 of 4 TxEIS Student - PSAT Test Scores Import (October 2015 and forward) - PSAT 10 Source Target Field Start End Length Column Length Comments 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 3 of 4 TxEIS Student - PSAT Test Scores Import (October 2015 and forward) - PSAT 10 Source Target 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 4 of 4 TxEIS Student - PSAT Test Scores Import (October 2015 and forward) - PSAT 10 Source Target 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.1504536700.txt.gz · Last modified: 2017/09/04 09:51 (external edit)