S_NC_RPT_DISC_TRANSDTL_TBL (ver 13.6.0)
This table is a stand alone table that stores information used in the student discipline views particularly the Transferred Offered to Violent Crimes Detail View.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| INCIDENT_NUMBER | 13.6.0 | NUMBER(10,0) | Indicates the incident number. |
| INSTANCE_ID | 13.6.0 | NUMBER(10,0) | Indicates the instance id that links back to the S_NC_RPT_RUN table along with the RPT_RUN_ID. |
| LEA_ID | 13.6.0 | VARCHAR2(20) | Indicates the LEA number where the incident occurred. |
| NOAVALIABLE_TRANSFER | 13.6.0 | NUMBER(10,0) | Indicates whether or not a transfer was available or not. |
| 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 |
| SCHOOL_ID | 13.6.0 | NUMBER(10,0) | Indicates the School number where the incident occurred. |
| STUDENT_ID | 13.6.0 | VARCHAR2(15) | Indicates the student number of the student involved in this violent crime. |
| STUDENT_NAME | 13.6.0 | VARCHAR2(100) | Indicates the student name of the student involved in this violent crime. |
| VICACCEPTED_TRANSFER | 13.6.0 | NUMBER(10,0) | Indicates if the student accepted the offer of a transfer to another school. This is based on sub-codes setup in the Action Codes for Victim Actions. |
| VICDECL_TRANFEROFFER | 13.6.0 | NUMBER(10,0) | Indicates if the student declined the offer of a transfer to another school.This is based on sub-codes setup in the Action Codes for Victim Actions. |
| VICNOTOFF_TRANSFER | 13.6.0 | NUMBER(10,0) | Indicates if the student was not offered a transfer to another school.This is based on sub-codes setup in the Action Codes for Victim Actions. |
| VICOFF_TRANSFER | 13.6.0 | NUMBER(10,0) | Indicates if the student was offered a transfer to another school.This is based on sub-codes setup in the Action Codes for Victim Actions. |