Need start date DBI to fetch Hire Date from the person type as 'Employee'

Summary:

The DBI PER_PERSON_ENTERPRISE_HIRE_DATE is picking min (ppos.start_date) which is the pending work type in our case, however we would like to have the start date picked from the person type as 'Employee'.

Do we have any such DBI which will help in getting the correct Start Date of Person Type 'Employee'

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):