AVINTVCMBRVWLNG

(SQL View)
 Index Back

Rel LangInitiative Camp/MBR VW

AVINTVCMBRVWLNG is the language record related to AV_INTV_CMBR_VW. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT B.INSTITUTION , B.INTV_TYPE , B.INTV_CD , A.LANGUAGE_CD , A.DESCR60 , A.DESCR60_SRCH FROM PS_AV_INTV_TBLLNG A , PS_AV_INTV_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.INTV_CD = B.INTV_CD AND (B.INTV_TYPE = 'CAMPAIGN' OR B.INTV_TYPE = 'MEMBERSHIP')

  • Related Language Record for AV_INTV_CMBR_VW

    • # 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: INSTITUTION_TBL

    2 INTV_TYPE Character(10) VARCHAR2(10) NOT NULL Initiative Type

    Prompt Table: AV_INTV_TYP_VW2

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

    Prompt Table: AV_INTV2_VW

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    6 DESCR60_SRCH Character(60) VARCHAR2(60) NOT NULL Formal Description