Database Item PER_PERSON_ENTERPRISE_HIRE_DATE issue

Summary:

Database Item PER_PERSON_ENTERPRISE_HIRE_DATE is providing the minimum of date start from Period of service table.

Actual Result: The DBI provides date start of employee with assignment type as Pending Worker since that is the minimum of date start.

Expected Result: The Hire date for HIRE action code should be picked by the DBI for an employee with assignment type other than pending worker.

When this DBI is used in fast formulas there is a mismatch with the date start for employees.

Please mention if there is any alternate DBI which will provide the hire date for HIRE action code for an employee.