Leave Summary

The data model includes metrics such as Leave Entitlement, Balance Brought Forward, Accrued This Period, Leave Days Taken, Balance Carried Forward, Termination Payout Rate, Active Employees HeadCount, Average Leave Days Taken per active headcount, Employees With Excess Leave, and Percentage of Employees With Excess Leave. Views provide insights on leave provision by hierarchy, annual leave provision, accumulated leave warning, top employees by leave liability, leave breakdown by type, and annual leave overview for efficient management of employee leave entitlements and balances.

Benefits of This Data Model

• Improved Leave Management: The data model provides detailed metrics such as Leave Entitlement, Balance Brought Forward, and Accrued This Period, enabling organizations to efficiently track and manage employee leave balances.
• Enhanced Decision-Making: With insights on leave provision by hierarchy, annual leave allocation, and top employees by leave liability, managers can make informed decisions to optimize leave planning and resource allocation.
• Proactive Leave Monitoring: The model offers alerts for accumulated leave warnings and identifies employees with excess leave, allowing HR teams to proactively address leave balances and prevent disruptions in operations.
• Efficient Resource Utilization: By analyzing metrics such as Average Leave Days Taken per active headcount and Percentage of Employees With Excess Leave, organizations can identify trends, optimize workforce planning, and improve resource utilization.

Key Performance Indicators (KPIs)

• Leave Entitlement: The total number of leave days an employee is entitled to in a given period.
• Balance Brought Forward: The remaining leave days carried over from the previous period.
• Accrued This Period: The total number of leave days accrued by an employee in the current period.
• Leave Days Taken ALL: The total number of leave days taken by all employees in a given period.
• Leave Days Taken YTD: The total number of leave days taken by all employees year-to-date.
• Leave Days Taken LYTD: The total number of leave days taken by all employees last year.
• Balance Carried Forward: The remaining leave days carried over to the next period.
• Termination Payout Rate: The rate at which leave days are paid out upon termination.
• Termination Payout Total YTD: The total amount paid out for leave days upon termination year-to-date.
• Termination Payout Total LYTD: The total amount paid out for leave days upon termination last year.
• Termination Payout Variance: The difference in termination payout amounts between the current and previous year.
• Active Employees HeadCount YTD: The total number of active employees year-to-date.
• Active Employees HeadCount LYTD: The total number of active employees last year.
• Avg. Leave Days Taken per active headcount YTD: The average number of leave days taken per active employee year-to-date.
• Avg. Leave Days Taken per active headcount LYTD: The average number of leave days taken per active employee last year.
• Avg. Leave Days Taken per active headcount LYTD Variance: The difference in average leave days taken per active employee between the current and previous year.
• Active Employees With Leave YTD: The number of active employees who have taken leave year-to-date.
• Active Employees With Leave LYTD: The number of active employees who took leave last year.
• Employees With Excess Leave YTD: The number of employees with unused leave days year-to-date.
• Employees With Excess Leave LYTD: The number of employees with unused leave days last year.
• % of Employees With Excess Leave YTD: The percentage of employees with unused leave days year-to-date.
• % of Employees With Excess Leave LYTD: The percentage of employees with unused leave days last year.
• % of Employees With Excess Leave Variance: The difference in the percentage of employees with unused leave days between the current and previous year.
• Active Employees With Zero Leave YTD: The number of active employees with zero leave days taken year-to-date.
• Active Employees With Zero Leave LYTD: The number of active employees with zero leave days taken last year.
• Active Employees With Zero Leave Variance: The difference in the number of active employees with zero leave days taken between the current and previous year.

Available Visualisations

View Name	Description
Leave Provision By Hierarchy	Insights on leave provision distribution based on organizational hierarchy.
Annual Leave Provision	Insights on annual leave allocation and utilization across the organization.
Accumulated Leave Warning	Alerts for employees with accumulated leave exceeding predefined threshold.
Top 10 Employees by Leave Liability	Ranking of employees with the highest leave liabilities within the organization.
Leave by Type	Breakdown of leave taken categorized by different types (e.g., annual, sick, unpaid).
Annual Leave	Overview of annual leave entitlements and balances for all employees.