S_NC_RPT_RUN (ver 13.6.0)
This table is used exclusively for state reporting and provides a unique identifier used in other S_NC_RPT_* tables, providing the LEA, school, and dashboard instance as context. An entry is created in this table each time a school chooses to run a collection. Collected data is stored in the appropriate S_NC_RPT_x table(s).
Column Name | Version | Data Type | Description |
|---|---|---|---|
RPT_Run_ID | 13.6.0 | Number(11,0) | The unique ID for this row. |
SchoolID | 13.6.0 | Number(11,0) | The school number for this report run. |
LEA_ID | 13.6.0 | Varchar2(10) | The LEA number for this report run. |
Instance_ID | 13.6.0 | Number(11,0) | The ID linking this row to a specific row in the CST_DSHReportSubmissions table. |
Rpt_Type | 13.6.0 | Varchar2(10) | An abbreviated name for the state report or collection. |
WhenCreated | 13.6.0 | Date | The system date when the row was created. |
WhenModified | 13.6.0 | Date | The system date when the row was modified. |
WhoCreated | 13.6.0 | Varchar2(100) | The Oracle account used to create the row. |
WhoModified | 13.6.0 | Varchar2(100) | The Oracle account used to modify the row. |