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

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