Payroll

The Payroll entity provides employee hours and amounts based on the payroll import, and paycode and paid job details for each employee and pay period.

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. Please see the Developer Portal for more information.

Data Granularity

Supported Dataview/RDO Type

Employee	Business Structure	Employee - Time Series	Business Structure - Time Series	Work Unit	Work Unit - Time Series

Columns


Raw Payroll Employment Status	Raw Payroll Employment Status	HCA_METRIC_RAW_PAYROLL_EMPLOYMENT_STATUS	String	No
Raw Payroll Amount	Raw Payroll Amount	HCA_METRIC_RAW_PAYROLL_PAID_AMOUNT	Number	No
Raw Payroll Hours	Raw Payroll Hours	HCA_METRIC_RAW_PAYROLL_PAID_HOURS	Number	No
Raw Payroll Paid Job	Raw Payroll Paid Job	HCA_METRIC_RAW_PAYROLL_PAID_JOB	String	No
Raw Payroll Paycode Name	Raw Payroll Paycode Name	HCA_METRIC_RAW_PAYROLL_PAYCODE_NAME	String	No

No related entities

Additional Info

For symbolic periods that are not based on pay periods, no data is returned
No roll-ups are supported. Data is exported at the lowest grain
Raw payroll data is rolled up by payroll Paycode, payroll employee status, employee, and payroll paid job

Core Entity

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

Relationship

Core Entity	Relationship
Work Unit	One to One
Day	One to One
Organizational Job	One to Many
Employee	One to Many