tbl_salarystructuretemplateemployeemapping

-1 rows


Description

Module: Payroll/Compensation Management - Employee-Salary Structure Template Assignment
Purpose: Stores the current, active assignment of a master Salary Structure Template to an individual employee. This linkage determines the employee’s compensation framework and the set of earnings/deductions used in their payroll calculation.
Data: Captures the unique ID of the employee and the ID of the master salary structure template that governs their pay details.
Process Usage:
- Payroll Engine Input: The payroll process uses this mapping to fetch the correct rules, formulas, and pay elements when calculating an employee’s gross and net pay.
- Compensation Management: Ensures all employees are assigned a valid, defined salary structure.
Key Points:
- Many-to-One Relationship: Many employees can be mapped to one standard template.
- This table represents the operational assignment of a compensation policy to an individual.
Business Impact: Essential for the accurate and compliant processing of payroll for all employees.

Columns

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

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

FK: public.tbl_employee.employeeId
Meaning: The Employee ID being assigned the salary structure.
templateid int8 19 √ null

FK: public.tbl_SalaryStructureTemplate.Id (Implied)
Meaning: The ID of the master salary structure template that defines this employee’s compensation components and rules.
createddate timestamp 29,6 √ null
createdby varchar 500 null
modifieddate timestamp 29,6 √ null
modifiedby varchar 500 null

Indexes

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

Relationships

Close relationships within degrees of separation