tbl_pfaccountdeductionmapping

-1 rows


Description

Module: Payroll Compliance - PF Deduction Detail
Purpose: Stores the detailed, calculated monthly contributions for the Provident Fund (PF) and related schemes for each employee, segregated by its components (EPF, EPS, EDLI, Admin Charges).
Data: Captures employee and employer PF account numbers, contribution amounts for the employee and the employer (broken down), VPF, and the corresponding payroll period.
Process Usage:
- Generated during the final payroll processing run for each month.
- Provides the granular data necessary for generating monthly PF challan payments and statutory compliance reports (e.g., ECR file).
Key Points:
- Tracks both the Employee’s and the Employer’s statutory share.
- Separates contributions into PF (EPF), Pension (EPS), and Insurance (EDLI) components as required by law.
Business Impact: Essential for maintaining statutory compliance with EPF regulations and ensuring accurate remittance to the PF authorities.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a single employee’s PF deduction record for a specific month.
sbuid int8 19 null

FK: public.tbl_SBU.id
Meaning: The Strategic Business Unit (SBU) to which the employee belongs for payroll purposes.
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid
Meaning: The employee whose PF contribution is being recorded.
month int4 10 null

The payroll month (1-12) to which this contribution applies.
year int4 10 null

The payroll year to which this contribution applies.
employeeaccountno varchar 100 √ null

The employee’s Universal Account Number (UAN) or PF member ID.
employeraccountno varchar 100 √ null

The employer’s PF Establishment ID.
employeecontributionamount numeric 0 null

The total PF amount deducted from the employee’s salary.
employercontributiontotalamount numeric 0 null

The total statutory amount contributed by the employer.
employercontributionepfamount numeric 0 null

The portion of the employer’s contribution allocated to the Employees’ Provident Fund (EPF).
employercontributionepsamount numeric 0 null

The portion of the employer’s contribution allocated to the Employee Pension Scheme (EPS).
employercontributionedliamount numeric 0 null

The employer’s contribution towards the Employee Deposit Linked Insurance (EDLI) scheme.
employercontributionepfacamount numeric 0 null

The amount paid by the employer as EPF Administrative Charges (A/c 2).
employercontributionedliacamount numeric 0 null

The amount paid by the employer as EDLIS Administrative Charges (A/c 22).
vpfamount numeric 0 null

The amount contributed by the employee under the Voluntary Provident Fund (VPF) scheme.
compliancebranchid int8 19 √ null

The compliance/establishment branch ID under which the PF submission is made.
branchid int8 19 √ null
tbl_branchmaster.branchid Implied Constraint R

FK: public.tbl_branch.id
Meaning: The actual branch/location the employee reports to.
pfrulehistoryid int8 19 √ null

FK: public.tbl_PFRuleHistory.id
Meaning: Links to the specific set of PF rules and rates used for the calculation in this period.
isimport bool 1 √ false

Boolean flag: Indicates if this record was generated through an import process rather than the standard payroll calculation.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation