AV_ADJ_GIFTD_VW(SQL View) |
Index Back |
|---|---|
Adjusted Gift Details ViewContains all negation records for adjusted gifts ----------------------------------------------------------------------------------------------------------------- Code change 26 July 2000 (for SetId/Business Unit functionality) - old code follows: SELECT INSTITUTION, SESSION_NO, GIFT_NO, SEQ_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, ADJ_REASON_CD, CAE_GIFT_TYPE, CHARITABLE_AMT, MBR_PMT_NO, ADJ_AMT, CURRENCY_CD1, REFUND_FLG, DESCRLONG FROM PS_AV_ADJ_GIFT_DTL ----------------------------------------------------------------------------------------------------------------- |
| SELECT BUSINESS_UNIT , SESSION_NO , GIFT_NO , SEQ_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 , ADJ_REASON_CD , CAE_GIFT_TYPE , CHARITABLE_AMT , MBR_PMT_NO , ADJ_AMT , CURRENCY_CD1 , REFUND_FLG , INSTITUTION , FEED_GIFT_FLG , DESCRLONG FROM PS_AV_ADJ_GIFT_DTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 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 | SEQ_NO |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: AV_PEOPLE_SRCH |
| 6 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: AV_EXT_ORG_SRCH |
| 7 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 8 | GIFT_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Gift Amount |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 10 | GIFT_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Gift Type
Prompt Table: AV_GFT_TYPE_TBL |
| 11 | PLEDGE_GIFT_NO | Character(11) | VARCHAR2(11) NOT NULL |
Pledge Number
Prompt Table: AV_PLEDGES_P_VW |
| 12 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 13 | GIFT_DT | Date(10) | DATE | Gift Date |
| 14 | DATA_ENTRY_DT | Date(10) | DATE | Data Entry Date |
| 15 | TENDER_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Tender Type
Prompt Table: AV_TENDER_TBL |
| 16 | CHECK_NO | Character(10) | VARCHAR2(10) NOT NULL | Check Number |
| 17 | CREDIT_CARD_NO | Character(20) | VARCHAR2(20) NOT NULL | Credit Card Number |
| 18 | CREDIT_CARD_HOLDER | Character(30) | VARCHAR2(30) NOT NULL | Credit Card Holder |
| 19 | 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 |
| 20 | CREDIT_CARD_EXP_DT | Date(10) | DATE | Expiration Date |
| 21 | TENDER_TYPE_NOTE | Character(50) | VARCHAR2(50) NOT NULL | Tender Type Notes |
| 22 | ADJ_REASON_CD | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 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 | ADJ_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | Adjusted Amt |
| 27 | CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 28 | REFUND_FLG | Character(1) | VARCHAR2(1) NOT NULL | Refund |
| 29 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 30 | FEED_GIFT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Feed Gift
N=No Y=Yes |
| 31 | DESCRLONG | Long Character | CLOB | Long Description |