This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
student:sat_test_scores_import_oct2015_feb2016 [2017/09/04 20:46] – created jstanford | student:sat_test_scores_import_oct2015_feb2016 [2018/07/24 13:21] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 3: | Line 3: | ||
The import allows both a fixed-width positional and a comma-delimited (CSV) file import. | 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 | + | * 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. |
- | 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 | + | * The **Column #** column indicates the position in the comma-delimited |
- | ^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\\ | ||