Gifted Students

Contents

Introduction

The Gifted Students report generates a comma separated (.csv) file containing one record for each student with a Gifted and Talented (GAT or Gifted) program status at any time during the collection period. This report is processed at the district-level for state reporting submission. The option to process for selected staff or for a single school is provided for troubleshooting purposes only.

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.

Special Education Selection

The report selects records from the [SpEnrollments] table based on the following criteria:

The student must be enrolled in a gifted and talented program (program name starts with GAT) during the specified reporting period.
The student’s last date of attendance must be on or after the report start date.
The student’s last date of attendance in a Special Program must be on or after the report start date.
The student must not be excluded from state reporting.
The school must not be excluded from state reporting.
The Special Program enrollment has a Program Name contains GAT or GIFTED.

Back to Top

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	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.
Select 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 a date using the format mm/dd/yyyy or mm-dd-yyyy for the first day of the report date range.
Report End Date	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy for the last day of the report date range.
Include Audit Fields	Choose Yes or No from the pop-up menu. The default option is No. Choosing Yes includes additional fields used for troubleshooting to identify data that may need to be modified prior to submitting the report to the state.
Validate Data	Choose Yes or No from the pop-up menu. The default option is Yes. Choosing No requires PowerSchool to validate whether the records meet the selection criteria listed above. The report returns a validation error if any of the selection criteria are not met.

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.

Item #	Data Element	Description	[Table]FieldName	Field Name	Field Path	Field Type	Field Length	Reqd
1	IDStuId	The Idaho student number.	[Students]State_StudentNumber			Varchar	9	Yes
2	servSchoolId	The school number. The service school ID is reported, if populated, otherwise, alternate school number is reported. If the service school ID and the alternative school number are not populated, then the school number is reported.	[S_ID_SEN_X]ServiceSchoolID [Schools]Alternate_School_Number [Schools]School_Number	Service School ID	Special Programs > Service School ID	Option Set	4	Yes
3	academicGift	The status for academically gifted.	[S_ID_SEN_X]AcademicGift	Academically Gifted	Special Programs > Gifted and Talented Student Flags	Option Set	1	Yes
4	creativeGift	The status for creatively gifted.	[S_ID_SEN_X]CreativeGift	Creatively Gifted	Special Programs > Gifted and Talented Student Flags	Option Set	1	Yes
5	intellectualGift	The status for intellectually gifted.	[S_ID_SEN_X]IntellectualGift	Intellectually Gifted	Special Programs > Gifted and Talented Student Flags	Option Set	1	Yes
6	leadershipGift	The status for leadership gifted.	[S_ID_SEN_X]LeadershipGift	Leadership Gifted	Special Programs > Gifted and Talented Student Flags	Option Set	1	Yes
7	artsGift	The status for visual/performing arts gifted.	[S_ID_SEN_X]ArtsGift	Visual/Performing Arts Gifted	Special Programs > Gifted and Talented Student Flags	Option Set	1	Yes
8	GTStatus	The status for the special program enrollment. This value is based on the student’s program and school enrollment dates. If the student is actively enrolled in the program on the last day of the report date range, then a value of “A” is reported for Active. If the student exited the program during the date range, without reenrolling in the same program, then a value of “I” is reported for inactive. Note: A value of “I” will be reported when the report is in EOY mode, and the SpEd program is either open-ended or has a date that ends beyond the end of the year.	[SpEnrollments]Enter_Date [SpEnrollments]Exit_Date			Option Set	1	Yes
9	GTEntryDate	The entry date for the gifted and talented program. Note: The first in-session day of school (based on the student’s entry date into school) will be returned if the program started in a previous school year.	[SpEnrollments]Enter_Date			Date	10	No
10	GTIdDate	The date the student was first identified as qualifying for gifted/talented.	[S_ID_SEN_X]GTIdDate	First Identified as Gifted/Talented	Special Programs > Gifted and Talented Student Flags	Date	10	Yes
11	GTExitDate	The date the student left gifted and talented services for the current school year. Note: If the program ends before the end of the school year, there will be an exit date present. In this scenario, this will be reported. If there's no exit date, or if the exit date is beyond the last day of the full-year term, and the record is current, report the last in-session day (based on the school calendar) of the full-year term.	[SpEnrollments]Exit_Date [Calendar_Day]Date			Date	10	No
12	GTExitReason	The exit reason for the gifted and talented program. Note: If there's no exit date, or if the exit date is beyond the last day of the full-year term, and the record is current, the report will automatically return an GTExitReason of 12 (Summer Break).	[SpEnrollments]ExitCode			Option Set	2	Cond
13	Notes	Comments or notes. This will always report as blank.	N/A			Varchar	250	No
14	CurrentSchoolID* Audit mode only	The student’s current school id.	[Students]SchoolID			N/A	N/A	N/A
15	LastFirst* Audit mode only	The student’s name.	[Students]LastFirst			N/A	N/A	N/A
16	LegalFirst* Audit mode only	The student's legal first name.	[StudentCoreFields]PSCore_Legal_First_Name			N/A	N/A	N/A
17	LegalLast* Audit mode only	The student's legal last name.	[StudentCoreFields]PSCore_Legal_Last_Name			N/A	N/A	N/A

Back to Top