Analytics

The Analytics entity provides the metrics and KPIs that are defined in the product and those metrics and KPIs that are custom-defined. The metrics and KPIs provide a means to measure labor management performance in areas like overtime, absenteeism, and productivity. Use the data columns in Employee Dataviews and reports to measure and compare individual employee performance or in Business Structure Dataviews and reports to measure and compare organizational entities, such as job, department, region, or location.

Employee Dataview Business Structure Dataview Employee Time Series Dataview Business Structure Time Series Dataview
X X X X

Provides one row per employee for the defined time period.

Provides one row per selected Location Type for the defined time period.

Label   Key

Absenteeism Costs

  

KPI_METRIC_ABSENT_AMT

Absenteeism Hours

  

KPI_METRIC_ABSENT_HRS

Absenteeism Hours as a % of Actual Hours

  

KPI_KPI_ABS_PER_ACTUAL

Absenteeism Hours as a % of Productive Hours

  

KPI_KPI_ABS_PER_PROD

Absenteeism Hours as a % of Scheduled Hours

  

KPI_KPI_ABS_PER_SCHED

Actual Costs

  

KPI_METRIC_ACTUAL_AMT

Actual Costs as a % of Scheduled Costs

  

KPI_KPI_ACT_PR_SCHD_AMT
Actual Days   KPI_METRIC_TCLD_ACT_DAY

Actual Hours

  

KPI_METRIC_ACTUAL_HRS

Actual Hours as a % of Scheduled Hours

  

KPI_KPI_ACT_PR_SCHD_HRS
Actual Hours   KPI_METRIC_TCLD_ACT_HRS
Actual Labor Costs (Forecasting)   KPI_METRIC_ACT_LBR_AMT
Actual Labor Hours (Forecasting)   KPI_METRIC_ACT_LBR_HRS
Average Actual Labor Cost per Actual Hours (Forecasting)   KPI_KPI_ACT_LBR_AMT_PR_LBR_HRS
Average Scheduled Labor Cost per Scheduled Hours (Forecasting)   KPI_KPI_SCHD_LBR_AMT_PR_LBR_HRS

Bonus Applied Exception Count

  

KPI_METRIC_BONUS_EXCP

Break Out of Sequence Exception Count

  

KPI_METRIC_BRK_SEQ_EXCP
Budget Labor Cost Budget Costs imported by the customer. KPI_METRIC_BDGT_LBR_COST
Budget Labor Hours Budget Hours imported by the customer. KPI_METRIC_BDGT_LBR_HRS
Callback Costs The actual labor costs based on the pay codes identified as Callback. KPI_METRIC_CALLBACK_AMT
Callback Costs as a % of Productive Costs Callback Costs as a % of Productive Costs KPI_KPI_CALLBACK_AMT_PER_PROD_AMT
Callback Hours The total number of actual hours based on the pay codes identified as Callback. KPI_METRIC_CALLBACK_HRS
Callback Hours as a % of On Call Hours Callback Hours as a % of On Call Hours KPI_KPI_CALLBACK_HRS_PER_ONCALL_HRS
Callback Hours as a % of Productive Hours Callback Hours as a % of Productive Hours KPI_KPI_CALLBACK_HRS_PER_PROD_HRS

Cancelled Meal Deduction Exception Count

  

KPI_METRIC_CAN_MEAL_EXCP

Core Hours Violation Exception Count

  

KPI_METRIC_COR_HRS_UEXCP
Daily Agency Hours as a % of Paid Hours Daily Agency Hours as a % of Paid Hours KPI_KPI_DAILY_AGNCY_HRS_PER_PAID_HRS
Daily Paid Agency Amount   KPI_METRIC_PAID_AGNCY_AMT
Daily Paid Agency Hours   KPI_METRIC_PAID_AGNCY_HRS
Daily Paid Amount   KPI_METRIC_PAID_AMT
Daily Paid Float In Amount   KPI_METRIC_PAID_FLT_IN_AMT
Daily Paid Float In Hours   KPI_METRIC_PAID_FLT_IN_HRS
Daily Paid Float Out Amount   KPI_METRIC_PAID_FLT_OUT_AMT
Daily Paid Float Out Hours   KPI_METRIC_PAID_FLT_OUT_HRS
Daily Paid Full Time Amount   KPI_METRIC_PAID_FT_AMT
Daily Paid Full Time Hours   KPI_METRIC_PAID_FT_HRS
Daily Paid Hours   KPI_METRIC_PAID_HRS
Daily Paid Internal Agency Amount   KPI_METRIC_PAID_INT_AGNCY_AMT
Daily Paid Internal Agency Hours   KPI_METRIC_PAID_INT_AGNCY_HRS
Daily Paid Part Time Amount   KPI_METRIC_PAID_PT_AMT
Daily Paid Part Time Hours   KPI_METRIC_PAID_PT_HRS
Daily Paid Per Diem Amount   KPI_METRIC_PAID_PDIEM_AMT
Daily Paid Per Diem Hours   KPI_METRIC_PAID_PDIEM_HRS
Daily Paid Pool Amount   KPI_METRIC_PAID_POOL_AMT
Daily Paid Pool Hours   KPI_METRIC_PAID_POOL_HRS
Daily Productive Agency Amount   KPI_METRIC_PROD_AGNCY_AMT
Daily Productive Agency Hours   KPI_METRIC_PROD_AGNCY_HRS
Daily Productive Float In Amount   KPI_METRIC_PROD_FLT_IN_AMT
Daily Productive Float In Hours   KPI_METRIC_PROD_FLT_IN_HRS
Daily Productive Float Out Amount   KPI_METRIC_PROD_FLT_OUT_AMT
Daily Productive Float Out Hours   KPI_METRIC_PROD_FLT_OUT_HRS
Daily Productive Full Time Amount   KPI_METRIC_PROD_FT_AMT
Daily Productive Full Time Hours   KPI_METRIC_PROD_FT_HRS
Daily Productive Internal Agency Amount   KPI_METRIC_PROD_INT_AGNCY_AMT
Daily Productive Internal Agency Hours   KPI_METRIC_PROD_INT_AGNCY_HRS
Daily Productive Part Time Amount   KPI_METRIC_PROD_PT_AMT
Daily Productive Part Time Hours   KPI_METRIC_PROD_PT_HRS
Daily Productive Per Diem Amount   KPI_METRIC_PROD_PDIEM_AMT
Daily Productive Per Diem Hours   KPI_METRIC_PROD_PDIEM_HRS
Daily Productive Pool Amount   KPI_METRIC_PROD_POOL_AMT
Daily Productive Pool Hours   KPI_METRIC_PROD_POOL_HRS

Data Up-To-Date

  

KPI_FRESHNESS_DATAFRESHNESS_INDICATOR

Data Update Date Time

  

KPI_FRESHNESS_LASTUPDATEDTS

Early In Exception Count

  

KPI_METRIC_ERLY_IN_EXCP

Early In Exceptions as a % of All Exceptions

  

KPI_KPI_ERLY_IN_PER

Early Out Exception Count

  

KPI_METRIC_ERLY_OUT_UEXCP

Early Out Exceptions as a % of All Exceptions

  

KPI_KPI_ERLY_OUT_PER
Earned Hours as a % of Actual Labor Hours   KPI_KPI_EARNED_HRS_PER_ACT_LBR_HRS
Earned Hours How many labor hours should have been scheduled based on the actual volumes. KPI_METRIC_EARNED_HRS
Education Orientation Costs The actual labor costs based on the pay codes identified as Education Orientation. KPI_METRIC_EDUC_ORIENT_AMT
Education Orientation Hours The total number of actual hours based on the pay codes identified as Education Orientation. KPI_METRIC_EDUC_ORIENT_HRS

Employee Approval Count

  

KPI_METRIC_EMP_APRV_CNT

Exception Hours

  

KPI_METRIC_EXCP_HRS

Excused Absence Exception Count

  

KPI_METRIC_TOT_EXC_ABS

Excused Absenteeism Costs

  

KPI_METRIC_EXABSENT_AMT

Excused Absenteeism Hours

  

KPI_METRIC_EXABSENT_HRS

Excused Absenteeism Hours as a % of Actual Hours

  

KPI_KPI_EXABS_PER_ACT

Excused Absenteeism Hours as a % of Productive Hours

  

KPI_KPI_EXABS_PER_PROD

Excused Absenteeism Hours as a % of Scheduled Hours

  

KPI_KPI_EXABS_PER_SCH

Excused Absenteeism Hours as a % of Total Absenteeism Hours

  

KPI_KPI_EXABS_PER_ABS
Extended Absenteeism Costs The actual labor costs based on the pay codes identified as Extended Absenteeism. KPI_METRIC_ABSENT_EXTND_AMT
Extended Absenteeism Hours The total number of actual hours based on the pay codes identified as Extended Absenteeism. KPI_METRIC_ABSENT_EXTND
Extended Absenteeism Hours as % of Paid Hours Extended Absenteeism Hours as % of Paid Hours KPI_KPI_ABSENT_EXTND_HRS_PER_PAID_HRS
Extended Absenteeism Hours as % of Total Absenteeism Hours Extended Absenteeism Hours as % of Total Absenteeism Hours KPI_KPI_ABSENT_EXTND_HRS_PER_ABS_HRS
Extra and/ Lost time Extra and/ Lost time KPI_KPI_EXT_LOST_HRS
Forecasted Hours Forecasted Hours generated or optionally edited by a user. KPI_METRIC_FCST_HRS
Generated Forecasted Hours Generated Forecasted Hours calculated by the engine. KPI_METRIC_FCST_GEN_HRS

Holiday Scheduled Violation Exception Count

  

KPI_METRIC_HOL_SCD_EXCP

Hours Over Exception

  

KPI_METRIC_HRS_OVR_EXCP

Invalid Named Duration Exception Count

  

KPI_METRIC_INV_DUR_EXCP

Late In Exception Count

  

KPI_METRIC_LAT_IN_UEXCP

Late In Exceptions as a % of All Exceptions

  

KPI_KPI_LAT_IN_PER

Late Out Exception Count

  

KPI_METRIC_LAT_OUT_EXCP

Late Out Exceptions as a % of All Exceptions

  

KPI_KPI_LAT_OUT_PER

Long Break Exception Count

  

KPI_METRIC_LNG_BRK_UEXCP

Long Shift Exception Count

  

KPI_METRIC_LNG_SHFT_EXCP

Long Total Break Exception Count

  

KPI_METRIC_LNG_TBRK_EXCP
Low Census Costs The actual labor costs based on the pay codes identified as Low Census. KPI_METRIC_LOW_CENSUS_AMT
Low Census Hours The total number of actual hours based on the pay codes identified as Low Census. KPI_METRIC_LOW_CENSUS_HRS

Manager Approval Count

  

KPI_METRIC_MGR_APRV_CNT

Minimum Days Active Violation Exception Count

  

KPI_METRIC_MIN_ACT_EXCP

Minimum Days Employed Violation Exception Count

  

KPI_METRIC_MIN_EMP_EXCP

Missed In Punch Exception Count

  

KPI_METRIC_MIS_PNCIN_EXCP

Missed Out Punch Exception Count

  

KPI_METRIC_MIS_PNCOUT_EXCP

Missed Punch Exceptions as a % of All Exceptions

  

KPI_KPI_MIS_PNCH_PER

Non-Productive Costs

  

KPI_METRIC_NP_AMT

Non-Productive Costs as % of Total Labor Costs

  

KPI_KPI_NP_PER_ACT_AMT

Non-Productive Hours

  

KPI_METRIC_NP_HRS

Non-Productive Hours as % of Actual Hours

  

KPI_KPI_NP_PER_ACT_HRS

Non-Productive Hours as % of Productive Hours

  

KPI_KPI_NP_PER_PROD_HRS
On Call Costs The actual labor costs based on the pay codes identified as On Call. KPI_METRIC_ONCALL_AMT
On Call Hours The total number of actual hours based on the pay codes identified as On Call. KPI_METRIC_ONCALL_HRS
OnCall and Callback Costs OnCall and Callback Costs KPI_KPI_ONCALL_AMT_CALLBACK_AMT
OnCall and Callback Hours OnCall and Callback Hours KPI_KPI_ONCALL_HRS_CALLBACK_HRS

Overtime Costs

  

KPI_METRIC_OT_AMT
Overtime Costs as % of Paid Costs Overtime Costs as % of Paid Costs KPI_KPI_OT_AMT_PER_PAID_AMT

Overtime Costs as % of Total Labor Costs

  

KPI_KPI_OT_PER_ACT_AMT
Overtime Costs as a % of Overtime Hours Average Overtime Rate KPI_KPI_OT_AMT_PER_OT_HRS

Overtime Hours

  

KPI_METRIC_OT_HRS

Overtime Hours as % of Actual Hours

  

KPI_KPI_OT_PER_ACT_HRS
Overtime Hours as % of Paid Hours Overtime Hours as % of Paid Hours KPI_KPI_OT_HRS_PER_PAID_HRS

Overtime Hours as % of Productive Hours

  

KPI_KPI_OT_PER_PROD_HRS
Planned Absenteeism Costs The actual labor costs based on the pay codes identified as Planned Absenteeism. KPI_METRIC_ABSENT_PLND_AMT
Planned Absenteeism Hours The total number of actual hours based on the pay codes identified as Planned Absenteeism. KPI_METRIC_ABSENT_PLND
Premium Costs The actual labor costs based on the pay codes identified as Premium. KPI_METRIC_PREM_AMT
Premium costs as a % of paid costs Premium costs as a % of paid costs KPI_KPI_PREM_AMT_PER_PAID_AMT
Premium Hours The total number of actual hours based on the pay codes identified as Premium. KPI_METRIC_PREM_HRS
Premium Hours as % of Paid Hours Premium Hours as % of Paid Hours KPI_KPI_PREM_HRS_PER_PAID_HRS

Productive Costs

  

KPI_METRIC_PROD_AMT

Productive Costs as % of Total Labor Costs

  

KPI_KPI_PROD_PER_ACT_AMT

Productive Hours

  

KPI_METRIC_PROD_HRS

Productive Hours as % of Actual Hours

  

KPI_KPI_PROD_PER_ACT_HRS
Productive Hours as % of Scheduled Productive Hours Productive Hours as % of Scheduled Productive Hours KPI_KPI_PROD_HRS_PER_SCHD_PROD_HRS

Projected  Non-Productive Hours

  

KPI_METRIC_PRJ_NP_HRS
Projected Non-Productive Labor Costs   KPI_METRIC_PRJ_NP_AMT

Projected  Overtime Hours

  

KPI_METRIC_PRJ_OT_HRS

Projected  Overtime Labor Costs

  

KPI_METRIC_PRJ_OT_AMT

Projected  Productive Hours

  

KPI_METRIC_PRJ_PROD_HRS

Projected  Regular Costs

  

KPI_METRIC_PRJ_REG_AMT

Projected  Regular Hours

  

KPI_METRIC_PRJ_REG_HRS

Projected  Training Costs

  

KPI_METRIC_PRJ_TRN_AMT

Projected  Training Hours

  

KPI_METRIC_PRJ_TRN_HRS
Projected Days   KPI_METRIC_TCLD_PROJ_DAY

Projected Hours

  

KPI_METRIC_PROJ_HRS
Projected Hours   KPI_METRIC_TCLD_PROJ_HRS

Projected Labor Costs

  

KPI_METRIC_PROJ_AMT
Projected Overtime Hours as a % of Projected Productive Hours The percentage of Projected Overtime hours as a ratio of Projected Productive Hours. KPI_KPI_PRJ_OT_PER_PRJ_PROD

Projected Productive Labor Costs

  

KPI_METRIC_PRJ_PROD_AMT

Regular Costs

  

KPI_METRIC_REG_AMT

Regular Costs as % of Total Labor Costs

  

KPI_KPI_REG_PER_ACT_AMT

Regular Hours

  

KPI_METRIC_REG_HRS

Regular Hours as % of Actual Hours

  

KPI_KPI_REG_PER_ACT_HRS

Regular Hours as % of Productive Hours

  

KPI_KPI_REG_PER_PROD_HRS

Reviewed Exceptions

  

KPI_METRIC_REV_EXCP

Rounding Rule Variance

  

KPI_KPI_RND_RUL_VAR

Schedule Overtime Costs

  

KPI_METRIC_SCHD_OT_AMT

Scheduled Costs

  

KPI_METRIC_SCHED_AMT
Scheduled Days   KPI_METRIC_TCLD_SCHD_DAY

Scheduled Hours

  

KPI_METRIC_SCHED_HRS
Scheduled Hours   KPI_METRIC_TCLD_SCHD_HRS
Scheduled Labor Costs (Forecasting)   KPI_METRIC_SCHD_LBR_AMT
Scheduled Labor Hours (Forecasting)   KPI_METRIC_SCHD_LBR_HRS

Scheduled Non-Productive Costs

  

KPI_METRIC_SCHD_NP_AMT

Scheduled Non-Productive Hours

  

KPI_METRIC_SCHD_NP_HRS

Scheduled Overtime Hours

  

KPI_METRIC_SCHD_OT_HRS

Scheduled Productive Costs

  

KPI_METRIC_SCHD_PROD_AMT

Scheduled Productive Hours

  

KPI_METRIC_SCHD_PROD_HRS

Scheduled Regular Costs

  

KPI_METRIC_SCHD_REG_AMT

Scheduled Regular Hours

  

KPI_METRIC_SCHD_REG_HRS

Scheduled Training Costs

  

KPI_METRIC_SCHD_TRN_AMT

Scheduled Training Hours

  

KPI_METRIC_SCHD_TRN_HRS

Short Break Exception Count

  

KPI_METRIC_SHT_BRK_EXCP

Short Shift Exception Count

  

KPI_METRIC_SHT_SHFT_EXCP

Short Total Break Exception Count

  

KPI_METRIC_SHT_TBRK_EXCP
Sitter Costs The actual labor costs based on the pay codes identified as Sitter. KPI_METRIC_SITT_AMT
Sitter Costs per Sitter Hours Sitter Costs per Sitter Hours KPI_KPI_SITT_AMT_PER_SITT_HRS
Sitter Hours The total number of actual hours based on the pay codes identified as Sitter. KPI_METRIC_SITT_HRS
Sitter Hours as a % of Actual Hours Sitter Hours as a % of Actual Hours KPI_KPI_SITT_HRS_PER_ACTUAL_HRS
System Adjusted Hours System Adjusted Hours calculated by Labor Constraint engine. KPI_METRIC_FCST_ADJ_HRS

Time Paid Not Worked (In) Hours

  

KPI_METRIC_TPNW_IN_HRS

Time Paid Not Worked (In) Hours as % of Actual Hours

  

KPI_KPI_TPNWIN_PER_HRS

Time Paid Not Worked (Out) Hours

  

KPI_METRIC_TPNW_OUT_HRS

Time Paid Not Worked (Out) Hours as % of Actual Hours

  

KPI_KPI_TPNWOUT_PER_HRS

Time Paid Not Worked Hours

  

KPI_KPI_TPNW_HRS

Time Paid Not Worked Hours as % of Actual Hours

  

KPI_KPI_TPNW_PER_AHRS

Time Paid Not Worked Hours as % of Productive Hours

  

KPI_KPI_TPNW_PER_PHRS

Time Worked Not Paid (In) Hours

  

KPI_METRIC_TWNP_IN_HRS

Time Worked Not Paid (In) Hours as % of Actual Hours

  

KPI_KPI_TWNPIN_PER_HRS

Time Worked Not Paid (Out) Hours

  

KPI_METRIC_TWNP_OUT_HRS

Time Worked Not Paid (Out) Hours as % of Actual Hours

  

KPI_KPI_TWNPOUT_PER_HRS

Time Worked Not Paid Hours

  

KPI_KPI_TWNP_HRS

Time Worked Not Paid Hours as % of Actual Hours

  

KPI_KPI_TWNP_PER_AHRS

Time Worked Not Paid Hours as % of Productive Hours

  

KPI_KPI_TWNP_PER_PHRS
Total Actual Days   KPI_METRIC_TCL_ACT_DAY
Total Actual Hours   KPI_METRIC_TCL_ACT_HRS
Total Actual Wages   KPI_METRIC_TCL_ACT_AMT

Total Early In Exception Count

  

KPI_KPI_TOT_ERLIN_EXCP

Total Exception Count

  

KPI_METRIC_TOT_UNR_EXCPS

Total Late Out Exception Count

  

KPI_KPI_TOT_LATOT_EXCP

Total Missed Punch Exception Count

  

