S_VA_LOG_X (ver 16.6.0)
This table is an extension of the [Log] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| LogDCID | 16.6.0 | Number(10,0) | Foreign Key to Log table. |
| Aggravating_Circumstances | 19.1.0 | Varchar2(1) | Indicates if a discipline incident is associated with aggravating circumstances. |
| Alternative_Placement_TF | 16.6.0 | Number(1,0) | Migrated from: [Log]VA_placement |
| Days_Suspended | 16.6.0 | Number(25,10) | Migrated from: [Log]VA_days_suspended |
| Enrolled_Division | 16.6.0 | Varchar2(20) | Migrated from: [Log]VA_enrolled_division |
| Enrolled_School | 16.6.0 | Varchar2(20) | Migrated from: [Log]VA_enrolled_school |
| Final_Sanction_Code | 16.6.0 | Varchar2(3) | Migrated from: [Log]VA_sanction |
| Graded_Work_Provided | 20.9.3.0 | Varchar2(1) | To record if graded work was provided to meet the 2020-21 collection requirements. |
| Incident_Date | 16.6.0 | Date | Migrated from: [Log]VA_incident_date |
| Incident_Division | 16.6.0 | Varchar2(20) | Migrated from: [Log]VA_incident_division |
| Incident_ID | 16.6.0 | Varchar2(50) | Migrated from: [Log]VA_incident_code |
| Incident_School | 16.6.0 | Varchar2(20) | Migrated from: [Log]VA_incident_school |
| Incident_Time_Code | 16.6.0 | Varchar2(3) | Migrated from: [Log]VA_time_code |
| Num_Firearms_Confiscated | 16.6.0 | Varchar2(5) | Migrated from: [Log]VA_firearms |
| Num_Non_Firearms_Confiscated | 16.6.0 | Varchar2(5) | Migrated from: [Log]VA_non_firearms |
| Num_Victims | 16.6.0 | Number(11,0) | Migrated from: [Log]VA_victims |
| Offense_Code2 | 16.6.0 | Varchar2(5) | Migrated from: [Log]VA_offense_code2 |
| Offense_Code3 | 16.6.0 | Varchar2(5) | Migrated from: [Log]VA_offense_code3 |
| Permanent_Change_Placement_TF | 16.6.0 | Number(1,0) | Migrated from: [Log]VA_Permanent_Change_Placement |
| Permanent_Expulsion_TF | 16.6.0 | Number(1,0) | Migrated from: [Log]VA_expulsion |
| Primary_Offense_Code | 16.6.0 | Varchar2(5) | Migrated from: [Log]VA_primary_code |
| Reported_To_Law_Enforcement_TF | 16.6.0 | Number(1,0) | Migrated from: [Log]VA_reported_law |
| StuSeclusion | 19.8.2.0 | Varchar2(1) | Used for private schools for disabled students. Indicates cumulative number of times student required seclusion. |
| StuRestraint | 19.8.2.0 | Varchar2(1) | Used for private schools for disabled students. Indicates cumulative number of times student required restraint. |
| Law_Enf_Charged_YN | 16.11.0 | Boolean(1) | Indicates whether law enforcement charges were filed. |
| Providing_Edu_Serv | 16.11.0 | Boolean(1) | Indicates whether a means for obtaining coursework was provided. |