tbl_templatecustomfields

16 rows


Description

Module: HRMS Task/General Management - Template Custom Fields Master
Purpose: Stores the definitions for generic, reusable custom data fields that can be associated with various templates (e.g., Task Templates, Workflow Templates) across the HRIS system.
Data: Captures the field’s internal name, data type, display label, help text, and flags indicating if it is a system default or actively used.
Process Usage:
- Template Design: Administrators select fields from this master list to build customized forms or tasks.
- Form Rendering: Used to determine the appropriate input type (e.g., text box, calendar, dropdown) when a user interacts with a form derived from a template.
Key Points:
- Reusability: Fields are defined once and can be linked to multiple different templates.
- Extensibility: Allows for dynamic extension of data capture capabilities across various modules.
Business Impact: Provides a flexible, low-code way to tailor the HRIS to specific organizational data requirements.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_templatecustomfields_id_seq'::regclass)

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this custom field definition.
name varchar 200 √ null

The internal, programmatic name for the custom field (e.g., “project_code,” “date_completed”).
field_type varchar 200 √ null

The data type of the field (e.g., TEXT, NUMBER, DATE, DROPDOWN, BOOLEAN).
label varchar 200 √ null

The user-facing display label for the field (e.g., “Project Code,” “Completion Date”).
note varchar 200 √ null

Help text or instructional note displayed to the user filling out this field.
isdefault bool 1 √ null

Boolean flag: Indicates if this custom field is a mandatory, system-defined default field that cannot be removed by administrators.
status bool 1 √ null

Boolean flag: Indicates if the custom field is currently active and available for selection in template creation forms.
stage varchar 100 √ null

Current Status: Not used in code.
createdby varchar 50 √ null
modifiedby varchar 50 √ null
createddate timestamp 29,6 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_templatecustomfields_pk_tbl_templatecustomfields Primary key Asc id

Relationships

Close relationships within degrees of separation