AV_INTV_OTH_SRC

(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 , DESCR60_SRCH , 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: AVINTVOTHSRCLNG

    • # 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 DESCR60_SRCH Character(60) VARCHAR2(60) NOT NULL Initiative Name
    6 START_DT Date(10) DATE Start Date
    7 END_DT Date(10) DATE end date