AV_CMTMT_DTL_VW

(SQL View)
 Index Back

Donor designation view

View of gift donor designations. Selects all individuals that have given to a particular designation and the corresponding amount.

SELECT DISTINCT A.INSTITUTION , C.EMPLID , C.EXT_ORG_ID , A.SESSION_NO , B.DESIGNATION , A.GIFT_NO , A.SEQ_NO , B.INTV_CD , %Round(%DecMult(A.GIFT_AMT,%DecMult(B.DESIGNATION_PCT,%DecDiv(C.RECOGNITION_PCT,10000))) ,2) , A.GIFT_DT , A.GIFT_TYPE , A.ADJUSTMENT_FLG , C.RECOGNITION_TYPE , D.AV_SESS_TYPE , A.FISCAL_YEAR FROM PS_AV_GIFT_DTL A , PS_AV_DESIGNATION B , PS_AV_RECOGNITION C , PS_AV_SESSION_TBL D 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 AND B.GIFT_NO=C.GIFT_NO AND A.INSTITUTION=D.INSTITUTION AND A.SESSION_NO=D.SESSION_NO

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