S_NC_RPT_DISC_IMPERDTL_TBL (ver 13.6.0)
This table is a standalone table that stores information about the student impermissible uses of seclusion and restraint detail view.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| AVERSIVE_PROCED | 13.6.0 | NUMBER(10,0) | Indicates if the offense was type 097 for Aversive Procedure |
| ILLEGAL_MECHRESTR | 13.6.0 | NUMBER(10,0) | Indicates if the offense was type 099 for Illegal Mechanical Restraints |
| ILLEGAL_PHYRESTR | 13.6.0 | NUMBER(10,0) | Indicates if the offense was type 098 for Illegal Physical Restraints |
| ILLEGAL_SECLUSION | 13.6.0 | NUMBER(10,0) | Indicates if the offense was 100 for Illegal Seclusion Restraints |
| INCIDENT_NUMBER | 13.6.0 | NUMBER(10,0) | The incident number. |
| INSTANCE_ID | 13.6.0 | NUMBER(10,0) | The instance id that ties this table to the other discipline collection tables. |
| 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. |
| SCHOOL_ID | 13.6.0 | NUMBER(10,0) | The school where the incident occurred. |