tbl_employeepayment

-1 rows


Description

Module: Reimbursement/Payroll Management - Employee Payment Ledger
Purpose: Stores individual payment records for employees that are separate from their regular fixed salary, typically used for approved reimbursements, variable bonuses, or other ad-hoc earnings/deductions intended to be included in a specific month’s payroll.
Data: Captures the payment amount, the specific payroll element it relates to, the target employee, the payroll month/year it should be processed in, and its current processing status.
Process Usage:
- Payroll Input: Records in this table are pulled by the payroll engine during the run for the specified PaySlipMonth/PSYear to calculate the final net pay.
- Reimbursement Closure: Marks approved claims or expenses as ready for payment.
Key Points:
- Variable Component: Manages dynamic and one-time payments/earnings that fluctuate month-to-month.
- The PayElementID links the amount to a specific recognized pay type (e.g., “Mobile Reimbursement,” “Travel Allowance”).
Business Impact: Ensures accurate and timely processing of all employee entitlements and deductions outside of the standard salary structure.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific payment record.
payelementid int4 10 √ null

FK: public.tbl_PayElements.Id (Implied)
Meaning: The ID of the specific earnings or deduction component (Pay Element) this amount relates to (e.g., HRA, Medical Reimbursement).
payelementcode varchar 50 √ null

The short code associated with the PayElementID.
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid
Meaning: The Employee ID who is receiving this payment.
payslipmonth int4 10 √ null

The target payroll month (1-12) for which this payment is intended to be processed.
psyear int4 10 √ null

The target payroll year for which this payment is intended to be processed.
amount numeric 18,2 √ '0'::numeric

The monetary amount of the payment/earning to be processed.
paymentstatus bool 1 √ false

Boolean flag: Indicates the final payment status (e.g., TRUE=Paid/Processed, FALSE=Pending).
readytoprocess bool 1 √ false

Boolean flag: Set to TRUE once the payment is fully approved and ready to be included in the next payroll run.
createdatetime timestamp 29,6 √ null

The date and time the payment record was initially created or approved.
iscarryforward bool 1 √ false

Boolean flag: Indicates if this payment was carried forward from a previous month’s payroll cycle.

Indexes

Constraint Name Type Sort Column(s)
tbl_employeepayment_pk_tbl_employeepayment Primary key Asc paymentid

Relationships

Close relationships within degrees of separation