| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION
Prompt Table:
INSTITUTN_SCRTY
|
| 2 |
INTV_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Initiative Code
|
| 3 |
CAMPAIGN_LENGTH |
Character(16) |
VARCHAR2(16) NOT NULL |
Length of Cmpgn Period
|
| 4 |
CAMPAIGN_SCOPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Campaign Scope
C=Comprehensive
M=Mulitiple Units
S=Single Unit
Default Value: S
|
| 5 |
CMPGN_ADVANCE_GIFT |
Character(2) |
VARCHAR2(2) NOT NULL |
Advance-Gifts Phase in Totals
AG=All Gifts Rcvd by Institution
FO=Featured Objectives Only
Default Value: FO
|
| 6 |
CMPGN_PYMT_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Maximum Pledge Payment Period
1=1 Year
2=2 Years
3=3 Years
4=4 Years
5=5 Years
O=Other (Please Explain)
Default Value: 3
|
| 7 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 8 |
CAMPAIGN_BEQUESTS |
Character(2) |
VARCHAR2(2) NOT NULL |
Bequests
BE=Include Bequests by Exception
IB=Include Bequests
Default Value: BE
|
| 9 |
CMPGN_LIFE_INSURNC |
Character(2) |
VARCHAR2(2) NOT NULL |
Life Insurance
CV=Cash Surrender Value Only
DB=Realized Death Benefit Only
FV=Face Value/Present Value
NI=Do Not Include Life Insurance
Default Value: NI
|