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

PS_AV_RELATE_E Table

Explanation
This table lists org to org relationships. Elements include the id and name of the related org, type of relationship, and the reciprocal relationship type. If the related organization does not have an ID in the system, address information may be in this table.

Common Uses

Finding sudsidiaries of a parent company.

EXT_ORG_ID
ORG_RELATE_NBR


      

EXT_ORG_ID
EXT_ORG_ID_RELATED
ORG_RELATE_NBR
ORG_RELATE_NBR_RCP
ORG_RELATE_RCP
ORG_RELATION

WHSE_CONSTITUENTS

• A related organization does not have to be an entity in the database.

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