FTE October March Report (2018-19) - Legacy
Introduction
The FTE October/March Report extracts both basic and detailed student demographics.
The FTE October/March Report may be run in two different modes:
- FTE Cycle 1 (October)
- FTE Cycle 3 (March)
These reports use PS_AdaAdm_Defaults_All - This reporting view supports ADA/ADM calculation using default settings for all valid attendance mode and conversion mode combinations.
FTE October (Cycle 1) Report
The FTE October cycle 1 report includes both active and withdrawn students. The report extracts detailed student demographics, such as ESOL, diploma type, Transported Segments, Supplemental Speech Segments, and Inclusion Segments. The report also includes information for the federal December 1 count of students with disabilities, indicated by their Primary Area of Exceptionality (PAE). The report also includes course enrollment details such as Program Codes and Gifted Delivery Models.
FTE March (Cycle 3) Report
The FTE March cycle 3 report includes only active students. The report includes detailed student demographics, such as ESOL, diploma type, Transported Segments, Supplemental Speech Segments, and Inclusion Segments. The report also includes course enrollment details such as Program Codes and Gifted Delivery Models.
Selection Criteria
Selection criteria determine which database records are used in the report.
FTE October Student Selection
The report selects records from the [Students] or [ReEnrollments] table based on the following criteria:
- The student must not be excluded from state reporting.
- If the report is not run district wide, the student must be enrolled at one of the selected schools.
- The student must have an enrollment date in the current school year that is prior to or on the FTE count date.
- The student must meet one of the following criteria:
- The student must have an entry date before this year's FTE October Cycle 1 date and an exit date on or after this year's FTE October Cycle 1 date.
- The student must have been previously enrolled in the selected school with an entry date before this year's FTE October Cycle 1 date and an exit date between last Year's FTE October Cycle 1 date and this year's FTE October Cycle 1 date, and be marked as graduated from the selected school. Note that if the graduated students school is not set to exclude from state reporting, students will be reported as attending the graduated school.
- The student must have been previously enrolled in the selected school with an entry date before this year's FTE October Cycle 1 date and an exit date between last year's FTE October Cycle 1 date and this year's FTE October Cycle 1 date, and have no subsequent enrollment record in the district.
FTE March Student Selection
The report selects records from the [Students] or [ReEnrollments] table based on the following criteria:
- The student must be enrolled in the school chosen at report runtime.
- The student must be enrolled on this year's FTE March Cycle 3 date.
- The student must have an enrollment date in the current school year that is prior to or on the FTE count date.
- The student must not be excluded from state reporting.
- If the report is not run district wide, the student must be enrolled at one of the selected schools.
Report Input – Combined for All FTE Reports
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:
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 | Run the report for the current selection of students or all students. |
FTE Cycle | Choose the FTE Cycle of October or March. The report will contain the correct cycle period of 1 or 3. |
Current FTE date | Enter the FTE date for the current report cycle. Note: Enter the date in a format of MM/DD/YYYY. |
Previous Year FTE date Used for Cycle 1 (October) | Enter the FTE date for the previous school year. This field is required, but will not affect the results for the March (Cycle 3) report. Note: Enter the date in a format of MM/DD/YYYY. |
File Path and File Suffix | The File Path and File Suffix must both be valid in order to save the results to a location on the server. The File Name will be the district number, date, and time, in the format dddYYYYMMDDHHmi, followed by the provided file suffix. For example a report run at district 999 on August 1, 2014 at 9:15 AM with a suffix of _AAA.txt will save the results to a file named 999201408010915_AAA.txt in the provided location. If no path is given, or if PowerSchool is unable to write to the given folder, the report will run but will not be saved to the server. |
Use Last In-Session Date before the Exit Date as Withdrawal date | When this checkbox is selected, the report extracts any exiting student's withdrawal date as the last in-session day before the student's exit date. This prevents overlapping enrollment dates when a student withdraws from one school and enrolls in another on the same day. Note: Does not apply to No-Show students (Students with an Exit code of 'U' and Exit Date after last in-session date). |
SFTP connections | Choose the defined SFTP connection to use for sending the file to a remote location. |
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.
ID | Data Element | Description | [Table]FieldName | Length | FTE |
FTE001 | System | The school system code. Note: This is the district number in PowerSchool. | [Prefs]Value [Prefs]Name=districtnumber | 3 | 1,3 |
FTE002 | Fiscal Year | The fiscal year of the record. The report extracts the year from the last day in the current school calendar. | [Terms]LastDay | 2 | 1,3 |
FTE003 | Report Period | The FTE report period, depending on which report is run. | N/A | 1 | 1,3 |
Filler | Filler | Filler | N/A | 16 | 1,3 |
FTE005 | School Code | The school code. Note: If the HomeSchool Override Number is set up, it will be used. If not, the alternate school number is reported if populated. Otherwise, the school number is reported. | [S_GA_STU_X]SchoolNumberOverride [S_GA_REN_X]SchoolNumberOverride [Schools]Alternate_School_Number [Schools]School_Number | 4 | 1,3 |
FTE006 | Grade Level | The student’s grade level. | [Students]Grade_Level [ReEnrollments]Grade_Level | 2 | 1,3 |
Filler | Filler | Filler | N/A | 1 | 1,3 |
FTE007 | Prior Ten Days | Indicates whether the student has been present at least one of the 10 school days immediately preceding the FTE day. The report runs a PowerSchool ADA calculation to determine if the student was present at the school for 0.5 days or greater during the 10 days prior to this year’s FTE date, entered at report runtime. The calculation results in a value of Y or N. Y – Present at least 1 day of the 10 days prior to the FTE day. N – Not present any of the 10 days prior to the FTE day. To troubleshoot attendance, refer to guidance for troubleshooting attendance. As of January 2014 when duplicate attendance records cause the attendance query to fail, the report returns ‘X’ for the Prior Ten Days value. This value is invalid and will result in errors at the state. Note: When the report returns the value X, follow guidance for fixing duplicate attendance values. | [Attendance]Antedate [Attendance]StudentID | 1 | 1,3 |
FTE008 | Residence Status Code | Indicates the student’s residency status. | [S_GA_STU_X]ResStatusCode [S_GA_REN_X]ResStatusCode | 1 | 1,3 |
FTE009 | System of Residency | The home system (district) of the non-resident student. Blank if the Residence Status Code is 1. | [S_GA_STU_X]residencedistrict [S_GA_REN_X]ResidenceDistrict [Prefs]Value [Prefs]Name=districtnumber | 3 | 1,3 |
FTE010 | Program Code 1 | The FTE program for segment 1 of the school day. Program codes are calculated based on the course numbers and state specific course fields associated with the student’s course enrollments. See the Appendix for more details and a list of valid Program Codes. The following rules apply to all of the program codes:
| [S_GA_STU_SpecEd_X]PAE [S_GA_STU_FTE_X]ProgramCode1 or If [S_GA_STU_FTE_X]UseManual=1 Then [S_GA_STU_FTE_X]]ProgramCodeM1 | 1 | 1,3 |
FTE011 | Program Code 2 | The FTE program for segment 2 of the school day. For rules, see Program Code 1. | [S_GA_STU_FTE_X]ProgramCode2 [S_GA_STU_FTE_X]ProgramCodeM2(Manual Override) | 1 | 1,3 |
FTE012 | Program Code 3 | The FTE program for segment 3 of the school day. For rules, see Program Code 1. | [S_GA_STU_FTE_X]ProgramCode3 [S_GA_STU_FTE_X]]ProgramCodeM3 (Manual Override) | 1 | 1,3 |
FTE013 | Program Code 4 | The FTE program for segment 4 of the school day. For rules, see Program Code 1. | [S_GA_STU_FTE_X]ProgramCode4 [S_GA_STU_FTE_X]]ProgramCodeM4 (Manual Override) | 1 | 1,3 |
FTE014 | Program Code 5 | The FTE program for segment 5 of the school day. For rules, see Program Code 1. | [S_GA_STU_FTE_X]ProgramCode5 [S_GA_STU_FTE_X]]ProgramCodeM5 (Manual Override) | 1 | 1,3 |
FTE015 | Program Code 6 | The FTE program for segment 6 of the school day. For rules, see Program Code 1. | [S_GA_STU_FTE_X]ProgramCode6 [S_GA_STU_FTE_X]]ProgramCodeM6 (Manual Override) | 1 | 1,3 |
Filler | Filler | Filler | N/A | 1 | 1,3 |
FTE017 | Withdrawal Date | The date the student withdrew from school. This is usually the day after the student’s last day in class. This value is extracted from the Exit Date field on the Transfer Info student page if the student has a school enrollment that meets the following criteria:
Note: If Use Withdrawal Date as One day before Student Exit Date is selected in the report input, the report output displays the Withdrawal date as one in session day prior to the actual exit date. | [Students]ExitDate [ReEnrollments]ExitDate | 6 | 1 |
FTE018 | Location of Enrollment 1 | If the student has a dual enrollment, this field indicates where the student took the first of their dual courses. If the Use Manual Override checkbox is selected on the FTE Student Information page, the report will extract location of enrollment manually entered for students. This rule applies to all of the Location of Enrollment fields. | [S_GA_STU_FTE_X]LocationEnrollment1 [S_GA_CRS_X]LocEnroll [S_GA_SEC_X]LocEnroll or If [S_GA_STU_FTE_X]UseManual=1 Then [S_GA_STU_FTE_X]LocationEnrollmentM1 | 1 | 1,3 |
FTE019 | Location of Enrollment 2 | If the student has a dual enrollment, this field indicates where the student took their second dual course. For rules, see Location of Enrollment 1. | [S_GA_STU_FTE_X]LocationEnrollment2 [S_GA_CRS_X]LocEnroll [S_GA_SEC_X]LocEnroll [S_GA_STU_FTE_X]LocationEnrollmentM2 (Manual Override) | 1 | 1,3 |
FTE020 | Location of Enrollment 3 | If the student has a dual enrollment, this field indicates where the student took their third dual course. For rules, see Location of Enrollment 1. | [S_GA_STU_FTE_X]LocationEnrollment3 [S_GA_CRS_X]LocEnroll [S_GA_SEC_X]LocEnroll [S_GA_STU_FTE_X]LocationEnrollmentM3 (Manual Override) | 1 | 1,3 |
FTE021 | Location of Enrollment 4 | If the student has a dual enrollment, this field indicates where the student took their fourth dual course. For rules, see Location of Enrollment 1. | [S_GA_STU_FTE_X]LocationEnrollment4 [S_GA_CRS_X]LocEnroll [S_GA_SEC_X]LocEnroll [S_GA_STU_FTE_X]LocationEnrollmentM (Manual Override) | 1 | 1,3 |
FTE022 | Location of Enrollment 5 | If the student has a dual enrollment, this field indicates where the student took their fifth dual course. For rules, see Location of Enrollment 1. | [S_GA_STU_FTE_X]LocationEnrollment5 [S_GA_CRS_X]LocEnroll [S_GA_SEC_X]LocEnroll [S_GA_STU_FTE_X]LocationEnrollmentM5 (Manual Override) | 1 | 1,3 |
FTE023 | Location of Enrollment 6 | If the student has a dual enrollment, this field indicates where the student took their sixth dual course. For rules, see Location of Enrollment 1. | [S_GA_STU_FTE_X]LocationEnrollment6 [S_GA_CRS_X]LocEnroll [S_GA_SEC_X]LocEnroll [S_GA_STU_FTE_X]LocationEnrollmentM6 (Manual Override) | 1 | 1,3 |
FTE024 | Total Service Minutes | The total number of minutes for all IEP services which were in effect the week of the FTE count. Report for active students only. Exception Criteria: Students that meet the following criteria should not report TOTAL SERVICE MINUTES. Leave field null.
| [S_GA_STU_SPECED_X]SpedSvcMin [S_GA_REN_SPECED_X]SpedSvcMin | 5 | 1,3 |
Filler | Filler | Filler | N/A | 1 | 1,3 |
FTE030 | ESOL – Itinerant | The number of segments of English for Speakers of Other Languages (ESOL) for the student taught by an itinerant teacher. | [S_GA_STU_ESOL_C]Itin | 1 | 1,3 |
FTE031 | ESOL – Non-Itinerant | The number of segments of ESOL for the student taught by a non-itinerant teacher. | [S_GA_STU_ESOL_C]NonItin | 1 | 1,3 |
Filler | Filler | Filler | N/A | 1 | 1,3 |
FTE032 | Gender | The student’s gender. Note: The legal gender field is extracted, if populated. | [StudentCoreFields]PSCore_Legal_Gender [Students]Gender [ReEnrollments]Gender | 1 | 1,3 |
Filler | Filler | Filler | N/A | 1 | 1,3 |
FTE033 | Ethnic Hispanic | Indicates whether the student is Hispanic or Latino. | [Students]Fedethnicity | 1 | 1,3 |
FTE034 | Race Indian | Indicates whether the student is American Indian or Alaska Native. | [StudentRace]racecd [Gen]Cat=race [Gen]Cat=federalrace [Gen]Name=I | 1 | 1,3 |
FTE035 | Race Asian | Indicates whether the student is Asian. | [StudentRace]racecd [Gen]Cat=race [Gen]Cat=federalrace [Gen]Name=S | 1 | 1,3 |
FTE036 | Race Black | Indicates whether the student is African American. | [StudentRace]racecd [Gen]Cat=race [Gen]Cat=federalrace [Gen]Name=B | 1 | 1,3 |
FTE037 | Race Pacific | Indicates whether the student is New Hawaiian or Other Pacific Islander. | [StudentRace]racecd [Gen]Cat=race [Gen]Cat=federalrace [Gen]Name=P | 1 | 1,3 |
FTE038 | Race White | Indicates whether the student is Asian. | [StudentRace]racecd [Gen]Cat=race [Gen]Cat=federalrace [Gen]Name=W | 1 | 1,3 |
FTE039 | Withdrawal Reason | The reason the student withdrew or exited from the school. See the Appendix for a list of valid withdrawal/exit codes. This value is extracted from the Exit Code field on the Transfer Info student page if the student has a school enrollment that meets the following criteria:
| [Students]ExitCode [ReEnrollments]ExitCode | 1 | 1 |
FTE040 | Diploma Type | The type of the diploma earned for high school graduates. | [S_GA_STU_X]DiplomaType [S_GA_REN_X]DiplomaType | 1 | 1 |
FTE041 | Student Status | The student’s enrollment status. The report calculates the ‘W’ status based on the student’s enrollment dates and exit code. | [S_GA_STU_X]StudentStatus [S_GA_REN_X]StudentStatus | 1 | 1,3 |
FTE042 | School Entry Code | The reason the student enrolled in school. See the Appendix for a list of valid entry codes. This value is extracted from the Entry Code field on the Transfer Info student page if the student has a school enrollment that meets the following criteria:
| [Students]EntryCode [ReEnrollments]EntryCode | 1 | 1 |
FTE | Date of ELP Screener | Indicates the date the student was first tested for EL program eligibility. Note: Blank is a valid value. | [S_GA_STU_X]DateofELPScreener | 8 | 1 |
FTE | Date of Entry to U.S School | Indicates the date of entry to a United States school if the student‘s country of birth is not the U.S or Puerto Rico. Note: Blank is a valid value. | [Students]dateOfEntryIntoUSA | 8 | 1 |
FTE | Place of Birth | Indicates the student’s place of birth. Note: Must be one of the valid codes 0010-2460 or 9999. | [S_GA_STU_X]PlaceOfBirth | 4 | 1 |
FTE | Student Primary Language | Indicates the primary language spoken by the student. | [Students]PrimaryLanguage | 3 | 1 |
FTE043 | Environment | The type of residential environment in which the student resides. | [S_GA_STU_X]Residential_Environ [S_GA_REN_X]Residential_Environ | 1 | 1,3 |
Filler | Filler | Filler | N/A | 1 | 1,3 |
FTE044 | Report Type | Indicates whether the student receives Special Education services. The report extracts R for Regular Education if the student’s primary area of exceptionality is blank. The repot extracts S for Special Education if the report period is FTE 1 and FTE 3 and the following two criteria are met:
| [S_GA_STU_SpecEd_X]PAE [S_GA_REN_SpecEd_X]PAE [S_GA_STU_SpecEd_X]ExitDate [S_GA_REN_SpecEd_X]]ExitDate | 1 | 1,3 |
FTE045 | Date of Birth | The student’s date of birth. | [Students]DOB | 6 | 1,3 |
FTE046 | Transported Segment 1 | Indicates whether the student is transported from one instructional setting to another during segment 1 of the school day. If the Use Manual Override checkbox is selected on the FTE Student Information page, the report extracts the manually entered transported segment values. This rule applies to all of the transported segments. | [S_GA_STU_FTE_X]TransportedFlag1 or If [S_GA_STU_FTE_X]UseManual=1 Then [S_GA_STU_FTE_X]TransportedFlagM1 | 1 | 1,3 |
FTE047 | Transported Segment 2 | Indicates whether the student is transported from one instructional setting to another during segment 2 of the school day. For rules, see Transported Segment 1. | [S_GA_STU_FTE_X]TransportedFlag2 S_GA_STU_FTE_X]TransportedFlagM2 (Manual Override) | 1 | 1,3 |
FTE048 | Transported Segment 3 | Indicates whether the student is transported from one instructional setting to another during segment 3 of the school day. For rules, see Transported Segment 1. | [S_GA_STU_FTE_X]TransportedFlag3 [S_GA_STU_FTE_X]TransportedFlagM3 (Manual Override) | 1 | 1,3 |
FTE049 | Transported Segment 4 | Indicates whether the student is transported from one instructional setting to another during segment 4 of the school day. For rules, see Transported Segment 1. | [S_GA_STU_FTE_X]TransportedFlag4 [S_GA_STU_FTE_X]TransportedFlagM4 (Manual Override) | 1 | 1,3 |
FTE050 | Transported Segment 5 | Indicates whether the student is transported from one instructional setting to another during segment 5 of the school day. For rules, see Transported Segment 1. | [S_GA_STU_FTE_X]TransportedFlag5 [S_GA_STU_FTE_X]TransportedFlagM5 (Manual Override) | 1 | 1,3 |
FTE051 | Transported Segment 6 | Indicates whether the student is transported from one instructional setting to another during segment 6 of the school day. For rules, see Transported Segment 1. | [S_GA_STU_FTE_X]TransportedFlag6 [S_GA_STU_FTE_X]TransportedFlagM6 (Manual Override) | 1 | 1,3 |
FTE052 | Supplemental Speech Segment 1 | Indicates whether the student received supplemental speech services in segment 1. If the Use Manual Override checkbox is selected on the FTE Student Information page, the report extracts the manually entered supplemental speech values. This rule applies to all of the supplemental speech segments. | [S_GA_STU_FTE_X]SupplSpeechFlag1 or If [S_GA_STU_FTE_X]UseManual=1 Then [S_GA_STU_FTE_X]SupplSpeechFlagM1 | 1 | 1,3 |
FTE053 | Supplemental Speech Segment 2 | Indicates whether the student received supplemental speech services in segment 2. For rules, see Supplemental Speech Segment 1. | [S_GA_STU_FTE_X]SupplSpeechFlag2 S_GA_STU_FTE_X]SupplSpeechFlagM2 (Manual Override) | 1 | 1,3 |
FTE054 | Supplemental Speech Segment 3 | Indicates whether the student received supplemental speech services in segment 3. For rules, see Supplemental Speech Segment 1. | [S_GA_STU_FTE_X]SupplSpeechFlag3 S_GA_STU_FTE_X]SupplSpeechFlagM3 (Manual Override) | 1 | 1,3 |
FTE055 | Supplemental Speech Segment 4 | Indicates whether the student received supplemental speech services in segment 4. For rules, see Supplemental Speech Segment 1. | [S_GA_STU_FTE_X]SupplSpeechFlag4 S_GA_STU_FTE_X]SupplSpeechFlagM4 (Manual Override) | 1 | 1,3 |
FTE056 | Supplemental Speech Segment 5 | Indicates whether the student received supplemental speech services in segment 5. For rules, see Supplemental Speech Segment 1. | [S_GA_STU_FTE_X]SupplSpeechFlag5 S_GA_STU_FTE_X]SupplSpeechFlagM5 (Manual Override) | 1 | 1,3 |
FTE057 | Supplemental Speech Segment 6 | Indicates whether the student received supplemental speech services in segment 6. For rules, see Supplemental Speech Segment 1. | [S_GA_STU_FTE_X]SupplSpeechFlag6 S_GA_STU_FTE_X]SupplSpeechFlagM6 (Manual Override) | 1 | 1,3 |
FTE058 | Itinerant Teacher Segment 1 | Indicates whether the student received Special Education services by an itinerant teacher in segment 1. If the Use Manual Override checkbox is selected on the FTE Student Information page, the report extracts the manually entered itinerant values. This rule applies to all of the itinerant teacher segments. | [S_GA_STU_FTE_X]ItinerantTchFlag1 or If [S_GA_STU_FTE_X]UseManual=1 Then [S_GA_STU_FTE_X]ItinerantTchFlagM1 | 1 | 1,3 |
FTE059 | Itinerant Teacher Segment 2 | Indicates whether the student received Special Education services by an itinerant teacher in segment 2. For rules, see Itinerant Teacher Segment 1. | [S_GA_STU_FTE_X]ItinerantTchFlag2 [S_GA_STU_FTE_X]ItinerantTchFlagM2 (Manual Override) | 1 | 1,3 |
FTE060 | Itinerant Teacher Segment 3 | Indicates whether the student received Special Education services by an itinerant teacher in segment 3. For rules, see Itinerant Teacher Segment 1. | [S_GA_STU_FTE_X]ItinerantTchFlag3 [S_GA_STU_FTE_X]ItinerantTchFlagM3 (Manual Override) | 1 | 1,3 |
FTE061 | Itinerant Teacher Segment 4 | Indicates whether the student received Special Education services by an itinerant teacher in segment 4. For rules, see Itinerant Teacher Segment 1. | [S_GA_STU_FTE_X]ItinerantTchFlag4 [S_GA_STU_FTE_X]ItinerantTchFlagM4 (Manual Override) | 1 | 1,3 |
FTE062 | Itinerant Teacher Segment 5 | Indicates whether the student received Special Education services by an itinerant teacher in segment 5. For rules, see Itinerant Teacher Segment 1. | [S_GA_STU_FTE_X]ItinerantTchFlag5 [S_GA_STU_FTE_X]ItinerantTchFlagM5 (Manual Override) | 1 | 1,3 |
FTE063 | Itinerant Teacher Segment 6 | Indicates whether the student received Special Education services by an itinerant teacher in segment 6. For rules, see Itinerant Teacher Segment 1. | [S_GA_STU_FTE_X]ItinerantTchFlag6 [S_GA_STU_FTE_X]ItinerantTchFlagM6 (Manual Override) | 1 | 1,3 |
FTE064 | Inclusion Segment 1 | Indicates whether the student received Regular Education services in segment 1 via the Inclusion model. If the Use Manual Override checkbox is selected on the FTE Student Information page, the report extracts the manually entered inclusion values. This rule applies to all of the inclusion segments. | [S_GA_STU_FTE_X]InclusionCode1 or If [S_GA_STU_FTE_X]UseManual=1 Then [S_GA_STU_FTE_X]InclusionCodeM1 | 1 | 1,3 |
FTE065 | Inclusion Segment 2 | Indicates whether the student received Regular Education services in segment 2 via the Inclusion model. For rules, see Inclusion Segment 1. | [S_GA_STU_FTE_X]InclusionCode2 [S_GA_STU_FTE_X]InclusionCodeM2 (Manual Override) | 1 | 1,3 |
FTE066 | Inclusion Segment 3 | Indicates whether the student received Regular Education services in segment 3 via the Inclusion model. For rules, see Inclusion Segment 1. | [S_GA_STU_FTE_X]InclusionCode3 [S_GA_STU_FTE_X]InclusionCodeM3 (Manual Override) | 1 | 1,3 |
FTE067 | Inclusion Segment 4 | Indicates whether the student received Regular Education services in segment 4 via the Inclusion model. For rules, see Inclusion Segment 1. | [S_GA_STU_FTE_X]InclusionCode4 [S_GA_STU_FTE_X]InclusionCodeM4 (Manual Override) | 1 | 1,3 |
FTE068 | Inclusion Segment 5 | Indicates whether the student received Regular Education services in segment 5 via the Inclusion model. For rules, see Inclusion Segment 1. | [S_GA_STU_FTE_X]InclusionCode5 [S_GA_STU_FTE_X]InclusionCodeM5 (Manual Override) | 1 | 1,3 |
FTE069 | Inclusion Segment 6 | Indicates whether the student received Regular Education services in segment 6 via the Inclusion model. For rules, see Inclusion Segment 1. | [S_GA_STU_FTE_X]InclusionCode6 [S_GA_STU_FTE_X]InclusionCodeM6 (Manual Override) | 1 | 1,3 |
Filler | Filler | Filler | N/A | 1 | 1,3 |
FTE070 | Special Ed Services P | The number of hours per week the student is currently recieving for Mild Intellectual Disability (P). This value is extracted if the following criteria are met:
| [S_GA_STU_SpecEdHrs_X]HPWP [S_GA_REN_SpecEdHrs_X]HPWP [S_GA_STU_SpecEd_X]All_IEP [S_GA_REN_SpecEd_X]All_IEP [S_GA_STU_SpecEd_X]Environment [S_GA_REN_SpecEd_X]Environment | 1 | 1 |
FTE071 | Special Ed Services Q | The number of hours per week the student is currently receiving for Moderate Intellectual Disability (Q).
| [S_GA_STU_SpecEdHrs_X]HPWQ [S_GA_REN_SpecEdHrs_X]HPWQ | 1 | 1 |
FTE072 | Special Ed Services R | The number of hours per week the student is served for Severe Intellectual Disability (R).
| [S_GA_STU_SpecEdHrs_X]HPWR [S_GA_REN_SpecEdHrs_X]HPWR | 1 | 1 |
FTE073 | Special Ed Services S | The number of hours per week the student is served for Profound Intellectual Disability (S).
| [S_GA_STU_SpecEdHrs_X]HPWS [S_GA_REN_SpecEdHrs_X]HPWS | 1 | 1 |
FTE074 | Special Ed Services T | The number of hours per week the student is served for Emotional / Behavioral Disorder (T).
| [S_GA_STU_SpecEdHrs_X]HPWT [S_GA_REN_SpecEdHrs_X]HPWT | 1 | 1 |
FTE075 | Special Ed Services U | The number of hours per week the student is served for Specific Learning Disability (U).
| [S_GA_STU_SpecEdHrs_X]HPWU [S_GA_REN_SpecEdHrs_X]HPWU | 1 | 1 |
FTE076 | Special Ed Services V | The number of hours per week the student is served for Orthopedic Impairment (V).
| [S_GA_STU_SpecEdHrs_X]HPWV [S_GA_REN_SpecEdHrs_X]HPWV | 1 | 1 |
FTE077 | Special Ed Services W | The number of hours per week the student is served for Hearing Impairment (W).
| [S_GA_STU_SpecEdHrs_X]HPWW [S_GA_REN_SpecEdHrs_X]HPWV | 1 | 1 |
FTE078 | Special Ed Services X | The number of hours per week the student is served for Deaf (X).
| [S_GA_STU_SpecEdHrs_X]HPWX [S_GA_REN_SpecEdHrs_X]HPWX | 1 | 1 |
FTE079 | Special Ed Services Y | The number of hours per week the student is served for Other Health Impairment (Y).
| [S_GA_STU_SpecEdHrs_X]HPWY [S_GA_REN_SpecEdHrs_X]HPWY | 1 | 1 |
FTE080 | Special Ed Services Z | The number of hours per week the student is served for Visual Impairment (Z).
| [S_GA_STU_SpecEdHrs_X]HPWZ [S_GA_REN_SpecEdHrs_X]HPWZ | 1 | 1 |
FTE081 | Special Ed Services 1 | The number of hours per week the student is served for Blind (1).
| [S_GA_STU_SpecEdHrs_X]HPW1 [S_GA_REN_SpecEdHrs_X]HPW1 | 1 | 1 |
FTE082 | Special Ed Services 2 | The number of hours per week the student is served for Deaf and Blind (2).
| [S_GA_STU_SpecEdHrs_X]HPW2 [S_GA_REN_SpecEdHrs_X]HPW2 | 1 | 1 |
FTE083 | Special Ed Services 3 | The number of hours per week the student is served for Speech / Language Impairment (3).
| [S_GA_STU_SpecEdHrs_X]HPW3 [S_GA_REN_SpecEdHrs_X]HPW3 | 1 | 1 |
FTE084 | Special Ed Services 6 | The number of hours per week the student is served for Autism (6).
| [S_GA_STU_SpecEdHrs_X]HPW6 [S_GA_REN_SpecEdHrs_X]HPW6 | 1 | 1 |
FTE085 | Special Ed Services 7 | The number of hours per week the student is served for Traumatic Brain Injury (7).
| [S_GA_STU_SpecEdHrs_X]HPW7 [S_GA_REN_SpecEdHrs_X]HPW7 | 1 | 1 |
FTE086 | Special Ed Services 8 | The number of hours per week the student is served for Preschool Special Education/SSD (8).
| [S_GA_STU_SpecEdHrs_X]HPW8 [S_GA_REN_SpecEdHrs_X]HPW8 | 1 | 1 |
FTE | Non-ESOL | Indicates the status of an EL student who is not in ESOL program. | [S_GA_STU_ESOL_C]Refused | 1 | 1 |
FTE087 | Primary Area | The student’s Primary Area of Exceptionality (PAE). | [S_GA_STU_SpecEd_X]PAE [S_GA_REN_SpecEd_X]PAE | 1 | 1 |
FTE088 | Related Special Ed Services A | The number of hours per week the student is currently receiving in direct adapted PE services.
| [S_GA_STU_SpecEdHrs_X]RelHoursA [S_GA_REN_SpecEdHrs_X]RelHoursA | 1 | 1 |
FTE089 | Related Special Ed Services B | The number of hours per week the student received Audiology services.
| [S_GA_STU_SpecEdHrs_X]RelHoursB [S_GA_REN_SpecEdHrs_X]RelHoursB | 1 | 1 |
FTE090 | Related Special Ed Services C | The number of hours per week the student received Counseling.
| [S_GA_STU_SpecEdHrs_X]RelHoursC [S_GA_REN_SpecEdHrs_X]RelHoursC | 1 | 1 |
FTE091 | Related Special Ed Services D | The number of hours per week the student received Diagnostic services.
| [S_GA_STU_SpecEdHrs_X]RelHoursD [S_GA_REN_SpecEdHrs_X]RelHoursD | 1 | 1 |
FTE092 | Related Special Ed Services E | The number of hours per week the student received Occupational Therapy services.
| [S_GA_STU_SpecEdHrs_X]RelHoursE [S_GA_REN_SpecEdHrs_X]RelHoursE | 1 | 1 |
FTE093 | Related Special Ed Services F | The number of hours per week the student received Physical Therapy services.
| [S_GA_STU_SpecEdHrs_X]RelHoursF [S_GA_REN_SpecEdHrs_X]RelHoursF | 1 | 1 |
FTE094 | Related Special Ed Services G | The number of hours per week the student received Psychological services.
| [S_GA_STU_SpecEdHrs_X]RelHoursG [S_GA_REN_SpecEdHrs_X]RelHoursG | 1 | 1 |
FTE095 | Related Special Ed Services H | The number of hours per week the student received Interpreter services.
| [S_GA_STU_SpecEdHrs_X]RelHoursH [S_GA_REN_SpecEdHrs_X]RelHoursH | 1 | 1 |
FTE096 | Related Special Ed Services I | The number of hours per week the student received School Health / Nursing services.
| [S_GA_STU_SpecEdHrs_X]RelHoursI [S_GA_REN_SpecEdHrs_X]RelHoursI | 1 | 1 |
FTE097 | Related Special Ed Services J | The number of hours per week the student received School Social Work services.
| [S_GA_STU_SpecEdHrs_X]RelHoursJ [S_GA_REN_SpecEdHrs_X]RelHoursJ | 1 | 1 |
FTE098 | Related Special Ed Services K | The number of hours per week the student received Special Transportation services.
| [S_GA_STU_SpecEdHrs_X]RelHoursK [S_GA_REN_SpecEdHrs_X]RelHoursK | 1 | 1 |
FTE099 | Related Special Ed Services L | The number of hours per week the student received Orientation and Mobility services.
| [S_GA_STU_SpecEdHrs_X]RelHoursL [S_GA_REN_SpecEdHrs_X]RelHoursL | 1 | 1 |
FTE | U.S School Less Than Three (3) Years | Indicates whether the student has been enrolled in a U.S. school for less than three years. | Calculated [Students]dateOfEntryIntoUSA | 1 | 1 |
FTE | Parent Communication Language | Indicates the preferred language for parental communications. | [S_GA_STU_X]ParentCommunicationLang | 3 | 1 |
FTE100 | All IEP Services | Indicates whether the student receives all services identified in the Individual Education Plan (IEP) or Service Plan. Note: This field is blank for inactive students. | [S_GA_STU_SpecEd_X]All_IEP [S_GA_REN_SpecEd_X]All_IEP | 1 | 1,3 |
FTE101 | English Learner (EL) | Indicates whether the student has limited proficiency in English. | [S_GA_STU_ESOL_C]ELFlag | 1 | 1,3 |
FTE102 | Special Ed Environment | The student’s type of educational placement. Note: The report extracts the values 0-9 for students greater than five years of age as of the October count day, and A-J for students younger than five as of September 1st. | [S_GA_STU_SpecEd_X]Environment [[S_GA_REN_SpecEd_X]]Environment | 1 | 1 |
FTE103 | GTID | The student’s Georgia Testing Identifier. | [Students]State_StudentNumber | 10 | 1,3 |
FTE104 | Gifted Delivery Model 1 | The type of delivery for gifted services. This value is extracted if the student’s exit date occurs on or after this year’s FTE date. If the Use Manual Override checkbox is selected on the FTE Student Information page, the report extracts the manually entered gifted delivery model values. This rule applies to all of the gifted delivery model segments. | [S_GA_STU_FTE_X]GiftedDeliveryModel1 or If [S_GA_STU_FTE_X]UseManual=1 Then [S_GA_STU_FTE_X]GiftedDeliveryModelM1 | 1 | 1,3 |
FTE105 | Gifted Delivery Model 2 | The type of delivery for gifted services. For rules, see Gifted Delivery Model 1. | [S_GA_STU_FTE_X]GiftedDeliveryModel2 [S_GA_STU_FTE_X]GiftedDeliveryModelM2 (Manual Override) | 1 | 1,3 |
FTE106 | Gifted Delivery Model 3 | The type of delivery for gifted services. For rules, see Gifted Delivery Model 1. | [S_GA_STU_FTE_X]GiftedDeliveryModel3 [S_GA_STU_FTE_X]GiftedDeliveryModelM3 (Manual Override) | 1 | 1,3 |
FTE107 | Gifted Delivery Model 4 | The type of delivery for gifted services. For rules, see Gifted Delivery Model 1. | [S_GA_STU_FTE_X]GiftedDeliveryModel4 [S_GA_STU_FTE_X]GiftedDeliveryModelM4 (Manual Override) | 1 | 1,3 |
FTE108 | Gifted Delivery Model 5 | The type of delivery for gifted services. For rules, see Gifted Delivery Model 1. | [S_GA_STU_FTE_X]GiftedDeliveryModel5 [S_GA_STU_FTE_X]GiftedDeliveryModelM5 (Manual Override) | 1 | 1,3 |
FTE109 | Gifted Delivery Model 6 | The type of delivery for gifted services. For rules, see Gifted Delivery Model 1. | [S_GA_STU_FTE_X]GiftedDeliveryModel6 [S_GA_STU_FTE_X]GiftedDeliveryModelM6 (Manual Override) | 1 | 1,3 |
FTE110 | Event Code | Indicates if the student exited special education between last year’s FTE date and this year’s FTE date. This value is reported if the student has an Event Code of 09 (Special Education Exit), 10 (Parent Revoked Consent), or 13 (District verified that the student was incorrectly reported as SWD in a prior year) via Start Page > Student > State/Province – GA > Special Education (G01) > Special Education Activity. The student is reported as exiting special education in FTE 1 if the event date is within the current fiscal year and before the current fiscal year FTE Cycle-1 count date. The value on the student’s Special Education Information page is used when both a Special Education Exit Code and Special Education Exit Date are entered, and no Special Education event of code 09, 10, or 13 is found as described above. Special Education Exit Codes other than 9, 10, or 13 are reported as 09. | [S_GA_STU_SpecialEd_C]EventCode [S_GA_STU_SpecEd_X]ExitCode [S_GA_REN_SpecEd_X]ExitCode | 2 | 1 |
FTE111 | Event Date | The date the student exited special education, if applicable. The date must be between last year’s FTE date and this year’s FTE date. The value on the student’s Special Education Information page is used when both a Special Education Exit Code and Special Education Exit Date are entered, and no Special Education event of code 09, 10, or 13 is found as described above. The student is reported as exiting special education in FTE 1 if the event date is within the current fiscal year and before the current fiscal year FTE Cycle-1 count date. | [S_GA_STU_SpecialEd_C]EventDate [S_GA_STU_SpecEd_X]ExitDate [S_GA_REN_SpecEd_X]ExitCode | 8 | 1 |
FTE112 | Filler | Filler | N/A | 3 | 1,3 |
FTE114 | School Entry Date | Date of the student’s entry into the school this school year. Must be a valid date in the fiscal year. The date must be in the school calendar. The School Entry Date is only pulled for active students. | 8 | 1,3 | |
Filler | Filler | Filler | N/A | 2 | 1,3 |
FTE115 | Last Name | The student’s last name. Note: The legal last name field is extracted, if populated. | [StudentCoreFields]PSCore_Legal_Last_Name [Students]Last_Name | 30 | 1,3 |
FTE116 | First Name | The student’s first name. Note: The legal first name field is extracted, if populated. | [StudentCoreFields]PSCore_Legal_First_Name [Students]First_Name | 30 | 1,3 |
FTE117 | Filler | Filler (was Dual Enrollment Type prior to 2015-2016) | N/A | 13 | 1,3 |
FTE124 | Middle Name | The Student’s middle name. Note: The legal middle name is extracted, if populated. | [StudentCoreFields]PSCore_Legal_Middle_Name [Students]Middle_Name | 30 | 1,3 |
Filler | Filler | Filler | N/A | 20 | 1,3 |