IncidentTemplate (ver19.11.0.0)
This table stores template details for incidents. These templates are consumed by quick incident page to simplify incident creation.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| IncidentTemplateID | 19.11.0 | Number(16,0) | The unique sequential number generated by the application. Indexed. Required. |
| TemplateName | 19.11.0 | Varchar2(100) | Name of the template stored in the database, such as Fighting. Required |
| Description | 19.11.0 | Varchar2(4000) | Description of the template. Optional. |
| IsEnabled | 19.11.0 | Number(1) | Indicates whether this template is visible to users in the quick incident template dropdown. Defaults to 0 |
| FormData | 19.11.0 | CLOB | Template form data is stored in this column. This should be JSON data. A constraint is in place to validate the type. |
| TemplateBuiltBy | 19.11.0 | Varchar2(135) | The name of the person who created the record. Defaults to user. but can be modified by the user. |
| Incident_LU_Code_ID | 19.11.0 | Number(10,0) | This column helps filter templates based on user permission security group. |
| UiDisplayOrder | 19.11.0 | Number(4,0) | Indicates the display order associated with each template. This column auto-populated by the code on the template creation. User can modify the order from UI. |
| WhoCreated | 19.11.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. Required. |
| WhenCreated | 19.11.0 | Date | The date and time the record was created. Defaults to system date. Required. |
| WhoModified | 19.11.0 | Varchar2(100) | The name of the person who modified the record. Defaults to user. Required. |
| WhenModified | 19.11.0 | Date | The date and time the record was modified. Defaults to system date. Required. |