The F01 - Enrollment Level report extracts school enrollment and attendance data. One record is transmitted for every student. If there is no withdrawal date, the student is considered active. Students may have more than one enrollment record if the student withdrew and re-enrolled during the school year. Each enrollment record must correspond to a student level record. Students reported as a no-show in FTE 1 and FTE 3 should not have an enrollment record.
This report uses:
- PS_AdaAdm_Defaults_All - This reporting view supports ADA/ADM calculation using default settings for all valid attendance mode and conversion mode combinations.
- PS_Enrollment_All - This view provides Current Enrollment, Previous Enrollment, and Special Program Enrollment information.
- PS_Membership_Defaults - This database table provides student membership information for each day that they have an active enrollment on valid in-session school days. It includes potential periods and minutes as well as actual periods and minutes absent.
Selection criteria determine which database records are used in the report.
The report selects records from the [Students] and [Reenrollments] tables that are associated with the school included in the report. A student who is enrolled in multiple schools during the report period will have an enrollment record for each school ifthe report is run district wide. The record must have an entry and exit date for the school enrollment that occur during the report date range.
For help with navigation and running the report, see How to Find and Generate a Report.
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.
Current Selection Students
Run the report for the current selection of students or all students.
Report Start Date
Enter the start date of the report.
Note: Enter the date in a format of MM/DD/YYYY.
Report End Date
Enter the end date of the 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 Withdrawal Date as One day before Student Exit 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.
Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically.
Please refer to Setting Up a SFTP Connection for details on how to create a SFTP connection.
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.
The students with Dexter Mosely set as Yes in the State Information page are not included in the report output.
The fiscal year of the record.
The report extracts the year based on the last day in the current school calendar.
The reporting period.
The school system code. This is the district number in PowerSchool.
Identifies the record layout.
The report extracts Fnn where nn is a number from 01-99, used to sequentially number the school enrollment records reported for each student.
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.
School Entry Code
The code identifying the reason the student enrolled in the school - extracted for the school enrollment that occurred during the report date range.
School Entry Date
The date the student entered the school – extracted for the school enrollment that occurred during the report date range.
The code identifying the reason the student withdrew from school - extracted for the school enrollment that occurred during the report date range.
The date the student withdrew from the school - extracted for the school enrollment that occurred during the report date range.
Total Days Absent
The total days the student was absent for more than one-half of the instructional day during the report period.
The total days the student was present for at least one-half of the instructional day during the report date range.
Unexcused Days Absent
The number of unexcused days absent for the student during the report date range.
Days Made Up
The number of days the student was allowed to make up by attending Saturday School.
The identification number assigned to each student to uniquely identify the student throughout his/her public education years in the Georgia public school system.