tbl_salarystructuretemplateelements

-1 rows


Description

Module: Payroll - Salary Structure Template Element Details
Purpose: Stores the granular rules for each component (pay element) included in a master salary structure template defined in tbl_SalaryStructureTemplate.
Data: Captures the pay element ID, its calculation method (fixed, percentage, formula), the fixed amount or percentage value, and its grouping section within the salary slip.
Process Usage:
- Structure Definition: Works with the parent template to form a complete, assignable salary structure.
- Payroll Calculation: Provides the specific rules used by the payroll engine to calculate the value of each element for an employee assigned to this template.
Key Points:
- Calculation Logic: The combination of CalculationType, ValueAmount, and ValuePercentage is the core formula for the element.
- The SectionName (A, B, C, etc.) is crucial for grouping elements on a salary slip (Earnings, Deductions, Employer Contributions).
Business Impact: Ensures that salary components are consistently and correctly computed according to predefined organizational rules.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this detail element record.
templateid int8 19 null

FK: public.tbl_SalaryStructureTemplate.Id
Meaning: The ID of the master salary structure template this element belongs to.
payelementid int8 19 null
tbl_employeepayelement.payelementid Implied Constraint R

FK: public.tbl_PayElements.Id (Implied)
Meaning: The ID of the specific earnings or deduction component (e.g., Basic, HRA, PF) this rule is defined for.
calculationtype varchar 50 null

Defines how the value for the PayElementId is determined.
Values: FIXED, P_CTC (Percentage of CTC), P_GROSS (Percentage of Gross), P_PAY_ELEMENT (Percentage of another element), BALANCE_AMOUNT (Remainder), AS_PER_COMPLIANCE (Statutory rule), FORMULA.
sectionname varchar 50 null

The section of the salary structure/slip where this element belongs (e.g., A=Earnings, B=Deductions, C=Employer Contribution).
valueamount numeric 0 √ null

The fixed amount to be used for calculation, if CalculationType is FIXED.
valuepercentage numeric 0 √ null

The percentage rate to be used for calculation, if CalculationType is P_CTC, P_GROSS, etc.
valuepayelementid int8 19 √ null

FK: public.tbl_PayElements.Id (Implied)
Meaning: The ID of the base pay element used for calculation, if CalculationType is P_PAY_ELEMENT.
remark varchar 500 √ null

Any internal comments or notes related to the calculation or definition of this element.
createdby varchar 50 null
modifiedby varchar 50 null
createddate timestamp 29,6 null
modifieddate timestamp 29,6 null

Indexes

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

Relationships

Close relationships within degrees of separation