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.

Supported Dataview types

Employee Dataview

Business Structure Dataview

Employee Time Series Dataview

Business Structure Time Series Dataview

X

X

X

X

Data granularity (Employee Dataviews)

Provides one row per employee for the defined time period.

Data granularity (Business Structure Dataviews)

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

Columns

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

Related entities

Employee Dataview

Business Structure Dataview

Additional information

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.

Core entity (Employee Dataviews)

EmployeeOrganizationDayOrganizational JobPaycodeLabor Category
XX

Core entity (Business Structure Dataviews)

EmployeeOrganizationDayOrganizational JobPaycodeLabor Category
XXX

Relationship

One-to-One

One-to-Many

X