tbl_employeetrackingpolicymapping_history

-1 rows


Description

Module: HRMS Employee Tracking
Purpose: Provides complete, immutable audit trail for all employee tracking policy assignment changes and historical tracking configurations.
Data: Each row represents a historical record of employee tracking policy assignments, preserving the relationship between employees and their tracking policy versions over time.
Process Usage:
- Automatically populated when tracking policy assignments are created, modified, or deleted.
- Used by administrators and auditors to review historical tracking policy assignments and changes.
- Essential for compliance reporting and tracking policy lifecycle management.
Key Points:
- Maintains historical relationships between employees and tracking policy versions.
- Provides audit trail for tracking policy assignment changes and employee monitoring history.
- Enables reconstruction of tracking configurations at any point in time.
Business Impact: Critical for regulatory compliance audits, employee monitoring history tracking, and maintaining complete audit trail of tracking policy assignments.

Columns

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

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

FK: public.tbl_tracking_policy_history.TrackingPolicyHistoryId
Purpose: Links to the historical version of the tracking policy that was assigned to the employee.
Usage: Preserves the exact policy configuration (frequency, accuracy, rules) that was active during the assignment period.
Audit Value: Maintains relationship with policy snapshots for accurate historical reconstruction.
employeeid varchar 50 √ null

FK: public.tbl_employee.employeeid
Purpose: Identifies the employee who was assigned the historical tracking policy.
Dependency: Links historical assignments to employee master records for reporting and analysis.
Usage: Tracks which employees were subject to specific tracking policy versions over time.
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_employeetrackingpolicymapping_history_pk_tbl_employeetracki Primary key Asc id

Relationships

Close relationships within degrees of separation