S_NC_RPT_DISC_CRIMESUMM_TBL (ver 13.6.0)
This table is a stand alone table that stores information about the student reportable crimes summary view.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| AP_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of assault on school personnel. |
| AR_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of assault resulting in serious injury. |
| AW_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of assault involving a weapon. |
| BS_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of burning of school building. |
| BT_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of bomb threats. |
| D_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of death by other than natural causes. |
| IM_COUNT | 13.6.0 | NUMBER(5,0) | The incident 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 incident count of kidnappings. |
| LEA_ID | 13.6.0 | VARCHAR2(20) | The LEA ID where the incident occurred. |
| PA_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of possession of alcoholic beverage. |
| PF_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of possession of a firearm. |
| PS_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of possession of a controlled substance - Violation of Law. |
| PW_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of possession of a weapon. |
| 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 incident count of robbery with a dangerous weapon. |
| R_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of rape. |
| SA_COUNT | 13.6.0 | NUMBER(5,0) | The incident 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 crime incidents for the school for the reporting year. |
| SO_COUNT | 13.6.0 | NUMBER(5,0) | The incident count of sexual offense. |