tbl_templatecustomfieldvalue

-1 rows


Description

Module: HRMS Task/General Management - Template Custom Field Assignment and Configuration
Purpose: Stores the specific configuration and assignment of master custom fields (from tbl_TemplateCustomfields) to an individual template (e.g., a Task Template).
Data: Captures the linkage between a template and a custom field, including template-specific properties like whether the field is mandatory and its default value.
Process Usage:
- Template Instantiation: Used when a user creates an item (like a task) based on a template, as it defines which fields appear and what their behavior is.
- Form Validation: The isRequired flag enforces mandatory data entry within the context of that template.
Key Points:
- Many-to-Many Linkage: This is the joining table that links a template (TemplateId) to a custom field definition (CustomFieldId).
- Instance Configuration: Allows the same custom field to have different labels or required status depending on the template it’s used in.
Business Impact: Enables flexible and context-specific data capture for tasks, forms, or other templated entities across the system.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific custom field assignment within the template.
templateid int8 19 null

FK: public.tbl_Template.Id (Implied)
Meaning: The ID of the specific task, form, or general template to which the custom field is being assigned.
customfieldid int8 19 null

FK: public.tbl_TemplateCustomfields.Id
Meaning: The ID of the master custom field definition that is being assigned to the template.
customfieldlabel text 2147483647 √ null

The display label for the custom field, specifically tailored for use within this template (can override the master field label).
isrequired bool 1 √ null

Boolean flag: Indicates if this specific custom field is mandatory when filling out a form/task based on this template.
status bool 1 √ null

Boolean flag: Indicates if this custom field is currently active and visible within the template.
customfielddefaultvalue text 2147483647 √ null

The default value (if any) to be pre-populated in the field when creating a new item from this template.
customfieldoptionid text 2147483647 √ null

Reference to an option set or lookup ID (e.g., public.tbl_lookup_option.id), used if the custom field type is a dropdown/selection list.
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_templatecustomfieldvalue_pk__tbl_templatecustomfieldvalue Primary key Asc id

Relationships

Close relationships within degrees of separation