AV_DESIGNATION

(SQL Table)
 Index Back

Designation Table

Contains all designation records for gifts and pledges.

  • Parent record: AV_GIFT_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: AV_SESSION_TBL.BUSINESS_UNIT

    Prompt Table: AV_BUS_UNIT_TBL

    2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr

    Prompt Table: AV_SESSION_TBL

    3 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr

    Prompt Table: AV_GIFT_DTL

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

    Prompt Table: AV_ACCT_VW

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

    Prompt Table: AV_INTV_CMP_VW

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

    Default Value: 100

    7 DES_PCT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
    8 MOTIVATION_CD Character(9) VARCHAR2(9) NOT NULL Appeal Code

    Prompt Table: AV_MTVTN_VW1

    9 DES_APPLIED Number(16,2) DECIMAL(15,2) NOT NULL Designation Applied
    10 CHARITABLE_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Charitable Amount
    11 AV_INST_TYPE Character(6) VARCHAR2(6) NOT NULL Designation Type
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: AV_SESSION_TBL.CURRENCY_CD

    13 CURRENCY_CD_ENTRY Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: AV_SESSION_TBL.CURRENCY_CD_ENTRY

    14 DES_PCT_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
    15 CHARITAB_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Charitable Amount
    16 AV_DES_BU Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: %EDITTABLE

    17 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: AV_SESSION_TBL.INSTITUTION