This is the documentation for Ed-Fi Data Standard v3.2.0-c. This early access version of the standard powers supported products, including the ODS / API v5.0 and v5.1. This version was superseded by Ed-Fi Data Standard v3.2.
Expected and Actual Program/Intervention Attendance
Expected and Actual Program/Intervention Attendance Use Cases
Report a student's expected total time in attendance for a program or intervention.
Expected, or prescribed attendance is not supported for the generic StudentProgramAssociation or its sub-classes. Expected attendance is only available in StudentSpecialEducationProgramAssociation and StudentLanguageInstructionProgramAssociation. The use cases below are therefore limited to those two program types.
For a special education program
Expected Time in Attendance for a Special Education Program = ( StudentSpecialEducationProgramAssociation.SpecialEducationHoursPerWeek )
* COUNT ( ( StudentSpecialEducationProgramAssociation.EndDate - StudentSpecialEducationProgramAssociation.BeginDate ) / 7 )
WHERE StudentSpecialEducationProgramAssociation.Program = { Program for the attendance calculation }
AND StudentSpecialEducationProgramAssociation.Student= { Student for the attendance calculation }
For a language instruction program
Expected Time in Attendance for a Language Instruction Program = StudentLanguageInstructionProgramAssociation.Dosage
WHERE StudentLanguageInstructionProgramAssociation.Program = { Program for the attendance calculation }
AND StudentLanguageInstructionProgramAssociation.Student= { Student for the attendance calculation }
For an intervention
Expected Time in Attendance for an Intervention = StudentInterventionAssociation.Dosage
WHERE StudentInterventionAssociation.Intervention= { Intervention for the attendance calculation }
AND StudentInterventionAssociation.Student= { Student for the attendance calculation }
Assumptions:
- The student is actively participating in the special education program between the association BeginDate and EndDate values. If not, the ParticipationStatus.StatusBeginDate and ParticipationStatus.StatusEndDate values where ParticipationStatus.ParticipationStatusDescriptor is equal to an active status should be used for the calculation.
- Expected time in attendance for a special education program is reported in hours.
- Expected time in attendance for a language instruction program and an intervention are both reported in minutes.
Report a student's actual attendance for a program.
Student attendance for a program requires positive attendance to be recorded. Unlike with school and section attendance, positive attendance for a program cannot be otherwise derived from the model. The following use case therefore assumes positive attendance is taken for a student in a program. Special education and language instruction programs, as described in the previous use case, are the exceptions to this rule.
Option 1: When EventDuration is used to capture portions of a school day in attendance
Student Program Attendance = SUM ( StudentProgramAttendanceEvent.AttendanceEvent.EventDuration )
* COUNT ( StudentProgramAttendanceEvent.AttendanceEvent.EventDate )
WHERE StudentProgramAttendanceEvent.AttendanceEvent.AttendanceEventCategoryDescriptor IN { Present categories (e.g., In Attendance) as defined by the implementation }
AND StudentProgramAttendanceEvent.Student= { Student for the attendance calculation }
AND StudentProgramAttendanceEvent.Program= { Program for the attendance calculation }
Option 2: When ProgramAttendanceDuration (or InterventionDuration, for interventions) is used to capture time in attendance
Student Program Attendance = SUM ( StudentProgramAttendanceEvent.ProgramAttendanceDuration )
WHERE StudentProgramAttendanceEvent.AttendanceEvent.AttendanceEventCategoryDescriptor IN { Present categories (e.g., In Attendance) as defined by the implementation }
AND StudentProgramAttendanceEvent.Student= { Student for the attendance calculation }
AND StudentProgramAttendanceEvent.Program= { Program for the attendance calculation }
Assumptions:
- For a program or intervention, positive attendance is reported.
- Option 1 reports total time in attendance in days.
- Option 2 reports total time in attendance in minutes.