You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How do I pull an employee's Primary address in a data model?

Accepted answer


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!