AV_RLTD2_OTH_VW

(SQL View)
 Index Back

Other Related Initiative Vw

This table will determine if there have been any Related Initiatives of Type <> 'VOLUNTEER' OR 'CAMPAIGN' OR 'EVENT' OR 'MEMBERSHIP' defined for the given Initiative. It will return a 'Y' if records exist.

SELECT INSTITUTION , INTV_CD , 'Y' FROM PS_AV_INTV_RELATED WHERE INTV_TYPE_RELATED <> 'CAMPAIGN' AND INTV_TYPE_RELATED <> 'EVENT' AND INTV_TYPE_RELATED <> 'VOLUNTEER' AND INTV_TYPE_RELATED <> 'MEMBERSHIP'

  • Parent record: AV_INTV_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
    3 RELATED_OTHER Character(1) VARCHAR2(1) NOT NULL Related OTH Intv

    Y/N Table Edit