Daily Productivity

For Healthcare Analytics

The Daily Productivity entity provides work unit productivity data based on daily timekeeping totals, regular and supplemental labor details, and fixed and variable targets compared to actual hours and amounts.

Caution: The Healthcare Analytics entities and columns are available only from the API and cannot be used in Dataviews or to create reports at this time. To get the Healthcare Analytics data, use the Retrieve Data (POST /v1/commons/data/multi_read) API operation. Retrieve only the WORKUNIT and WORKUNIT_TIMESERIES data and ignore the Employee and Location data.

Supported Dataview types

Standard Dataview	Timeseries Dataview	Employee Dataview	Business Structure Dataview
Yes Only date range is supported to retrieve productivity data by day.	Yes Calendar-based roll-ups are supported for DAY, WEEK, MONTH, QUARTER.

Standard Dataview

Timeseries Dataview

Employee Dataview

Business Structure Dataview

Yes

Only date range is supported to retrieve productivity data by day.

Yes

Calendar-based roll-ups are supported for DAY, WEEK, MONTH, QUARTER.

Data granularity

Workunit
For the standard, work unit view, one row (for each column) for each work unit for each date is returned.
For the work unit time series view, one row (for each column) for each work unit for each time increment (resolved by input type: DAY, WEEK, MONTH, QUARTER) is returned.

Columns

