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.
Supported Dataview types
|
Employee Dataview |
Business Structure Dataview |
|---|---|
|
X |
Data granularity
Provides one row per employee per selected time period.
Columns
|
Label |
Key |
|---|---|
|
% Increase |
BASE_COMPENSATION_PERCENT_INCREASE |
|
Date From |
BASE_COMPENSATION_DATE_FROM |
|
Date To |
BASE_COMPENSATION_DATE_TO |
|
Hourly Pay |
BASE_COMPENSATION_HOURLY_PAY |
|
Hours Per Pay Period |
BASE_COMPENSATION_HOURS_PER_PP |
|
Hours Per Year |
BASE_COMPENSATION_HOURS_PER_YEAR |
|
Is Current |
BASE_COMPENSATION_IS_CURRENT |
|
Monthly Pay |
BASE_COMPENSATION_MONTHLY_PAY |
|
Notes (200 chars) |
BASE_COMPENSATION_NOTES_200_CHARS |
|
Pay Period in Year |
BASE_COMPENSATION_NUM_PP_IN_A_YEAR |
|
Pay Period Pay |
BASE_COMPENSATION_PAY_PERIOD_PAY |
|
Payroll Data Option |
BASE_COMPENSATION_PAYROLL_DATA_OPTION |
|
Reason Code |
BASE_COMPENSATION_REASON_CODE |
|
Salary |
BASE_COMPENSATION_SALARY |
|
Weekly Pay |
BASE_COMPENSATION_WEEKLY_PAY |
Related entities
- Absence Exceptions
- Accrual Code
- Accrual Daily Balances
- Accrual Reporting Period Balances
- Accrual Transactions
- Actual Paycode Totals Corrections Only
- Actual Paycode Totals Exclude Corrections
- Actual Paycode Totals Include Corrections
- Actual Totals Corrections Only
- Actual Totals Exclude Corrections
- Actual Totals Include Corrections
- Analytics
- Approval Summary
- Approval Transactions
- Attendance Actions Summary
- Attendance Summary
- Attendance Transactions
- Audit
- Audit Attendance
- Audit Leave
- Audit Timekeeping
- Average Worked Hours
- Exception Counter
- Exceptions
- Group Edit Results
- Leave Case
- Leave Case Document
- Leave Case Note
- Leave Case Notification
- Leave Edit
- Leave Profile
- Leave Taking
- License Assignment
- Pay Period
- Paycode Edit
- Paycode Edit Comments
- Projected Paycode Totals Corrections Only
- Projected Paycode Totals Exclude Corrections
- Projected Paycode Totals Include Corrections
- Projected Totals Corrections Only
- Projected Totals Exclude Corrections
- Projected Totals Include Corrections
- Schedule Availability
- Schedule Day Lock
- Schedule Event Shift
- Schedule Events
- Schedule Events Pay Code Edit
- Schedule Group Assignment
- Schedule Group Totals
- Schedule Segment Availability
- Schedule Tag
- Schedule Tag Segment
- Scheduled Paycode Edit
- Scheduled Paycode Totals
- Scheduled Shift
- Scheduled Shift Segment
- Scheduled Totals
- Shift Segment Tag
- Sign Off
- Target Hours
- Timecard Transactions
- Totalization Status
- Worked Shift
- Worked Span
- Worked Span In Punch
- Worked Span Out Punch
Additional information
Core entity
|
Employee |
Organization |
Day |
Organizational Job |
Paycode |
Labor Category |
|---|---|---|---|---|---|
|
X |
Relationship
|
One-to-One |
One-to-Many |
|---|---|
|
X |