Fetch Enterprise seniority date in HCM extracts for Seniority Dates v3 setup

Summary:

Recently, we have moved to Seniority Dates v3 setup from the earlier v1 setup.

The seniority dates are now stored in table PER_SENIORITY_DATES table in multiple lines based on our requirement to calculate seniority dates at multiple levels(Enterprise Hire date-Person Level, Legal Employer Hire date-Assg level,Grade-Assg level, Position-Assg level etc..).

Now, while we try to use seniority dates DBIs in our HCM extracts to fetch Enterprise seniority dates, the system is passing NULL values.

We tried with multiple DBIs but none of them are working. Please share if you have any existing code in HCM extracts that is correctly fetching enterprise date where you are already on Seniority dates v3 setup. This is of high importance while calculating gratuity in our downstream applications.