S_TX_STU_SR_DISC_C (ver 16.11.0)
This table is a child of the Students table and is used for storing discipline data that was migrated from the SRUSER Student_Discipline table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| CRDC_BULLYING | 16.11.0 | VARCHAR2(1) | Indicates this incident is to be reported on CRDC as an offender of bullying. |
| CRDC_BULLYINGVICTIM | 16.11.0 | VARCHAR2(1) | Indicates this incident is to be reported on CRDC as a victim of bullying. |
| CRDC_CORPPUN_YN | 16.11.0 | VARCHAR2(15) | Indicates this incident is to be reported on CRDC as involving corporal punishment. |
| CRDC_DISC_TRANSFER | 16.11.0 | VARCHAR2(1) | Indicates the type of discipline transfer for this incident for CRDC reporting. |
| CRDC_OFFENSE_CATEGORY | 16.11.0 | VARCHAR2(2) | Indicates the type of offense for this incident for CRDC reporting. |
| CRDC_REFERLAW_YN | 16.11.0 | VARCHAR2(15) | Indicates that this incident resulted in a referral to law enforcement for CRDC reporting. |
| CRDC_REPORTBULLYING | 16.11.0 | VARCHAR2(1) | Indicates this incident is to be reported as an allegation of harassment/bullying for CRDC reporting. |
| CRDC_SCHOOLARREST_YN | 16.11.0 | VARCHAR2(15) | Indicates that this incident resulted in a school arrest for CRDC reporting. |
| CRDC_ZEROTOLERANCE_YN | 16.11.0 | VARCHAR2(15) | Indicates that the action taken on this incident was based on a zero tolerance policy that the district has for CRDC reporting. |
| DISCIPLINE_COMMENT | 16.11.0 | CLOB | Comments |
| DISC_ADMINISTRATOR | 16.11.0 | VARCHAR2(50) | The staff person that made the decision about the action to be taken for this incident. |
| DISC_LOCAL_ACTION_CODE | 16.11.0 | VARCHAR2(50) | Any local action code that was assigned to this incident. |
| DISC_SCHOOL_ID | 16.11.0 | VARCHAR2(15) | The school number where the incident occurred. |
| DISC_TEACHER | 16.11.0 | VARCHAR2(50) | The teacher reporting the incident. |
| E1003_CAMPUS_OF_ASSIGN | 16.11.0 | VARCHAR2(15) | Campus ID of Assignment |
| E1005_ACTION_CODE | 16.11.0 | VARCHAR2(15) | The action reported on the incident. |
| E1006_ACTION_REASON | 16.11.0 | VARCHAR2(15) | The behavior reported on the incident. |
| E1007_DURATION_ASSIGN | 16.11.0 | NUMBER(11,0) | The number of days the action is assigned. |
| E1008_DURATION_ACTUAL | 16.11.0 | NUMBER(11,0) | The actual number of days the action was served. |
| E1009_LENGTH_DIFF | 16.11.0 | VARCHAR2(15) | The reason there is a difference between the assigned days and the actual days. |
| E1016_INC_NUMBER | 16.11.0 | VARCHAR2(50) | The state incident number. |
| E1036_ACTION_DATE | 16.11.0 | DATE | The date the action began. |
| E1037_CAMPUS_OF_RESP | 16.11.0 | VARCHAR2(15) | The Campus ID of Responsibility for the incident. |
| E1083_BEHAVIOR_LOC | 16.11.0 | VARCHAR2(2) | The Behavior Location Code. |
| E1227_INCIDENTTIME | 16.11.0 | VARCHAR2(5) | The time the incident occurred. |
| E1228_INCIDENTLOCATION | 16.11.0 | VARCHAR2(2) | The location where the incident took place. |
| E1413_STUDENTDISCIPLINE | 16.11.0 | VARCHAR2(2) | Student Participation Code for TSDS Dashboard. |
| EXCLUDE_FROM_DASHBOARD | 16.11.0 | VARCHAR2(1) | Indicates if the incident should be reported in the Dashboard extract. |
| EXCLUDE_FROM_PEIMS | 16.11.0 | NUMBER(1,0) | Indicates if the incident should be reported in the PEIMS extract. |
| ID | 16.11.0 | NUMBER(10,0) | Primary key |
| INCIDENT_DATE | 16.11.0 | DATE | The date the incident occurred. |
| RECORD_ID | 16.11.0 | NUMBER(11,0) | The record id from the SRUSER Student_Discipline table. |
| STUDENTSDCID | 16.11.0 | NUMBER(10,0) | The foreign key to link to the student table. |