PS_AV_RELATE_PE Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

PS_AV_RELATE_PE Table

Explanation
This table stores person to external org relationships. If one side of the relationship is not an entitly in the database, the Id field can be blank.

Common Uses

Finding a board members of a particular company.

Finding board memberships for a person.

EMPLID
PE_RELATE_NBR

      

EMPLID
EXT_ORG_ID
PE_RELATE_NBR
PE_RELATION
SSN

WHSE_CONSTITUENTS

• Either the EMPLID or EXT_ORG_ID fields can be blank.

PS_AV_RELATE_PE Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home