Incident_LU_Sub_Code (ver5.2.0)
This table contains details for codes used to define the specific characteristics of the incident.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Application_Display_Order | 5.2.0 | Number(10) | A user-defined value that determines the order in which codes are displayed on the user interface. |
Comment_Enable_State | 6.0.1 | Varchar2(30) | Valid values: Disabled, Force. This will be enabled to allow a comment on a field. |
Created_By | 5.2.0 | Varchar2(30) | The username of the session that created the record. |
Created_TS | 5.2.0 | Timestamp(6) | The date and time when this record was created. |
Datatype_Attribute | 6.0.1 | Varchar2(30) | Value is used with a code_type of "actionattribute". Valid values: Text, Number, Date, Boolean, Select. |
Effective_Begin_DT | 5.2.0 | Date(0) | Not currently used. |
Effective_End_DT | 5.2.0 | Date(0) | Not currently used. |
Is_Affects_Attendance_Flg | 7.9.1 | Number(1, 0) | No longer used by the application. The field may still be reference on reports and/or custom pages. |
Is_Police_Reportable_Flg | 5.2.0 | Number(1) | Indicates whether the incident is police reportable, or not. Valid values: 1=true, 0=false. Defaults to 0. |
Is_State_Reportable_Flg | 5.2.0 | Number(1) | Indicates whether the incident is state reportable, or not. Valid values: 1=true, 0=false. Defaults to 0. |
Last_Modified_By | 5.2.0 | Varchar2(30) | The username of the session that last updated the record. |
Last_Modified_TS | 5.2.0 | Timestamp(6) | The date and time when this record was last updated. |
Long_Desc | 5.2.0 | Varchar2(256) | A more detailed description. |
LU_Code_ID | 5.2.0 | Number(10) | Internal ID for the Incident_LU_Code record to which the record is associated. |
LU_Sub_Code_ID | 5.2.0 | Number(10) | Unique sequential number generated by the application. |
Parent_LU_Sub_Code_ID | 6.0.1 | Number(10) | Contains the ID of a parent sub code, if one exists. |
Policy_Desc | 7.9.1 | Varchar(1000) | User-specified policy-related information about working with this subcode. |
PSGUID | 7.8.0 | Varchar2(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
Restricted | 5.2.0 | Number(1) | Used for Incident Type security purposes. 1 = Yes, display on the Group Security UI page. 0 = No, this is not an Incident Type record, do not display on the Group Security UI page. |
Severity | 6.0.1 | Number(12,2) | Used to indicate the weight or severity of the incident. Expanded to use up to 2 decimal places. |
Short_Desc | 5.2.0 | Varchar2(80) | A short description. |
State_Detail_Report_Code | 5.2.0 | Varchar2(20) | A user-defined value used for detailed reports. |
Status | 5.2.0 | Varchar2(30) | Not currently used. |
Sub_Category | 5.2.0 | Varchar2(50) | The value in the Sub_Category directly relates to the value in the Incident_Category in the Incident_LU_Code table; for example: For Code_Type="timecode" you may have one or more of the following Incident_Category values: "during school hours", "in transit", "outside school hours". You may have one or more of the following Sub_Category values: "before classes", "during class", "between classes", "after classes". For Code_Type="behaviorcode" you may have one or more of the following Incident_Category values: "alcohol", "arson", "battery". You may have one or more of the following Sub_Category values: "possession of alcohol", "use of alcohol", "sale of alcohol", "setting a fire", "physically attacking", "intentionally causing bodily harm". |