KPI_KPI_TOT_MP_EXCP
Total Projected Days   KPI_METRIC_TCL_PROJ_DAY
Total Projected Hours   KPI_METRIC_TCL_PROJ_HRS
Total Projected Wages   KPI_METRIC_TCL_PROJ_AMT
Total Scheduled Days   KPI_METRIC_TCL_SCHD_DAY
Total Scheduled Hours   KPI_METRIC_TCL_SCHD_HRS
Total Scheduled Wages   KPI_METRIC_TCL_SCHD_AMT

Training Costs

  

KPI_METRIC_TRN_AMT

Training Costs as % of Total Labor Costs

  

KPI_KPI_TRN_PER_ACT_AMT

Training Hours

  

KPI_METRIC_TRN_HRS

Training Hours as % of Actual Hours

  

KPI_KPI_TRN_PER_ACT_HRS

Training Hours as % of Productive Hours

  

KPI_KPI_TRN_PER_PROD_HRS

Unexcused Absence Exception Count

  

KPI_METRIC_TOT_UNR_ABS

Unexcused Absenteeism Costs

  

KPI_METRIC_UNABSENT_AMT

Unexcused Absenteeism Hours

  

KPI_METRIC_UNABSENT_HRS

Unexcused Absenteeism Hours as a % of Actual Hours

  

KPI_KPI_UNABS_PER_ACT

Unexcused Absenteeism Hours as a % of Productive Hours

  

KPI_KPI_UNABS_PER_PROD

Unexcused Absenteeism Hours as a % of Scheduled Hours

  

KPI_KPI_UNABS_PER_SCH

Unexcused Absenteeism Hours as a % of Total Absenteeism Hours

  

KPI_KPI_UNABS_PER_ABS
Unplanned Absenteeism Costs The actual labor costs based on the pay codes identified as Unplanned Absenteeism. KPI_METRIC_ABSENT_UNPLND_AMT
Unplanned Absenteeism Costs as % of Paid Costs Unplanned Absenteeism Costs as % of Paid Costs KPI_KPI_ABSENT_UNPLND_AMT_PER_PAID_AMT
Unplanned Absenteeism Hours The total number of actual hours based on the pay codes identified as Unplanned Absenteeism. KPI_METRIC_ABSENT_UNPLND
Unplanned Absenteeism Hours as % of Absenteeism Hours The percentage of Absenteeism Hours that were not planned, such as absences related to illness. KPI_KPI_UNPLN_ABS_PER_ABS_HRS
Unplanned Absenteeism Hours as % of Paid Hours Unplanned Absenteeism Hours as % of Paid Hours KPI_KPI_ABSENT_UNPLND_HRS_PER_PAID_HRS
Unplanned Absenteeism Hours as % of Total Absenteeism Hours Unplanned Absenteeism Hours as % of Total Absenteeism Hours KPI_KPI_ABSENT_UNPLND_HRS_PER_ABS_HRS
Unplanned Absenteeism Hours The number of hours that represent Unplanned Absenteeism. KPI_METRIC_UNPLN_ABS_HRS

Unscheduled Time Exception Count

  

KPI_METRIC_UNSCH_TM_EXCP

Very Early In Exception Count

  

KPI_METRIC_VERLY_IN_EXCP

Very Late Out Exception Count

  

KPI_METRIC_VLAT_OUT_EXCP

Work History Violation Exception Count

  

KPI_METRIC_WRK_HIST_EXCP

Employee Dataview

Business Structure Dataview

When a target is first defined for any metric or KPI, the system generates the following columns that can be used in Dataviews and reports:

  • {Metric/KPIName} Target: The target value for the assigned location or employee during the time period.
  • {Metric/KPIName} Threshold Value: Displays the threshold value when it is violated.
  • {Metric/KPIName} Threshold Indicator: Displays the indicator text when the threshold value is violated.
  • {Metric/KPIName} Evaluation Period: The evaluation period for the target. Examples: Daily, Weekly.

See the online help for Setup > Application Setup > Target Management for more informatiom on creating targets and thresholds.

Employee Organization Day Organizational Job Paycode Labor Category
X   X      
Employee Organization Day Organizational Job Paycode Labor Category
X X X      
One-to-One One-to-Many
  X