State Reporting 23.3.1.0 Release Notes | PowerSchool SIS Compliance

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.

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.