Skip to main content
Skip table of contents

S_NC_RPT_DISC_CRIMEDTL_TBL (ver 13.6.0)

This table is a stand alone table that stores information about the student reportable crimes detail view.

Column Name

Version

Data Type

Description

BEHAVIOR_CODE13.6.0 VARCHAR2(2)The behavior code on the incident.
BEHAVIOR_STATE_CODE13.6.0 VARCHAR2(2)The state code for the behavior code to note the type of reportable crime.
INCIDENT_NUMBER13.6.0 NUMBER(10,0)The incident number.
INSTANCE_ID13.6.0 NUMBER(10,0)The id that links this to the other discipline collection views.
LEA_ID13.6.0 VARCHAR2(20)The LEA ID where the incident occurred.
OFFENDER_NAME13.6.0 VARCHAR2(100)The name of the student or staff that was the offender.
OFFENSE_DATE13.6.0 VARCHAR2(10)The date of the offense.
OFFENSE_TYPE13.6.0 VARCHAR2(100)The description of the offense.
RPT_RUN_ID13.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.
SCHOOL_ID13.6.0 NUMBER(10,0)The school where the incident occurred.
STUDENT_ID13.6.0 VARCHAR2(15)The state number of the student that was the offender.



JavaScript errors detected

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

If this problem persists, please contact our support.