(GI) Student Demographic Record

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.

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 is set by report input.

N/A

Alpha-numeric

4

12–15

GI030

Data Set

This is the reporting period set by report input.

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 page of the State/Province- OH page, Student Selection > State/Province - OH > 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, District Management > School Info > Edit School, is extracted.

If the Alternate School ID field is blank, the School Number value entered on the Edit School page, District Management > 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 Student Profile > Demographics page, 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 Demographics page, Student Selection > Student Profile > 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 Demographics page, Student Selection > Student Profile > 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 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 and no race checkbox are identified, this value defaults to the Scheduling/ Reporting Ethnicity value on the General Demographics page.

This value is extracted from the GI page of the State/Province OH menu, Student Selection > State/Province - OH > (GI) Student Demographic Record.

[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 page of the State/Province OH menu, Student Selection > State/Province - OH > (GI) Student Demographic Record.

[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 page of the State/Province OH menu, Student Selection > State/Province - OH > (GI) Student Demographic Record.

[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 page of the State/Province OH menu, Student Selection > State/Province - OH > (GI) Student Demographic Record.

[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 page of the State/Province OH menu, Student Selection > State/Province - OH > (GI) Student Demographic Record.

[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 page of the State/Province OH menu, Student Selection > State/Province - OH > (GI) Student Demographic Record.

[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 page of the State/Province OH menu, Student Selection > State/Province - OH > (GI) Student Demographic Record.

[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 from the GI page of the State/Province OH menu, Student Selection > State/Province - OH > (GI) Student Demographic Record.

[Students]FedEthnicity

Alpha-numeric

1

242