Human Resources Data Mart

These are the measures or metrics we track in the Data Marts for LBI. The Data Mart includes significant intellectual property not only from an IT data base design perspective but also from a "Best Practice" perspective. The below measures included most of the items an organization should be tracking. New measures and dimensions can be added relatively easy on a consulting basis.

HR Measures

Headcount
FTE Count
Average Headcount
Latest Headcount
Average FTE Count
Leavers Count
Leaving Rate %
Appointed Count
Appointed Rate %
Terminations Count
Terminations Rate %
Resignations Count
Resignations Rate %
Early Retirements Count
Early Retirements Rate %
Ill Health Retirements Count
Ill Health Retirements Rate %
FTE Workdays
Absence Days
Elapse Days
Sickness Days
Sickness Absence Rate %
Sickness Absence Cost per FTE
Monthly Sick Days per Person
Period Absence Days
Period FTE Absence Days
Period Absence Elapsed
New Absence Occurrences
Absence Rate
Absence Days per FTE
Absence Cost
Absence Cost per FTE
Pay
Pension
Average Pay and Pension
Total Pay and Pension (Compensation)
Employer NI
Overtime Units
Overtime Pay
Top 5 Flag All
Top 5 Flag Not Schools
Discretion Days
Employee Days
Holiday Days
Maternity Days
Paternal Days
Average Remuneration
Average Benefits
Total Benefits/Total Compensation
Variable Compensation

Incentive Premium
Attendance Premium
Payroll Costs per Employee
Total OH&S Cost per FTE
Preventative Costs per FTE
Liability & Rehabilitation Costs per FTE
Executive Stability Ratio
Reactive Ratio
Rookie Ratio
Grievance Rate
External Recruitment Rate
Internal Recruitment Rate
External Addition Rate
External Replacement Rate
Cost per Hire
Time to Accept
Acceptance Rate
Female Diversity
FTEs per Training & Development FTE
Training Costs per FTE
Training Costs/Total Compensation
Training Costs per Hour
In House Training Costs per FTE
External Training Costs per FTE
Technical Training Costs per FTE
Development Training Costs per FTE
Training Hours per FTE
In House Training Hours per FTE
External Training Hours per FTE
Scheduled Days
Statutory Days
Training Days
Unauthorized Days
Transfer In
Transfer Out
Grade Transfer
Gender Diversity
Ethnic Diversity
Disability Diversity
Total Costs
Total Revenue
Profit After Tax
Profit Before Tax
Shareholder Equity
Revenue from Services
Revenue from New Products & Services
R&D Expenses
Marketing Expenses
Professional Services Expenses
Outsource Costs

Suggestions Received
Suggestions Accepted
Customer Complaints Received
Payroll Costs
Organizational Health & Safety Costs
Reported Safety Issues
Health & Safety Preventative Costs
Employers Liabilities
Employee Grievances
HR Outsource Costs
HR Internal Charges
Wealth Created per FTE
Human Investment Ratio
Profit per FTE
Revenue per FTE
Costs per FTE
Non Operating Costs per FTE
% Managers & Professionals
Outsource Rate
Total Productivity
Remuneration/Revenue
Compensation/Revenue
Remuneration/Total Costs
Compensation/Total Costs
Compensation/Net Operating Costs
Enquiries per Vacancy
Applications per Vacancy
Application Rejections per Vacancy
Interviews per Vacancy
Interview Rejections per Vacancy
Interview Offers per Vacancy
Acceptances per Vacancy
Declines per Vacancy
Applications to Enquiries per Vacancy
Interviews per Applications for Vacancy
Offers per Interview for Vacancy
Average Days to Application Rejection for Vacancy
Average Days to Interview for Vacancy
Average Days to Interview Offer for Vacancy
Average Days to Interview Decline for Vacancy
Average Days to Join for Vacancy
Cost per Application
Cost per Vacancy
Total Inquiries
Total Applications
Total Interviews
Total Interview Offers
Total Interview Declines
Total Joins/Hires from Vacancies

HR Dimensions

The above measures can be viewed by any combination of parameters or "Dimensions". Multiple measures like "Voluntary and Involuntary Separations" can be viewed by any number of dimensions on the same report.

Absence Cube Dimensions:

All Dates
All Organization Levels
All Absence Reasons
All Genders
All Ethnicity
All Pay Grades
All Age Levels
All Length of Service
Full or Part Time
Short and Long Term

Recruiting Cube Dimensions:

All Dates
All Organization Levels
All Grades
All Job Tiers
All Vacancy Categories
All Headcount Effects
All Vacancy Status
All Ethnicity
All Genders
Full or Part Time
All Contract Types
All Application Methods
All Application Sources

Workforce Analysis Cube:

All Dates
All Organization Levels
All Job Tiers
All Genders
All Ethnicity
Able and Disabled
All Pay Grades
All Age Levels
All Length of Service
All Jobs
Full or Part Time
All Employee Statuses
All Separation Reasons

Training Cube:

All Dates
All Organization Levels
Internal and External
All Courses
All Job Tiers
All Ethnicity
All Genders
Able and Disabled
All Grades
Full or Part Time
All Contract Types
All Training Results