Skip to main content
Skip table of contents


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


Data Type


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 DATEThe 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 DATEThe 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 CHARIndicates 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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.