(GQ) Student Program 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.

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

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.

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

GQ010

Sort Type

The sort type equals GQ for the Student Program extract.

N/A

Alpha-numeric

2

9–10

N/A

Filler

Filler

N/A

Alpha-numeric

1

11

GQ020

Fiscal Year

The fiscal year is set by report input.

N/A

Alpha-numeric

4

12–15

GQ030

Data Set

This is the reporting period set by report input.

N/A

Alpha-numeric

1

16

GQ040

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

[Schools]School_Number

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

GQ050

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

GQ060

Program Code

This field contains the code that identifies the program in which this student is eligible to participate or currently participates. This field value is extracted from the Program ID field on the Special Program Information page, Start Page > District > Courses and Programs > All Student Programs.

[S_OH_GEN_X]ProgramID

Alpha-numeric

6

32–37

GQ070

Employee ID

This field contains the unique nine-character code assigned to the staff member providing the program. This field is required only when reporting 206xxx Gifted Education Services program codes (services provided by a Gifted Intervention Specialist). Do not report the Employee ID for non-gifted program codes. This field value is extracted from the Employee ID field on the New/Edit Student Program Enrollment page, Start Page > Student Selection > Student Programs > [New/Edit]Student Program Enrollment.

[SPENROLLMENTS.S_OH_SEN_X]Employee_Id_Program

Alpha-numeric

9

38–46

N/A

Filler

Filler

N/A

Alpha-numeric

6

47–52

GQ090

Program Provider IRN

This field contains the IRN number of the program provider. This field value is extracted from the New/Edit Student Program Enrollment page, Start Page > Student Selection > Student Programs > [New/Edit] Student Program Enrollment.

[SPENROLLMENTS.S_OH_SEN_X]Program_Provider_IRN

Alpha-numeric

6

53–58

GQ100

Program Enrollment Start Date

This field contains the first day a student is enrolled in a program where dates are required. This field value is extracted from the New/Edit Student Program Enrollment page, Start Page > Student Selection > Student Programs > [New/Edit] Student Program Enrollment.

[SpEnrollments]Enter_Date

Numeric

8

59–66

GQ110

Program Enrollment End Date

This field contains the last day a student is enrolled in a program where dates are required. This field value is extracted from the New/Edit Student Program Enrollment page, Start Page > Student Selection > Student Programs > [New/Edit] Student Program Enrollment.

[SpEnrollments]Exit_Date

Numeric

8

67–74