Student Attendance Summary
This object provides a summary of a student’s daily attendance and membership information for a given school during the time period between the StartDate and EndDate, inclusive. As such, there may be multiple instances of this object for a student in a school over the course of a school year.
This object provides an inclusive summary of a student's daily attendance and membership information for a given school during the time period between the StartDate and EndDate. There may be multiple instances of this object for a student in a school over the school year. There will be one Student Attendance Summary per Enrollment record with corresponding Start and End Dates.
Note: This object will be collected daily during reporting windows and two additional times a year. The first will be upon completion of the first nine-week reporting period; the second will be upon completion of the school year. SIF_Query will be used to submit the request during these two time periods. The OSDE Web site will be accessible to a district user to input the parameters for the query and request their own data.
The following table lists the elements that are published for this object:
Element Name | Submission | Definition | Code Set, if applicable | [Table]Field Mapping | Business Rules |
|---|---|---|---|---|---|
RefId | Yes | The Id (GUID) of this record. | Derived | ||
StudentPersonalRefId | Yes | The ID (GUID) of the student for whom this attendance information is being reported. | [Students]DCID | ||
SchoolInfoRefId | Yes | The ID (GUID) of the school for which this attendance information is being reported. | [Schools]DCID | ||
SchoolYear | Yes | School year for which the information is applicable. | Current School Year | ||
StartDate | Yes | The starting date on which the information in this object instance is applicable. | [Terms]FirstDay [Calendar_Day]Date_Value [Students]EntryDate |
| |
StartDay | Yes | Number of the first school day to which this object instance applies. | [Calendar_Day]InSession [Calendar_Day]Date_Value [Terms]FirstDay | The number of the school day will reflect actual instructional days and exclude professional days and holidays. | |
EndDate | Yes | The ending date on which the information in this object instance is applicable. | [Terms]LastDay [Calendar_Day]Date_Value [Students]ExitDate | ||
EndDay | Yes | Number of the last school day to which this object instance applies. | [Calendar_Day]InSession [Calendar_Day]Date_Value [Terms]LastDay | The number of the school day will reflect actual instructional days and exclude professional days and holidays. | |
Resident | Yes | An indication as to whether or not the student's legal residence was within the boundaries of the school during the time between the StartDate and EndDate, inclusive. |
| Default value is Yes Note: No SIF_Query or SIF_Condition support is required for this element. | |
DaysAttended | Yes | The number of days the student attended school when school was in session between the StartDate and EndDate, inclusive. | Note: No SIF_Query or SIF_Condition support is required for this element. | ||
ExcusedAbsences | Yes | The number of days the student was absent from school with a valid excuse when school was in session between the StartDate and EndDate, inclusive. | Note: No SIF_Query or SIF_Condition support is required for this element. | ||
UnexcusedAbsences | Yes | The number of days the student was absent from school without a valid excuse when school was in session between the StartDate and EndDate, inclusive. | Note: No SIF_Query or SIF_Condition support is required for this element. | ||
DaysInMembership | Yes | The number of days the student was present plus the number of days the student was absent when school was in session during the period between the StartDate and EndDate, inclusive. | Note: No SIF_Query or SIF_Condition support is required for this element. | ||
SIF_ExtendedElements/SIF_ExtendedElementName | |||||
DaysTransportedEligibleStateAid | Optional | Total should be for the reporting period between the StartDate and EndDate inclusive. | |||
CalendarSummaryRefId | Optional | The RefId for the CalendarSummary object associated with this enrollment. | The format for the RefId should not contain spaces or hyphens. Example: F4AABF042EAD4781A9AA20BF64C4EDAC | ||
StudentSchoolEnrollmentRefId | Optional | RefId (GUID) of the StudentSchoolEnrollment object instance that corresponds to this object instance. | OSDE will expect to see multiple StudentAttendanceSummary objects for a single student if multiple StudentSchoolEnrollment objects exist for that student during the time period requested. The format for the RefId should not contain spaces or hyphens. Example: F4AABF042EAD4781A9AA20BF64C4EDAC |