tbl_leavecreditdebit

-1 rows


Description

Module: HRMS Leave Management (Balance Storage)
Purpose: Central repository storing current leave balances for each employee by leave type.
Data: Maintains real-time snapshot of available leave credits for all active employees.
Process Usage:
- Serves as the primary source for leave balance checks during application validation.
- Updated automatically by leave allocation engines and leave approval workflows.
Key Points:
- Provides quick lookup for available leave balances without complex calculations.
- Supports multiple leave types (PL, CL, SL, LWP, etc.) per employee.
Business Impact: Essential for real-time leave availability checks, application processing, and balance reporting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
leavedcid serial 10 √ nextval('tbl_leavecreditdebit_leavedcid_seq'::regclass)

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for each employee leave balance record.
employeeid varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: References the employee for whom the leave balance is maintained.
Relationship: Each employee has multiple records for different leave types.
leavecode varchar 50 √ null

Leave type identifier
Format: String code (2-4 characters)
Examples: “PL” (Privilege Leave), “CL” (Casual Leave), “SL” (Sick Leave), “LWP” (Leave Without Pay)
Usage: Identifies which type of leave balance this record represents.
totalblance numeric 0 √ null

Current available leave balance
Format: Float (supports fractional values like 0.5, 1.5)
Unit: Days
Examples: 7.0 (seven days available), 0.5 (half day available), 0.0 (no balance)
Usage: Directly used for leave application eligibility checks and balance displays.
component1 varchar 2147483647 √ null

DEPRECATED - No Longer Used
Historical Purpose: Previously used for probation-specific balance tracking
Current Status: Not used in current code base
component2 varchar 2147483647 √ null

DEPRECATED - No Longer Used
Historical Purpose: Part of legacy segmented balance system
Current Status: Not used in current code base
component3 varchar 2147483647 √ null

DEPRECATED - No Longer Used
Historical Purpose: Component-based balance segmentation (legacy feature)
Current Status: Not used in current code base
component4 varchar 2147483647 √ null

DEPRECATED - No Longer Used
Historical Purpose: Additional balance compartmentalization
Current Status: Not used in current code base
component5 varchar 2147483647 √ null

DEPRECATED - No Longer Used
Historical Purpose: Extended component storage for complex scenarios
Current Status: Not used in current code base
component6 varchar 2147483647 √ null

DEPRECATED - No Longer Used
Historical Purpose: Supplementary balance storage field
Current Status: Not used in current code base
component7 varchar 2147483647 √ null

DEPRECATED - No Longer Used
Historical Purpose: Legacy balance component storage
Current Status: Not used in current code base
component8 varchar 2147483647 √ null

DEPRECATED - No Longer Used
Historical Purpose: Additional segmentation field in old architecture
Current Status: Not used in current code base
component9 varchar 2147483647 √ null

DEPRECATED - No Longer Used
Historical Purpose: Final component in legacy segmented system
Current Status: Not used in current code base
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)
tbl_leavecreditdebit_pk_tbl_leavecreditdebit Primary key Asc leavedcid
tbl_leavecreditdebit_ix_tbl_leavecreditdebit Must be unique Asc/Asc employeeid + leavecode

Relationships

Close relationships within degrees of separation