Employee History Hourly Wage Rate
Data Granularity
Provides one row per employee per hourly wage rate history record.
Supported Dataview/RDO Type
| Employee | Business Structure | Employee - Time Series | Business Structure - Time Series | Work Unit | Work Unit - Time Series |
|---|---|---|---|---|---|
Columns
| Hourly Wage Rate | Employee's base wage | PEOPLE_HOURLY_WAGE_RATE | Number | No |
| Hourly Wage Rate (History) | The value of the hourly wage rate assigned to the employee currently or previously based on the selected date range. | EMP_HIST_HOURLY_WAGE_RATE_VALUE | Number | No |
| Hourly Wage Rate Effective Date (History) | EMP_HIST_HOURLY_WAGE_RATE_EFFECTIVE_DATE | Date | No | |
| Hourly Wage Rate Expiration Date (History) | EMP_HIST_HOURLY_WAGE_RATE_EXPIRATION_DATE | Date | No |
Related Entities
Core Entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category | Activity | Work Unit | Work Group | Procedure Code |
|---|---|---|---|---|---|---|---|---|---|
Relationship
| One-to-One | One-to-Many |
|---|---|