tbl_leaveencashmentv1

-1 rows


Description

  • Module:* HRMS Leave Management
    Purpose: Tracks and manages leave encashment requests and payments for employees.
    Data: Stores encashment requests, calculations, approval status, and payment details for converted leave balances.
    Process Usage:
    - Handles both automatic system-generated and manual HR-initiated leave encashments.
    - Integrates with payroll system for encashment amount processing and payment.
    Key Points:
    - Supports multiple encashment scenarios (yearly, tenure-based, manual, cycle-based).
    - Calculates encashment amounts using various salary formulae and employee data.
    Business Impact: Essential for monetizing unused leave balances while maintaining audit trails and compliance.

Columns

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

Primary key
Format: BigSerial (auto-increment)
Used as: Unique identifier for each encashment transaction.
employeeid varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: Employee requesting or eligible for leave encashment.
Usage: Links encashment to employee profile and salary data.
leavecodeid int8 19 √ null
tbl_leavecodemaster.leavecodeid Implied Constraint R

FK: public.tbl_leavecodemaster.leavecodeid
Meaning: Type of leave being encashed (PL, CL, etc.).
Usage: Determines which leave balance is being monetized.
leavecodename varchar 50 √ null

Human-readable leave type name
Examples: “Privilege Leave”, “Casual Leave”
Usage: Display purposes in reports and approval workflows.
leavepolicyid int8 19 √ null

FK: public.tbl_leavecodepolicyconfig.id
Meaning: Policy governing the encashment rules and calculations.
Usage: References the specific policy configuration for encashment limits and formulae.
requestedleavebalance numeric 0 √ null

Number of leave days requested for encashment
Format: Double (supports fractional values)
Unit: Days
Usage: Base quantity for encashment amount calculation.
balancebeforeencashment numeric 0 √ null

Total available leave balance before this encashment
Format: Double
Unit: Days
Audit Purpose: Preserves snapshot of balance for historical reference and dispute resolution.
encashmentstatus varchar 50 √ null

Current processing status of encashment
Values: PENDING, DONE
PENDING: Awaiting approval or payment processing
DONE: Successfully processed and paid through payroll.
encashmentmonth int4 10 √ null

Target month for encashment payment processing
Format: Integer (1-12)
Usage: Scheduled payment month for automatic encashments.
encashmentyear int4 10 √ null

Target year for encashment payment processing
Format: Integer (4-digit year)
Usage: Scheduled payment year for automatic encashments.
encashmentamount numeric 0 √ null

Calculated monetary value of encashed leaves
Format: Double
Unit: Currency amount
Calculation: Based on requestedleavebalance × daily salary × encashformula
Usage: Final amount processed through payroll system.
encashmenttype varchar 100 √ null

Category of encashment triggering event
Values: CYCLE_MONTHLY, CYCLE_QUARTERLY, CYCLE_HALF_YEARLY, CYCLE_YEARLY, YEARLY, YEARLY_TENURE, MANUAL
Usage: Determines calculation period and business rules applied.
encashformula varchar 100 √ null
approvedby varchar 50 √ null
approveddate timestamp 29,6 √ null
paymentdate timestamp 29,6 √ null
deductionid int8 19 √ null
requestedrangestartmonth int4 10 √ null

Start month of the leave accumulation period
Format: Integer (1-12)
Calculation: Automatically set based on encashment type and policy frequency.
requestedrangestartyear int4 10 √ null

Start year of the leave accumulation period
Format: Integer (4-digit year)
Usage: Defines the beginning of the period for which leaves are being encashed.
requestedrangeendmonth int4 10 √ null

End month of the leave accumulation period
Format: Integer (1-12)
Usage: Typically current month when encashment is processed.
requestedrangeendyear int4 10 √ null

End year of the leave accumulation period
Format: Integer (4-digit year)
Usage: Typically current year when encashment is processed.
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)
pk_tbl_leaveencashmentv1_id Primary key Asc id

Relationships

Close relationships within degrees of separation