AV_WEBP_ACCT_VW

(SQL View)
 Index Back

Web designation view type pldg

Involvement designations with a type of pledge.

SELECT INSTITUTION , EFFDT , SEQNO , AV_DES_BU , DESIGNATION , AV_ALT_DESCR FROM PS_AV_WEB_ACCT WHERE 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 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    4 AV_DES_BU Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: AV_WEB_INSTALL.BUSINESS_UNIT

    Prompt Table: AV_INST_BU_VW

    5 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation

    Prompt Table: AV_ACCT_VW

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

    Default Value: AV_ACCOUNT_TBL.AV_DES_NAME