AV_ACK_GIFT_AMT

(SQL Table)
Index Back

Acknowledgement Gift Amounts

This table defines the acknowledgements for a gift range.

# 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 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
3 ACKNLDG_TYPE Character(1) VARCHAR2(1) NOT NULL Acknowledgement Type
G=Gift
P=Pledge

Default Value: G

4 RCPT_FLG Character(1) VARCHAR2(1) NOT NULL Receipt

Y/N Table Edit

Default Value: N

5 EVENT_3CS_ID Character(10) VARCHAR2(10) NOT NULL 3Cs event ID

Prompt Table: EVNT_3CS_TBL

6 AV_FROM_AMT Number(16,2) DECIMAL(15,2) NOT NULL From Amount
7 AV_TO_AMT Number(16,2) DECIMAL(15,2) NOT NULL To Amount
8 PURPOSE_CD Character(3) VARCHAR2(3) NOT NULL Role

Prompt Table: AV_PRPS_VW