Template (ver20.4.0)
This table stores template details for general purposes. These templates are consumed by different modules, such as Health and Incidents.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| Category | 20.4.0 | Varchar2(50) | This column indicates the category of the template for health templates, such as HEALTHPLAN. Required. |
| Description | 20.4.0 | Varchar2(4000) | Description of the template. Optional. |
| EndDate | 20.4.0 | Date | Used to determine the active status of the template. Optional. |
| FormData | 20.4.0 | CLOB | The template form data is stored in this column. This should be JSON data. A constraint is in place to validate the type. |
| TemplateID | 20.4.0 | Number(16,0) | The unique sequential number generated by the application. Indexed. Required. |
| IsEnabled | 20.4.0 | Number(1) | Indicates whether this template is enabled for use. Defaults to 0. |
| IsLocked | 20.4.0 | Number(1) | Indicates whether this template is locked for edit or delete. Defaults to 0. |
| StartDate | 20.4.0 | Date | Used to determine the active status of the template. Optional. |
| SubCategory | 20.4.0 | Varchar2(50) | Used for distinction within the category. Optional. |
| SubCategoryID | 20.4.0 | Number(10,0) | Generic subcategory distinction. Optional. |
| TemplateBuiltBy | 20.4.0 | Varchar2(305) | The name of the person who created the record. Defaults to user, but can be modified by the user. Optional. |
| TemplateName | 20.4.0 | Varchar2(100) | Name of the template stored in the database, such as Fighting. Required. |
| UiDisplayOrder | 20.4.0 | Number(4,0) | Indicates the display order associated with each template. This column auto-populated by the code on the template creation. Users can modify the order from UI. Required. |
| WhenCreated | 20.4.0 | Date | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 20.4.0 | Date | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 20.4.0 | Varchar2(305) | The name of the person who created the record. Defaults to user. Required. |
| WhoModified | 20.4.0 | Varchar2(305) | The name of the person who modified the record. Defaults to user. Required. |