S_NC_RPT_DISC_OBJECTS (ver 13.6.0)
This table is a stand alone table that stores information used in the student discipline views.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| HAS_FATALS | 13.6.0 | CHAR(1) | Indicates if the weapons involved cause a fatal exception. |
| INCIDENT_ID | 13.6.0 | NUMBER(10,0) | Indicates the incident number. |
| OBJECT_CODE | 13.6.0 | VARCHAR2(20) | Indicates the state reportable code for the weapon. |
| OBJECT_DESC | 13.6.0 | VARCHAR2(80) | Indicates the description of the weapon based on the object code. |
| OFFENDER_ID | 13.6.0 | NUMBER(10,0) | Indicates the student id of the offender. |
| OFFENDER_TYPE | 13.6.0 | VARCHAR2(20) | Indicates if offender type such as student or staff. |
| RPT_RUN_ID | 13.6.0 | NUMBER | 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. |