AV_RLTD_OTHR_VW

(SQL View)
Index Back

Related Initiative Other

Related Initiative Other

SELECT INSTITUTION, INTV_CD, INTV_CD_RELATED, INTV_TYPE_RELATED FROM PS_AV_INTV_RELATED WHERE INTV_TYPE_RELATED <> 'CAMPAIGN' AND INTV_TYPE_RELATED <> 'EVENT' AND INTV_TYPE_RELATED <> 'PROJECT'

  • 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 INTV_CD_RELATED Character(10) VARCHAR2(10) NOT NULL Related Initiative Code

    Prompt Table: AV_INTV_OTHR_VW

    4 INTV_TYPE_RELATED Character(10) VARCHAR2(10) NOT NULL Related Initiative Type