| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 3 |
AV_SESS_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Session Type
AG=Gift Adjustment
AM=Adjust Membership
AP=Pledge Adjustment
G=Gift
M=Membership
PL=Pledge
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
|
| 6 |
GIFT_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Gift Amount
|
| 7 |
GIFT_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Gift Type
|
| 8 |
PLEDGE_GIFT_NO |
Character(11) |
VARCHAR2(11) NOT NULL |
Pledge Number
|
| 9 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 10 |
GIFT_DT |
Date(10) |
DATE |
Gift Date
|
| 11 |
TENDER_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Tender Type
|
| 12 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: AV_INSTALL_INST.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 13 |
CHECK_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Check Number
|
| 14 |
CREDIT_CARD_NO |
Character(20) |
VARCHAR2(20) NOT NULL |
Credit Card Number
|
| 15 |
CREDIT_CARD_HOLDER |
Character(30) |
VARCHAR2(30) NOT NULL |
Credit Card Holder
|
| 16 |
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
|
| 17 |
CREDIT_CARD_EXP_DT |
Date(10) |
DATE |
Expiration Date
|
| 18 |
TENDER_TYPE_NOTE |
Character(50) |
VARCHAR2(50) NOT NULL |
Tender Type Notes
|
| 19 |
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
|
| 20 |
PLDG_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 21 |
PLEDGE_DT |
Date(10) |
DATE |
First Payment Date
|
| 22 |
FULF_DT |
Date(10) |
DATE |
Fulfillment Date
|
| 23 |
PLEDGE_PMT_RCVD |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Payments Received
|
| 24 |
LAST_PMT_DT |
Date(10) |
DATE |
Last Payment Date
|
| 25 |
CP_PLEDGE_NO |
Character(11) |
VARCHAR2(11) NOT NULL |
Conditional Pledge Nbr
|
| 26 |
FEED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Feed Pledge
N=No
Y=Yes
|
| 27 |
FEED_GIFT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Feed Gift
N=No
Y=Yes
|
| 28 |
AV_PLDG_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Pledge Status
A=Active
C=Closed
W=Written Off
|
| 29 |
PLEDGE_PG_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Planned Giving Type
AT=Annuity Trust
BQ=Bequest
|
| 30 |
RCG_EMPLID1 |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID
|
| 31 |
RCG_EMPLID2 |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID
|
| 32 |
RCG_EMPLID3 |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID
|
| 33 |
RCG_EMPLID4 |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID
|
| 34 |
RCG_EXT_ORG_ID1 |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
|
| 35 |
RCG_EXT_ORG_ID2 |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
|
| 36 |
RCG_EXT_ORG_ID3 |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
|
| 37 |
RCG_EXT_ORG_ID4 |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
|
| 38 |
RECOGNITION_TYPE1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recognition Type
|
| 39 |
RECOGNITION_TYPE2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recognition Type
|
| 40 |
RECOGNITION_TYPE3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recognition Type
|
| 41 |
RECOGNITION_TYPE4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recognition Type
|
| 42 |
RCG_PCT_AMT1 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount
|
| 43 |
RCG_PCT_AMT2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount
|
| 44 |
RCG_PCT_AMT3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount
|
| 45 |
RCG_PCT_AMT4 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount
|
| 46 |
ANONYMOUS_FLG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Anonymous
|
| 47 |
ANONYMOUS_FLG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Anonymous
|
| 48 |
ANONYMOUS_FLG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Anonymous
|
| 49 |
ANONYMOUS_FLG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Anonymous
|
| 50 |
DESIGNATION1 |
Character(11) |
VARCHAR2(11) NOT NULL |
Designation Code
|
| 51 |
DESIGNATION2 |
Character(11) |
VARCHAR2(11) NOT NULL |
Designation Code
|
| 52 |
DESIGNATION3 |
Character(11) |
VARCHAR2(11) NOT NULL |
Designation Code
|
| 53 |
DESIGNATION4 |
Character(11) |
VARCHAR2(11) NOT NULL |
Designation Code
|
| 54 |
AV_DES_BU1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 55 |
AV_DES_BU2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 56 |
AV_DES_BU3 |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 57 |
AV_DES_BU4 |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 58 |
INTV_CD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Initiative Code
|
| 59 |
INTV_CD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Initiative Code
|
| 60 |
INTV_CD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Initiative Code
|
| 61 |
INTV_CD4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Initiative Code
|
| 62 |
DES_PCT_AMT1 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount
|
| 63 |
DES_PCT_AMT2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount
|
| 64 |
DES_PCT_AMT3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount
|
| 65 |
DES_PCT_AMT4 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount
|
| 66 |
MOTIVATION_CD1 |
Character(9) |
VARCHAR2(9) NOT NULL |
Appeal Code
|
| 67 |
MOTIVATION_CD2 |
Character(9) |
VARCHAR2(9) NOT NULL |
Appeal Code
|
| 68 |
MOTIVATION_CD3 |
Character(9) |
VARCHAR2(9) NOT NULL |
Appeal Code
|
| 69 |
MOTIVATION_CD4 |
Character(9) |
VARCHAR2(9) NOT NULL |
Appeal Code
|
| 70 |
CHARITABLE_AMT1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Charitable Amount
|
| 71 |
CHARITABLE_AMT2 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Charitable Amount
|
| 72 |
CHARITABLE_AMT3 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Charitable Amount
|
| 73 |
CHARITABLE_AMT4 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Charitable Amount
|
| 74 |
COMPLETE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Complete Flag
N=
Y=
Y/N Table Edit
Default Value: N
|
| 75 |
GP_LOAD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Gift/Pledge Mass load record status.
P=Processed
S=Suspense
|
| 76 |
SESSION_NO |
Character(11) |
VARCHAR2(11) NOT NULL |
Session Nbr
|
| 77 |
GIFT_NO |
Character(11) |
VARCHAR2(11) NOT NULL |
Gift Nbr
|
| 78 |
CR_CARD_EXPMO |
Character(2) |
VARCHAR2(2) NOT NULL |
Card Expiration Month
01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
10=10
11=11
12=12
|
| 79 |
CR_CARD_EXPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Expiration Year
|
| 80 |
CR_CARD_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Card Type
|
| 81 |
AV_CR_CARD_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
*Credit Card Number
|
| 82 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|