S_NC_RPT_DISC_VCRIMESUMM_TBL (ver 13.6.0)
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 | Version | Data Type | Description |
---|---|---|---|
AR_COUNT | 13.6.0 | NUMBER(5,0) | The total count of assaults resulting in serious injury. |
AW_COUNT | 13.6.0 | NUMBER(5,0) | The total count of assaults involving a weapon. |
D_COUNT | 13.6.0 | NUMBER(5,0) | The total count of deaths by other than natural causes. |
IM_COUNT | 13.6.0 | NUMBER(5,0) | The total count of taking liberties with a minor. |
INSTANCE_ID | 13.6.0 | NUMBER(10,0) | The id that links this to the other discipline collection views. |
K_COUNT | 13.6.0 | NUMBER(5,0) | The total count of kidnappings. |
LEA_ID | 13.6.0 | VARCHAR2(20) | The LEA ID where the incident occurred. |
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. |
RW_COUNT | 13.6.0 | NUMBER(5,0) | The total count of robbery with a dangerous weapon. |
R_COUNT | 13.6.0 | NUMBER(5,0) | The total count of rape. |
SA_COUNT | 13.6.0 | NUMBER(5,0) | The total count of sexual assault. |
SCHOOL_ID | 13.6.0 | NUMBER(10,0) | The school where the incident occurred. |
SCHOOL_TOTAL | 13.6.0 | NUMBER(5,0) | The total reportable violent crime incidents for the school for the reporting year. |
SO_COUNT | 13.6.0 | NUMBER(5,0) | The total count of sexual offense. |