S_NC_RPT_DISC_BEHAVIOR (ver 13.6.0)
This table is a stand alone table that stores information about the student behavior on incidents.
Column Name | Version | Data Type | Description |
---|---|---|---|
BEHAVIOR_CATEGORY | 13.6.0 | VARCHAR2(80) | The category for the behavior on the incident. |
BEHAVIOR_CODE | 13.6.0 | VARCHAR2(20) | The behavior code on the incident if it is a reportable crime offense. |
BEHAVIOR_DESC | 13.6.0 | VARCHAR2(80) | The description of the offense. |
HAS_FATALS | 13.6.0 | CHAR | Indicates if there are fatals on this record and is not counted in the view. |
INCIDENT_ID | 13.6.0 | NUMBER(10,0) | Incident ID. |
OFFENDER_ID | 13.6.0 | NUMBER(10,0) | The state student or staff number for the student on the record. |
OFFENDER_TYPE | 13.6.0 | VARCHAR2(20) | Indicates if the offender is a student, staff or other. |
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. |