Picking up the person's phone number in the HCM Extract

Summary

We need to pick the person's phone number based on certain logic

Content

Hi All,

We are building a custom HCM Extract. There are 2 fields on the record, phone number1 and phone number2. We need to populate the fields based on the following logic:

Phone Number1:
- Step 1: Use the Phone Rank DFF (Phone DFF) to rank phone numbers, from 1 to 2.
- Step 2: If there are multiple phones with the same rank, prioritize them in this order:
Personal Mobile
Personal Phone
Personal Phone (Other)
Work Mobile
Work Phone
Work Pager
Work Phone (Other)
- Step 3: If there are less than 2 phone numbers with a rank (or no phone with a rank), populate the phone numbers on the interface based on the same order as in rule 2 above