This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
student:sat_test_scores_import_oct2015_feb2016 [2017/09/04 20:46] – jstanford | student:sat_test_scores_import_oct2015_feb2016 [2017/09/04 21:08] – jstanford | ||
---|---|---|---|
Line 7: | Line 7: | ||
* 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. | * 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. | ||
- | ^Source^^^^Target^^Comments^ | + | ^Field^Position^Column #^Length |
- | ^Field^Start Position^End Position^Length^Table^Column^ | + | |Stu Last Name|113-147|6|35| |
- | |Last Name|7|21|15|sr_stu_enroll|name_l| | | + | |Stu First Name|148-182|7|35| |
+ | |Stu Middle Initial|183-183|8| | | ||
+ | |Stu Gender|184-184|9| | | ||
+ | |Stu DOB|203-212|23|YYYY-MM-DD| | ||
+ | |Test Date|659-668|44|YYYY-MM-DD| | ||
+ | |Education Level/Grade Level at Time of Test|669-670|45|1 = Not yet in 8th grade\\ | ||
+ | |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\\ | ||
+ | |Math State Percentile|817-818|109|0-99\\ | ||
+ | |Writing State Percentile|819-820|110|0-99\\ | ||