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. |