Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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
Tagged:
2