Create Primary Mailing Address Column

User_RD03L

Hello,

We're trying to create BIP Report that that extracts all employees address. One of the requirement is to create
Primary Mailing column, output values should be (Y/N) to check if employees address is primary or not.

Our SQL uses PER_ALL_PEOPLE_F, PER_ADDRESSES_F and PER_PERSON_ADDR_USAGES_F but we haven't figured out yet on how
to create this condition in the Primary Mailing column.

Any help would be appreciated, thank you!

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24006/create-primary-mailing-address-column

Please check the query on below link:

How do I pull an employee's Primary address in a data model? — Cloud Customer Connect

Thanks.

bmanikan

the mailining address ID on Per All People if present is your primary email address. The address usage has the person id to link to per all people f and the address and address usage can be linked using address id.

User_RD03L

Hello guys,

Thanks for your help!