S_NC_RPT_DISC_ACTIONDTL_TBL (ver 13.6.0)
This table is a stand alone table that stores information about the student discipline action details.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ACTION_DAYS | 13.6.0 | VARCHAR2(10) | The number of action days for this instance. |
| ACTION_TYPE | 13.6.0 | VARCHAR2(100) | Indicates the type of the action. |
| INCIDENT_NUMBER | 13.6.0 | NUMBER(10,0) | The incident id 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) | Indicates the LEA number where the incident occurred. |
| OFFENSE_DATE | 13.6.0 | VARCHAR2(10) | The date that the offense 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 number where the incident occurred. |
| STUDENT_ID | 13.6.0 | VARCHAR2(12) | The state student number. |
| STUDENT_NAME | 13.6.0 | VARCHAR2(100) | The name of the student. |