AV_WEB_MTVA_VW

(SQL View)
 Index Back

All Web Appeals View

All Involvement appeals regardless of type. Needed for prompt on AV_WEB_CMP_MTVN.MOTIVATION_CD field.

SELECT INSTITUTION , EFFDT , MOTIVATION_CD , AV_ALT_DESCR FROM PS_AV_WEB_MTVTN WHERE AV_SS_GIFT = 'Y' OR AV_SS_PLEDGE = 'Y'

  • Parent record: AV_WEB_INSTALL

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

    Default Value: AV_WEB_INSTALL.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 EFFDT_WRK Date(10) DATE Effective Date
    3 MOTIVATION_CD Character(9) VARCHAR2(9) NOT NULL Appeal Code

    Prompt Table: AV_MTVTN_TBL

    4 AV_ALT_DESCR Character(80) VARCHAR2(80) NOT NULL Description

    Default Value: AV_MTVTN_TBL.DESCR