PowerSchool SIS Mississippi

K12 Student Attendance

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

  • The students must be enrolled in the current school year, and NOT be excluded from state reporting.

  • The students must NOT be pre-registered in the current school year. They are excluded automatically until they become active.

    • A pre-registered student has an Enroll_Status = -1 and a future entry date.

  • 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.

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

  1. The K12 Student Attendance resource appears under the ON DEMAND Category.

  2. Customers can publish immediately using the Run Now option.

  3. 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.

Daily Attendance Calculation

Beginning school year 2026–27, Mississippi defines students as present if they attend 66 percent or more of their expected school day. Expected minutes must be derived from the school bell schedule and include instructional time, passing time, lunch, recess, and time between classes.

If a school has a configured a bell schedule that includes instructional time, passing time, lunch, recess, and time between classes, when daily attendance is calculated for a student, the system determines the student’s expected school day minutes from that bell schedule. The daily attendance is calculated as follows:

  • If a student attends at least 66 percent of those expected minutes, then the student is marked present for the day.

  • If a student attends less than 66 percent of those expected minutes, then the student is marked absent for the day.

Pre-requisite Attendance Setup

The attendance setup is based on the Mississippi 66% Rule for Attendance Reports.

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".

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

attendanceEventDurationDay

Yes

The value represents the daily total derived from attendance events for that student and date.

The value is calculated from existing attendance code values and instructional minutes.

None



  • Value must be between 0.00 and 1.00, inclusive.

  • Decimal precision is supported (for example: 0.66).

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



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



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.

schoolYear

Yes

Indicates the current school year.

None




localEducationAgencyIdentifier

Yes

Identifies the LEA.

None




dateTimeProcess

Yes

Captures the date and time of publishing.

None