Student Demographic (GI) Record

School Year

The school year you are running the download for. Typically, this matches the school year environment.

Note that when you select the Graduate reporting period, the school year changes to the year based on the Grad Period End Date in the EMIS Configuration. This allows you to process the Graduate submission without changing your environment to the prior year.

Download Period

Select the reporting period to process:

• Student/Student Cross Reference (S)

Download Period Window

This selection is active only for the Student/Student Cross Reference (S) and Student Records Exchange (X) download periods. The eTranscript (E) download period will not have this field active.

• Initial

• Midyear

• Final

Building List

Select the buildings to process.

Select codes from the drop-down list, or click Asterisk to select all codes, then remove any that do not apply.

Start Date / End Date

The date range you are running the download for. The values for these fields are entered in the EMIS Configuration. The text next to the field indicates the EMIS Configuration field used for the date. If the incorrect dates are displayed, you must update the EMIS Configuration.

• EOY Submission – Use the first day of school through the last day of school. (Not valid as of Fiscal Year 2014).

• Graduate Submission – Use the first day of school through the last day for summer graduates.

• Calendar, Student, Staff/Course, Grad Requirements Progress – Fiscal Year Start and End Dates from EMIS Configuration.

These fields are inactive for the March submission.

View Type

View type that you set up for Excused / Unexcused absences. Displays the values selected on the EMIS Configuration page.

Excused Absence Codes

Attendance codes that you set up in your view to convert your Excused Absence Codes to (EXC). Displays the values selected on the EMIS Configuration page.

Unexcused Absence Codes

Attendance codes that you set up in your view to convert your Unexcused Absence Codes to (UNX). Displays the values selected on the EMIS Configuration page.

Clear Options

Select the appropriate option:

• Do not delete any existing records - to insert only new records; it will not overwrite existing records in the download tables.

• Delete existing records for this year and reporting period, based on the selected filter criteria - to clear the records that match the filter you entered. If you are running a submission for 1 student, it will clear out the previous data for that student and create new records.

• Delete all existing records for this year and reporting period – to clear all records for the submission. This option clears out orphaned records in the download tables. For example, if a student has a record and you make changes to Entry/Withdrawal data so the download no longer selects the student, the student's existing record becomes an orphan record.

Process only changed records

Select if you want to only process FS/FD records that have changed since the last download.

Clear Overridden Records

Select if you want to re-build download data for download records that a user modified and set the Override box to selected. The records will be deleted and then built by the Student/Course Download.

Clear if you want to keep the download records when the Override checkbox is selected.

This checkbox is inactive if you select not to delete any existing records.

Scan Data While Processing

Select if you want to scan the data for errors and list the errors in the download log file.

Scan Downloaded Data

Select if you want to run the error scan immediately after the download records are created.

File Type

Select whether the errors should be listed in a PDF or CSV file. You can only access this field if you select Scan Downloaded Data.

Include Warnings

Select if you want to list errors that would be considered warnings. If you clear this checkbox and run the error scan, only fatal errors, such as missing data, will be reported. You can only access this field if you select Scan Downloaded Data.

Default Local Classroom Codes

Select if you want to default the local classroom code to the EMIS Course records without building download records. This checkbox is inactive if the Run Download option is selected because the Run Download always defaults the local classroom code to the EMIS Course records.

CORE Validation File

Select if you wish to create a CORE Validation file with the download. This will create 2 CSV files. One will provide totals for each CORE area, and the other will provide all the courses for each student with associated CORE areas. This field will only be active for submission periods that require the Student Graduation – Core Summary (GC) record.

Include In Progress Grades

Select if you want to populate the In Progress Grades. This field will only be active for the Staff (L) submission period that requires the Student Course Grade (FR) record.

Include Non-Credit Courses

Select if you want to populate the Non-Credit Courses. This field will only be active for the Staff (L) submission period that requires the Student Course Grade (FR) record.

Run Download

Select if you want to populate the download tables with data.

Task Name

If you want to rename the task and report file, change the text that displays in this field. If you use the / (slash) character, _ (underscore) will be used in the task and report name.

Download Types

Select each section that you want to include in the download. Only the selected sections will be generated. Refer to the EMIS Submission Files for a list of the records reported for a submission.

To create downloads for all of the submission's records, click Select All.

To select individual records to download, click Deselect All and then click the box for the desired records.

Number

Position

Name

PIC/Size

1-8

Filler

PIC 9(8)

GI010

9-10

Sort Type

PIC X(2)

Always “GI”

11

Filler

PIC X

GI020

12-15

Fiscal Year, e.g., 2020 (CCYY)

PIC X(4)

GI030

16

Data Sets

PIC X

G – Graduation

S – Student

GI040

17-22

Building IRN

PIC X(6)

GI050

23-31

EMIS Student ID Number

PIC X(9)

GI070

32-39

Date of Birth (CCYYMMDD)

PIC 9(8)

GI080

40

Gender

PIC X

GI090

41

Summative Racial/Ethnic Group

PIC X

42-64

Filler

PIC X(23)

GI270

65-67

Native Language

PIC X(3)

68-85

Filler

PIC X(18)

GI330

86-115

First Name (Optional)

PIC X(30)

GI340

116-145

Middle Name (Optional)

PIC X(30)

GI350

146-175

Last Name (Optional)

PIC X(30)

GI360

176-205

Student Birth Place City (Optional)

PIC X(30)

206-238

Filler

PIC X(33)

GI570

239-241

Student Home Language

PIC X(3)

GI580

242

Hispanic/Latino

PIC X

243-251

Filler

PIC X(9)

252-255

Filler

PIC X(4)

GI610

256-264

Local Use Identification Code

PIC X(9)