S_AK_LOG_X (ver 15.7.0)
This is an extension of the Log table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
LogDCID | 15.7.0 | Number(10,0) | Primary Key |
| Bullying_TypeID | 17.8.0 | Number(10,0) | The type of bullying that occurred. |
| ConsequenceAssignedBy | 17.8.0 | Varchar2(100) | The name of the school personnel who assigned the disciplinary action. |
| Consequence_Start_Date | 17.8.0 | Date | The start date of the student's disciplinary action. |
| Consequence_Return_Date | 17.8.0 | Date | The end date of the student's disciplinary action. |
| CRDC_Bullying | 17.8.0 | Varchar2(40) | The student's bullying, harassment, or intimidation offense. |
| Disability_Code | 17.8.0 | Varchar2(2) | The student's disability code. |
| Discipline_Mod | 17.8.0 | Varchar2(1) | An indicator of whether the disciplinary action was modified. |
| Discipline_Mod_Length | 17.8.0 | Number(25,10) | The final, actual length of time the student was removed from a regular education setting. |
| Discipline_Mod_Consequence | 17.8.0 | Varchar2(80) | The disciplinary action taken. |
| Educational_Services | 17.8.0 | Varchar2(1) | An indicator of whether the student received educational services during the expulsion. |
| Grade_Level | 17.8.0 | Number(10,0) | The student's grade level. |
Handicapping_Conditions | 15.7.0 | Varchar2(5) | Student With Disabilities. Migrated from [Logs.ak_handicapping_conditions]. |
| Hearing_Officer_Removal | 17.8.0 | Varchar2(1) | An indicator of whether a student with a disability was removed from his/her current educational placement to an appropriate interim alternative educational setting for no more than 45 school days by a hearing officer or the IEP team. |
IEP | 15.7.0 | Varchar2(5) | IEP. Migrated from [Logs.ak_IEP]. |
| Incident_Date | 17.8.0 | Date | The date of the offense which led to the student's suspension/expulsion. |
| IncidentID | 17.9.0 | Number(10,0) | The ID of the Incident. |
| Incident_Number | 17.8.0 | Number(10,0) | Not used. |
| Interim_Setting | 17.8.0 | Varchar2(160) | The name of the Interim Alternative Educational Setting that the student with a disability was removed to as a result of this incident. |
| LEPCode | 17.8.0 | Varchar2(5) | The student's English Language Learner code. |
| ModifiedOtherDesc | 17.9.0 | Varchar2(250) | A description of the disciplinary action taken. |
| NonWeapon_ID | 17.8.0 | Number(10,0) | The non-weapon infractions involved in this incident. |
| NumberVictims | 17.8.0 | Number(10,0) | Not used. |
| OtherDesc | 17.9.0 | Varchar2(250) | A description of the disciplinary action. |
| Other_NonWeapon_Description | 17.8.0 | Varchar2(160) | A description of non-weapon violation. |
| Other_Weapon_Description | 17.8.0 | Varchar2(160) | A description of the weapon violation. |
| Parent_Contacted | 17.8.0 | Number(1,0) | An indicator of whether the parent was contacted in the suspension/expulsion process. |
| Physical_Injury | 17.8.0 | Varchar2(1) | An indicator of whether one or more students, school personnel, or other person on the school grounds required professional medical attention due to the offense. |
| Return_Date | 17.8.0 | Date | The end date of the student's suspension/expulsion. |
| SchoolArrest | 17.9.0 | Number(1,0) | An idicator of whether the offense led to a school-related arrest. |
| SpEdIndicator | 17.9.0 | Varchar2(1) | An indicator of whether the student is a special education student. |
| SusExpRecord | 17.9.0 | Number(1,0) | Indicates this record was entered via the State Discipline Tracking interface. |
| TransferRequest | 17.8.0 | Number(10,0) | The number of student victims who requested to be transferred to a new education setting as a direct result of the incident. |
| TransferRequestCompleted | 17.8.0 | Number(10,0) | The number of student victims who were transferred to a new educational setting as a direct result of the transfer request. |
| Unilateral_Removal | 17.8.0 | Varchar2(1) | An indicator of whether a student with a disability was removed from his/her current educational placement to an appropriate interim alternative educational setting for no more than 45 school days by school personnel (not by a hearing officer or the IEP team). |
| Weapon_Code | 17.8.0 | Varchar2(10) | The student's weapon code violation. |
| Weapon_ID | 17.8.0 | Number(10,0) | The ID of the weapon used. |
| ZeroTolerance | 17.9.0 | Number(1,0) | An indicator of whether the student was expelled due to a zero tolerance issue. |
| CRDC_Harass_RelAffiliation | 22.1.2.0 | Varchar2(2) | CRDC Perceived Religion |