Skip to main content
Skip table of contents


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

Column Name


Data Type


AP_COUNT13.6.0 NUMBER(5,0)The incident count of assault on school personnel.
AR_COUNT13.6.0 NUMBER(5,0)The incident count of assault resulting in serious injury.
AW_COUNT13.6.0 NUMBER(5,0)The incident count of assault involving a weapon.
BS_COUNT13.6.0 NUMBER(5,0)The incident count of burning of school building.
BT_COUNT13.6.0 NUMBER(5,0)The incident count of bomb threats.
D_COUNT13.6.0 NUMBER(5,0)The incident count of death by other than natural causes.
IM_COUNT13.6.0 NUMBER(5,0)The incident 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 incident count of kidnappings.
LEA_ID13.6.0 VARCHAR2(20)The LEA ID where the incident occurred.
PA_COUNT13.6.0 NUMBER(5,0)The incident count of possession of alcoholic beverage.
PF_COUNT13.6.0 NUMBER(5,0)The incident count of possession of a firearm.
PS_COUNT13.6.0 NUMBER(5,0)The incident count of possession of a controlled substance - Violation of Law.
PW_COUNT13.6.0 NUMBER(5,0)The incident count of possession of a weapon.
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 incident count of robbery with a dangerous weapon.
R_COUNT13.6.0 NUMBER(5,0)The incident count of rape.
SA_COUNT13.6.0 NUMBER(5,0)The incident 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 crime incidents for the school for the reporting year.
SO_COUNT13.6.0 NUMBER(5,0)The incident 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.