Skip to main content
Skip table of contents


This table is a stand alone table that stores information about the student violent crimes summary view. The details are included in the reportable crimes detail view.

Column Name


Data Type


AR_COUNT13.6.0 NUMBER(5,0)The total count of assaults resulting in serious injury.
AW_COUNT13.6.0 NUMBER(5,0)The total  count of assaults involving a weapon.
D_COUNT13.6.0 NUMBER(5,0)The total count of deaths by other than natural causes.
IM_COUNT13.6.0 NUMBER(5,0)The total count of taking liberties with a minor.
INSTANCE_ID13.6.0 NUMBER(10,0)The id that links this to the other discipline collection views.
K_COUNT13.6.0 NUMBER(5,0)The total count of kidnappings.
LEA_ID13.6.0 VARCHAR2(20)The LEA ID where the incident occurred.
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.
RW_COUNT13.6.0 NUMBER(5,0)The total count of robbery with a dangerous weapon.
R_COUNT13.6.0 NUMBER(5,0)The total count of rape.
SA_COUNT13.6.0 NUMBER(5,0)The total count of sexual assault.
SCHOOL_ID13.6.0 NUMBER(10,0)The school where the incident occurred.
SCHOOL_TOTAL13.6.0 NUMBER(5,0)The total reportable violent crime incidents for the school for the reporting year.
SO_COUNT13.6.0 NUMBER(5,0)The total count of sexual offense.

JavaScript errors detected

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

If this problem persists, please contact our support.