AV_DES_VW

(SQL View)
 Index Back

Designation View

Exact view of the AV_DESIGNATION table. ----------------------------------------------------------------------------------------------------------------- Code change 26 July 2000 (for SetId/Business Unit functionality) - old code follows: SELECT INSTITUTION, SESSION_NO, GIFT_NO, DESIGNATION, INTV_CD, DESIGNATION_PCT, DES_PCT_AMT, MOTIVATION_CD, DES_APPLIED, CHARITABLE_AMT, AV_INST_TYPE FROM PS_AV_DESIGNATION -----------------------------------------------------------------------------------------------------------------

SELECT BUSINESS_UNIT, SESSION_NO, GIFT_NO, DESIGNATION, INTV_CD, DESIGNATION_PCT, DES_PCT_AMT, MOTIVATION_CD, DES_APPLIED, CHARITABLE_AMT, AV_INST_TYPE, CURRENCY_CD, CURRENCY_CD_ENTRY, AV_DES_BU, INSTITUTION FROM PS_AV_DESIGNATION

  • 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

    Prompt Table: AV_INST_BU_VW

    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_ACCOUNT_TBL

    5 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
    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_TBL

    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
    13 CURRENCY_CD_ENTRY Character(3) VARCHAR2(3) NOT NULL Currency Code
    14 AV_DES_BU Character(5) VARCHAR2(5) NOT NULL Business Unit
    15 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: AV_SESSION_TBL.INSTITUTION