AV_INTV_OTHR_VW

(SQL View)
 Index Back

Initiative Other View

This is a view of Initiatives that are something OTHER than Type = Campaign, Volunteer, Membership, or Event. To be used as a prompt table/search record.

SELECT INSTITUTION, INTV_CD, INTV_TYPE, DESCR60, START_DT, END_DT FROM PS_AV_INTV_TBL WHERE INTV_TYPE <> 'CAMPAIGN' AND INTV_TYPE <> 'EVENT' AND INTV_TYPE <> 'VOLUNTEER' AND INTV_TYPE <> 'MEMBERSHIP'

  • Related Language Record: AVINTVOTHRVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: AV_OPR_DEF_TBL.INSTITUTION

    Prompt Table: INSTITUTN_SCRTY

    2 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

    Prompt Table: AV_INTV_OTHR_VW

    3 INTV_TYPE Character(10) VARCHAR2(10) NOT NULL Initiative Type
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 START_DT Date(10) DATE Start Date
    6 END_DT Date(10) DATE end date