tbl_clubbing

-1 rows


Description

Module: HRMS Leave Management
Purpose: Defines restrictions preventing specific leave types from being combined in consecutive leave applications.
Data: Stores relationships between leave types that CANNOT be clubbed together in single leave applications.
Process Usage:
- Used during leave application validation to prevent mixing of incompatible leave types.
- Enforces strict leave policies where certain leave types cannot be used consecutively.
Key Points:
- Creates restrictions between incompatible leave types.
- Prevents policy violations in multi-day leave applications.
Business Impact: Ensures compliance with leave policies by preventing invalid leave combinations.

Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for each clubbing restriction rule.
leavemasterid int4 10 √ null
leavecode varchar 50 √ null
clubbingleavecode varchar 50 √ null
cmpid int4 10 √ null
status bool 1 √ null

Active status of the clubbing restriction
Type: Boolean (default: true)
TRUE: Clubbing restriction is active and enforced
FALSE: Clubbing restriction is inactive/disabled
Usage: Allows temporary suspension of restrictions without deleting them.
createby varchar 100 √ null
createon timestamp 29,6 √ null
modifiedby varchar 100 √ null
modifiedon timestamp 29,6 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifieddate timestamp 29,6 √ null
leavecodeid int8 19 √ null
tbl_leavecodemaster.leavecodeid Implied Constraint R

FK: public.tbl_leavecodemaster.leavecodeid
Meaning: Primary leave type for which restrictions are being defined.
Usage: The base leave code that cannot be combined with specific other leave types.
clubbingleavecodeid int8 19 √ null

FK: public.tbl_leavecodemaster.leavecodeid
Meaning: Secondary leave type that CANNOT be combined with the primary leave type.
Usage: The restricted leave code that cannot be clubbed with the primary leave code.
Validation: System prevents leave applications that mix these two leave types consecutively.

Indexes

Constraint Name Type Sort Column(s)
tbl_clubbing_pk_tbl_clubbing Primary key Asc clubbingid

Relationships

Close relationships within degrees of separation