The following fields are matched with the student records to ensure that the student’s correct records are stored for PSAT 8/9:
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/9: | ||||||
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, 14, 15, 2, 4, 5, 35 |
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 |