S_NC_RPT_DISC_OFFENDER (ver 13.6.0)
This table is a stand alone table that stores information used in the student discipline views particularly the Incident Detail Report for offenders.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| HAS_FATALS | 13.6.0 | CHAR(1) | Indicates if there are issues on this record that cause a fatal exception which will prevent the record from being counted on the reports summarized for the state. |
| INCIDENT_DATE | 13.6.0 | DATE | The date the incident occurred. |
| INCIDENT_ID | 13.6.0 | NUMBER(10,0) | Indicates the incident number. |
| LOCATION_CODE | 13.6.0 | VARCHAR2(3) | The code that indicates the location where the incident occurred. |
| LOCATION_DESC | 13.6.0 | VARCHAR2(100) | The description for the location where the incident occurred. |
| OFFENDER_AGE | 13.6.0 | NUMBER(5,0) | The age at the time of the incident of the offender. |
| OFFENDER_BIRTH_DATE | 13.6.0 | DATE | The birth date of the offender. |
| OFFENDER_EC | 13.6.0 | VARCHAR2(4) | The offender's exceptionality code if applicable. |
| OFFENDER_ETHNIC_DESC | 13.6.0 | VARCHAR2(50) | The description of the student's ethnicity. |
| OFFENDER_FIRST_NAME | 13.6.0 | VARCHAR2(50) | The offender's first name. |
| OFFENDER_GENDER | 13.6.0 | VARCHAR2(2) | The gender of the offender. |
| OFFENDER_GRADE_CODE | 13.6.0 | VARCHAR2(4) | The offender's PowerSchool grade level at the time of the incident. |
| OFFENDER_ID | 13.6.0 | NUMBER(10,0) | Indicates the student id of the offender. |
| OFFENDER_LAST_NAME | 13.6.0 | VARCHAR2(50) | The offender's last name. |
| OFFENDER_STATE_ETHNIC_CODE | 13.6.0 | VARCHAR2(1) | The offender's ethnicity code. |
| OFFENDER_STATE_GRADE_CODE | 13.6.0 | VARCHAR2(4) | The offender's State grade level at the time of the incident (i.e KI for grade 0) |
| OFFENDER_STATE_RPT_CODE | 13.6.0 | VARCHAR2(20) | Indicates the appropriate code from the incident participant role codes for this offender. |
| OFFENDER_STATE_RPT_FLAG | 13.6.0 | CHAR | Indicates if this student is reported to the state or not. 0 indicates a yes. |
| OFFENDER_STATE_STUDENTID | 13.6.0 | VARCHAR2(20) | Indicates the state student number for this offender if it is a student. |
| OFFENDER_TYPE | 13.6.0 | VARCHAR2(20) | Indicates if offender type is student or staff from participant role codes. |
| 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 |