S_MA_LOG_Discipline_X (ver 15.3.0)
This table is an extension of the Log table, which maintains offense and discipline data for students.
Column Name | Version | Data Type | Description |
|---|---|---|---|
LogDCID | 15.3.0 | Number(10,0) | Primary key that relates the extended table to the [Log] table. |
| ActionTaken | 15.11.0 | Varchar2(10) | Code indicating the discipline action taken against the student perpetrator in this log entry. Migrates from [Log]MA_DAT. |
| AEOtherSpecExplanation | 15.3.0 | Varchar2(500) | Additional information related to the educational services provided or the reason educational services were not provided. |
AltEdIndicator | 15.11.0 | Varchar2(2) | Indicates whether or not alternative education was provided to the student. Migrates from [Log]MA_AEInc. |
| AltEdNotProvidedCode | 15.11.0 | Varchar2(2) | Code indicating the reason alternative education was not provided to the student. Migrates from [Log]MA_NAE. |
AltEdProvidedCode | 15.11.0 | Varchar2(2) | Code indicating the type of alternative education that was provided to the student. Migrates from [Log]MA_AE. |
| AppealCode | 15.3.0 | Number(1,0) | Indicates if the student appealed the suspension/expulsion decision to the superintendent. |
| DaysMissed | 15.11.0 | Number(25,10) | The number of days of school the student missed due to the disciplinary action taken. Migrates from [Log]MA_DaysMissed. |
| DisciplineActionIndicator | 15.11.0 | Varchar2(1) | Indicates whether or not this offense resulted in a disciplinary action. Migrates from [Log]MA_DiscInd. |
| EligibleReturnDate | 15.11.0 | Date | The date the student was eligible to return to school. Migrates from [Log]MA_EligibleReturnDate. |
| ExtraSuspDays | 15.3.0 | Number(11,0) | The number of additional suspension days beyond the emergency removal. |
| IncidentDesciption | 15.11.0 | Varchar2(100) | A general description of the incident. Migrates from [Log]MA_INC_DESC. |
| NonSchoolPersVictimCount | 15.11.0 | Number(11,0) | The number of non-school personnel victims involved in this incident. Migrates from [Log]MA_VNSCHP. |
| NonStudentOffenderCount | 15.11.0 | Number(11,0) | The number of non-student offenders involved in this incident. Migrates from [Log]MA_OFFENS. |
Offense1Desc | 15.3.0 | Varchar2(500) | Additional description for offense 1. |
Offense2Desc | 15.3.0 | Varchar2(500) | Additional description for offense 2. |
Offense3Desc | 15.3.0 | Varchar2(500) | Additional description for offense 3. |
Offense4Desc | 15.3.0 | Varchar2(500) | Additional description for offense 4. |
Offense5Desc | 15.3.0 | Varchar2(500) | Additional description for offense 5. |
| OffenseDate | 15.11.0 | Date | The date the offense occurred. Migrates from [Log]MA_OFFDATE. |
| PhysicalInjuryInd | 15.11.0 | Varchar2(1) | Indicates if the offense resulted in a physical injury. Migrates from [Log]MA_PHYSINJ. |
| ProgramStatusCode | 15.11.0 | Varchar2(1) | Indicates whether or not the student is in special education and has an IEP. Migrates from [Log]MA_PST. |
| ReturnDate | 15.11.0 | Date | The date the student returned to school after the disciplinary action. Migrates from [Log]MA_ReturnDate. |
| SchoolPersVictimCount | 15.11.0 | Number(11,0) | The number of school personnel victims involved in this incident. Migrates from [Log]MA_VSCHP. |
| SevereBodilyInjuryOffenseInd | 15.11.0 | Varchar2(2) | Indicates whether or not the student is being disciplined as a result of an incident that caused serious bodily injury. Migrates from [Log]MA_BiInd. |
| SOT1 | 15.3.0 | Varchar2(5) | Code for the primary offense that was committed which resulted in a disciplinary action. |
| SOT2 | 15.3.0 | Varchar2(5) | Code for an additional offense that was committed which resulted in a disciplinary action, if applicable. |
| SOT3 | 15.3.0 | Varchar2(5) | Code for an additional offense that was committed which resulted in a disciplinary action, if applicable. |
| SOT4 | 15.3.0 | Varchar2(5) | Code for an additional offense that was committed which resulted in a disciplinary action, if applicable. |
| SOT5 | 15.3.0 | Varchar2(5) | Code for an additional offense that was committed which resulted in a disciplinary action, if applicable. |
| StartDate | 15.11.0 | Date | The date the disciplinary action started for the student. Migrates from [Log]MA_StartDate. |
| StateIncidentID | 15.11.0 | Varchar2(30) | ID that uniquely identifies this incident and other related incidents to the state. Migrates from [Log]MA_IncidentID. |
| State_ExcludeFromReporting | 15.11.0 | Number(1,0) | Indicates if this discipline record should be excluded from state reporting. Migrates from [Log]MA_OFFIND. |
| StudentOffenderCount | 15.11.0 | Number(11,0) | Count of student offenders that were involved in this incident. Migrates from [Log]MA_OFFES. |
| StudentOffense1 | 15.11.0 | Varchar2(4) | Code for an offense committed as part of this incident whether or not the offense resulted in an action. Migrates from [Log]MA_OT1. |
| StudentOffense2 | 15.11.0 | Varchar2(4) | Code for a second offense committed as part of this incident whether or not the offense resulted in an action. Migrates from [Log]MA_OT2. |
| StudentOffense3 | 15.11.0 | Varchar2(4) | Code for a third offense committed as part of this incident whether or not the offense resulted in an action. Migrates from [Log]MA_OT3. |
| StudentOffense4 | 15.11.0 | Varchar2(4) | Code for a fourth offense committed as part of this incident whether or not the offense resulted in an action. Migrates from [Log]MA_OT4. |
| StudentOffense5 | 15.11.0 | Varchar2(4) | Code for a fifth offense committed as part of this incident whether or not the offense resulted in an action. Migrates from [Log]MA_OT5. |
| StudentVictimCount | 15.11.0 | Number(11,0) | Count of student victims that were involved in this incident. Migrates from [Log]MA_VS. |
| UnknownOffenderCount | 15.11.0 | Number(11,0) | Count of unknown offenders that were involved in this incident. Migrates from [Log]MA_OFFEU. |
| UnknownVictimCount | 15.11.0 | Number(11,0) | Count of unknown victims that were involved in this incident. Migrates from [Log]MA_VU. |
| DiscEndDate | 17.7.0 | Date | Discipline End Date |
| SSDR_Disciplinary_Action | 19.8.2 | Boolean(1) | Indicates whether the incident resulted in a referral to law enforcement. |