The Burnout Risk report shows the likelihood that an employee may experience burnout, along with key drivers that contribute to and help prevent it.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee Name Number | |||
| Snapshot Date | |||
|
Observation Number |
|||
| Driver | |||
| Driver Effect | |||
| Driver Value | |||
| Total Driver Impact on Burnout Risk | |||
| Index | |||
| Driver Ranking | |||
| Baseline Risk Level | |||
| Burnout Risk Likelihood | |||
| Employee Risk Percentile | |||
| Generation | |||
| Department Name | |||
| Employee Gender | |||
| Ethnicity Name | |||
| Age Band | |||
| Age | |||
| Tenure Band | |||
| Seniority Date | |||
| Median of Feature | |||
| Age Band Sort | |||
| Assigned Sex | |||
| Gender Identity name | |||
| Tenure Band Sort | |||
| Friendly Feature Name |
Custom Fields
Age Band
The Age Band custom field shows the grouping o ages together. It uses the following expression:
CASE WHEN (Employee.Age BETWEEN 15.0 AND 19.9) THEN '15-19' WHEN (Employee.Age BETWEEN 20.0 AND 24.9) THEN '20-24' WHEN (Employee.Age BETWEEN 20.0 AND 24.9) THEN '25-34' WHEN (Employee.Age BETWEEN 20.0 AND 24.9) THEN '35-44' WHEN (Employee.Age BETWEEN 20.0 AND 24.9) THEN '45-54' WHEN (Employee.Age BETWEEN 20.0 AND 24.9) THEN '55-64' WHEN (Employee.Age >= 65.0) THEN '65+' ELSE 'Under 15' END
Tenure Band
The Tenure Band custom field uses the following expression:
CASE WHEN (DATEDIFF(yyyy,Employee.SeniorityDate,Burnout.SnapshotDate) < 1) THEN '<1 <dayforceLabel>lblYear</dayforceLabel>' WHEN (DATEDIFF(yyyy,Employee.SeniorityDate,Burnout.SnapshotDate) >= 1 AND DATEDIFF(yyyy,Employee.SeniorityDate,CURRENT_TIMESTAMP) <= 2) THEN '1-2 <dayforceLabel>lblYears</dayforceLabel>' WHEN (DATEDIFF(yyyy,Employee.SeniorityDate,Burnout.SnapshotDate) >= 3 AND DATEDIFF(yyyy,Employee.SeniorityDate,CURRENT_TIMESTAMP) <= 5) THEN '3-5 <dayforceLabel>lblYears</dayforceLabel>' WHEN (DATEDIFF(yyyy,Employee.SeniorityDate,Burnout.SnapshotDate) >= 6 AND DATEDIFF(yyyy,Employee.SeniorityDate,CURRENT_TIMESTAMP) <= 10) THEN '6-10 <dayforceLabel>lblYears</dayforceLabel>' WHEN (DATEDIFF(yyyy,Employee.SeniorityDate,Burnout.SnapshotDate) >= 11) THEN '11+ <dayforceLabel>lblYears</dayforceLabel>' ELSE null END
Median of Feature
The Median of Feature custom field shows the median of feature for employee to group compasion. It uses the following expression:
Burnout.feature_name,PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY Burnout.feature_value) OVER (PARTITION BY Burnout.feature_name)
Age Band Sort
The Age Band Sort custom field shows the helper column for sorting age band. It uses the following expression:
CASE WHEN (Employee.Age BETWEEN 15.0 AND 19.9) THEN '2' WHEN (Employee.Age BETWEEN 20.0 AND 24.9) THEN '3' WHEN (Employee.Age BETWEEN 20.0 AND 24.9) THEN '4' WHEN (Employee.Age BETWEEN 20.0 AND 24.9) THEN '5' WHEN (Employee.Age BETWEEN 20.0 AND 24.9) THEN '6' WHEN (Employee.Age BETWEEN 20.0 AND 24.9) THEN '7' WHEN (Employee.Age >= 65.0) THEN '8' ELS '1' END
Tenure Band Sort
The Tenure Band Sort custom field shows the helper column for proper sorting of tenure. It uses the following expression:
CASE WHEN (DATEDIFF(yyyy,Employee.SeniorityDate,Burnout.SnapshotDate) < 1) THEN '1' WHEN (DATEDIFF(yyyy,Employee.SeniorityDate,Burnout.SnapshotDate) >= 1 AND DATEDIFF(yyyy,Employee.SeniorityDate,CURRENT_TIMESTAMP) <= 2) THEN '2' WHEN (DATEDIFF(yyyy,Employee.SeniorityDate,Burnout.SnapshotDate) >= 3 AND DATEDIFF(yyyy,Employee.SeniorityDate,CURRENT_TIMESTAMP) <= 5) THEN '3' WHEN (DATEDIFF(yyyy,Employee.SeniorityDate,Burnout.SnapshotDate) >= 6 AND DATEDIFF(yyyy,Employee.SeniorityDate,CURRENT_TIMESTAMP) <= 10) THEN '4' WHEN (DATEDIFF(yyyy,Employee.SeniorityDate,Burnout.SnapshotDate) >= 11) THEN '5' ELSE null END
Friendly Feature Name
The Friendly Feature Name custom field shows the easier to read translation of the feature name. It uses the following expression:
CASE WHEN Burnout.feature_name = 'BaseRate' THEN 'Base rate' WHEN Burnout.feature_name = 'BaseSalary' THEN 'Base salary' WHEN Burnout.feature_name = 'DaysSinceLastTAFW' THEN 'Days since last time away from work' WHEN Burnout.feature_name = 'IsVirtual' THEN 'Is virtual' WHEN Burnout.feature_name = 'Mrv_AverageDailyHours_employeeemploymentstatus' THEN 'Contracted average daily hours' WHEN Burnout.feature_name = 'Mrv_AverageDailyHours_employeeemploymentstatus' THEN 'Contracted average daily hours' WHEN Burnout.feature_name = 'Mrv_NormalWeeklyHours_employeeemploymentstatus' THEN 'Contracted normal weekly hours' WHEN Burnout.feature_name = 'NumberOfManagers' THEN 'Total number of managers' WHEN Burnout.feature_name = 'NumberOfManagersDividedByTenure' THEN 'Average number of managers per year' WHEN Burnout.feature_name = 'NumberOfTAFWRequests' THEN 'Number of Time away from work requests' WHEN Burnout.feature_name = 'NumberOfTAFWRequestsDividedByTenure' THEN 'Average number of Time away from work requests' work requests' WHEN Burnout.feature_name = 'TimeInCurrentWorkAssignmentInDays' THEN 'Time in current work assignment in days' WHEN Burnout.feature_name = 'TotalBaseRateChanges' THEN 'Total base rate changes' WHEN Burnout.feature_name = 'TotalBaseRateChangesDividedByTenure' THEN 'Average base rate changes per year' WHEN Burnout.feature_name = 'TotalBaseSalaryChanges' THEN 'Total base salary changes' WHEN Burnout.feature_name = 'TotalBaseSalaryChangesDividedByTenure' THEN 'Average base salary changes per year' WHEN Burnout.feature_name = 'TotalNumberOfWorkAssignments' THEN 'Total number of work assignments in org tenure' WHEN Burnout.feature_name = 'TotalNumberOfWorkAssignmentsDividedByTenure' THEN 'Average number of work assignments per year' WHEN Burnout.feature_name = 'TotalTAFWNetHours' THEN 'Total hours of time away from work' WHEN Burnout.feature_name = 'TotalTAFWNetHoursDividedByTenure' THEN 'Average time away from work hours per year' WHEN Burnout.feature_name = 'TotalNumberOfWorkAssignments' THEN 'Total number of work assignments in org tenure' WHEN Burnout.feature_name = 'TotalNumberOfWorkAssignmentsDividedByTenure' THEN 'Average number of work assignments per year' WHEN Burnout.feature_name = 'TotalTAFWNetHours' THEN 'Total hours of time away from work' WHEN Burnout.feature_name = 'TotalTAFWNetHoursDividedByTenure' THEN 'Average time away from work hours per year' WHEN Burnout.feature_name = 'TurnoverRate_0_period_back' THEN 'Organization turnover rate' WHEN Burnout.feature_name = 'NumberOfTAFWRequestsLast180' THEN 'Number of time away from work requests in the last 180 days' WHEN Burnout.feature_name = 'TotalTAFWNetHoursLast180' THEN 'Total hours of time away from work in the last 180 days' ELSE Burnout.feature_name END