K12 Student Attendance

This resource publishes Student Daily Attendance including present days, excused absences, and unexcused absences.

The students that are published must NOT be excluded from state reporting.
The school must not be excluded from reporting. No students will be published from a school that is excluded from reporting.

Saturdays, Sundays, and days not in session such as holidays or teacher workdays are excluded.

Note:

This resource is updated to support sub-district capabilities in MS MSIS 2.0 for charter schools and includes publishing of the correct District and School references across the system. For more information, refer to the Additional Setup for Charter Schools section.
The resource is updated to publish based on the district that is associated with it.

The following change impacts this resource:

The school’s StatePrId field is now used as an override for the School Number when publishing School Identifier on resources via DEX. This update primarily affects charter schools but can also be used for public schools with alternate schools.

The K12 Student Attendance Resource is updated and this can now be scheduled to publish changes once daily.

The K12 Student Attendance resource appears under the ON DEMAND Category.
Customers can publish immediately using the Run Now option.
Customers can run it daily to publish the changes using the Schedule option.

Note: Customers must use the Publish 45 Days option. This publishes all attendance data for the past 45 days based on the current system date.

Pre-requisite Attendance Setup:

The Attendance Setup is based on the current setup required for the Monthly Student Data (MSD) report. Refer to Mississippi Attendance Reports and the 63% Rule.

Element Name	Submission	Definition	Code Set, if applicable	Technical Name	[Table]Field Mapping	Business Rules or Comments
Category - Attendance
Attendance Event Type	Yes	The type of attendance event.	MDE Option Set DailyAttendance - Daily attendance	AttendanceEventType		Default to "DailyAttendance". In MS, customers are required to set up the "Daily Attendance" bridge.
Attendance Event Date	Yes	The date on which an attendance event takes place.	None	AttendanceEventDate	Calculated	Derived using the attendance date from the ADA/ADM views
Attendance Status	Yes	The status of a person's attendance associated with an Attendance Event Type and Attendance Event Date in an organization-person-role context.	The codeset for the attendanceStatus field is updated and publishes correctly. The valid values are: Present ExcusedAbsence UnexcusedAbsence	AttendanceStatus	Calculated	Derived using the attendance views based on the Attendance Code category. Present = Present Excused = ExcusedAbsence Unexcused = UnexcusedAbsence
Local Education Agency Identification System	Yes	A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a local education agency.	MDE Option Set SEA - State Education Agency assigned number	LEAIdentificationSystem		Default to "SEA"
Local Education Agency Identifier	Yes	A unique number or alphanumeric code assigned to a local education agency by a school system, a state, or other agency or entity.	None	LocalEducationAgencyIdentifier	[Prefs]Value where [Prefs]Name="DistrictNumber"	Extract the first 4 characters so that they match the K12School and Calendar resource rule for School Identifier.
School Identification System	Yes	A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to an institution.	Refer to School Identification System.	SchoolIdentificationSystem		Default to "SEA"
School Identifier	Yes	A unique number or alphanumeric code assigned to an institution by a school, school system, a state, or other agency or entity.	None	SchoolIdentifier	[Prefs]Value where [Prefs]Name="DistrictNumber" concatenated with [Schools]School_Number	Format: School ID (0000-000) 4 character district number + - + 3 character school number.