AV_ACK_DTL_VW

(SQL View)
Index Back

Acknowledgement Detail

Acknowledgement Detail

SELECT INSTITUTION ,SESSION_NO ,GIFT_NO ,EMPLID ,EXT_ORG_ID ,RECOGNITION_TYPE ,DESIGNATION ,AV_ACKNLDG_NO ,SA_ID_TYPE ,AV_DATE ,TENDER_TYPE ,GIFT_TYPE ,AV_AMOUNT ,CHARITABLE_AMT ,CURRENCY_CD ,ACKNLDG_STATUS ,ACKNLDG_TYPE ,ACKNLDG_REASON ,ACKNLDG_CTGY ,OPRID ,TRIBUTE_FLG ,LTR_TYPE ,EVENT_3CS_ID ,COMMENTS FROM PS_AV_ACKNLDG_DTL

# 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 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
3 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
6 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type
7 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation
8 AV_ACKNLDG_NO Number(4,0) SMALLINT NOT NULL Acknowledgement Number
9 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
10 AV_DATE Date(10) DATE Date
11 TENDER_TYPE Character(6) VARCHAR2(6) NOT NULL Tender Type

Prompt Table: AV_TNDR_TYPE_VW

12 GIFT_TYPE Character(6) VARCHAR2(6) NOT NULL Gift Type
13 AV_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
14 CHARITABLE_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Charitable Amount
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 ACKNLDG_STATUS Character(2) VARCHAR2(2) NOT NULL Acknowledgement Status
C=Complete
IP=In Process
Q=Queued
S=Suspense
17 ACKNLDG_TYPE Character(1) VARCHAR2(1) NOT NULL Acknowledgement Type
G=Gift
P=Pledge
18 ACKNLDG_REASON Character(4) VARCHAR2(4) NOT NULL Suspense Reason
ADJG=Adjusted Gift
ADJP=Adjusted Pledge
ANON=Anonymous Gift
DEC=Deceased
DES=Designation
GAMT=Gift Amount
HGTR=Gift In Honor of
HPTR=Pledge In Honor of
MGTR=Gift In Memory of
MPTR=Pledge In Memory of
NONE=No Acknowledgement Criteria
RCPT=Receipt
SRVC=Service Indicator
19 ACKNLDG_CTGY Character(4) VARCHAR2(4) NOT NULL Acknowledgement Category
ANON=Anonymous
DEC=Deceased
DES=Designation
GA=Gift Amount
HONR=In Honor
MEM=In Memory
SI=Service Indicator
SUS=Suspense
20 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
21 TRIBUTE_FLG Character(1) VARCHAR2(1) NOT NULL In Honor/In Memory

Y/N Table Edit

22 LTR_TYPE Character(1) VARCHAR2(1) NOT NULL Letter Type
C=Custom
N=None
S=Standard
23 EVENT_3CS_ID Character(10) VARCHAR2(10) NOT NULL 3Cs event ID

Prompt Table: EVNT_3CS_TBL

24 COMMENTS Long Character CLOB Comment