State Reporting 23.3.1.0 Release Notes

A release announcement will be posted on PowerSchool Community when the installer is available for download. Refer to 2023 State Reporting Releases for release dates.

Reference

Summary

Release Note

PSSR-310289

NC07 CFS Student Enrollment Report Logic Missing From the Tables

Updates are made to reflect the report logic at the table level.

PSSR-306878

State Reporting Dashboard is not Displaying the Number of Schools in Any Reports for Some Districts

The number of school counts in NC Dashboard reports is fixed and is displaying on the reports.

PSSR-314990

Table Data Type and extschema Update

The following changes have been made:

Altered column data type for these 4 columns: WHOCREATED, WHENCREATED, WHOMODIFIED, and WHENMODIFIED in the below mentioned tables.
S_NC_ACCESS_DATA, S_NC_CTE_CONCSURVEY, S_NC_CTE_SYSTEM_CODES, S_NC_ESR_DISTRICT,
S_NC_ESR_SCHOOL, S_NC_ESR_SYS_CODE, S_NC_HML_DETAIL, S_NC_HML_DISTRICT, S_NC_HML_SCHOOL,
S_NC_HML_SYS_CODE, S_NC_IMM_IMMIGRANT_DATA, S_NC_IMM_SYSTEM_CODES, S_NC_LEP_AUDIT, S_NC_LEP_DATA,
S_NC_LEP_DOM, S_NC_LEP_WORK, S_NC_LPD_PROFDEV, S_NC_LPD_SYSTEM_CODES, S_NC_NAD_CLUSTER, S_NC_NAD_DETAIL,
S_NC_NAD_DISTRICT, S_NC_NAD_SYS_CODE, S_NC_NDA_DISTRICT, S_NC_NDA_DISTRICT_PROGRAM, S_NC_NDA_LT_STU_PRETEST,
S_NC_NDA_LT_STU_PROGRESS, S_NC_NDA_STUDENT_AGE, S_NC_NDA_STUDENT_GENDER, S_NC_NDA_STUDENT_OUTCOME,
S_NC_NDA_STUDENT_RACE, S_NC_NDA_STUDENT_UNDUP, S_NC_NDA_SYS_CODE, S_NC_PLAN_ACCOM, S_NC_PLAN_DATA,
S_NC_PLAN_PROGRESS, S_NC_PLAN_STAFF, S_NC_RLI_DISTRICT, S_NC_RLI_SYS_CODE, S_NC_SIG_DISTRICT, S_NC_SIG_SCHOOL,
S_NC_SIG_SYS_CODE, S_NC_STP_DISTRICT, S_NC_STP_DISTRICT_ANSWER, S_NC_STP_SYS_CODE, S_NC_TAS_DETAIL,
S_NC_TAS_DISTRICT, S_NC_TAS_SCHOOL, S_NC_TAS_SYS_CODE, S_NC_WAPT_AUDIT, S_NC_WAPT_DATA,
S_NC_WAPT_IMPORT, S_NC_WAPT_IMPORT_HISTOR

2. Removed WHOCREATED, WHENCREATED, WHOMODIFIED, and WHENMODIFIED columns from the extschema xml file in all the tables mentioned in point 1. These columns should not be added in the extschema xml file as it gets created automatically as audit data.