SQL Query to Identify the Seniority Date Version in Oracle HCM

The SQL query below helps you identify the Seniority Date setup versions active in your Oracle HCM environment. It lists the seniority date code, its meaning (description), and the configured version used in service date calculations.

SELECT 
    SeniorityDateSetUp.seniority_date_code, 
    HcmLookup.meaning, 
    SeniorityDateSetUp.seniority_version 
FROM 
    fusion.per_seniority_dates_setup SeniorityDateSetUp,
    fusion.hcm_lookups HcmLookup 
WHERE 
    HcmLookup.lookup_code = SeniorityDateSetUp.seniority_date_code 
    AND SeniorityDateSetUp.active_flag = 'Y'

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.