tbl_leavecodepolicyconfighistory

-1 rows


Description

Module: HRMS Leave Management
Purpose: Provides complete historical tracking of changes to leave policy applicability criteria and status.
Data: One row is created each time a leave policy’s target employee criteria or active status is modified.
Process Usage:
- Automatically populated when policy applicability rules are updated.
- Used for audit compliance, policy change analysis, and dispute resolution.
Key Points:
- Maintains immutable record of policy evolution over time.
- Enables reconstruction of policy state at any historical point.
Business Impact: Essential for regulatory compliance, policy transparency, and tracking how leave entitlements have changed for employee groups.

Columns

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

Primary key
Format: BigSerial (auto-increment)
Used as: Unique identifier for each historical policy change record.
leavecodepolicyid int8 19 null
tbl_leavecodepolicyconfig.id fk_tbl_leavecodepolicyconfighistory_leavecodepolicyid R

FK: public.tbl_leavecodepolicyconfig.id
Meaning: References the parent leave policy configuration that was modified.
Dependency: Links historical changes to the active policy configuration for traceability.
applicablecriteria text 2147483647 √ null

Snapshot of employee eligibility rules at time of change
Format: JSON configuration
Content: Target employee criteria including department, location, grade, custom rules
Audit Value: Preserves exact eligibility conditions that were in effect during specific periods.
status varchar 100 √ null

Policy status at the time of historical record creation
Values: ACTIVE, INACTIVE
ACTIVE: Policy was operational and applicable to employees
INACTIVE: Policy was suspended or archived
Tracking Purpose: Documents when policies were enabled/disabled throughout their lifecycle.
createdby varchar 50 null
createddate timestamp 29,6 null
modifiedby varchar 50 null
modifieddate timestamp 29,6 null

Indexes

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

Relationships

Close relationships within degrees of separation