S_TN_LOG_CRDC_X (ver 16.10.1)
This table is an extension of the [Logs] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
logDCID | 16.10.1 | Number(10,0) NOT NULL | A foreign key that relates the extended table to the [Log] table. |
TRANSFERALTSCHOOL | 16.10.1 | Varchar2(1) | Transfer to Alternative School or Regular School. |
| OFFENSEINCIDENTINVOLVE | 16.10.1 | Varchar2(10) | Offenses - Incident Involved: (select the most egregious). |
| DISCIPLINESEX | 16.10.1 | Number(1,0) | Disciplined based on sexual harassment or bullying.. |
| DISCIPLINERACE | 16.10.1 | Number(1,0) | Disciplined based on racial harassment or bullying |
| DISCIPLINEDISABLE | 16.10.1 | Number(1,0) | Disciplined for harassment or bullying of disabled person. |
| DiscActTaken | 17.6.0 | Varchar2(3) | Discipline Action Taken. |
| DiscArrest_YN | 17.6.0 | Varchar2(1) | Disciplined based on School-related Arrest. |
| DiscCorpSeclusion_YN | 17.6.0 | Varchar2(1) | Incident based on Seclusion. |
| DiscHarassDisability_YN | 17.6.0 | Varchar2(1) | Incident based on Disability. |
| DiscHarassOffender_YN | 17.6.0 | Varchar2(1) | Incident based on Offender. |
| DiscHarassRace_YN | 17.6.0 | Varchar2(1) | Incident based on Race, color or national origin. |
| DiscHarassSex_YN | 17.6.0 | Varchar2(1) | Incident based on Sex. |
| DiscHarassVictim_YN | 17.6.0 | Varchar2(1) | Incident based on Victim. |
| DiscLawEnforcement_YN | 17.6.0 | Varchar2(1) | Disciplined based on the student referred to law enforcement. |
| DiscMechanicalRestraint_YN | 17.6.0 | Varchar2(1) | Incident based on Mechanical Restraint. |
| DiscPhysicalRestraint_YN | 17.6.0 | Varchar2(1) | Incident based on Physical Restraint. |
| DiscZeroTolerance_YN | 17.6.0 | Varchar2(1) | Disciplined based on the Expulsion under a zero-tolerance policy. |