tbl_expense_custom_field_values

-1 rows


Description

Module: HRMS Expense Management
Purpose: Stores custom field values associated with expense claims, enabling flexible extension of expense data beyond standard fields while maintaining referential integrity.
Data: Each row represents a single custom field value linked to an expense claim, supporting both free-text values and predefined option selections.
Process Usage:
- Captures additional expense-related data through configurable custom fields.
- Supports both direct text input and dropdown selection from predefined options.
- Enables dynamic expense categorization, classification, and reporting beyond standard fields.
Key Points:
- Flexible key-value storage for expense claim extensions.
- Integration with both custom field definitions and predefined options.
- Supports audit trail and reporting on custom expense attributes.
Business Impact: Enables organizations to capture specialized expense data, supports complex approval workflows, and provides enhanced reporting capabilities for customized expense analysis.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for each custom field value record.
expenseid int8 19 √ null

FK: public.tbl_ExpenceClaimMaster.ExpID
Purpose: Links this custom field value to the specific expense claim.
Cardinality: Many-to-One (multiple custom fields per expense claim)
Usage: Associates additional data with the main expense record.
Business Logic: Enables expense claims to have multiple custom attributes.
customfieldid int8 19 √ null

FK: public.tbl_customfields.id
Purpose: Identifies which custom field definition this value belongs to.
Usage: Determines the field type, validation rules, and display properties.
Examples: Project Code, Client Name, Business Purpose, Cost Center
Business Logic: References the field definition that controls data type and behavior.
customfieldoptionid int8 19 √ null

FK: public.tbl_customfields_options.id
Purpose: References a predefined option when field uses dropdown selection.
Usage: For dropdown fields, stores the selected option rather than free text.
Business Logic:
- NULL: Field uses free-text input (value column)
- NOT NULL: Field uses predefined option (references CustomFieldsOptions)
Integration: Works with expense policy payment calculations that reference custom fields.
expensevalue varchar 225 √ null

Format: String
Purpose: Stores the actual custom field value entered or calculated.
Usage Scenarios:
- Free-text input: Direct user entry
- Calculated value: System-generated content<br- Display value: Human-readable representation
Business Logic: When CustomFieldOptionId is populated, this may store display text while option stores the actual value.

Indexes

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

Relationships

Close relationships within degrees of separation