AV_E_RELATE_VW

(SQL View)
 Index Back

Org/Org Relationship

Relate Display view providing the first relationship between two organizations.

SELECT A.EXT_ORG_ID, A.EXT_ORG_ID_RELATED, A.ORG_RELATION FROM PS_AV_RELATE_E A WHERE A.ORG_RELATE_NBR IN ( SELECT MIN(A1.ORG_RELATE_NBR ) FROM PS_AV_RELATE_E A1 WHERE A1.EXT_ORG_ID=A.EXT_ORG_ID AND A1.EXT_ORG_ID_RELATED= A.EXT_ORG_ID_RELATED)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AV_EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
2 EXT_ORG_ID_RELATED Character(11) VARCHAR2(11) NOT NULL Related ID
3 ORG_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
BR=Branch
CF=Corporate Foundation
PC=Parent Company
SS=Subsidiary