GSA Validation
Contents
Introduction
Use this report to generate the General State Aid (GSA) extract file that is used to validate information for the GSA Report.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
For the GSA Validation report, student enrollment 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.
- The school must not be excluded from state reporting.
Student Selection
The report selects which student records to use based on the following criteria:
- The student must not be excluded from state reporting.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Use | If run at the district level, choose one of the following from the pop-up menu:
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. |
f | 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 runningreport. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2011 @ 10:05 AM. |
Select District | (Optional) If this option appears, select the District for which to run the report. |
Start Date | Enter the start date for the reporting period. Format: MM/DD/YYYY |
End Date | Enter the end date for the reporting period. Format: MM/DD/YYYY |
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.
Item # | Data Element | Description | [Table]FieldName | Field Type | Field Length |
1 | Student Last Name | This field contains the student’s first name. This field is extracted from the Name (last, first MI) field on the General Demographics page, Start Page > Student Selection > General Demographics. | [Students]Last_Name | Alpha-numeric | 35 |
2 | Student First Name | This field contains the student’s last name. This field is extracted from the Name field on the General Demographics page, Start Page > Student Selection > General Demographics. | [Students]First_Name | Alpha-numeric | 20 |
3 | Claimable/Non-Claimable | This field contains a C if this student’s attendance is claimable for state aid or an N if this student’s attendance is not claimable for state aid. This field is extracted from the Enrollment Type field on the Edit Current Enrollment page, Start Page > Student Selection > Transfer Information > Edit Current Enrollment. Note: If blank is found in the Enrollment Type field, “C” extracts rather than blank. | [Students]EnrollmentType [ReEnrollments]EnrollmentType | Alpha-numeric | 2 |
4 | Grade Level | This field contains the student’s grade level for the reporting period. This field is extracted from the Grade Level field on the General Demographics page, Start Page > Student Selection > General Demographics. | [Students]Grade_Level [S_IL_STU_ELL_X]Grade_Level [ReEnrollments]Grade_Level | Alpha-numeric | 2 |
5 | # Days Attended | This field is calculated. | N/A | N/A | N/A |
6 | Membership Share | This field contains the amount of a student’s membership for this enrollment. This field is extracted from the Membership Share field on the Illinois State Information General page, Start Page > Student Selection > Illinois State Information. | [Students]MembershipShare [ReEnrollments]MembershipShare | Numeric | 4 |
7 | Birthday | This field contains the student’s date of birth. This field is extracted from the DOB field on the General Demographics page, Start Page > Student Selection > General Demographics. | [Students]DOB | Numeric | 10 |
8 | IEP | This field contains a Y if the student has an Individualized Educational Plan (IEP) or an N if the student does not have an (IEP) This field is extracted from the IEP field on the Illinois State Information General page, Start Page > Student Selection > Illinois State Information. | [S_IL_STU_X]IEP | Numeric | 2 |
9 | School ID | This field contains the number identifying the school where the student is enrolled. This field is extracted from the School Number field on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School. | [Schools]School_number | Alpha-numeric | 9 |
10 | Age | This field is calculated. | N/A | N/A | N/A |
11 | Run Date | This field contains the date that the report was generated. | N/A | N/A | N/A |
12 | Dates Reported From / To | This field contains the Start Date and End Date entered on the GSA Validation Report page. | N/A | N/A | N/A |
13 | Total Claimable Days | This is a calculated field. It is the total number of attendance days that the school can claim for state aid. | N/A | N/A | N/A |
14 | Total Kindergarten – 12th Grade Claimable | These are calculated fields. It is the total number of attendance days, by grade level, that the school can claim for state aid. | N/A | N/A | N/A |
15 | Total Non-Claimable Days | This is a calculated field. It is the total number of attendance days that the school cannot claim for state aid. | N/A | N/A | N/A |
16 | Total Kindergarten – 12th Grade Claimable | These are calculated fields. It is the total number of attendance days, by grade level, that the school cannot claim for state aid. | N/A | N/A | N/A |