tbl_dynamicfieldsconfiguration

-1 rows


Description

Module: HRMS System Administration & Configuration
Purpose: Stores the configuration metadata for all dynamic (custom) fields used across various modules in the application (e.g., employee forms, request forms, etc.).
Data: Defines field type, validation rules (regex), example values, header text, and display criteria for each dynamic field.
Process Usage:
- Referenced by the UI rendering engine to dynamically build input forms and ensure client-side validation.
- Used by backend services to validate and process submitted custom data fields.
Key Points:
- Enables highly flexible and configurable data capture across the system without requiring code deployment.
- Fields can be configured as mandatory, restricted by regex, and tied to specific lookup data.
Business Impact: Allows the system to adapt quickly to changing organizational data requirements and compliance needs.

Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single dynamic field configuration.
ismandatory bool 1 false

Flag indicating if this dynamic field is required for the user to submit the form.
Format: Boolean.
fieldname varchar 100 null

The user-facing label or name displayed for the field on the form.
Format: Varchar/Text.
fieldkey varchar 100 null

The unique technical key (e.g., variable name) used by the system to reference the field’s data.
Format: Varchar.
regex varchar 500 √ null

The Regular Expression string used for complex input validation (e.g., specific format for a license number).
Format: Varchar/Text.
headerdescription varchar 500 √ null

A short title or header text displayed above a group of related dynamic fields.
Format: Varchar/Text.
fieldexamplevalue varchar 100 √ null

An example or placeholder text shown in the input box to guide the user on the expected format.
Format: Varchar/Text.
defaultvalue varchar 100 √ null

The value that is automatically populated into the field when a new form is created.
Format: Varchar/Text.
fielddescription varchar 500 √ null

A longer description providing detailed context or rules for the field.
Format: Text.
tooltip varchar 500 √ null

The help text displayed when the user hovers over the field label.
Format: Varchar/Text.
type varchar 50 null

The UI type of the input field (e.g., text, number, date, dropdown, textarea, checkbox).
Format: Varchar/Text.
maxvalue varchar 100 √ null

The maximum allowed value (for number fields) or maximum length (for text fields).
Format: Integer/Numeric.
lookuptypeid int8 19 √ null

FK: Reference to a lookup master table
Meaning: If the field is a dropdown/list, this ID specifies the source of the options/data.
Format: Integer.
applicablecriteria varchar 2147483647 √ null

JSON or Text rule defining where and for whom this field should be displayed (e.g., “Only for HR users,” “Only for employees in the India branch”).
Format: JSONB/Text.
createdby varchar 50 null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The user who created this configuration record.
createddate timestamp 29,6 √ null

Timestamp of when the configuration record was created.
Format: Timestamp with timezone.
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The last user who modified this configuration record.
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the configuration record.
Format: Timestamp with timezone.
deleted bool 1 null

Flag indicating if the field configuration has been logically deleted (soft delete).
Format: Boolean.

Indexes

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

Relationships

Close relationships within degrees of separation