Data Import Map for ODDEX (Ohio Data Exchange)
This page describes the process for importing assessment results from the Ohio District Data Exchange (ODDEX) site via the Student Assessment (FA) Import function.
From the Student Assessment (FA) Import page, select ODDEX as the test type. The following parameters must be set:
- Exclude from EMIS Reporting: Yes or No (Should these tests be included in (FA) Student Assessment report results?)
- Import Graduation Tests Only: Yes or No (Should only tests related to graduation be imported?)
- Ignore First Line: Yes or No (Does the file contain a header row that should be ignored? Hint: The file provided by ODDEX does not include a header row.)
File to Import: Click the Choose File button and browse to attach the ODDEX file.
Run validation: Click the Validate File button
Click Save to import the results into the S_OH_Stu_Assessment_C table.
Data Map for ODDEX
File format is fixed width
Position | Length | Field Name | Field Content | FA Import Use | |
Start | End | ||||
1 | 8 | 8 | Filler | Blank | Not used |
9 | 10 | 2 | Sort Type | FA | Not used |
11 | 11 | 1 | Filler | Blank | Not used |
12 | 15 | 4 | Fiscal Year | Four digit fiscal year for which the file was created | Not used |
16 | 16 | 1 | Collection Period | Valid values are A, D, G, R, E, X | Not used |
17 | 22 | 6 | District IRN | IRN of district that reported the assessment to ODDEX | Not used |
23 | 31 | 9 | State Student Number | SSID for student | Used for matching |
32 | 33 | 2 | Assessment Type Code | Complete list of Assessment Type Codes are found in the Ohio State Reporting EMIS Manual. | Imported into Test Type |
34 | 35 | 2 | Test Grade Level | Two-digit state equivalent grade level | Imported into Test Grade Level |
36 | 39 | 4 | Assessment Area Code | Complete list of Assessment Area Codes are found in the Ohio State Reporting EMIS Manual. | Imported into Assessment Area |
40 | 45 | 6 | Test Date | Data formatted as CCYYMM | Imported into Test Date |
46 | 47 | 2 | Test Day of the Month | Data formatted as DD | Imported into Test Day |
48 | 50 | 3 | Required Test Type | Complete list of Required Test Type values are found in the Ohio State Reporting EMIS Manual. | Imported into Required Test Type |
51 | 52 | 2 | Grade Level of Student at Time of Test | Two digit state equivalent grade level, if applicable. | Imported into Grade Level of Student at Time of Test |
53 | 54 | 2 | Type of Accommodation | Valid values are **, NO, Y1, Y2, Y3. | Imported into Type of Accommodation |
55 | 55 | 1 | Score Not Reported | Complete list of Score Not Reported values are found in the Ohio State Reporting EMIS Manual. | Imported into Score Not Reported |
56 | 58 | 3 | Score | Complete list of Score values are found found in the Ohio State Reporting EMIS Manual. | Imported into Score |
59 | 50 | 2 | Performance Indicator | Valid values are 01 through 05 and translate to the number of points a student will receive toward End of Course assessments for graduation requirements. | Imported into Performance Level |