AV_ACCT_INTV_VW

(SQL View)
Index Back

Initiative Camp/MBR View

This is a view of Initiatives that are of Type = Campaign or Membership. To be used as a prompt table/search record.

SELECT DISTINCT A.INSTITUTION , B.EMPLID , B.ext_org_id , A.INTV_CD , A.DESCR60 , A.DESCR60_SRCH , A.START_DT , A.END_DT FROM PS_AV_INTV_TBL A ,PS_AV_RCG_DES B WHERE A.INSTITUTION =B.INSTITUTION AND A.INTV_CD = B.INTV_CD AND INTV_TYPE = 'CAMPAIGN'

  • Related Language Record: AV_INTVCMPVWLNG
  • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    4 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    6 DESCR60_SRCH Character(60) VARCHAR2(60) NOT NULL Formal Description
    7 START_DT Date(10) DATE Start Date
    8 END_DT Date(10) DATE end date