Label	Description	Key
Daily Variable Productive Hours Targets/Unit Of Service	Daily Variable Productive Hours Targets/Unit Of Service	HCA_DRVDKPI_HCAVARIABLE_METRIC_PROD_HRS_PER_VOL_WEIGHTED_DAILY
Daily Paid Amount Target	Daily Paid Amount Target	HCA_DRVDKPI_PAID_AMT_TGT
Daily Paid Amount Target/Unit Of Service	Daily Paid Amount Target/Unit Of Service	HCA_DRVDKPI_PAID_AMT_TGT_PER_VOL_WEIGHTED
Daily Paid Amount Variance	Daily Paid Amount Variance	HCA_DRVDKPI_PAID_AMT_VAR
Daily Paid FTEs	Daily Paid FTEs	HCA_DRVDKPI_PAID_HRS_FTE
Daily Paid Hours Target	Daily Paid Hours Target	HCA_DRVDKPI_PAID_HRS_TGT
Daily Paid Hours Target/Unit Of Service	Daily Paid Hours Target/Unit Of Service	HCA_DRVDKPI_PAID_HRS_TGT_PER_VOL_WEIGHTED
Daily Paid Hours Variance	Daily Paid Hours Variance	HCA_DRVDKPI_PAID_HRS_VAR
Daily Productivity Index % Cost	Daily Productivity Amount Index	HCA_DRVDKPI_PROD_AMT_IDX
Daily Productive Amount Target	Daily Productive Amount Target	HCA_DRVDKPI_PROD_AMT_TGT
Daily Productive Amount Target/Unit Of Service	Daily Productive Amount Target/Unit Of Service	HCA_DRVDKPI_PROD_AMT_TGT_PER_VOL_WEIGHTED
Daily Productive Amount Variance	Daily Productive Amount Variance	HCA_DRVDKPI_PROD_AMT_VAR
Recommended Adjustment	Recommended Adjustment	HCA_DRVDKPI_PROD_HRS_ADJUSTMENT
Daily Productivity Index	Daily Productivity Index	HCA_DRVDKPI_PROD_HRS_IDX
Actual/Unit Of Service	Daily Actual/Unit Of Service	HCA_DRVDKPI_PROD_HRS_PER_VOL_WEIGHTED
Daily Productive Hours Target	Daily Productive Hours Target	HCA_DRVDKPI_PROD_HRS_TGT
Daily Productive Hours Target/Unit Of Service	Daily Productive Hours Target/Unit Of Service	HCA_DRVDKPI_PROD_HRS_TGT_PER_VOL_WEIGHTED
Daily Productive Hour Variance	Daily Productive Hour Variance	HCA_DRVDKPI_PROD_HRS_VAR
Regular	Daily Regular Hours	HCA_DRVDKPI_PROD_REG_HRS
Daily Non Productive Amount	Daily Non Productive Amount	HCA_METRIC_NP_AMT
Daily Non Productive Hours	Daily Non Productive Hours	HCA_METRIC_NP_HRS
Daily Overtime Hours	Daily Overtime Hours	HCA_METRIC_OT_HRS
Daily Paid Amount	Daily Paid Amount	HCA_METRIC_PAID_AMT
Daily Paid Float In Amount	Daily Paid Float In Amount	HCA_METRIC_PAID_FLT_IN_AMT
Daily Paid Float In Hours	Daily Paid Float In Hours	HCA_METRIC_PAID_FLT_IN_HRS
Daily Paid Float Out Amount	Daily Paid Float Out Amount	HCA_METRIC_PAID_FLT_OUT_AMT
Daily Paid Float Out Hours	Daily Paid Float Out Hours	HCA_METRIC_PAID_FLT_OUT_HRS
Daily Paid Full Time Amount	Daily Paid Full Time Amount	HCA_METRIC_PAID_FT_AMT
Daily Paid Full Time Hours	Daily Paid Full Time Hours	HCA_METRIC_PAID_FT_HRS
Daily Paid Hours	Daily Paid Hours	HCA_METRIC_PAID_HRS
Daily Paid Per Diem Amount	Daily Paid Per Diem Amount	HCA_METRIC_PAID_PDIEM_AMT
Daily Paid Per Diem Hours	Daily Paid Per Diem Hours	HCA_METRIC_PAID_PDIEM_HRS
Daily Paid Pool Amount	Daily Paid Pool Amount	HCA_METRIC_PAID_POOL_AMT
Daily Paid Pool Hours	Daily Paid Pool Hours	HCA_METRIC_PAID_POOL_HRS
Daily Paid Part Time Amount	Daily Paid Part Time Amount	HCA_METRIC_PAID_PT_AMT
Daily Paid Part Time Hours	Daily Paid Part Time Hours	HCA_METRIC_PAID_PT_HRS
Daily Productive Agency Hours	Daily Productive Agency Hours	HCA_METRIC_PROD_AGNCY_HRS
Daily Productive Amount	Daily Productive Amount	HCA_METRIC_PROD_AMT
Daily Productive Float In Amount	Daily Productive Float In Amount	HCA_METRIC_PROD_FLT_IN_AMT
Daily Productive Float In Hours	Daily Productive Float In Hours	HCA_METRIC_PROD_FLT_IN_HRS
Daily Productive Float Out Amount	Daily Productive Float Out Amount	HCA_METRIC_PROD_FLT_OUT_AMT
Daily Productive Float Out Hours	Daily Productive Float Out Hours	HCA_METRIC_PROD_FLT_OUT_HRS
Daily Productive Full Time Amount	Daily Productive Full Time Amount	HCA_METRIC_PROD_FT_AMT
Daily Productive Full Time Hours	Daily Productive Full Time Hours	HCA_METRIC_PROD_FT_HRS
Daily Productive Hours	Daily Productive Hours	HCA_METRIC_PROD_HRS
Daily Productive Internal Agency Hours	Daily Productive Internal Agency Hours	HCA_METRIC_PROD_INT_AGNCY_HRS
Daily Productive Per Diem Amount	Daily Productive Per Diem Amount	HCA_METRIC_PROD_PDIEM_AMT
Daily Productive Per Diem Hours	Daily Productive Per Diem Hours	HCA_METRIC_PROD_PDIEM_HRS
Daily Productive Pool Amount	Daily Productive Pool Amount	HCA_METRIC_PROD_POOL_AMT
Daily Productive Pool Hours	Daily Productive Pool Hours	HCA_METRIC_PROD_POOL_HRS
Daily Productive Part Time Amount	Daily Productive Part Time Amount	HCA_METRIC_PROD_PT_AMT
Daily Productive Part Time Hours	Daily Productive Part Time Hours	HCA_METRIC_PROD_PT_HRS
Daily Fixed Paid Amount Target	Daily Fixed Paid Amount Target	HCA_TGT_HCAFIXED_METRIC_PAID_AMT
Daily Fixed Paid Hours Target	Daily Fixed Paid Hours Target	HCA_TGT_HCAFIXED_METRIC_PAID_HRS
Daily Fixed Productive Amount Target	Daily Fixed Productive Amount Target	HCA_TGT_HCAFIXED_METRIC_PROD_AMT
Daily Fixed Productive Hours Target	Daily Fixed Productive Hours Target	HCA_TGT_HCAFIXED_METRIC_PROD_HRS
Daily Variable Paid Amount Target	Daily Variable Paid Amount Target	HCA_TGT_HCAVARIABLE_METRIC_PAID_AMT
Daily Variable Paid Hours Target	Daily Variable Paid Hours Target	HCA_TGT_HCAVARIABLE_METRIC_PAID_HRS
Daily Variable Productive Amount Target	Daily Variable Productive Amount Target	HCA_TGT_HCAVARIABLE_METRIC_PROD_AMT
Daily Variable Productive Hours Target	Daily Variable Productive Hours Target	HCA_TGT_HCAVARIABLE_METRIC_PROD_HRS

Related entities

Volume Work Unit

Additional information

This entity also includes daily targets and full-time equivalent (FTE) metrics, but secondary dimensions cannot apply to these.

Supported views:

Work unit
Work unit time series

Core entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category	Activity	Work Unit	Work Group
		X					X

Relationship

One-to-One	One-to-Many
Work Unit Day

One-to-One

One-to-Many

Work Unit

Day