AV_CP_DESIG_VW

(SQL View)
 Index Back

Designation Table

Contains all designation records for gifts and pledges.

SELECT INSTITUTION , GIFT_NO , DESIGNATION , DESIGNATION_PCT , DES_PCT_AMT , INTV_CD , MOTIVATION_CD , AV_DES_BU FROM PS_AV_CP_DESIG

  • Parent record: AV_GIFT_DTL

    • # 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 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr

    Prompt Table: AV_GIFT_DTL

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

    Prompt Table: AV_ACCOUNT_TBL

    4 DESIGNATION_PCT Number(8,4) DECIMAL(7,4) NOT NULL Designation Pct

    Default Value: 100

    5 DES_PCT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount

    Default Value: AV_GIFT_DTL.GIFT_AMT

    6 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
    7 MOTIVATION_CD Character(9) VARCHAR2(9) NOT NULL Appeal Code

    Prompt Table: AV_MTVTN_TBL

    8 AV_DES_BU Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT