How do I pull an employee's Primary address in a data model?
Summary:
I need to pull the primary mailing address for our employees in a BI Publisher report, but I cannot figure out how to tell which address is primary for employees who have both a home and mailing address.
Content (please ensure you mask any confidential information):
I am using per_addresses and per_person_addr_usages_f to pull address information in my data model. For employees who have both HOME and MAIL addresses, I need to know which one has been marked as primary, and I cannot seem to find the field/table that has this information. Both the home and mailing addresses appear on the Person screen in Oracle, and then one of these addresses appears next to the "Primary Mailing" field. When I click "EDIT" on the Person screen for the "Primary Mailing" field, I have the option of selecting either the home or mailing address