Recent hires (last 90 days)
New joiner list with start date, manager and position — useful when onboarding access controls.
Tables used
per_periods_of_service per_all_people_f per_person_names_f per_all_assignments_m hr_all_organization_units
Bind parameters
None — the statement runs as written; edit the literals in the WHERE clause to narrow it.
How to run it
Paste it into a BI Publisher data model as a SQL data set, or into QueryWell's Query Studio and run it against your pod with a reporting account. Results come back to a grid you can profile, chart and export with a SHA-256 hash. HCM data-source.
SELECT ppl.person_number, nm.full_name, pos.date_start AS hire_date, org.name AS department
FROM per_periods_of_service pos
JOIN per_all_people_f ppl ON ppl.person_id = pos.person_id AND TRUNC(SYSDATE) BETWEEN ppl.effective_start_date AND ppl.effective_end_date
JOIN per_person_names_f nm ON nm.person_id = pos.person_id AND nm.name_type = 'GLOBAL' AND TRUNC(SYSDATE) BETWEEN nm.effective_start_date AND nm.effective_end_date
LEFT JOIN per_all_assignments_m ass ON ass.period_of_service_id = pos.period_of_service_id AND ass.assignment_type = 'E' AND TRUNC(SYSDATE) BETWEEN ass.effective_start_date AND ass.effective_end_date
LEFT JOIN hr_all_organization_units org ON org.organization_id = ass.organization_id
WHERE pos.date_start >= TRUNC(SYSDATE) - 90
ORDER BY pos.date_start DESCA single read-only SELECT against Oracle Fusion Cloud's supported reporting surface. Column names and views can differ by release and by the roles your reporting account holds, so validate the result against a report you already trust before relying on it.
hcmhiresonboarding
More Human Capital queries
Run it without the template cycle
QueryWell runs this and 81 other curated scripts against your own Fusion pod from one signed desktop app — grid, charts, profiling and hashed exports included. Perpetual licence, 14-day trial.