tbl_gratuityruledetail

-1 rows


Description

Module: Compliance/Payroll Management - Gratuity Rule Detail Configuration
Purpose: Stores the specific parameters and components that determine how an employee’s Gratuity amount is calculated, in accordance with regulatory compliance and organizational policy.
Data: Captures which pay elements (earnings) form the basis of the “last drawn salary,” the minimum service tenure required, and the period for calculating average salary.
Process Usage:
- Gratuity Calculation: Used by the system’s calculation engine to identify the correct components and formula variables when an employee becomes eligible for gratuity (e.g., during separation).
- Compliance: Links the rule set to a specific compliance account or policy (ComplienceAccountId).
Key Points:
- Component Definition: PayElementsId and PayElementsName define the constituent parts of the salary considered for gratuity.
- Eligibility & Base: ServiceMonths defines minimum eligibility, and LastNoOfMonths defines the look-back period for the salary average.
Business Impact: Ensures the organization’s Gratuity liability is calculated accurately and consistently as per legal and internal rules.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific line item within the Gratuity rule set.
complienceaccountid int8 19 √ null

FK: public.tbl_ComplienceAccount.Id (Implied)
Meaning: The ID of the master compliance policy or account this gratuity rule detail belongs to.
payelementsid varchar 1000 √ null

Comma-separated string of FKs to public.tbl_PayElements.Id (Implied)
Meaning: The IDs of the pay elements (e.g., Basic Salary, DA) that are to be included in the calculation of the “last drawn salary” base for gratuity.
payelementsname varchar 1000 √ null

Comma-separated names corresponding to the PayElementsId for easy reference.
servicemonths int8 19 √ null

The minimum number of months of continuous service required for an employee to become eligible for gratuity (e.g., 5 years * 12 months = 60).
lastnoofmonths int4 10 √ null

The number of preceding months whose average salary components (PayElementsId) should be used as the base for the gratuity calculation.
isgratuity bool 1 √ null

Boolean flag: Typically TRUE, indicating this rule is part of a Gratuity calculation setup.
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)
tbl_gratuityruledetail_pk__tbl__gratuityruledetail_id Primary key Asc id

Relationships

Close relationships within degrees of separation