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. |