| # |
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
Default Value: NEW
|
| 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
Default Value: P
|
| 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
Default Value: GIFT
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
Default Value: %date
|
| 14 |
DATA_ENTRY_DT |
Date(10) |
DATE |
Data Entry Date
Default Value: %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 |
GIFT_AMT_ENTRY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Gift Amount
|
| 30 |
CURRENCY_CD_ENTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 31 |
CHARITAB_AMT_ENTRY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Charitable Amount
|
| 32 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 33 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 34 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 35 |
FEED_GIFT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Feed Gift
N=No
Y=Yes
|
| 36 |
AV_TNDR_GIFT_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
Gift Description used for Gift in Kind and Security Tender Types
|
| 37 |
AV_TNDR_GIFT_PURP |
Character(254) |
VARCHAR2(254) NOT NULL |
Gift Purpose used for Gift in Kind Tender Type
|
| 38 |
AV_EST_VAL |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Estimated Value
|
| 39 |
AV_APPRAISAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Written Appraisal used for Gift in Kind Tender Type
|
| 40 |
AV_APPRAISE_VAL |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Appraised Value used in Gift in Kind Tender type
|
| 41 |
AV_APPRAISAL_DATE |
Date(10) |
DATE |
Appraisal Date used in Gift i n Kind Tender Type
|
| 42 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|