AV_RLTN_E_VW

(SQL View)
 Index Back

Relationship Flag View

Use AV_RLTN_VW to determine if any relationships exist for the constitutent

SELECT A.EXT_ORG_ID , 'Y' FROM PS_EXT_ORG_TBL A WHERE EXISTS ( SELECT A1.EXT_ORG_ID FROM PS_AV_RELATE_E A1 WHERE A1.EXT_ORG_ID = A.EXT_ORG_ID) OR EXISTS ( SELECT A2.EXT_ORG_ID FROM PS_AV_RELATE_PE A2 WHERE A2.EXT_ORG_ID = A.EXT_ORG_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
2 RELATIONSHIPS_FLG Character(1) VARCHAR2(1) NOT NULL Relationships

Y/N Table Edit