This is an old revision of the document!
The following fields are matched with the student records to ensure that the student’s correct records are stored for PSAT 10:
Source | Target | Comments | ||||
---|---|---|---|---|---|---|
Field | Start Position | End Position | Length | Table | Column | |
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 Position | End Position | Length | Column | Length | |
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 |
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 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