AV_GIFT_RCG_AET

(SQL Table)
 Index Back

Transaction Register Gifts

Selects all gifts and their corresponding splits for designations and recognitions. 16Mar2000 - Change View SQL to pull Institution from Recognition Table instead of Gift Table for Perf. APRD=>R-SSEMEG-EF2M6. before 7/25/00: SELECT DISTINCT B.INSTITUTION, B.EMPLID, B.EXT_ORG_ID, A.SESSION_NO, A.GIFT_NO, A.SEQ_NO, B.RCG_PCT_AMT, B.CURRENCY_CD, A.GIFT_DT, A.GIFT_TYPE, A.ADJUSTMENT_FLG, B.RECOGNITION_TYPE, C.AV_SESS_TYPE, A.FISCAL_YEAR FROM PS_AV_GIFT_DTL A, PS_AV_RECOGNITION B, PS_AV_SESSION_TBL C WHERE A.INSTITUTION=B.INSTITUTION AND B.INSTITUTION=C.INSTITUTION AND A.SESSION_NO=B.SESSION_NO AND B.SESSION_NO=C.SESSION_NO AND A.GIFT_NO=B.GIFT_NO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
6 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
7 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
8 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
9 RCG_DES_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 GIFT_DT Date(10) DATE Gift Date
12 GIFT_TYPE Character(6) VARCHAR2(6) NOT NULL Gift Type
13 ADJUSTMENT_FLG Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
N=No
Y=Yes
14 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type
15 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
16 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year