Tables with employee cost center, manager, assignment, and job title history
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.
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.
23D HCM cloud
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