tbl_ptaccountdeductionmapping

-1 rows


Description

Module: Payroll Compliance - Professional Tax (PT) Deduction Detail
Purpose: Stores the detailed, calculated monthly Professional Tax deduction amount for each employee, linking the deduction to the relevant payroll period and compliance accounts.
Data: Captures the employee ID, the SBU, the payroll month/year, the state PT account number, and the deducted tax amount.
Process Usage:
- Generated during the payroll calculation run for each month.
- Provides the necessary granular data for generating monthly/quarterly Professional Tax compliance returns and remittances.
Key Points:
- State Tax: Crucial for managing the state-specific statutory compliance related to Professional Tax.
- Links the calculated deduction amount to the governing rule and organizational structure.
Business Impact: Ensures compliance with state-specific Professional Tax laws and accurate deduction from employee salaries.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a single employee’s PT 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.
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid
Meaning: The employee whose Professional Tax deduction is being recorded.
month int4 10 null

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

The payroll year to which this PT deduction applies.
ptaccountno varchar 100 √ null

The establishment’s Professional Tax registration account number in the relevant state.
ptamount numeric 0 null

The final calculated Professional Tax amount deducted from the employee’s salary for this month.
compliancebranchid int8 19 √ null

FK: public.tbl_compliance_branch.id
Meaning: The compliance/establishment branch ID under which the PT submission is made (important for state-level grouping).
branchid int8 19 √ null
tbl_branchmaster.branchid Implied Constraint R

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

FK: public.tbl_PTRuleHistory.id
Meaning: Links to the specific Professional Tax rule and slab used for the calculation in this period.
isimport bool 1 √ false

Boolean flag: Indicates if this record was generated through an import process (e.g., bulk upload) 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_ptaccountdeductionmapping_pk_tbl_ptaccountdeductionmapping Primary key Asc id

Relationships

Close relationships within degrees of separation