PowerSchool SIS South Carolina

Attendance Code Standardization Report

Introduction

This report will rename, add, or remove spaces from Attendance Categories and Attendance Codes to match them with state-approved values. Invalid Attendance Categories/Codes will either be renamed as "Invalid" (if attendance records are associated with a code) or deleted (if no attendance records are associated with the code).

Note: The report does not force Attendance Codes to be part of all possible valid Attendance Categories. If an Attendance Code is part of at least one valid category and no invalid categories, no changes are made to the code.

Prerequisites for Summer School Publishing

  • Is Summer School: For any school that operates as a summer school, verify that this field is enabled. For example, a summer session starting in June 2026 belongs to the 2026–2027 school year.

Navigation: Start Page, District Setup, Schools/School Info, select a school, Edit School

  • School Year (Years and Terms): Verify that the correct school year has been created for every school, including summer schools. The Attendance Code Standardization Report requires a school year to exist for each selected school.

Navigation: Start Page, School Setup, Years and Terms

  • Term Setup: Within the school year, confirm that at least one year-level term record (Is Year Record = Yes) exists for the school. For summer schools, the term for the summer session must be created under the correct school year (not the prior year). Verify the term dates align with the actual summer session dates.
    Navigation: Start Page, School Setup, Years and Terms

  • Attendance Codes: Before running the report, review existing attendance codes for the school year. The report will rename any non-state-approved codes as Invalid (if attendance records exist) or delete them (if no attendance records are linked). Verify you are aware of any custom codes that may be affected.

Navigation: Start Page, School Setup, Attendance Codes, filter by school year

  • Attendance Code Categories: Review existing attendance code categories. The report creates or updates the four SC state-approved categories: Excused, Unexcused, Out of School Suspension, and Tardy. Any categories not matching one of these values will be renamed as Invalid or deleted depending on whether attendance records are linked.

Navigation: Start Page, School Setup, Attendance Code Categories

Selection criteria

Selection criteria determine which database records are used in the report.

School Selection

  • The school must have currently enrolled students to be included in the process.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Select School Year

Choose the appropriate school year from the pop-up menu.

Schools to Include

Select All Schools to run the extract for all schools not excluded from state reporting.

Select Multiple Schools allows the user to use the Ctrl or SHIFT key on your keyboard to click each school you want to run the extract.

Report Output

The report standardizes Attendance Codes and Categories. See School Setup > Attendance Codes and School Setup > Attendance Code Categories for updated codes.

See Attendance Codes and Attendance Code Categories for updated lists of standardized attendance codes and categories.

Field

Description

[Table]Field Name

School Name

Name of the school. Displays in both the Updated and Not Updated sections.

Calculated

School Number

School number. Displays in both the Updated and Not Updated sections.

[Schools]School_Number