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 | Version | Data Type | Description |
|---|---|---|---|
| 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. |