tbl_leavecodepolicycounton

5 rows


Description

Module: HRMS Leave Management (Attendance-Based Allocation Configuration)
Purpose: Defines which day types count towards attendance for pro-rata leave calculations when allocation is based on attendance.
Data: Stores boolean flags indicating which attendance categories should be included in leave entitlement calculations.
Process Usage:
- Used by leave allocation engine when AllotLeaveCountBasedOn.ATTENDANCE is configured.
- Determines the denominator for pro-rata calculations based on actual working days.
Key Points:
- Only relevant when allotment is configured to be attendance-based rather than fixed.
- Controls which types of absences/presences count as “attended” days.
Business Impact: Critical for accurate pro-rata leave calculations for employees with variable attendance patterns.

Columns

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

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

FK: public.tbl_leavecodepolicyconfig.id
Meaning: References the parent leave policy configuration.
Relationship: One-to-One with leave policy - each policy has one counting configuration when using attendance-based allocation.
presentdays bool 1 false

Flag to include actual present working days in attendance count
Type: Boolean (default: false)
TRUE: Regular working days when employee was physically present count towards attendance
FALSE: Present days are excluded from attendance calculation
Usage: Typically enabled for most accurate pro-rata calculations.
paidleaves bool 1 false

Flag to include paid leave days in attendance count
Type: Boolean (default: false)
TRUE: Days taken as paid leave (CL, SL, PL) count as “attended” for pro-rata
FALSE: Leave days are treated as absences in calculation
Business Logic: Enabling this provides more generous leave allocation for employees taking leaves.
unpaidleaves bool 1 false

Flag to include unpaid leave days in attendance count
Type: Boolean (default: false)
TRUE: Unpaid leave days (LWP) count towards attendance calculation
FALSE: Unpaid leaves treated as non-attendance
Usage: Rarely enabled as unpaid leaves typically indicate extended absences.
holidaysonweekdays bool 1 false

Flag to include holidays falling on weekdays in attendance count
Type: Boolean (default: false)
TRUE: Company holidays on regular weekdays count as attended days
FALSE: Holidays are excluded from attendance calculation
Usage: Enabling this provides credit for holidays as “working” days.
holidaysonweekoffs bool 1 false

Flag to include holidays falling on weekly offs in attendance count
Type: Boolean (default: false)
TRUE: Holidays that coincide with weekly offs (Sundays) count towards attendance
FALSE: These “double off” days are excluded from calculation
Usage: Typically disabled as these represent non-working scenarios.
weekoffs bool 1 false

Flag to include regular weekly offs in attendance count
Type: Boolean (default: false)
TRUE: Weekly offs (Saturdays/Sundays) count as attended days
FALSE: Weekly offs are excluded from attendance calculation
Usage: Enabling this provides more generous allocation but may not reflect actual work patterns.
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_leavecodepolicycounton_id Primary key Asc id

Relationships

Close relationships within degrees of separation