Skip to main content
Skip table of contents

S_NC_RPT_RUN_LOGGING (ver 13.6.0)

This table is used exclusively for state reporting and stores data on instances of each report.

Column Name


Data Type


INSTANCE_ID 13.6.0 VARCHAR2(10)The ID linking this row to a specific row in the CST_DSHReportSubmissions table.
LEA_ID 13.6.0 VARCHAR2(10)The LEA number for this report run/instance id.
LOG_MESSAGE 13.6.0 VARCHAR2(2000)Indicates the log message collected for this record.
LOG_PARAMETERS 13.6.0 VARCHAR2(100)Indicates the report parameters that were in place for this log record.
LOG_TS 13.6.0 TIMESTAMP(6)Indicates the date/time the record log was created.
LOG_TYPE 13.6.0 VARCHAR2(20)Indicates if this log record was created through the report package or a trigger.
LOG_USER 13.6.0 VARCHAR2(100)Indicates who the user was that ran the report.
RPT_RUN_ID 13.6.0 VARCHAR2(10)Indicates the unique report run ID for this run. This links to the S_NC_RPT_RUN table to identify the LEA, School, Report Type, Instance ID, and Year ID.
RPT_TYPE 13.6.0 VARCHAR2(10)The code for the type of state report.
SCHOOLID 13.6.0 VARCHAR2(10)The school number for this report run/instance id.
YEARID 13.6.0 VARCHAR2(10)The year id for the school year the report was run.

JavaScript errors detected

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

If this problem persists, please contact our support.