How to Identify the Seniority Date Version in Oracle HCM

Requirement:

Identify the Seniority Date Version and related codes used in your Oracle HCM environment.

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.