Skip to main content
Skip table of contents

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.

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

When publishing the K12 Student Attendance resource there are two options:

  • Publish 45 Days - This publishes all attendance data for the past 45 days based on the current system date.

  • Publish All - This publishes all attendance data for the school year 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.

Present - Present
ExcusedAbsence - Excused Absence
UnexcusedAbsence - Unexcused Absence
Tardy - Tardy
EarlyDeparture - Early Departure

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.