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
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
|---|---|---|---|---|---|
| X |
Relationship
| One-to-One | One-to-Many |
|---|---|
| X |