Interfaces

User Tools

Site Tools

Trace:
student:psat_test_scores_import_10

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
student:psat_test_scores_import_10 [2017/09/04 14:51] – jstanfordstudent:psat_test_scores_import_10 [2018/07/24 13:21] (current) – external edit 127.0.0.1
Line 5: Line 5:
 ^Source^^^^Target^^Comments^ ^Source^^^^Target^^Comments^
 ^Field^Start Position^End Position^Length^Table^Column^ ^ ^Field^Start Position^End Position^Length^Table^Column^ ^
-|Assessment year|663|666|4| |sch_yr|YYYY| +|Assessment year|665|668|4| |sch_yr|YYYY| 
- +|Last Name|113|147|35| |name_l| | 
-|The following fields are imported into the PSAT test scores table for PSAT 8/9:|||||||+|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^ ^ ^Field^Start Position^End Position^Length^Column^Length^ ^
-|Year|663|666|4|admin_dt|4| | +|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| 
-Field Start End Length Table Column Comments +|Evidence-Based Reading & Writing Score|681|683|3|read_writ_sec_scr|3|160-760| 
-Assessment year 665 668 4 sch_yr YYYY +|Math Section Score|684|686|3|math_sec_scr|3|160-760| 
-Last Name 113 147 35 name_l +|Reading Score|687|688|2|verbal_scr|2|8-38| 
-First Name 148 182 35 name_f +|Writing Score|689|690|2|write_scr|2|8-38| 
-Middle Initial 183 183 1 name_m Compare first char +|Math Score|691|694|4|math_scr|4|8.0-38.0 in .5 increments| 
-Date of Birth 203 212 10 sr_stu_demo dob YYYY-MM-DD +|Analysis in Science Crosstest Score|695|696|2|sci_cross_scr|2|8-38| 
-Sex 184 184 1 sex +|Analysis in History/SS Cross-test Score|697|698|2|hist_cross_scr|2|8-38| 
-The following fields are imported into the PSAT test scores table for PSAT 10: +|Relevant Words in Context Subscore|699|700|2|words_subscr|2|1-15| 
-Field Start End Length Column Length Comments +|Command of Evidence Subscore|701|702|2|comm_ev_subscr|2|1-15| 
-Year 665 668 4 admin_dt 4 +|Expression of Idea Subscore|703|704|2|expr_idea_subscr|2|1-15| 
-Education Level Cd 675 676 1 *ed_lvl 1 1-2, 4-7, blank +|Standard English Conventions Subscore|705|706|2|eng_conv_subscr|2|1-15| 
-Total for Evidence-Based +|Heart of Algebra Subscore|707|708|2|heart_alg_subscr|2|1-15|     
-Reading & Writing and +|Passport to Advanced Mathematics Subscore|709|710|2|adv_math_subscr|2|1-15| 
-Math Section Score +|Problem Solving and Data Analysis Subscore|711|712|2|prob_solv_subscr|2|1-15| 
-677 680 4 tot_sec_scr 4 320-1520 +|Selection Index|732|734|3|total|3|24-114| 
-Evidence-Based Reading & +|Selection Index National Percentile|735|736|2|total_perc|2|0-99| 
-Writing Score +|Total for Evidence-Based Reading & Writing and Math Section Score Representative Percentile|753|754|2|tot_sec_rep_perc|2|0-99| 
-681 683 3 read_writ_sec_scr 3 160-760 +|Evidence-Based Reading & Writing Representative Percentile|755|756|2|read_writ_rep_perc|2|0-99|     
-Math Section Score 684 686 3 math_sec_scr 3 160-760 +|Math Section Representative Percentile|757|758|2|math_sec_rep_perc|2|0-99| 
-Reading Score 687 688 2 verbal_scr 2 8-38 +|Reading Representative Percentile|759|760|2|verbal_st_perc|2|0-99| 
-Writing Score 689 690 2 write_scr 2 8-38 +|Writing Representative Percentile|761|762|2|write_st_perc|2|0-99| 
-Math Score 691 694 4 math_scr 4 8.0-38.0 in .5 +|Math Representative Percentile|763|764|2|math_st_perc|2|0-99| 
-increments +|Analysis in Science Crosstest Representative Percentile|765|766|2|sci_cross_rep_perc|2|0-99| 
-Analysis in Science Crosstest +|Analysis in History/SS Cross-test Representative Percentile|767|768|2|hist_cross_rep_perc|2|0-99|     
-Score +|Relevant Words in Context Subscore Representative Percentile|769|770|2|words_rep_perc|2|0-99| 
-695 696 2 sci_cross_scr 2 8-38 +|Command of Evidence Subscore Representative Percentile|771|772|2|comm_ev_rep_perc|2|0-99| 
-Analysis in History/SS +|Expression of Idea Subscore Representative Percentile|773|774|2|expr_idea_rep_perc|2|0-99| 
-Cross-test Score +|Standard English Conventions Subscore Representative Percentile|775|776|2|eng_conv_rep_perc|2|0-99|    
-697 698 2 hist_cross_scr 2 8-38 +|Heart of Algebra Subscore Representative Percentile|777|778|2|heart_alg_rep_perc|2|0-99| 
-Relevant Words in Context +|Passport to Advanced Mathematic Subscore Representative Percentile|779|780|2|adv_math_rep_perc|2|0-99| 
-Subscore +|Problem Solving and Data Analysis Subscore Representative Percentile|781|782|2|prob_solv_rep_perc|2|0-99| 
-699 700 2 words_subscr 2 1-15 +|Total for Evidence-Based Reading & Writing and Math Section Score National Percentile|789|790|2|tot_sec_perc|2|0-99|      
-Command of Evidence +|Evidence-Based Reading & Writing National Percentile|791|792|2|read_writ_sec_perc|2|0-99| 
-Subscore +|Math Section National Percentile|793|794|2|math_sec_perc|2|0-99| 
-701 702 2 comm_ev_subscr 2 1-15 +|Reading National Percentile|795|796|2|verbal_perc|2|0-99|      
-Expression of Idea +|Writing National Percentile|797|798|2|write_perc|2|0-99| 
-Subscore +|Math National Percentile|799|800|2|math_perc|2|0-99| 
-703 704 2 expr_idea_subscr 2 1-15 +|Analysis in Science CrossTest National Percentile|801|802|2|sci_cross_perc|2|0-99|      
-Standard English +|Analysis in History/SS Cross-test National Percentile|803|804|2|hist_cross_perc|2|0-99| 
-Conventions Subscore +|Relevant Words in Context Subscore National Percentile|805|806|2|words_perc|2|0-99| 
-705 706 2 eng_conv_subscr 2 1-15 +|Command of Evidence National Representative Percentile|807|808|2|comm_ev_perc|2|0-99|      
-2 of 4 +|Expression of Idea Subscore National Percentile|809|810|2|expr_idea_perc|2|0-99| 
-TxEIS Student - PSAT Test Scores Import (October 2015 and forward) - PSAT 10 +|Standard English Conventions Subscore National Percentile|811|812|2|eng_conv_perc|2|0-99| 
-Source Target +|Heart of Algebra Subscore National Percentile|813|814|2|heart_alg_perc|2|0-99|      
-Field Start End Length Column Length Comments +|Passport to Advanced Mathematic Subscore National Percentile|815|816|2|adv_math_perc|2|0-99| 
-Heart of Algebra Subscore 707 708 2 heart_alg_subscr 2 1-15 +|Problem Solving and Data Analysis Subscore National Percentile|817|818|2|prob_solv_perc|2|0-99|
-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)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.