Student Fact Template for Unlawful Absences
This report shows the total school days each student was unlawfully absent during the school year. Local Education Agencies (LEAs) must report unlawful absences for students of compulsory school age. Both partial and full days can be reported.
Navigation: Reports, State Reports, Student Domain, Student Fact Template for Unlawful Absences
Report Requirements
Before running this report, ensure the following setup requirements are met:
Attendance Code Setup
Attendance codes must be properly mapped to the Unlawful Attendance Category.
Attendance codes must be mapped to the code_entity table with external_name = 'Unlawful'
School Year Configuration
School year terms must be properly set up with valid start and end dates
State Reporting Exclusions
Schools and students excluded from state reporting must be properly flagged
Selection Criteria
Selection criteria determine which database records are used in the report.
Student Selection
Students must not be excluded from state reporting.
School must not be excluded from state reporting.
Students must be enrolled during the report date range.
Student exit date must be after the entry date.
Students must have a valid state_studentnumber (PASecureId).
At least one unlawful absence code assigned during the reporting period.
Definitions for unlawful absence
Unlawful Absence: Any unexcused absence for a student of compulsory age.
School Day of Unlawful Absence: Period of an unlawful absence or absences equivalent in time to a full school day.
Compulsory Age: When a student first enrolls in school (which may be no later than 6 years old), until the age of 18 or graduation from high school, whichever comes first.
Report Input
For help with report generation and navigation, see How to Find and Generate a Report.
Field | Description |
|---|---|
Select Schools | Select one or more schools for which to generate report content. Only schools not excluded from state reporting are available for selection. |
Students to Include | Option to use current student selection or include all students. This leverages the PowerSchool current selection feature. |
Select School Year | Select the school year for the report. Displays available school years from the terms table. |
Report Start Date | The start date for the reporting period. Defaults to the first day of the selected school year. |
Report End Date | The end date for the reporting period. Defaults to the last day of the selected school year. |
Field Delimiter | Select the delimiter for the output file: Tab (default), comma, or pipe. |
Include Header Labels in output file? | Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report. |
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 Type | Field Length |
1 | SUBMITTING AUN | The unique, 9-digit Administrative Unit | If PSSR_SUBDISTRICT = 1: [cst_subDistricts].SUBDISTRICT_NUMBER (first 9 chars); Otherwise: [PREFS].value WHERE name = 'PA_DISTRICTAUN' or 'districtnumber' | VARCHAR2 | 9 |
2 | SCHOOL YEAR DATE | The school year end date in YYYY-06-30 format. | Derived from [TERMS].lastDay: TO_CHAR(MAX(lastDay), 'YYYY') || '-06-30' WHERE lastDay > reportStartDate AND firstDay < reportEndDate | VARCHAR2 | 10 |
3 | PASECUREID | The 10-digit Pennsylvania Secure Student Identifier reported for the student. | [STUDENTS].state_studentnumber | VARCHAR2 | 32 |
4 | REPORTING DATE | The last day of the current school year in YYYY-MM-DD format. | Input Parameter: TO_CHAR(reportEndDate, 'YYYY-MM-DD') | VARCHAR2 | 10 |
5 | CATEGORY SET CODE | Fixed value indicating the category of fact data. | Constant value: 'UNLAWFULABS' | VARCHAR2 | 11 |
6 | PRIMARY MEASURE TYPE | Fixed value indicating the measure type. | Constant value: 'AMOUNT' | VARCHAR2 | 6 |
7 | NOT COLLECTED | N/A | N/A | N/A | N/A |
8 | AMOUNT | Total number of school days of unlawful absence. | Calculated: SUM(1.0 - [ATT_ADAADM_DEFAULTS_ALL]attendancevalue for all attendance records where [CODE_ENTITY].external_name = 'Unlawful' [ATT_CODE_CODE_ENTITY] [ATTENDANCE_CODE] tables | NUMBER |