HCM Extract - Extract Employee Contact Details when multiple contacts

Summary

HCM Extract - How to Extract Employee Contact Details when multiple contacts

Content

Hi

In one of the HCM Extracts we are extracting Employee Contacts.  The user entity which we are using is PER_EXT_CONTACT_RELATIONSHIPS_UE.

When the data is extracted for an employee and if that employee has multiple contacts, when we extract Contact Person Number using the Extract Contact Person Number DBI it is giving both  the person numbers in the same field result.

This is doing the same thing for phones, emails  as well.

Not sure if i should be using any conditions or filters something like primary contact. the contacts which we have converted so far they do not have a primary flag.