Student Daily Attendance Extract

Introduction

This extract generates a comma-delimited file containing one record per full-day/half-day excused/unexcused absence, due to a cultural observance, for each student. The template is submitted at the following reporting periods:

40D
80D
120D
EOY

Full-day/half-day excused/unexcused absences, due to a cultural observance absence, should be reported for all students enrolled in the school at any time during the school year.

The following Attendance Code Long values will be reported in the output file based on the attendance, attendance setup, and school calendar setup:\

K5PATTD = Attended K5P
K5PABS = Absent K5P
ELTPATTD = Attended ETLP
ELTPABS = Absent ELTP
RMTEATTD = Attended Remote Learning
UNHDCO = Unexcused Half Day Absence Religious or Cultural Observance
UNFDCO = Unexcused Full Day Absence Religious or Cultural Observance
EHDCO = Excused Half Day Absence Religious or Cultural Observance
EFDCO = Excused Full Day Absence Religious or Cultural Observance

Student Selection

The report selects student records from the [Students] or [ReEnrollments] table who meet the following criteria:

The student must not be excluded from state reporting.
The student must be enrolled in a school included in the report.
The student’s school enrollment Entry Date must occur on or before the report end date.
The student’s school enrollment Exit Date must occur on or after the report start date.
The student is HSDA-flagged.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Select Students	Choose one of the following: The Selected [x] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district.
K5P Submission	Choose one of the following: Yes, the report is being run for the K5P Submission. No, the report is not being run for the K5P submission.
Attendance Period Start Date	Enter the attendance period start date.
Attendance Period End Date	Enter the attendance period end date.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Tables for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Begin / End Position
1	District Code	PED assigned three-digit district number.	[Prefs]Name=DistrictNumber [Prefs]Value	1/8
2	Location Code	The alternate school number is extracted, if populated. Use the following Location Codes for special education students not enrolled at an actual district location: 993 – Students who are hospitalized 997 – Students who are enrolled in a private school 998 – Students who are homebound 999 – Students who are home schooled	[Schools]Alternate_School_Number [Schools]School_Number For the Summer reporting period: [S_NM_STU_X]LocationCode [ReEnrollments]SchoolID [Schools]Alternate_School_Number	9/14
3	Student ID	The state assigned student ID number.	[Students]State_StudentNumber	15/26
4	Attendance Date	The date on which the unexcused absence occurred. The value is extracted in the format YYYY-DD-MM.	[Attendance]Att_Date	27/36
5	N/A	Not collected.	N/A	37/38
6	N/A	Not collected.	N/A	39/78
7	N/A	Not collected.	N/A	79/84
8	Attendance Code Long	The attendance code that indicates the unexcused absence for the date. The report identifies an attendance code as unexcused if the code is associated with an attendance code category named Unexcused. If the report is being run for the K5P submission (based off the runtime parameter), the report will return records for days where the student is both absent and present. Valid values: For K5P Days where the student is present will be represented with a value of ATTD. Days where the student was absent will be represented with a value of ABS. For EOY Days where the student had an excused half day absence for a cultural observance will be represented as EHDCO. Days where the student had an unexcused half day absence for a cultural observance will be represented as UNHDCO. Days where the student had and excused full day absence for a cultural observance will be represented as EFDCO. Days where the student had an unexcused full day absence for a cultural observance will be represented as UNFDCO. Notes: ATTD and ABS values are calculated based on the school's attendance setup and whether or not any assigned attendance codes are set as a present code or an absent code, codes are set as a present code or absent code. EHDCO, EFDCO, UNHDCO, UNFDC values are calculated based on how attendance is being taken at a given school. Absence codes that are set to count as the "Cultural Observance Absence" code will be used in the calculation and whether they're set to count towards the Excused or Unexcused attendance code category will determine if the student is reported with an "E" or "UN" Attendance Code Long value. For meeting attendance, full-day/half-values are determined based on the "Cultural Observance Absence" attendance code checkbox and the attendance conversion. For daily attendance, full-day/half-day values are determined based on the "Cultural Observance Absence" attendance code checkboxes (checked for one code to indicate full-day and checked for another code to indicate half-day).	[S_NM_ATC_X]halfDayCultObsAbsence [S_NM_ATC_X]fullDayCultObsAbsence [S_NM_ATC_X]cultObsAbsence	85/92
9	N/A	Not collected.	N/A	93/102

Back to Top