Primary Job Assignment History
The Primary Job Assignment History entity provides a historical record of the primary jobs that have been assigned to an employee. Using its data columns you can create a Dataview or report that shows each primary job that is assigned to an employee during a selected time period. The Primary Job Assignment History entity and associated data columns are not related to transactional data columns and support only an audit of an employee's assigned primary jobs.
Data Granularity
Provides one row per employee per assigned primary job.
Supported Dataview/RDO Type
Employee | Business Structure | Employee - Time Series | Business Structure - Time Series | Work Unit | Work Unit - Time Series |
---|---|---|---|---|---|
Columns
Primary Job — Full Path (History) | Full path of the primary job assigned to the employee currently or previously based on the selected date range | EMP_HIST_PRIMARY_JOB_PATH | String | No |
Home Labor Category | Full path of the home labor category assigned to the employee currently or previously based on the selected date range | EMP_HIST_HOME_LABOR_CATEGORY | String | No |
Primary Job Effective Date (History) | Effective date of the primary job assigned to the employee currently or previously based on the selected date range | EMP_HIST_PRIMARY_JOB_EFFECTIVE_DATE | Date | No |
Primary Job Expiration Date (History) | Expiration date of the primary job assigned to the employee currently or previously based on the selected date range | EMP_HIST_PRIMARY_JOB_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 |
---|---|