Skip to main content
Skip table of contents

(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:

  • Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report
  • All Schools – Run the report for the entire district.

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:

  • The selected [number] students only – Run the report for students in the current selection.
  • All students – Run the report for all students in the current school or district that meet the selection criteria.

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.

  • Select Run Once and Submit to run the report at the specified date and time.
  • Select Repeat to set future dates (Daily, Weekly, Monthly, Yearly) and Submit.

Back to Top

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

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

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.