(GI) Student Demographic Record
Contents
Introduction
The (GI) Student Demographic Record report provides State required demographic information.
Selection Criteria
Selection criteria determine which database records are used in the report. For the (GI) Student Demographic Record, 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.
Student Selection
The report selects which student records to use based on the following criteria:
- The student is not excluded from state reporting (State/Province - OH > Home Tab > State_ExcludeEnrollment).
- The student must be enrolled during the report start and end dates selected for the Student (S) reporting period.
- For the (S) Student reporting period the student is not identified as a ‘Grad Only’ student (State/Province - OH > Home Tab)
- The student must have a date in the Diploma Date field that falls within the report start and end dates for the Graduate (G) reporting period, to include ‘Grad Only’ students.
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 | |
Schools for which to run?* | If run at the district level, choose one of the following:
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. | |
Current Selection Students | 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 report. | |
Report Start Date | Enter the start date for scanning school enrollments. Format: [M]M/[D]D/[YY]YY | |
Report End Date | Enter the end date for scanning school enrollments. Format: [M]M/[D]D/[YY]YY | |
Reporting Period | Select the reporting period for which you are creating the extract. | |
Fiscal Year | Enter the fiscal year for the report. | |
Scheduling | ||
Run Now | Select this option to execute the report in the order it is received in the report queue. | |
Schedule (available Version 7.1.1.) | Enter the start date and start time for the report.
|
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/ |
N/A | Filler | Filler | N/A | Numeric | 8 | 1–8 |
GI010 | Sort Type | The sort type equals GI for the Student Demographic extract. | N/A | Alpha-numeric | 2 | 9–10 |
N/A | Filler | Filler | N/A | Alpha-numeric | 1 | 11 |
GI020 | Fiscal Year | The fiscal year defaults to the current school year. | N/A | Alpha-numeric | 4 | 12–15 |
GI030 | Reporting Period | This is the reporting period selected on the Ohio Student Demographic Report page, Start Page > Reports > Run Reports > Student Demographic (GI) Report. | N/A | Alpha-numeric | 1 | 16 |
GI040 | Building IRN | This field contains the school building number. This value is extracted from the Building IRN field on the GI tab of the Ohio State Information page, Start Page > Student Selection > Ohio State Information > GI, if this field is not blank. If the Building IRN field is blank, the Alternate School ID value entered on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School, is extracted. If the Alternate School ID field is blank, the School Number value entered on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School, is extracted. | [Schools]Alternate_School_Number or [Students]SchoolID or [S_OH_STU_COMMON_X]Building_IRN (current year) or [S_OH_STU_COMMON_SNAP_C]Building_IRN (prior year)
| Alpha-numeric | 6 | 17–22 |
GI050 | EMIS Student ID Number | This field contains the EMIS student ID number assigned by the district to this student. This field value is extracted from the Student Number field on the General Demographics page, Start Page > Student Selection > General Demographics and prepended with the EMIS Prefix ID, if entered, else zeroes are added to create a 9-digit number. | [Students]Student_Number | Alpha-numeric | 9 | 23–31 |
GI070 | Date of Birth | This field contains the student’s date of birth. This field value is extracted from the DOB field on the General Demographics page, Start Page > Student Selection > General Demographics. | [Students]DOB | Numeric | 8 | 32–39 |
GI080 | Gender | This field contains the student’s gender. This field value is extracted from the Gender field on the General Demographics page, Start Page > Student Selection > General Demographics. | [Students]Gender | Alpha-numeric | 1 | 40 |
GI090 | Summative Racial/Ethnic Group | This field contains the value calculated based on the student’s Federal Ethnicity and Race values defined on the General Demographics page. Below are the calculation rules. If the Is the student Hispanic or Latino value is Y, the Summative Racial/Ethnic Group is H – Hispanic/Latino. If the Is the student Hispanic or Latino value is N, the What is the Student’s Race value displays in this field. If multiple race values are selected on the General Demographic page, this field defaults to M for Multi-racial. If the Is the student Hispanic or Latino value is Not Re-collected, this value defaults to the Scheduling/ Reporting Ethnicity value on the General Demographics page. This value is extracted from the GI tab of the Ohio State Information page, Start Page > Student Selection > Ohio State Information - Student Demographics Record (GI). | [Students]Summative_Ethnicity | Alpha-numeric | 1 | 41 |
N/A | Filler | Filler | N/A | Alpha-numeric | 23 | 42–64 |
GI270 | Native Language | This field contains the student’s native language. This value is extracted from the GI tab of the Ohio State Information page, Start Page > Student Selection > Ohio State Information - Student Demographics Record (GI). | [Students]primarylanguage | Alpha-numeric | 3 | 65–67 |
N/A | Filler | Filler | N/A | Alpha-numeric | 18 | 68–85 |
GI330 | First Name | This field contains the student’s first name. This value is extracted from the GI tab of the Ohio State Information page, Start Page > Student Selection > Ohio State Information - Student Demographics Record (GI). | [Students]LastFirst | Alpha-numeric | 30 | 86–115 |
GI340 | Middle Name | This field contains the student’s middle name. This value is extracted from the GI tab of the Ohio State Information page, Start Page > Student Selection > Ohio State Information - Student Demographics Record (GI). | [Students]Middle_Name | Alpha-numeric | 30 | 116–145 |
GI350 | Last Name | This field contains the student’s last name. This value is extracted from the GI tab of the Ohio State Information page, Start Page > Student Selection > Ohio State Information - Student Demographics Record (GI). | [Students]Last_Name | Alpha-numeric | 30 | 146–175 |
GI360 | Student Birth Place City | This field contains the name of the city where the student was born. This value is extracted from the GI tab of the Ohio State Information page, Start Page > Student Selection > Ohio State Information - Student Demographics Record (GI). | [S_OH_STU_SSID_X]Birth_Place_City (current year) or [S_OH_STU_SSID_SNAP_C]Birth_Place_City (prior year) | Alpha-numeric | 30 | 176–205 |
N/A | Filler | Filler | N/A | Alpha-numeric | 33 | 206–238 |
GI570 | Student Home Language | This field contains the language the student uses in their home environment. This value is extracted from the GI tab of the Ohio State Information page, Start Page > Student Selection > Ohio State Information - Student Demographics Record (GI). | [S_OH_STU_GI_X]Home_Language (current year) or [S_OH_STU_GI_SNAP_C]Home_Language (prior year) | Alpha-numeric | 3 | 239–241 |
GI580 | Hispanic/Latino | This field may contain one of the following values, based on the value assigned to the Is the student Hispanic or Latino field: Y if the assigned value is Y N if the assigned value is N * if the assigned value is Not re-collected This value is extracted the GI tab of the Ohio State Information page, Start Page > Student Selection > Ohio State Information - Student Demographics Record (GI). | [Students]FedEthnicity | Alpha-numeric | 1 | 242 |