tbl_customfields

29 rows


Description

Module: System - Custom Field Configuration Master
Purpose: Stores the definitions and properties for dynamic, user-created fields that extend the core data structure of specific application modules (e.g., Expense Claims, Employee Profile).
Data: Captures the technical name, display label, field type (text, number, date), validation rules, component rendering type, and the operational stage of the field.
Process Usage:
- Form Generation: Used by the application UI layer to dynamically render input forms based on these definitions.
- Data Storage: Provides metadata necessary for validating and storing data collected via these custom fields.
Key Points:
- Extensibility: Crucial for allowing clients to tailor the HRIS without core code changes.
- Field properties like label and errorMessage support multi-tenant, user-friendly forms.
Business Impact: Enhances the flexibility and adaptability of the HRIS to meet varied organizational data requirements.

Columns

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

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

The internal, technical name of the field (used in the database and code for mapping, e.g., “travel_reason”).
field_type varchar 200 √ null

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

The user-facing display text or title for the field (e.g., “Reason for Travel”).
note varchar 200 √ null

A short instructional note or tooltip displayed to the user next to the field.
component_type varchar 200 √ null

The UI component or input mechanism used to render the field (e.g., DROPDOWN, TEXTAREA, RADIO_BUTTONS).
is_deletable int8 19 √ '1'::bigint

Flag (0=No, 1=Yes) indicating if the HRIS system allows this custom field to be deleted by a tenant administrator (often set to null for default/system fields).
error_message varchar 200 √ null

The validation message displayed to the user if the input to this field fails validation rules.
createdby varchar 50 √ null
modifiedby varchar 50 √ null
createddate timestamp 29,6 √ null
modifieddate timestamp 29,6 √ null
stage varchar 100 √ null

The current operational state of the custom field.
Values: Active, Inactive (determines if the field is visible/usable in the application).
companyid int8 19 √ null

FK: public.tbl_company.id
Meaning: The company entity for which this custom field is defined and available.

Indexes

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

Relationships

Close relationships within degrees of separation