Tool Search: ISEE Extracts
The Gifted and Talented Students extract reports active and inactive Gifted and Talented Students.
- Active Gifted and Talented students have a locked PLP with a plan label of Gifted/Talented that is active during the entire reporting date range or starts during the date range and remains active.
- Inactive Gifted and Talented students have a locked PLP active at least one day during the date range AND a Gifted Program Exit Date during the date range.
To report, PLPs must have a Plan Label of Gifted/Talented and are expected to include a Service with a Service Type of 26, 27, 28, 29, or 30.
ISEE Extrac EditorGifted and Talented Students Extract Logic
- For each reportable student, one record reports for each reportable PLP:
- A Reportable Student is one who:
- Has at least one enrollment in the selected calendar(s) active during the reporting date range that:
- Is not marked as No Show or State Exclude and is not in a Grade Level or Calendar marked as State Exclude and
- Has a Service Type of P: Primary or S: Partial
- Has at least one enrollment in the selected calendar(s) active during the reporting date range that:
- A Reportable PLP is one that:
- Is active during the reporting date range,
- Has a Plan Type of Gifted and Talented and
- Is a Locked idPLP active on at least one day in the reporting date range.
- A Reportable Student is one who:
- Should the student transition schools during the reporting year, the plan from the first school should have an End Date and a new plan should be created at the new school.
- An Active student should only report one record per PLP unless the student has two Plans that are active and locked during the date range; i.e., the Plan is renewed/changed during the reporting period) then report one record for each plan. PLPs must have a Plan Label of "Gifted/Talented".
- If a student has more than 10 reportable services during the date range, only the first 10 report. The "first 10" are defined as those with the earliest start date. If all have the same start date, then those with the greatest number of minutes. If all have the same number of minutes, then the first 10 codes numerically.
Report Editor Field Descriptions
Field | Description |
|---|---|
Report Type | Select Gifted and Talented Students. The following ISEE extract types are also available: |
Start Date | The earliest date from which data is pulled for the report. (Required) |
End Date | The latest date from which data is pulled for the report. (Required) |
Ad Hoc Filter | This field allows users to use an Ad hoc filter that was created in the Ad hoc Filter Designer. Only one Ad hoc filter may be selected. |
Format | The format in which the report will generate. Options include CSV (State Format) and HTML. |
Select Calendars | The calendar(s) from which data is pulled for the report. Can be set to display only the active year's calendars, or be sorted by school or by year. |
Batch Queue | Users have the option of submitting a District Calendar report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
Gifted and Talented Students Extract Layout
Column | Description & Format | Campus Location |
|---|---|---|
idStuId | The student's unique Idaho Student Identification Number. Numeric, 9 digits | Census > People > Demographics > Person Identifiers > Student State ID Person.stateID |
servSchoolId | The school where the student receives their education. Reports the Serving School Override entered on the Enrollment Status editor of the student's PLP. Otherwise reports the State School Number based on the School Name entered on the Student Demographics editor of the PLP. If School Name is not populated on the PLP, reports the State School Number based on the student's primary enrollment active on the PLP End Date or the extract End Date, whichever comes first. Numeric, 4 digits | Student Information > Special Ed > Documents > Plan > Education Plan > Serving School OR System Administration > Resources > School > State School Number School.schoolNumber |
academicGift | Indicates whether the student is academically gifted. Reports if the student has active service of 26: Gifted Talented: Academic during the reporting date range. Y or N, 1 character | Student Information > PLP PlanService.stateCodePLP |
creativeGift | Indicates whether the student is creatively gifted. Reports if the student has an active service of 29: Gifted Talented: Creativity during the reporting date range. Y or N, 1 character | Student Information > PLP PlanService.stateCodePLP |
intellectualGift | Indicates whether the student is intellectually gifted. Reports if the student has an active service of 30: Gifted Talented: Intellectual during the reporting date range. Y or N, 1 character | Student Information > PLP PlanService.stateCodePLP |
leadershipGift | Indicates whether the student is gifted in the area of leadership. Reports if the student ahs an active service of 28: Gifted Talented: Leadership during the reporting date range. Y or N, 1 character | Student Information > PLP PlanService.stateCodePLP |
artsGift | Indicates whether the student is gifted in the visual or performing arts. Y or N, 1 character | Student Information > PLP PlanService.stateCodePLP |
GTStatus | This field indicates whether the student is an active (A) or inactive (I) Gifted/Talented student. Reports as A if the student has a locked idPLP or a locked State Reporting Data Entry PLP that is active during the entire reporting date range, or starts during the date range and remains active. Otherwise reports as I. Alphanumeric, 1 character | Student Information > PLP > Documents > Education Plan > Start Date, Program Exit Date Plan.startDate Plan.giftedexitDate |
GTEntryDate | The date the student first received services for gifted/talented students. This field reports the date from the active, locked PLP with a Plan Label of "Gifted/Talented." Date Field, 10 characters, MM/DD/YYYY | Student Information > PLP > Documents > Education Plan > Start Date Plan.startDate |
GTIdDate | Identifies the earliest start date of a locked PLP with a Plan Label of "Gifted/Talented." Date Field, 10 characters, MM/DD/YYYY | Student Information > PLP > Documents > Education Plan > Start Date Plan.startDate |
GTExitDate | If the student is inactive, the date they left the gifted/talented program. Reports the Plan Exit Date from the student's reportable PLP. Otherwise reports as null. Date Field, 10 characters, MM/DD/YYYY | Student Information > PLP > Documents > Education Plan > Program Exit Date Plan.giftedExitDate |
GTExitReason | If the student is Inactive, the reason that they are now inactive. Otherwise reports as null. See options in the following Exit Reason Options table. Numeric, 2 digits | Student Information > PLP > Documents > Education Plan > Program Exit Reason Plan.giftedExitReason |
GT Exit Reason Options
Code | Options |
|---|---|
01 | Graduate - Met Regular Requirements |
02 | Graduate - Met Reduced Requirements |
03 | Certificate of Completion/Attendance |
04 | Reached Maximum Age |
05 | Dropped Out |
06 | Transfer to Another Education Environment |
07 | No Longer Eligible for Program |
08 | Deceased |
| 12 | Summer Break |
