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.