AV_MBR_DESIG

(SQL Table)
 Index Back

Designation Table

Contains all designation records for gifts and pledges.

  • Parent record: AV_MBR_DTL

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

    Prompt Table: AV_INST_BU_VW

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

    Prompt Table: AV_SESSION_TBL

    3 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number
    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_CMBR_VW

    6 DESIGNATION_PCT Number(8,4) DECIMAL(7,4) NOT NULL Designation Pct
    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 AV_LOAD_CHECK Number(16,2) DECIMAL(15,2) NOT NULL Minimum Amt
    13 AV_GIFT Character(1) VARCHAR2(1) NOT NULL Gift

    Y/N Table Edit

    14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: AV_SESSION_TBL.CURRENCY_CD

    15 DES_PCT_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
    16 CHARITAB_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Charitable Amount
    17 CURRENCY_CD_ENTRY Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: AV_SESSION_TBL.CURRENCY_CD_ENTRY

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

    Prompt Table: %EDITTABLE

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

    Default Value: AV_SESSION_TBL.INSTITUTION