S_NC_RPT_DISC_ACTIONSUMM_TBL (ver 13.6.0)
This table is a stand alone table that stores information about the student discipline summary view.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| CORPORAL_PUNISHMENT | 13.6.0 | NUMBER(5,0) | Indicates the number of instances that involved corporal punishment. |
| EXPULSION | 13.6.0 | NUMBER(5,0) | Indicates the number of instances that involved expulsion. |
| INSTANCE_ID | 13.6.0 | NUMBER(10,0) | The instance id that ties this table to the other discipline collection tables. |
| ISS | 13.6.0 | NUMBER(5,0) | Indicates the number of in school suspensions. |
| LEA_ID | 13.6.0 | VARCHAR2(20) | Indicates the LEA number for the collection. |
| LONG_OSS | 13.6.0 | NUMBER(5,0) | Indicates the number of Long Term Out of School suspensions. |
| 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 number for the collection. |
| SHORT_OSS | 13.6.0 | NUMBER(5,0) | Indicates the number of Short Term Out of School suspensions. |