tbl_salarystructuretemplate

-1 rows


Description

Module: Payroll - Salary Structure Template
Purpose: Stores the definitions and rules for standardized salary structures. Each record defines a specific compensation framework, including the acceptable range of CTC/Gross Salary and the criteria for its applicability.
Data: Captures the template name, type, min/max financial limits (CTC/Gross), applicability rules, and status.
Process Usage:
- Employee Assignment: Used by HR/Payroll to quickly and consistently assign a defined salary structure to new or existing employees.
- Validation: Enforces minimum and maximum limits for CTC/Gross salary when calculating or assigning compensation.
- The OneToMany relationship links this template header to its detailed components (e.g., Basic, HRA, Deductions) stored in tbl_SalaryStructureTemplateElement.
Key Points:
- Standardization: Ensures equitable and compliant compensation practices.
- Range Control: Manages salary bands through MinCTC, MaxCTC, etc.
Business Impact: Critical for scalable and compliant payroll setup and compensation management.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this salary structure template.
templatename varchar 200 null

The unique name given to the template (e.g., “Standard Sales Structure,” “Senior Management CTC”).
templatetype varchar 50 null

The type or category of the template (e.g., CTC_BASED, GROSS_BASED).
minctc numeric 0 √ null

The minimum acceptable annual Cost-to-Company (CTC) value that can be assigned using this template.
maxctc numeric 0 √ null

The maximum acceptable annual Cost-to-Company (CTC) value that can be assigned using this template.
mingross numeric 0 √ null

The minimum acceptable monthly/annual Gross Salary value that can be assigned using this template.
maxgross numeric 0 √ null

The maximum acceptable monthly/annual Gross Salary value that can be assigned using this template.
applicablecriteria text 2147483647 √ null

JSON or string data defining the employee groups or criteria for which this template is applicable (e.g., Department=Sales, Designation=Manager).
splitsectiona bool 1 √ null

Boolean flag: Likely controls a visual or calculation split in the presentation of the salary structure (e.g., statutory vs. non-statutory components).
status varchar 50 null

The current operational state of the template (e.g., ACTIVE, INACTIVE, DRAFT).
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_salarystructuretemplate_pk_tbl_salarystructuretemplate Primary key Asc id

Relationships

Close relationships within degrees of separation