S_MD_LOG_ARREST_X (ver 17.5.0)
This table is an extension of the [LOG] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
LogDCID | 17.5.0 | Number (10,0) | Foreign key |
| Date_of_Arrest | 17.5.0 | Date | Date of the student arrest. |
| Days_Removed_After | 17.5.0 | Number (25,10) | Number of days the student was suspended/excluded from school after the arrest. |
| DJS_Referred | 17.5.0 | Varchar2 (1) | Indicates if school‐based incident lead to DJS referral. |
| DJS_Referred_By | 17.5.0 | Varchar2 (200) | Name of the person who made the DJS referral. |
| DJS_Referred_By_Position | 18.10.0 | Varchar2 (4) | If incident led to DJS referral, report the position of the person that made the referral. |
| Foster_Care_TF | 22.8.2.0 | Varchar2 (1) | Indicates an override to the student's foster care status from the State/Province - MD page. |
| Juvenile_Detent_Length | 17.5.0 | Number (25,10) | Number of days the student was in Juvenile Placement or Juvenile Detention. |
| Law_Enf_Referral | 17.5.0 | Varchar2 (1) | Indicates if school‐based incident led to a law enforcement referral. |
| Location | 17.5.0 | Varchar2 (2) | Location of the arrest. |
| Offense | 18.10.0 | Varchar2 (4) | The offense that led to the arrest. |
| Officer | 17.5.0 | Varchar2 (2) | Indicates which officer made the arrest. |
| Officer_Is_Prim_Sch | 17.5.0 | Varchar2 (1) | Indicates if arresting officer is primarily assigned to the school where the arrest occurred. |
| Officer_Prim_Sch_Name | 17.5.0 | Varchar2 (200) | If arresting officer is not primarily assigned to the school, indicates where they are assigned. |
| Outcome | 17.5.0 | Varchar2 (2) | The final outcome of the process. |
| Type | 17.5.0 | Varchar2 (2) | The offense that led to the arrest. |