User Tools

Site Tools


student:sat_test_scores_import_oct2015_feb2016

This is an old revision of the document!


SAT Test Scores Import (October 2015-February 2016)

The import allows both a fixed-width positional and a comma-delimited (CSV) file import.

  • The Position column indicates the start and end in the positional import file. The program determines that the import is the positional layout if the file length is 2591 or greater, and position 59-62 contains a numeric four-digit year starting with 20.
  • The Column # column indicates the position in the comma-delimited file. The program determines that the import file is the comma delimited if it contains enough commas to be split into at least 449 columns, and the fourth column either contains a numeric four-digit year starting with 20 or the word YEAR to indicate it is a heading row.
FieldPositionColumn #Length and Valid Values
Stu Last Name113-147635
Stu First Name148-182735
Stu Middle Initial183-1838
Stu Gender184-1849
Stu DOB203-21223YYYY-MM-DD
Test Date659-66844YYYY-MM-DD
Education Level/Grade Level at Time of Test669-670451 = Not yet in 8th grade
2 = 8th grade
4 = 9th grade
5 = 10th grade
6 = 11th grade
7 = 12th grade
8 = No longer in high school
10 = No response 1
11 = Unknown
12 = 1st year of college
13 = 2nd year of college

Reading Score 714-716 66 Math 717-719 67 Writing 720-722 68 Essay Score 723-724 69 Multiple Choice 725-726 70 Reading National Percentile 773-774 88 0-99 Math National Percentile 775-776 89 0-99 Writing National Percentile 777-778 90 0-99 Reading State Percentile 815-816 108 0-99 Nationally Representative Sample Percentile Math State Percentile 817-818 109 0-99 Nationally Representative Sample Percentile Writing State Percentile 819-820 110 0-99 Nationally Representative Sample Percentile

student/sat_test_scores_import_oct2015_feb2016.1504558576.txt.gz · Last modified: 2017/09/04 15:56 (external edit)