The report output tables may include some or all of the following elements, depending on whether the report is output as a .txt file or a .csv file.
For details on file layout parameters, please see https://education.ohio.gov/.
Text File (.txt) Output
For reports output as a .txt file, data elements are extracted at fixed character positions within each line. The report output table may include some or all of the following columns:
-
Item # or Position – Either the numerical order of the data element (first element is 1, second element is 2), or the position in the report. For example, if there is a string of data elements, such as 2009YNYN08091989, the particular element may start at position 5. In this example, position 5 is Y.
-
Data Element – The name of the data element.
-
Description – Additional information about the data element, including state reporting rules.
-
[Table] – The name of the table where the data is stored.
-
Table.Field Name – The name of the field where the data is stored.
Note: The Table name appears in brackets with the Field Name directly following. Example: [Table]FieldName.
-
Data Type – The field type used for the data element, such as character string, numeric, etc.
-
Field Length – The length of the data element when extracted.
-
Begin/End Position – The position of the data element in the report. For example, if there is a string of data elements, such as 2009YNYN08091989, the particular element may start at position 5. In this example, position 5 is Y.
CSV File (.csv) Output
For reports output as a .csv (comma-separated values) file, data elements are separated by commas rather than placed at fixed character positions. The .csv file can be opened and manipulated in spreadsheet applications such as Microsoft Excel.
Because .csv files use comma delimiters instead of fixed-width positions, the report output table for .csv reports does not include the Begin/End Position column. The report output table may include some or all of the following columns:
-
Item # – The numerical order of the data element in the file (first element is 1, second element is 2, and so on). This indicates the column order in the .csv file.
-
Data Element – The name of the data element.
-
Description – Additional information about the data element, including state reporting rules.
-
[Table]FieldName – The name of the table and field where the data is stored. The table name appears in brackets with the field name directly following. Example: [Students]Student_Number.
-
Field Type – The field type used for the data element, such as alpha-numeric, numeric, etc.
-
Field Length – The maximum length of the data element when extracted. This column may not appear in all .csv report output tables.