Skip to main content
Skip table of contents

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

Category20.4.0Varchar2(50)This column indicates the category of the template for health templates, such as HEALTHPLAN. Required.
Description20.4.0Varchar2(4000)Description of the template. Optional.
EndDate20.4.0DateUsed to determine the active status of the template. Optional.
FormData20.4.0CLOBThe template form data is stored in this column. This should be JSON data. A constraint is in place to validate the type.
TemplateID20.4.0Number(16,0)The unique sequential number generated by the application. Indexed. Required.
IsEnabled20.4.0Number(1)Indicates whether this template is enabled for use. Defaults to 0.
IsLocked20.4.0Number(1)Indicates whether this template is locked for edit or delete. Defaults to 0.
StartDate20.4.0DateUsed to determine the active status of the template. Optional.
SubCategory20.4.0Varchar2(50)Used for distinction within the category. Optional.
SubCategoryID20.4.0Number(10,0)Generic subcategory distinction. Optional.
TemplateBuiltBy20.4.0Varchar2(135)The name of the person who created the record. Defaults to user, but can be modified by the user. Optional.
TemplateName20.4.0Varchar2(100)Name of the template stored in the database, such as Fighting. Required.
UiDisplayOrder20.4.0Number(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.
WhenCreated20.4.0DateThe date and time the record was created. Defaults to system date. Required.
WhenModified20.4.0DateThe date and time the record was modified. Defaults to system date. Required.
WhoCreated20.4.0Varchar2(100)The name of the person who created the record. Defaults to user. Required.
WhoModified20.4.0Varchar2(100)The name of the person who modified the record. Defaults to user. Required.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.