tbl_holdsalaryhistory

-1 rows


Description

Module: HRMS Payroll Management - Hold Salary Audit History
Purpose: Stores an immutable, time-stamped log of all changes and historical states for employee salary hold records (from tbl_HoldSalary). This is a critical audit trail for payroll compliance and dispute resolution.
Data: Captures a snapshot of the held amount, status, period of hold, and intended release period every time the original hold record is created or modified.
Process Usage:
- Auditing: Provides a complete historical timeline of the salary hold lifecycle (from creation to release/cancellation).
- Compliance: Used to prove why, when, and by whom a salary amount was held or released during past payroll cycles.
Key Points:
- Immutability: Records here are generally preserved and not modified.
- The AbstractAuditingEntity parent class provides the necessary audit fields (e.g., CreatedBy, CreatedDate) to show the change details.
Business Impact: Ensures controlled, transparent, and auditable management of withheld employee compensation.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific historical version or transaction log entry.
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid
Meaning: The Employee ID whose salary hold transaction is being recorded.
month int4 10 null

The payroll month (1-12) for which the salary was originally put on hold, as recorded in this history version.
year int4 10 null

The payroll year for which the salary was originally put on hold.
holdsalaryamount numeric 0 null

The exact monetary amount of the salary that was held in this version of the record.
holdsalarystatus varchar 100 null

The status of the held amount at the time this history record was created.
Values: RELEASED, PENDING, REJECTED, FNF_RELEASED.
remarks varchar 500 √ null

The detailed note or reason explaining the salary hold or the specific change event that triggered this history record.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
releasemonth int4 10 √ null

The intended payroll month (1-12) for the release of the held salary amount, as planned in this historical record.
releaseyear int4 10 √ null

The intended payroll year for the release of the held salary amount.

Indexes

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

Relationships

Close relationships within degrees of separation