| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTN_SCRTY
|
| 2 |
PLDG_OVRPAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute Overpayment
E=Equally
I=Ignore
N=Next Payment
Default Value: N
|
| 3 |
PLDG_UNDPAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute Underpayment
E=Equally
N=Next Payment
Default Value: N
|
| 4 |
SOFT_CRDT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Soft Credit
Y/N Table Edit
Default Value: N
|
| 5 |
MTCH_GIFT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Matching Gift
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 6 |
AV_ADJ_GIFT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Acknowledge Adjusted Gifts
Y/N Table Edit
Default Value: N
|
| 7 |
AV_ADJ_PLDG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Acknowledge Adjusted Pledge
Y/N Table Edit
Default Value: N
|
| 8 |
AV_SRVC_IND_PRTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Indicator Priority
|
| 9 |
AV_GIFT_PRTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Gift Priority
|
| 10 |
AV_HNR_PRTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Honor Priority
|
| 11 |
AV_MEM_PRTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Memory Priority
|
| 12 |
AV_DEC_PRTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Deceased Priority
|
| 13 |
MAX_RTRV |
Number(4,0) |
SMALLINT NOT NULL |
Maximum Retrieval
Default Value: 250
|
| 14 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: AV_OPR_DEF_TBL.SETID
Prompt Table:
SP_SETID_NONVW
|
| 15 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
CAL_DEFN_TBL
|
| 16 |
TENDER_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Tender Type
Prompt Table:
AV_TENDER_TBL
|
| 17 |
ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
Prompt Table:
AV_ITEM_TYPE_VW
|
| 18 |
AV_ALLOW_GIFTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Gifts in Membership
Y/N Table Edit
Default Value: N
|
| 19 |
AV_MBR_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Membership Days
Default Value: 60
|
| 20 |
EVENT_3CS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
3Cs event ID
Prompt Table:
EVNT_3CS_TBL
|
| 21 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 22 |
AV_MBR_ORG_COD |
Character(10) |
VARCHAR2(10) NOT NULL |
Member Organization Code
Prompt Table:
AV_MBR_ORG_VW
|
| 23 |
REMINDER_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Indicates the number of days prior to the next due date that the action should appear on the assigned Person's To Do List.
|
| 24 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 25 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Default Value: INSTALLATION.EXCHNG_TO_RT_TYPE
Prompt Table:
RT_TYPE_TBL
|
| 26 |
AV_ATCH_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Attachment Type
Prompt Table:
AV_ATCH_TYPE
|
| 27 |
GIFT_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Gift Days
Default Value: 60
|
| 28 |
PLEDGE_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Pledge Days
Default Value: 60
|