Resource Overview
-
Ed-Fi endpoint:
/data/v3/studentSchoolAttendanceEvents -
Published view/entity: Student School Attendance
-
Purpose: Daily attendance information for students
-
Source query:
StudentSchoolAttendanceEvent -
Dependencies:
sessions,studentSchoolAssociations
studentSchoolAttendanceEvent
This event entity represents the recording of whether a student is in attendance for a school day.
Primary PowerSchool Source Data
-
[Attendance]
-
[Attendance_Code]
-
[Students]
Selection Criteria
Records are published if the following criteria are met:
-
The student was published in the Student category.
-
The student has an enrollment for the attendance school as published in the Student Enrollment category.
-
StudentUniqueId must be populated in PowerSchool.
-
The student must not be excluded from state reporting.
-
The school must not be excluded from state reporting.
-
On the date of the attendance event, the student must have a daily attendance record with an absence, tardy, or left early code, or at least one meeting attendance record with an absence code.
Resource Output
|
Data Element (Ed-Fi target) |
Data View Column Name |
Submission |
[Table]Field (PowerSchool Source) |
Business Rules |
Comments |
|---|---|---|---|---|---|
|
schoolReference.schoolId |
SchoolOrgID |
Y |
Publishing framework or supporting query Query alias: SchoolOrgID |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SchoolOrgID. |
|
sessionReference.schoolId |
SchoolOrgID |
Y |
Publishing framework or supporting query Query alias: SchoolOrgID |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SchoolOrgID. |
|
sessionReference.schoolYear |
SchoolYear |
Y |
Staging rule: studentSchoolAttendanceEvents p_yearid + 1991 |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolYear. |
|
sessionReference.sessionName |
SessionName |
Y |
[Students]Track; Transformation: case when s.track is not null then (select EDFI_TN_LIB.getSessionName_3(p_profileid,1,t.abbreviation,inst.InstructionalProgramNbr) from schools sch join terms t on t.schoolid = sch.school_number and t.isyearrec = 1 join S_TN_SCH_InstrProgram_C inst on inst.schoolsdcid = sch.dcid and inst.yearid = t.yearid where t.yearid = p_yearid and sch.school_number =p_schoolid and inst.powerschooltrack = s.track) else (select EDFI_TN_LIB.getSessionName_3(p_profileid,1,t.abbreviation,inst.InstructionalProgramNbr) from schools sch join terms t on t.schoolid = sch.school_number and t.isyearrec = 1 join S_TN_SCH_InstrProgram_C inst on inst.schoolsdcid = sch.dcid and inst.yearid = t.yearid where t.yearid = p_yearid and sch.school_number =p_schoolid and inst.powerschooltrack is null) end |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SessionName. |
|
studentReference.studentUniqueId |
StudentUID |
Y |
[Students]DCID; [Students]State_Studentnumber; Transformation: CST_PUBWORKFLOW_LIB.getStudentUniqueId(p_profileid, s.dcid, s.state_studentnumber) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StudentUID. |
|
eventDate |
EventDate |
Y |
[CST_PUBATTEND_DAILY_TMP]Event_date; transformation: to_char(att.event_date, 'YYYY-MM-DD') |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: EventDate. |
|
attendanceEventCategoryDescriptor |
EventCategory_DX |
Y |
[CST_PUBATTEND_DAILY_TMP]Att_category |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: EventCategory_DX. |
|
eventDuration |
EventDuration |
Conditional |
Publishing framework or supporting query Query alias: EventDuration |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: number. Query alias: EventDuration. |