Daily attendance information for students at school level, including excused and unexcused absences tracked by calendar date.
StudentSchoolAttendanceEvents
Daily attendance events for students including attendance category (Excused Absence, Unexcused Absence) and event dates during the school year.
Primary PowerSchool Source Data
Core tables used in this resource:
-
PS_ADAADM_DEFAULTS_ALL
-
UnexcusedHistorical
-
Students
-
Terms
Selection Criteria
Business logic for publishing this resource:
-
Enrollment record exists for student at specified school
-
Attendance date falls between first day and last term day of school year
-
Attendance date falls between student entry and exit dates
-
MembershipValue > 0 (student was enrolled)
-
AttendanceValue < MembershipValue (absences recorded)
-
OnTrack = 1 (student is on track)
-
Unexcused historical record matched on StudentID, SchoolID, and UnexcusedDate with rectype='TA' and percent_match=1 determines absence category
Resource Output
Expected output from the selection criteria:
-
StudentKeyID (Students.DCID)
-
StudentUID (Unique State Student Number)
-
SchoolYear (YearID + 1991)
-
SessionName (Academic term formatted)
-
EventDate (Calendar date of attendance event)
-
EventCategory_DX (Descriptor: 'Excused Absence' or 'Unexcused Absence')
Automatic Publishing
Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.
Data Elements
Details of each data element published in this resource:
|
Data Element |
Description |
[Table]Data Type |
Stored in [Table]Field |
|
StudentKeyID |
Unique database identifier for student enrollment record |
string |
[Students]DCID |
|
StudentUID |
State-assigned unique student identifier from CST_PUBWORKFLOW_LIB.getStudentUniqueId |
string |
[Students]State_StudentNumber |
|
SchoolYear |
School year expressed as numeric year (YearID + 1991), e.g., 2024 |
number |
[Terms]YearID |
|
SessionName |
Formatted session/term name from CST_PUBWORKFLOW_LIB.formatSessionNameBase using term abbreviation |
string |
[Terms]Abbreviation |
|
EventDate |
Calendar date of the attendance event (YYYY-MM-DD format) |
datetime |
[PS_ADAADM_DEFAULTS_ALL]CalendarDate |
|
EventCategory_DX |
Attendance event type: 'Excused Absence' when unexcused count is 0, 'Unexcused Absence' when unexcused count > 0 |
string |
[unexcusedhistorical]Percent_Match Lookup + COUNT |
|
SchoolOrgID |
School organization identifier for attendance record location |
string |
[PS_ADAADM_DEFAULTS_ALL]SchoolID |