tbl_leavecodepolicymonthlyconfig

4 rows


Description

Module: HRMS Leave Management
Purpose: Defines monthly allocation patterns and date-based proration rules for leave balance calculations.
Data: Stores date ranges and corresponding allocation values for precise monthly leave distribution.
Process Usage:
- Used by leave balance engine for pro-rata calculations based on joining dates.
- Supports complex allocation scenarios like decreasing entitlements or seasonal variations.
Key Points:
- Enables granular control over how leave balances are distributed across months.
- Supports both fixed and customized allocation patterns.
Business Impact: Critical for accurate leave accruals, especially for mid-month joiners and complex pro-rata scenarios.

Columns

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

Primary key
Format: BigSerial (auto-increment)
Used as: Unique identifier for each monthly configuration rule.
leavecodepolicyid int8 19 null
tbl_leavecodepolicyconfig.id fk_tbl_leavecodepolicymonthlyconfig_leavecodepolicyid R

FK: public.tbl_leavecodepolicyconfig.id
Meaning: References the parent leave policy configuration.
Dependency: Links monthly allocation rules to the main policy for cohesive configuration management.
fromdate int4 10 null

Start day of the allocation period within month
Format: Integer (1-31)
Examples: 1 (1st of month), 16 (16th of month)
Usage: Defines the beginning of the date range for allocation calculation.
todate int4 10 null

End day of the allocation period within month
Format: Integer (1-31)
Examples: 15 (15th of month), 31 (end of month)
Usage: Defines the conclusion of the date range for allocation calculation.
valueofrange int4 10 null

Percentage allocation value for the specified date range
Format: Integer (0-100)
Examples: 100 (full allocation), 50 (half allocation), 25 (quarter allocation)
Calculation: (valueOfRange * baseCount) / 100 = final allocated balance.
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_leavecodepolicymonthlyconfig_id Primary key Asc id

Relationships

Close relationships within degrees of separation