S_NC_RPT_DISC_VICTIM (ver 13.6.0)
This table is a stand alone table that stores information used in the student discipline views particularly the Incident Detail Report for victms.
Column Name | Version | Data Type | Description |
---|---|---|---|
INCIDENT_DATE | 13.6.0 | DATE | The date of the incident. |
INCIDENT_ID | 13.6.0 | NUMBER(10,0) | The incident id of the incident. |
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. |
VICTIM_ID | 13.6.0 | NUMBER(10,0) | Indicates the student id of the victim. |
VICTIM_STATE_RPT_CODE | 13.6.0 | VARCHAR2(20) | Indicates the appropriate code from the incident participant role codes for this victim. |
VICTIM_TYPE | 13.6.0 | VARCHAR2(20) | Indicates the victim type code such as student or staff from the participant role codes. |