AV_FNDTN_ORG_VW

(SQL View)
 Index Back

Foundation Organization

This view is used in the Giving Profile Org screen for the Foundation check box for the EXT_ORG_ID in context. It is a join between AV_CNST_TYP_TBL and AV_RELATE_E. Created on 09/16/99 by Jitendra Gupta.

SELECT DISTINCT A.EXT_ORG_ID , A.EXT_ORG_ID_RELATED FROM PS_AV_RELATE_E A , PS_AV_CNST_TYP_TBL B WHERE A.EXT_ORG_ID_RELATED = B.EXT_ORG_ID AND B.CNST_TYPE IN (11,12,13)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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