S_PA_LOG_X (ver 17.3.0)
This table is an extension of the [Log] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| LogDCID | 17.3.0 | Number(10,0) | Foreign Key to the Log table. |
| Adjudication_Code | 17.3.0 | Varchar2(1) | Migrated from [Log]PA_Adjudication. |
| Against_Person | 17.3.0 | Varchar2(100) | Migrated from [Log]PA_Against_Person. |
| Against_Property | 17.3.0 | Varchar2(10) | Migrated from [Log]PA_Against_Prop. |
| Against_Society | 17.3.0 | Varchar2(10) | Migrated from [Log]PA_Against_Soc. |
| Arrest_Code | 17.3.0 | Varchar2(1) | Migrated from [Log]PA_Arrest. |
| Arrest_Code_TF | 17.3.0 | Number(1,0) | Migrated from [Log]PA_Arrest_Yes. |
| Assigned_To_Alternative_Edu_TF | 17.3.0 | Number(1,0) | Migrated from[Log]PA_Assign_Alt_Ed. |
| Assign_Ed_Hearing_TF | 17.3.0 | Number(1,0) | Migrated from [Log]PA_Assign_Ed_Hearing. |
| Disciplinary_Action_Code | 17.3.0 | Varchar2(60) | Migrated from [Log]PA_Disc_Action_Cd. |
| Disciplinary_Action_Comment | 17.3.0 | Varchar2(100) | Migrated from [Log]PA_Disc_Action_Comm. |
| Received_Edu_Serv_Dur_Expul_TF | 17.3.0 | Number(1,0) | Migrated from [Log]PA_Ed_Service_Expul. |
| Illegal_Possession_Of_Weapon | 17.3.0 | Varchar2(20) | Migrated from [Log]PA_Illegal_Pos. |
| Illegal_Possession_Code | 17.3.0 | Varchar2(10) | Migrated from [Log]PA_Illegal_Pos_Oth. |
| Incident_Number | 17.3.0 | Varchar2(30) | Migrated from [Log]PA_Incident_Num. |
| Include_Record_TF | 17.3.0 | Number(1,0) | Migrated from [Log]PA_Include_Record. |
| Infraction_Comment | 17.3.0 | Varchar2(2000) | Migrated from [Log]PA_Infraction_Comm. |
| Injury_Severity_Code | 17.3.0 | Varchar2(1) | Migrated from [Log]PA_Injury. |
| Limited_English_Proficiency_TF | 17.3.0 | Number(1,0) | Migrated from [Log]PA_Limited_Eng_Prof. |
| Name_Of_Contacted_LLE_Office | 17.3.0 | Varchar2(50) | Migrated from [Log]PA_Loc_Law_Office. |
| Local_Offender_Number | 17.3.0 | Varchar2(30) | Migrated from [Log]PA_Loc_Offend_Num. |
| LLE_Notified_TF | 17.3.0 | Number(1,0) | Migrated from [Log]PA_Local_Law_Not. |
| LocationFact_Others | 17.3.0 | Varchar2(10) | Migrated from [Log]PA_LocationFact_Oth. |
| Medical_Treatment_TF | 17.3.0 | Number(1,0) | Migrated from [Log]PA_Medical_Treat. |
| No_Of_Days_Suspended | 17.3.0 | Number(25,10) | Migrated from [Log]PA_Num_Days_Expel. |
| Offender_Disability_Code | 17.3.0 | Varchar2(2) | Migrated from [Log]PA_Offend_Dis. |
| Offender_Status_Code | 17.3.0 | Varchar2(1) | Migrated from [Log]PA_Offend_Stat. |
| Parent_Involvement_Comment | 17.3.0 | Varchar2(1000) | Migrated from [Log]PA_Par_Involv_Comm. |
| Parental_Involvement_Type | 17.3.0 | Varchar2(15) | Migrated from [Log]PA_Parental_Inv. |
| Physical_Injury_TF | 17.3.0 | Number(1,0) | Migrated from [Log]PA_Physical_Injury. |
| Place_Occurrence_Code | 17.3.0 | Varchar2(2) | Migrated from [Log]PA_Place_Occur. |
| Remedial_Program_Code | 17.3.0 | Varchar2(1) | Migrated from [Log]PA_Remedial_Prog. |
| Serious_Bodily_Injury_TF | 17.3.0 | Number(1,0) | Migrated from [Log]PA_Remove_Bodily. |
| Report_Type | 17.3.0 | Varchar2(10) | Migrated from [Log]PA_Report_Type. |
| Victim_Age | 17.3.0 | Number(11,0) | Migrated from [Log]PA_Vic_Age. |
| Medical_Treatment_TF | 17.3.0 | Number(1,0) | Migrated from [Log]PA_Vic_Med_Treat. |
| Medical_Treatment_Reason | 17.3.0 | Varchar2(1000) | Migrated from [Log]PA_Vic_Reason_Treat. |
| Referred_To_SAP_Program_TF | 17.3.0 | Number(1,0) | Migrated from [Log]PA_Vic_SAP_Prog. |
| Victim_Type | 17.3.0 | Varchar2(1) | Migrated from [Log]PA_Vic_Status. |
| Weapon_Count | 17.3.0 | Number(11,0) | Migrated from [Log]PA_Weap_Count. |
| Weapon_Detected_Comment | 17.3.0 | Varchar2(1000) | Migrated from: [Log]PA_Weap_Det_Comm. |
| Weapon_Detected_Method_Code | ver 17.3.0 | Varchar2(1) | Migrated from [Log]PA_Weap_Det_Meth. |
| LocationCodeOfIncident | ver 17.4.0 | Number(11,0) | Migrated from [Log]PA_LocationCodeOfIncident. |