Pre-ID Labels Extract
Contents
Introduction
Use this option to generate the file that is uploaded to the test vendor site to request test labels for the OGT. This extract includes only the student’s current enrollment information.
Selection Criteria
Selection criteria determine which database records are used in the report. For the Pre-ID Labels Extract, student records are selected.
School Selection
The report selects which school records to use based on the following criteria:
- The school must be associated with a student included in the report.
- The school in which the student is enrolled is not excluded from state reporting.
Student Selection
The report selects which student records to use based on the following criteria:
- The student is included in state reporting.
- The student has a current enrollment record that is active between the term start and end dates and the student has an exit date that is greater than the student’s entry date
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
The report input is done in Incident Management with the codes and subcodes used in IM.
Field | Description |
Use | If run at the district level, choose one of the following from the pop-up menu:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running a report. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyyoruse the date picker icon in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10:05 AM. |
Grades (leave blank for all) | Click to select the check box for each grade level you want to include in the extract. |
Effective Date | Enter the effective date to extract only course enrollments for students with an active enrollment record on that date. Format: [M]M/[D]D/[YY]YY |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Note: For documentation of XML report output from the state department of education, refer to http://www.ode.state.oh.us.
Item # | Data Element | Description | [Table]FieldName | Field Type | Field Length | Begin/End Position |
1 | Attending District IRN | This field contains the number identifying the school district the student attends. This field value is extracted from the Edit District page, Start Page > District Setup > District Information. | [Prefs]DistrictNumber | Alpha-numeric | 6 | 1–6 |
2 | Attending School IRN | This field contains the number identifying the school the student attends. This field value is extracted from the Edit School page, Start Page > District Setup > Schools/School Info. | [Students]SchoolID | Alpha-numeric | 6 | 7–12 |
3 | Attending District Name | This field contains the name of the district. This field value is extracted from the Edit District page, Start Page > District Setup > District Information. | [Prefs]DistrictName | Alpha-numeric | 30 | 13–42 |
4 | Attending School IRN | This field contains the name of the school. This field value is extracted from the Edit School page, Start Page > District Setup > Schools/School Info. | [Schools]Name | Alpha-numeric | 30 | 43–72 |
5 | Last Name | This field contains the student’s last name. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [Students]Last_Name | Alpha-numeric | 20 | 73–92 |
6 | First Name | This field contains the student’s first name. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [Students]First_Name | Alpha-numeric | 20 | 93–112 |
7 | Middle Initial | This field contains the first letter of the student’s middle name. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [Students]Middle_Name | Alpha-numeric | 1 | 113 |
8 | Date of Birth Month (MM) | This field contains the month of the student’s date of birth. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [Students]DOB | Numeric | 2 | 114–115 |
9 | Date of Birth Month (DD) | This field contains the day of the student’s date of birth. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [Students]DOB | Numeric | 2 | 116–117 |
10 | Date of Birth Month (YYYY) | This field contains the year of the student’s date of birth. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [Students]DOB | Numeric | 4 | 118–121 |
11 | District Student ID Number (DSID) | This field value is calculated by concatenating the EMIS prefix and student number. | [Prefs]OH_EMIS_Prefix [Students]Student_Number | Alpha-numeric | 9 | 122–130 |
12 | Statewide Student Identifier (SSID) | This field contains the student ID number assigned by the State of Ohio to this student. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [Students]State_StudentNumber | Alpha-numeric | 9 | 131–139 |
13 | Enrolled Grade | This field contains the grade level in which the student is currently enrolled. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [Students]Grade_Level | Numeric | 2 | 140–141 |
14 | Gender | This field contains the student’s gender. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [Students]Gender | Numeric | 1 | 142 |
15 | Ethnicity | This field contains the student’s ethnicity. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [Students]Ethnicity | Numeric | 1 | 143 |
16 | Room Number | This field contains the room number where the student will take the test. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [S_OH_STU_PREID_X]PID_Room | Alpha-numeric | 5 | 144–148 |
17 | Migrant Student | Y is extracted for this field if the student meets the requirements for a migrant student. Otherwise, N is extracted for this field. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [S_OH_STU_FD_X]Migrant_Status | Alpha-numeric | 1 | 149 |
18 | Filler | This field is not currently used. | N/A | Alpha-numeric | 3 | 150–152 |
19 | Class Name/Course Name – Reading | This field contains the reading course in which the student is currently enrolled. A reading course is identified by the course subject code ([COURSES.S_CRS_COURSES_X]Subject_Code) assigned to that course. Valid reading subject codes are:
This value is extracted from the Edit Enrollment Record page, Start Page > Student Selection > Ohio State Information > Ohio Demographic Report Information. Note: If the course is not identified as a reading course, this field is blank in the extract. | [CC]Course_Number | Alpha-numeric | 10 | 153–162 |
20 | Section Number – Reading | This field contains the section number in which the student is enrolled, if the student is currently enrolled in a reading course. A reading course is identified by the course subject code ([COURSES.S_CRS_COURSES_X]Subject_Code) assigned to that course. Valid reading subject codes are:
Note: If the student is not enrolled in a reading course, this field is blank. | [CC]Section_Number | Alpha-numeric | 5 | 163–167 |
21 | Teacher Name – Reading | This field contains the name of the teacher that teaches the reading course in which the student is enrolled. A reading course is identified by the course subject code ([COURSES.S_CRS_COURSES_X]Subject_Code) assigned to that course. Valid reading subject codes are:
This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information. If the student is not enrolled in a reading course, this field is blank. | [Users]LastFirst | Alpha-numeric | 20 | 168–187 |
22 | Class Name/Course Name – Writing | This field contains the writing course in which the student is currently enrolled. A writing course is identified by the course subject code ([COURSES.S_CRS_COURSES_X]Subject_Code) assigned to that course. Valid writing subject codes include the 05xxxx codes not listed for Reading fields 19–21 as well as the following codes:
This value is extracted from the Edit Enrollment Record page, Start Page > Student Selection > Ohio State Information > Ohio Demographic Report Information. Note: If the course is not identified as a writing course, this field is blank in the extract. | [CC]Course_Number | Alpha-numeric | 10 | 188–197 |
23 | Section Number – Writing | This field contains the section number in which the student is enrolled, if the student is currently enrolled in a writing course. A writing course is identified by the course subject code ([COURSES.S_CRS_COURSES_X]Subject_Code) assigned to that course. Valid writing subject codes include the 05xxxx codes not listed for Reading fields 19–21 as well as the following codes:
Note: If the student is not enrolled in a writing course, this field is blank. | [CC]Section_Number | Alpha-numeric | 5 | 198–202 |
24 | Teacher Name – Writing | This field contains the name of the teacher that teaches the writing course in which the student is enrolled. A writing course is identified by the course subject code ([COURSES.S_CRS_COURSES_X]Subject_Code) assigned to that course. Valid writing subject codes include the 05xxxx codes not listed for Reading fields 19–21 as well as the following codes:
This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information. If the student is not enrolled in a writing course, this field is blank. | [Users]LastFirst | Alpha-numeric | 20 | 203–222 |
25 | Class Name/Course Name – Mathematics | This field contains the mathematics course in which the student is currently enrolled. A mathematics course is identified by the course subject code ([COURSES.S_CRS_COURSES_X]Subject_Code) assigned to that course. Valid mathematics subject codes include the 11xxxx codes as well as the following codes:
This value is extracted from the Edit Enrollment Record page, Start Page > Student Selection > Ohio State Information > Ohio Demographic Report Information. Note: If the course is not identified as a mathematics course, this field is blank in the extract. | [CC]Course_Number | Alpha-numeric | 10 | 223–232 |
26 | Section Number – Mathematics | This field contains the section number in which the student is enrolled, if the student is currently enrolled in a mathematics course. Valid mathematics subject codes include the 11xxxx codes as well as the following codes:
Note: If the student is not enrolled in a mathematics course, this field is blank. | [CC]Section_Number | Alpha-numeric | 5 | 233–237 |
27 | Teacher Name – Mathematics | This field contains the name of the teacher that teaches the mathematics course in which the student is enrolled. Valid mathematics subject codes include the 11xxxx codes as well as the following codes:
Note: This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information. If the student is not enrolled in a mathematics course, this field is blank. | [Users]LastFirst | Alpha-numeric | 20 | 238–257 |
28 | Class Name/Course Name – Social Studies | This field contains the social studies course in which the student is currently enrolled. A social studies course is identified by the course subject code ([COURSES.S_CRS_COURSES_X]Subject_Code) assigned to that course. Valid social studies subject codes include the 15xxxx codes as well as the following codes:
This value is extracted from the Edit Enrollment Record page, Start Page > Student Selection > Ohio State Information > Ohio Demographic Report Information. Note: If the course is not identified as social studies, this field is blank in the extract. | [CC]Course_Number | Alpha-numeric | 10 | 258–267 |
29 | Section Number – Social Studies | This field contains the section number in which the student is enrolled, if the student is currently enrolled in a social studies course. Valid social studies subject codes include the 15xxxx codes as well as the following codes:
Note: If the student is not enrolled in a social studies course, this field is blank. | [CC]Section_Number | Alpha-numeric | 5 | 268–272 |
30 | Teacher Name – Social Studies | This field contains the name of the teacher that teaches the social studies course in which the student is enrolled. Valid social studies subject codes include the 15xxxx codes as well as the following codes:
This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information. Note: If the student is not enrolled in a social studies course, this field is blank. | [Users]LastFirst | Alpha-numeric | 20 | 273–292 |
31 | Class Name/Course Name – Science | This field contains the science course in which the student is currently enrolled. A science course is identified by the course subject code ([COURSES.S_CRS_COURSES_X]Subject_Code) assigned to that course. Valid science subject codes include the 13xxxx codes as well as the following codes:
This value is extracted from the Edit Enrollment Record page, Start Page > Student Selection > Ohio State Information > Ohio Demographic Report Information. Note: If the course is not identified as a science course, this field is blank in the extract. | [CC]Course_Number | Alpha-numeric | 10 | 293–302 |
32 | Section Number – Science | This field contains the section number in which the student is enrolled, if the student is currently enrolled in a science course. Valid science subject codes include the 13xxxx codes as well as the following codes:
Note: If the student is not enrolled in a science course, this field is blank. | [CC]Section_Number | Alpha-numeric | 5 | 303–307 |
33 | Teacher Name – Science | This field contains the name of the teacher that teaches the science course in which the student is enrolled. Valid science subject codes include the 13xxxx codes as well as the following codes:
This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information. Note: If the student is not enrolled in a science course, this field is blank. | [Users]LastFirst | Alpha-numeric | 20 | 308–327 |
34 | Accelerated Testing Indicator – Reading | This field is calculated. If the Accelerated Testing – Reading field value is not equal to No, this field contains a Y. Otherwise this field contains an N value. This value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | Calculated Based on [S_OH_STU_PREID_X]AT_Reading | Alpha-numeric | 1 | 328 |
35 | Accelerated Testing Grade – Reading | This field contains the grade level of the reading test this student will take, as entered on the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. If the Accelerated Testing – Reading field is blank, this field contains the student’s current grade level. | [S_OH_STU_PREID_X]AT_Reading | Alpha-numeric | 2 | 329–330 |
36 | Accelerated Testing Indicator – Writing | This field is calculated. If the Accelerated Testing – Writing field value is not equal to No, this field contains a Y. Otherwise this field contains an N value. The Accelerated Testing – Writing field is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | Calculated Based on [S_OH_STU_PREID_X]AT_Writing | Alpha-numeric | 1 | 331 |
27 | Accelerated Testing Grade – Writing | This field contains the grade level of the writing test this student will take, as entered on the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. If the Accelerated Testing – Writing field is blank, this field contains the student’s current grade level. | [S_OH_STU_PREID_X]AT_Writing | Alpha-numeric | 2 | 332–333 |
38 | Accelerated Testing Indicator – Mathematics | This field is calculated. If the Accelerated Testing – Mathematics field value is not equal to No, this field contains a Y. Otherwise this field contains an N value. The Accelerated Testing – Mathematics field is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | Calculated Based on [S_OH_STU_PREID_X]AT_Math | Alpha-numeric | 1 | 334 |
39 | Accelerated Testing Grade – Mathematics | This field contains the grade level of the mathematics test this student will take, as entered on the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. If the Accelerated Testing – Mathematics field is blank, this field contains the student’s current grade level. | [S_OH_STU_PREID_X]AT_Math | Alpha-numeric | 2 | 335–336 |
40 | Accelerated Testing Indicator – Social Studies | This field is calculated. If the Accelerated Testing – Social studies field value is not equal to No, this field contains a Y. Otherwise this field contains an N value. The Accelerated Testing – Social studies field is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | Calculated Based on [S_OH_STU_PREID_X]AT_SocialStudies | Alpha-numeric | 1 | 337 |
41 | Accelerated Testing Grade – Social Studies | This field contains the grade level of the social studies test this student will take, as entered on the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. If the Accelerated Testing – Social studies field is blank, this field contains the student’s current grade level. | [S_OH_STU_PREID_X]AT_SocialStudies | Alpha-numeric | 2 | 338–339 |
42 | Accelerated Testing Indicator – Science | This field is calculated. If the Accelerated Testing – Science field value is not equal to No, this field contains a Y. Otherwise this field contains an N value. The Accelerated Testing – Science field is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | Calculated Based on [S_OH_STU_PREID_X]AT_Science | Alpha-numeric | 1 | 340 |
53 | Accelerated Testing Grade – Science | This field contains the grade level of the science test this student will take, as entered on the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. If the Accelerated Testing – Science field is blank, this field contains the student’s current grade level. | [S_OH_STU_PREID_X]AT_Science | Alpha-numeric | 2 | 341–342 |
44 | Teacher Identification Number – Reading | This field contains the number identifying the teacher of this course, if the student is enrolled in a reading course. A reading course is identified by the course subject code ([S_OH_CRS_COURSES_X]Subject_Code) assigned to that course. Valid reading subject codes are:
This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information. Note: If the course is not identified as a reading course, this field is blank in the extract. | [S_OH_USR_X]Teacher_Credential_ID | Alpha-numeric | 9 | 343–351 |
45 | Teacher Identification Number – Writing | This field contains the number identifying the teacher of this course, if the student is enrolled in a writing course. A writing course is identified by the course subject code ([S_OH_CRS_COURSES_X]Subject_Code) assigned to that course. Valid writing subject codes are:
This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information. Note: If the course is not identified as a writing course, this field is blank in the extract. | [S_OH_USR_X]Teacher_Credential_ID | Alpha-numeric | 9 | 352–560 |
46 | Teacher Identification Number – Mathematics | This field contains the number identifying the teacher of this course, if the student is enrolled in a mathematics course. A mathematics course is identified by the course subject code ([S_OH_CRS_COURSES_X]Subject_Code) assigned to that course. Valid mathematics subject codes start with 05 and include the following:
This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information. Note: If the course is not identified as a mathematics course, this field is blank in the extract. | [S_OH_USR_X]Teacher_Credential_ID | Alpha-numeric | 9 | 361–369 |
47 | Teacher Identification Number – Social Studies | This field contains the number identifying the teacher of this course, if the student is enrolled in a social studies course. A social studies course is identified by the course subject code ([S_OH_CRS_COURSES_X]Subject_Code) assigned to that course. Valid social studies subject codes are:
This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information. Note: If the course is not identified as a social studies course, then the field is blank in the extract. | [S_OH_USR_X]Teacher_Credential_ID | Alpha-numeric | 9 | 370–378 |
48 | Teacher Identification Number – Science | This field contains the number identifying the teacher of this course, if the student is enrolled in a science course. A science course is identified by the course subject code ([S_OH_CRS_COURSES_X]Subject_Code) assigned to that course. Valid science subject codes are:
This value is extracted from the Edit Staff Information page, Staff > Select A Staff Member > Edit Information. Note: If the course is not identified as a science course, this field is blank in the extract. | [S_OH_USR_X]Teacher_Credential_ID | Alpha-numeric | 9 | 379–387 |
49 | Course Code – Reading | This field is calculated by concatenating the student’s school ID, course number, and section number of the selected reading course. A reading course is identified by the course subject code ([S_OH_CRS_COURSES_X]Subject_Code) assigned to that course. Valid reading subject codes are:
Note: If the student is not enrolled in a reading course, this field is blank. | Calculated Based on: [Students]SchoolID AND [CC]Course_Number AND [CC]Section_Number | Alpha-numeric | 20 | 388–407 |
50 | Course Code – Writing | This field is calculated by concatenating the student’s school ID, course number, and section number of the selected writing course. A writing course is identified by the course subject code ([S_OH_CRS_COURSES_X]Subject_Code) assigned to that course. Valid writing subject codes are:
Note: If the student is not enrolled in a writing course, this field is blank. | Calculated Based on: [Students]SchoolID AND [CC]Course_Number AND [CC]Section_Number | Alpha-numeric | 20 | 408–427 |
51 | Course Code – Mathematics | This field is calculated by concatenating the student’s school ID, course number, and section number of the selected mathematics course. A mathematics course is identified by the course subject code ([S_OH_CRS_COURSES_X]Subject_Code) assigned to that course. Valid mathematics subject codes start with 05 and include the following:
Note: If the student is not enrolled in a mathematics course, this field is blank. | Calculated Based on: [Students]SchoolID AND [CC]Course_Number AND [CC]Section_Number | Alpha-numeric | 20 | 428–447 |
52 | Course Code – Social Studies | This field is calculated by concatenating the student’s school ID, course number, and section number of the selected social studies course. A social studies course is identified by the course subject code ([S_OH_CRS_COURSES_X]Subject_Code) assigned to that course. Valid social studies subject codes are:
Note: If the student is not enrolled in a social studies course, then this field is blank. | Calculated Based on: [Students]SchoolID AND [CC]Course_Number AND [CC]Section_Number | Alpha-numeric | 20 | 448–467 |
53 | Course Code – Science | This field is calculated by concatenating the student’s school ID, course number, and section number of the selected science course. A science course is identified by the course subject code ([S_OH_CRS_COURSES_X]Subject_Code) assigned to that course. Valid science subject codes are:
Note: If the student is not enrolled in a science course, then this field is blank. | Calculated Based on: [Students]SchoolID AND [CC]Course_Number AND [CC]Section_Number | Alpha-numeric | 20 | 468–487 |
54 | Home District IRN | This field contains the student’s district of residence. This field value is extracted from the Pre-ID tab, Start Page > Student Selection > Ohio State Information > Pre-ID. | [Students]DistrictOfResidence | Alpha-numeric | 6 | 488–493 |
55 | Home School IRN | This field is not currently extracted. | N/A | Alpha-numeric | 6 | 494–499 |
56 | Home District Name | This field is calculated. | Calculated Based on [Gen]Name | Alpha-numeric | 30 | 500–529 |
57 | Home School Name | This field is not currently extracted. | N/A | Alpha-numeric | 30 | 530–559 |