tbl_resetsalarydata

-1 rows


Description

Module: Payroll - Salary Data Reset/Backup Log
Purpose: Stores a snapshot of an employee’s comprehensive salary details (gross, deductions, net) for a specific month and year, typically taken when the payroll is reset.
Data: Captures the core financial totals, detailed JSON structures of salary and company contribution elements, and the payroll period.
Process Usage:
- Acts as a safeguard, providing a reference point to revert to in case of payroll errors or system resets.
- Used when payroll data for a finalized month is about to be modified, serving as a “before” image.
Key Points:
- Audit/Rollback: Crucial for maintaining data integrity and audit trails in payroll processing.
- Stores detailed element configuration in JSON format.
Business Impact: Enables safe reconciliation and rollback of salary changes, ensuring historical payroll accuracy.

Columns

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

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

FK: public.tbl_employee.employeeid
Meaning: The Employee ID whose salary data is being captured.
month int8 19 null

The payroll month (1-12) for which this salary data snapshot was taken.
year int8 19 null

The payroll year for which this salary data snapshot was taken.
grosssalary numeric 0 null

The total calculated Gross Salary (Earnings) for the employee in this snapshot.
deduction numeric 0 null

The total calculated Deductions for the employee in this snapshot.
netsalary numeric 0 null

The calculated Net Salary (Gross - Deductions) for the employee in this snapshot.
holdsalaryamount numeric 0 null

The amount of salary that was put on hold for the employee in this snapshot (if any).
salaryelemets text 2147483647 √ null

JSON string containing the detailed breakdown and values of all individual employee salary elements (e.g., Basic, HRA, Conveyance, statutory deductions).
remarks varchar 50 √ null

A note explaining the reason for creating this salary data reset record (e.g., “Pre-recalculation backup”, “Rollback checkpoint”).
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
company_contribution_elements varchar 2147483647 √ null

JSON string containing the detailed breakdown and values of all company-side contribution elements (e.g., Employer PF, ESI, Gratuity).

Indexes

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

Relationships

Close relationships within degrees of separation