S_NE_LOG_X (ver 15.11.0)
This table is an extension of the LOG table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
LOGDCID | 15.11.0 | Number(10,0) | Primary key. |
Action_Date | 15.11.0 | Date | Discipline action date. Migrated from [Log]Action_Date. |
Action_Taken | 15.11.0 | Varchar2(2) | Discipline action taken. Migrated from [Log]Action_Taken. |
| Action_Taken_Subcode | 18.4.0 | Varchar2(2) | Discipline action taken Subcode. |
Alcohol | 15.11.0 | Varchar2(1) | Was the discipline alcohol related. Migrated from [Log]Alcohol. |
Drugs | 15.11.0 | Varchar2(1) | Was the discipline drug related. Migrated from [Log]Drugs. |
Duration | 15.11.0 | Varchar2(5) | Duration of the discipline.Migrated from [Log]Duration. |
Gang_Related | 15.11.0 | Varchar2(1) | Was the discipline gang related. Migrated from [Log]GangRelated. |
| Gun_Free_School_Violation | 18.2.0 | Varchar2(1) | Was the incident a Gun Free School violation. |
| Hate_Crime | 15.11.0 | Varchar2(1) | Was the discipline hate crime related. Migrated from [Log]HateCrime. |
| Incident_Context | 15.11.0 | Varchar2(1) | Context. Migrated from [Log]Incident_Context. |
| Incident_Type | 15.11.0 | Varchar2(3) | Type of Incident. Migrated from [Log]Incident_Type. |
| Location_Incident | 15.11.0 | Varchar2(1) | Where the incident took place. Migrated from [Log]Location_Incident. |
| Money_Loss | 15.11.0 | Varchar2(30) | Was there a monetary charge for the incident. Migrated from [Log]Money_Loss. |
| Offender | 15.11.0 | Varchar2(1) | Who was the Offender. Migrated from [Log]Offender. |
| Police_Involvement | 15.11.0 | Varchar2(1) | Were the policy involved. Migrated from [Log]Police_Involvement. |
| Reporter | 15.11.0 | Varchar2(1) | Who was the Reporter. Migrated from [Log]Reporter. |
| Seq | 15.11.0 | Number(11,0) | Sequence number. Migrated from [Log]Sequence. |
| Victim_Type | 15.11.0 | Varchar2(1) | Type of victim. Migrated from [Log]Victim_Type. |
| Weapon | 15.11.0 | Varchar2(1) | Was a weapon used. Migrated from [Log]Weapon. |
| WeaponType | 15.11.0 | Varchar2(1) | Type of weapon used. Migrated from [Log]Weapon_Type. |