AV_GIFT_DTL_VW

(SQL View)
 Index Back

Gift Detail View

An exact view of the AV_GIFT_DTL table with no peoplecode ----------------------------------------------------------------------------------------------------------------- Code change 27 July 2000 (for SetId/Business Unit functionality) - old code follows: SELECT INSTITUTION, SESSION_NO, GIFT_NO, EMPLID, EXT_ORG_ID, SA_ID_TYPE, GIFT_AMT, CURRENCY_CD, GIFT_TYPE, PLEDGE_GIFT_NO, FISCAL_YEAR, GIFT_DT, DATA_ENTRY_DT, TENDER_TYPE, CHECK_NO, CREDIT_CARD_NO, CREDIT_CARD_HOLDER, CREDIT_CARD_TYPE, CREDIT_CARD_EXP_DT, TENDER_TYPE_NOTE, SEQ_NO, ADJUSTMENT_FLG, CAE_GIFT_TYPE, CHARITABLE_AMT, MBR_PMT_NO, ACKN_FLG, GIFT_AMT_ENTRY, CURRENCY_CD_ENTRY, CHARITAB_AMT_ENTRY, RATE_MULT, RATE_DIV, DESCRLONG FROM PS_AV_GIFT_DTL -----------------------------------------------------------------------------------------------------------------

SELECT BUSINESS_UNIT , SESSION_NO , GIFT_NO , EMPLID , EXT_ORG_ID , SA_ID_TYPE , GIFT_AMT , CURRENCY_CD , GIFT_TYPE , PLEDGE_GIFT_NO , FISCAL_YEAR , GIFT_DT , DATA_ENTRY_DT , TENDER_TYPE , CHECK_NO , CREDIT_CARD_NO , CREDIT_CARD_HOLDER , CREDIT_CARD_TYPE , CREDIT_CARD_EXP_DT , TENDER_TYPE_NOTE , SEQ_NO , ADJUSTMENT_FLG , CAE_GIFT_TYPE , CHARITABLE_AMT , MBR_PMT_NO , ACKN_FLG , GIFT_AMT_ENTRY , CURRENCY_CD_ENTRY , CHARITAB_AMT_ENTRY , RATE_MULT , RATE_DIV , INSTITUTION , FEED_GIFT_FLG , DESCRLONG FROM PS_AV_GIFT_DTL

  • Related Language Record: AV_GIFTDTLVWLNG

  • Parent record: AV_SESSION_TBL

    • # 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
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

    5 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: AV_EXT_ORG_SRCH

    6 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person

    Default Value: P

    7 GIFT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Gift Amount
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    9 GIFT_TYPE Character(6) VARCHAR2(6) NOT NULL Gift Type

    Default Value: GIFT

    Prompt Table: AV_GFT_TYPE_TBL

    10 PLEDGE_GIFT_NO Character(11) VARCHAR2(11) NOT NULL Pledge Number

    Prompt Table: AV_PLEDGES_P_VW

    11 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    12 GIFT_DT Date(10) DATE Gift Date

    Default Value: %date

    13 DATA_ENTRY_DT Date(10) DATE Data Entry Date

    Default Value: %date

    14 TENDER_TYPE Character(6) VARCHAR2(6) NOT NULL Tender Type

    Prompt Table: AV_TENDER_TBL

    15 CHECK_NO Character(10) VARCHAR2(10) NOT NULL Check Number
    16 CREDIT_CARD_NO Character(20) VARCHAR2(20) NOT NULL Credit Card Number
    17 CREDIT_CARD_HOLDER Character(30) VARCHAR2(30) NOT NULL Credit Card Holder
    18 CREDIT_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Card Type
    AE=American Express
    DC=Diners' Club
    DI=Diners Club
    MC=MasterCard
    VI=VISA
    19 CREDIT_CARD_EXP_DT Date(10) DATE Expiration Date
    20 TENDER_TYPE_NOTE Character(50) VARCHAR2(50) NOT NULL Tender Type Notes
    21 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    22 ADJUSTMENT_FLG Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    N=No
    Y=Yes
    23 CAE_GIFT_TYPE Character(1) VARCHAR2(1) NOT NULL CAE Type
    D=Deferred Gift
    E=Deferred Estate Gift
    G=Gift
    K=Gift In Kind
    N=Non-Gift
    24 CHARITABLE_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Charitable Amount
    25 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number
    26 ACKN_FLG Character(1) VARCHAR2(1) NOT NULL Acknowledgement Flg

    Y/N Table Edit

    Default Value: N

    27 GIFT_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Gift Amount
    28 CURRENCY_CD_ENTRY Character(3) VARCHAR2(3) NOT NULL Currency Code
    29 CHARITAB_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Charitable Amount
    30 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    31 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    32 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    33 FEED_GIFT_FLG Character(1) VARCHAR2(1) NOT NULL Feed Gift
    N=No
    Y=Yes
    34 DESCRLONG Long Character CLOB Long Description