tbl_holdsalary

-1 rows


Description

Module: Payroll - Hold Salary Tracking
Purpose: Records instances where a specific amount of an employee’s salary is intentionally withheld or put on hold for a given payroll month, and tracks its subsequent status and release plan.
Data: Captures the employee, the payroll period the amount was held, the amount held, the current status of the hold, and the intended release period.
Process Usage:
- Payroll Calculation: The amount recorded here is deducted from the net pay during the designated Month/Year payroll run.
- Release Tracking: Used to monitor when the held amount is to be processed and paid out in a future payroll cycle (ReleaseMonth/ReleaseYear).
Key Points:
- Financial Control: Essential for managing salary advances, final settlements, and other scenarios requiring temporary withholding.
- The HoldSalaryStatus drives the processing logic.
Business Impact: Ensures controlled and auditable management of withheld employee compensation.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific salary hold record.
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid
Meaning: The Employee ID whose salary amount is being held.
month int4 10 null

The payroll month (1-12) for which the salary was held.
year int4 10 null

The payroll year for which the salary was held.
holdsalaryamount numeric 0 null

The exact monetary amount of the salary that was put on hold for the employee.
holdsalarystatus varchar 100 null

The current status of the held amount.
Values: RELEASED, PENDING, REJECTED, FNF_RELEASED.
remarks varchar 500 √ null

Mandatory note detailing the reason why the employee’s salary was put on hold (e.g., “Pending asset return,” “Final settlement adjustment”).
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
releasemonth int4 10 √ null

The payroll month (1-12) in which the held amount is intended to be paid out.
releaseyear int4 10 √ null

The payroll year in which the held amount is intended to be paid out.

Indexes

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

Relationships

Close relationships within degrees of separation