tbl_trackingpolicy_history

1 rows


Description

Module: HRMS Employee Tracking
Purpose: Provides complete, immutable audit trail for all changes to tracking policy configurations, preserving historical versions of policy rules, rates, and settings.
Data: Each row represents a historical snapshot of a tracking policy configuration at the time of modification, capturing all policy attributes for compliance and reconstruction.
Process Usage:
- Automatically populated when tracking policies are created, updated, or have rate changes.
- Used by administrators and auditors to review policy evolution and rate change history.
- Essential for expense dispute resolution and compliance reporting.
Key Points:
- Complete policy configuration preservation including all vehicle rates and rules.
- Maintains historical context for expense calculations and policy assignments.
- Enables point-in-time reconstruction of policy configurations for audit purposes.
Business Impact: Critical for financial audits, expense claim verification, regulatory compliance, and maintaining complete policy change history.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for each historical policy version record.
trackingpolicyid int8 19 √ null

FK: public.tbl_trackingPolicy.Id
Purpose: Links this historical record to the current/live tracking policy.
Usage: Enables tracking all historical versions of a specific policy.
Audit Value: Maintains relationship while preserving historical policy configurations.
policyname varchar 100 √ null

Historical Snapshot: Policy name as it existed at the time of this version.
Purpose: Preserves policy naming conventions and rebranding changes.
Audit Use: Tracks how policy identification evolved over time.
members text 2147483647 √ null

Historical Snapshot: Membership rules and eligibility criteria at change time.
Purpose: Preserves exactly which employee groups were targeted by the policy.
Compliance Value: Critical for disputes about policy applicability and assignments.
description varchar 1000 √ null

Historical Snapshot: Policy description active during this version period.
Purpose: Maintains historical context of policy purpose and coverage rules.
Legal Value: Important for understanding policy intent during specific time periods.
allowexpense bool 1 √ null

Historical Snapshot: Expense allowance setting during this policy version.
Purpose: Tracks when policies began or stopped allowing expense claims.
Financial Impact: Essential for expense claim validation and audit trails.
enabletwowheeler bool 1 √ null

Historical Snapshot: Two-wheeler expense eligibility during this period.
Purpose: Preserves vehicle type availability for historical expense validation.
twowheelerrate float8 17,17 √ null

Historical Snapshot: Two-wheeler reimbursement rate active during this version.
Purpose: Critical for recalculating historical expenses and claim verification.
Financial Audit: Used to validate expense calculations for specific time periods.
twowheelerminkm float8 17,17 √ null

Historical Snapshot: Minimum distance threshold for two-wheeler claims.
Purpose: Preserves eligibility rules for historical expense validation.
twowheelermaxkm float8 17,17 √ null

Historical Snapshot: Maximum distance limit for two-wheeler claims.
Purpose: Maintains historical policy limits for compliance checking.
enablefourwheeler bool 1 √ null

Historical Snapshot: Four-wheeler expense eligibility during this period.
Purpose: Preserves vehicle type availability for historical expense validation.
fourwheelerrate float8 17,17 √ null

Historical Snapshot: Four-wheeler reimbursement rate active during this version.
Purpose: Essential for recalculating historical car/SUV expenses.
Financial Significance: Direct impact on historical expense amounts and approvals.
fourwheelerminkm float8 17,17 √ null

Historical Snapshot: Minimum distance threshold for four-wheeler claims.
Purpose: Preserves eligibility rules for historical expense validation.
fourwheelermaxkm float8 17,17 √ null

Historical Snapshot: Maximum distance limit for four-wheeler claims.
Purpose: Maintains historical policy limits for compliance checking.
defaultvehicletype varchar 50 √ null

Historical Snapshot: Default vehicle type preset during this policy version.
Purpose: Preserves user experience and default selection configurations.
status varchar 20 √ null

Historical Snapshot: Policy status (ACTIVE/INACTIVE) at change time.
Purpose: Tracks policy lifecycle states and availability periods.
Audit Value: Documents when policies were active and available for assignments.
isdefault bool 1 √ null

Historical Snapshot: Default policy status during this version period.
Purpose: Preserves which policy was set as system default at specific times.
Business Impact: Important for understanding automatic policy assignments historically.
createdby varchar 20 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 20 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation