What's new in Customer Journeys?

Connect and learn more!
Tables with employee cost center, manager, assignment, and job title history — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Tables with employee cost center, manager, assignment, and job title history

Received Response
66
Views
3
Comments
edited Nov 27, 2023 7:06PM in Reporting and Analytics for HCM 3 comments

Summary:

We need to write a query to report on employee cost center, manager, assignment, and job title history. So far we're not finding the data we need in the tables we think we should use. We need guidance on what tables hold this data and how to join between them.

Content:

See below for the query we're using. It doesn't seem to have all user assignment history (is assignment even the right table to use??) and the effective start and end dates don't seem to be accurate.

Version:

23D HCM cloud

Code Snippet:

select person.PERSON_NAME_PEOFULL_NAME, ou.organization_unit_translation_peoname, assignment.effective_start_date, assignment.effective_end_date from assignment.assignment_no_de_pvo assignment_hist

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!