Employee HCM - Base Compensation

The Base Compensation entity provides the employee's current base compensation information in the primary EIN, such as salary and salary increase %. It returns the latest data for an employee and is not dependent on the time period selected in Dataview or report.

Data Granularity

Provides one row per employee per selected time period.

Supported Dataview/RDO Type

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

Columns
% Increase BASE_COMPENSATION_PERCENT_INCREASE Number No
Date From BASE_COMPENSATION_DATE_FROM Date No
Date To BASE_COMPENSATION_DATE_TO Date No
Hourly Pay BASE_COMPENSATION_HOURLY_PAY Number No
Hours Per Pay Period BASE_COMPENSATION_HOURS_PER_PP Number No
Hours Per Year BASE_COMPENSATION_HOURS_PER_YEAR Number No
Is Current BASE_COMPENSATION_IS_CURRENT Boolean No
Monthly Pay BASE_COMPENSATION_MONTHLY_PAY Number No
Notes (200 chars) BASE_COMPENSATION_NOTES_200_CHARS String No
Pay Period in Year BASE_COMPENSATION_NUM_PP_IN_A_YEAR Number No
Pay Period Pay BASE_COMPENSATION_PAY_PERIOD_PAY Number No
Payroll Data Option BASE_COMPENSATION_PAYROLL_DATA_OPTION String No
Reason Code BASE_COMPENSATION_REASON_CODE String No
Salary BASE_COMPENSATION_SALARY Number No
Weekly Pay BASE_COMPENSATION_WEEKLY_PAY Number No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many