tbl_leavecancellationhistory

-1 rows


Description

Module: HRMS Leave Management
Purpose: Maintains complete audit history of leave cancellation workflows including all approval stages and remarks.
Data: Stores multi-level approval status and comments when leaves are cancelled through the approval hierarchy.
Process Usage:
- Tracks the complete cancellation workflow from initiation to final HR approval.
- Preserves all stakeholder comments and decisions for compliance and reference.
Key Points:
- Captures the entire cancellation approval chain (Manager 1 → Manager 2 → HR Admin).
- Stores remarks from each approval level for transparency and dispute resolution.
Business Impact: Essential for audit compliance, process transparency, and resolving cancellation-related disputes.

Columns

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

Primary key
Format: BigSerial (auto-increment)
Used as: Unique identifier for each cancellation history record.
leaveappid int8 19 null
tbl_leaveapplicationheader.id fk_tbl_leavecancellationhistory_leaveappid R

FK: public.tbl_leaveapplication.id
Meaning: References the original leave application being cancelled.
Usage: Links cancellation history to the specific leave application record.
employeeid varchar 500 null
tbl_employee.employeeid fk_tbl_leavecancellationhistory_employeeid R

FK: public.tbl_employee.employeeid
Meaning: Employee who requested the leave cancellation.
Usage: Identifies the employee associated with the cancellation request.
reporting1status varchar 20 √ null

First-level manager approval status for cancellation
Format: String
Typical Values: “PENDING”, “APPROVED”, “REJECTED”, “CANCELLED”
Role: Direct manager or team lead who first reviews the cancellation request
Workflow: Initial approval authority in the cancellation chain.
reporting2status varchar 20 √ null

Second-level manager approval status for cancellation
Format: String
Typical Values: “PENDING”, “APPROVED”, “REJECTED”, “CANCELLED”
Role: Department head or senior manager for secondary approval
Workflow: Secondary review for higher-value leaves or policy compliance.
finalstatus varchar 20 √ null

Final HR/Admin approval status for cancellation
Format: String
Typical Values: “PENDING”, “APPROVED”, “REJECTED”, “PROCESSED”
Role: HR administrator with final authority on leave cancellations
Workflow: Final decision that triggers balance restoration and system updates.
rep1remark varchar 255 √ null

Comments from first-level reporting manager
Format: String
Examples: “Approved due to urgent work requirement”, “Rejected - insufficient notice period”
Usage: Provides context for manager’s decision and business justification.
rep2remark varchar 255 √ null

Comments from second-level reporting manager
Format: String
Examples: “Concur with reporting1 approval”, “Additional review required for policy compliance”
Usage: Documents senior management input and oversight comments.
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_leavecancellationhistory_id Primary key Asc id

Relationships

Close relationships within degrees of separation