FTE October March Report 2020-21 - Legacy
Introduction
The FTE October/March Report extracts both basic and detailed student demographics.
The FTE October/March Report can 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 contains detailed student demographics, such as ESOL, Diploma Type, Transported Segments, Supplemental Speech Segments, and Inclusion Segments. The report also contains 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.
When the student status in Current/Previous enrollment is Child Find, then report type will extract value S.
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. |
Current FTE date | Enter the FTE date for the current report cycle. |
FTE Cycle | Choose the FTE Cycle of October or March. The report will contain the correct cycle period of 1 or 3. |
Previous Year FTE date Used for Cycle 1 (October) | Enter the FTE date for the previous school year. Note: This field is required, but will not affect the results in the March (Cycle 3) report |
File Path | The File Name is 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 option 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: This option does not apply to No-Show students (students with an Exit code of 'U' and Exit Date after the last in-session date). |
File Suffix | The provided file suffix for the file path (see above). |
SFTP connections | Choose the defined SFTP connection to use for sending the file to a remote location or leave as (Disable). |
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 Cycle | Start & End Positions | |
---|---|---|---|---|---|---|---|
FTE001 | System | The school system code. Note: This is the district number in PowerSchool. | [Prefs]Value [Prefs]Name=districtnumber | 3 | 1,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 | 4 | 5 |
FTE003 | Report Period | The FTE report period, depending on which report is run. | N/A | 1 | 1,3 | 6 | 6 |
Filler | Filler | Filler | N/A | 16 | 1,3 | 7 | 22 |
FTE005 | School Code | The school code. Note: If the HomeSchool Override Number is set up, that number used; if not, the alternate school number is reported; 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 | 23 | 26 |
FTE006 | Grade Level | The student’s grade level. | [Students]Grade_Level [ReEnrollments]Grade_Level | 2 | 1,3 | 27 | 28 |
Filler | Filler | Filler | N/A | 1 | 1,3 | 29 | 29 |
FTE007 | Prior Ten Days | Indicates whether the student has been present for 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:
Note: If duplicate attendance records cause an issue with the attendance query, the report returns ‘X’ for the Prior Ten Days value. This value is invalid and will result in errors at the state. Follow guidance for finding duplicate daily attendance records. | [Attendance]Antedate [Attendance]StudentID | 1 | 1,3 | 30 | 30 |
FTE008 | Residence Status Code | Indicates the student’s resident status. For valid values, see Resident Status Codes. | [S_GA_STU_X]ResStatusCode [S_GA_REN_X]ResStatusCode | 1 | 1,3 | 31 | 31 |
FTE009 | System of Residency | The home system (district) of the non-resident student. Note: Value is blank if the Resident Status Code is 1. | [S_GA_STU_X]residencedistrict [S_GA_REN_X]ResidenceDistrict [Prefs]Value [Prefs]Name=districtnumber | 3 | 1,3 | 32 | 34 |
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 Program Codes 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 | 35 | 35 |
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 | 36 | 36 |
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 | 37 | 37 |
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 | 38 | 38 |
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 | 39 | 39 |
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 | 40 | 40 |
FTE016 | Filler | Filler | N/A | 1 | 1,3 | 41 | 41 |
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 | 42 | 47 |
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. Note: If Use Manual Override is selected on the FTE Student Information page, the report will extract the 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 | 48 | 48 |
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 | 49 | 49 |
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 | 50 | 50 |
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 | 51 | 51 |
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 | 52 | 52 |
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 | 53 | 53 |
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 | 54 | 58 |
Filler | Filler | Filler | N/A | 1 | 1,3 | 59 | 59 |
FTE030 | ESOL Segments | The number of segments of English for Speakers of Other Languages (ESOL) for the student taught by an ESOL teacher. Note: As of school year 2019-2020, extracted from State/Province - GA > ESOL > Units | [S_GA_STU_ESOL_C]Itin | 1 | 1,3 | 60 | 60 |
Filler | Filler | Filler | N/A | 2 | 1,3 | 61 | 62 |
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 | 63 | 63 |
Filler | Filler | Filler | N/A | 1 | 1,3 | 64 | 64 |
FTE033 | Ethnic Hispanic | Indicates whether the student is Hispanic or Latino. | [Students]Fedethnicity | 1 | 1,3 | 65 | 65 |
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 | 66 | 66 |
FTE035 | Race Asian | Indicates whether the student is Asian. | [StudentRace]racecd [Gen]Cat=race [Gen]Cat=federalrace [Gen]Name=S | 1 | 1,3 | 67 | 67 |
FTE036 | Race Black | Indicates whether the student is African American. | [StudentRace]racecd [Gen]Cat=race [Gen]Cat=federalrace [Gen]Name=B | 1 | 1,3 | 68 | 68 |
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 | 69 | 69 |
FTE038 | Race White | Indicates whether the student is White. | [StudentRace]racecd [Gen]Cat=race [Gen]Cat=federalrace [Gen]Name=W | 1 | 1,3 | 70 | 70 |
FTE039 | Withdrawal Code | The reason the student withdrew or exited from the school. See the Exit Codes 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 | 71 | 71 |
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 | 72 | 72 |
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 | 73 | 73 |
FTE042 | School Entry Code | The reason the student enrolled in school. See the Entry Codes 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 | 74 | 74 |
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 | 75 | 82 |
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 | 83 | 90 |
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 | 91 | 94 |
FTE | Student Primary Language | Indicates the primary language spoken by the student. Note: When this field has no value, 008 is extracted. | [Students]PrimaryLanguage | 3 | 1 | 95 | 97 |
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 | 98 | 98 |
Filler | Filler | Filler | N/A | 1 | 1,3 | 99 | 99 |
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 | 100 | 100 |
FTE045 | Date of Birth | The student’s date of birth. | [Students]DOB | 6 | 1,3 | 101 | 106 |
FTE046 | Transported Segment 1 | Indicates whether the student is transported from one instructional setting to another during segment 1 of the school day. If Use Manual Override 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 | 107 | 107 |
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 | 108 | 108 |
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 | 109 | 109 |
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 | 110 | 110 |
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 | 111 | 111 |
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 | 112 | 112 |
FTE052 | Supplemental Speech Segment 1 | Indicates whether the student received supplemental speech services in segment 1. If Use Manual Override 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 | 113 | 113 |
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 | 114 | 114 |
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 | 115 | 115 |
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 | 116 | 116 |
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 | 117 | 117 |
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 | 118 | 118 |
FTE058 | Itinerant Teacher Segment 1 | Indicates whether the student received Special Education services by an itinerant teacher in segment 1. If Use Manual Override 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 | 119 | 119 |
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 | 120 | 120 |
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 | 121 | 121 |
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 | 122 | 122 |
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 | 123 | 123 |
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 | 124 | 124 |
FTE064 | Inclusion Segment 1 | Indicates whether the student received Regular Education services in segment 1 via the Inclusion model. If Use Manual Override 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 | 125 | 125 |
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 | 126 | 126 |
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 | 127 | 127 |
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 | 128 | 128 |
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 | 129 | 129 |
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 | 130 | 130 |
FTE118 | Title III Served (Y or N) This extract is pulled based on the latest enrollment date. If there are multiple EL/ESOL information with no exit dates then the report will extract Title III Served value updated against the latest enrollment date in the system. If there are multiple EL/ESOL information exit dates, then the report will extract Title III Served value of the latest entry per EL/ESOL enrollment date on or before the report's current FTE date and the Exit date is on or after the report current FTE Date. If none of the conditions are met, then the report will extract N. | Indicates whether the student is part of Title III Services. | [S_GA_STU_FTE_X]TitleIIIServed | 1 | 1,3 | 131 | 131 |
FTE070 | Special Ed Services P | The number of hours per week the student is currently receiving 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 | 132 | 132 |
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 | 133 | 133 |
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 | 134 | 134 |
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 | 135 | 135 |
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 | 136 | 136 |
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 | 137 | 137 |
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 | 138 | 138 |
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 | 139 | 139 |
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 | 140 | 140 |
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 | 141 | 141 |
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 | 142 | 142 |
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 | 143 | 143 |
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 | 144 | 144 |
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 | 145 | 145 |
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 | 146 | 146 |
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 | 147 | 147 |
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 | 148 | 148 |
FTE | Non-ESOL | Indicates the status of an EL student who is not in ESOL program. | [S_GA_STU_ESOL_C]Refused | 1 | 2 | 149 | 150 |
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 | 151 | 151 |
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 | 152 | 152 |
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 | 153 | 153 |
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 | 154 | 154 |
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 | 155 | 155 |
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 | 156 | 156 |
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 | 157 | 157 |
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 | 158 | 158 |
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 | 159 | 159 |
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 | 160 | 160 |
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 | 161 | 161 |
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 | 162 | 162 |
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 | 163 | 163 |
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 | 164 | 164 |
FTE | Parent Communication Language | Indicates the preferred language for parental communications. | [S_GA_STU_X]ParentCommunicationLang | 3 | 1 | 165 | 167 |
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 | 168 | 168 |
FTE101 | English Learner (EL) | Indicates whether the student has limited proficiency in English. | [S_GA_STU_ESOL_C]ELFlag | 1 | 1,3 | 169 | 169 |
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 | 170 | 170 |
FTE103 | GTID | The student’s Georgia Testing Identifier. | [Students]State_StudentNumber | 10 | 1,3 | 171 | 180 |
FTE | Related Special Ed Services 3 | Indicates the student is currently receiving Special Ed Services in Speech Therapy. Valid values:
| 1 | 181 | 181 | ||
Filler | Filler | Filler | N/A | 5 | 182 | 186 | |
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 | 187 | 188 |
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 | 189 | 196 |
FTE112 | Filler | Filler | N/A | 3 | 1,3 | 197 | 199 |
FTE113 | GAA | Indicates that the student will take the GAA this school year. | [S_GA_STU_SpecEd_X]GAA_Flag [S_GA_REN_SpecEd_X]GAA_Flag | 1 | 1 | 200 | 200 |
FTE114 | School Entry Date | Date of the student’s entry into the school this school year. The School Entry Date is extracted only for active students and must be a valid date in the fiscal year. In addition, the date must be in the school calendar. | 8 | 1,3 | 201 | 208 | |
Filler | Filler | Filler | N/A | 2 | 1,3 | 209 | 210 |
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 | 211 | 240 |
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 | 241 | 270 |
FTE125 | Date Student Became Eligible for GAA | The date the student became eligible for GAA. | [S_GA_STU_SpecEd_X]GaaEligibilityStartDate [S_GA_REN_SpecEd_X]GaaEligibilityStartDate | 10 | 1,3 | 271 | 278 |
FTE117 | Filler | Filler | N/A | 5 | 1,3 | 279 | 283 |
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 | 284 | 313 |
FTE126 | Date Student Identified No Longer Eligible for GAA | The end date of the student's GAA eligibility. | [S_GA_STU_SpecEd_X]GaaEligibilityEndDate [S_GA_REN_SpecEd_X]GaaEligibilityEndDate | 8 | 1,3 | 314 | 321 |
FTE131 | Title III Served The value is Y if the ESOL participation and Title III fields on the student EL section are checked. Otherwise, the value will be N. | Title III Served | [S_GA_STU_SpecEd_X]TitleIIIServed | 12 | 1,3 | 322 | 333 |