AV_DS_SMRY_G_VW

(SQL View)
Index Back

Designation Summary Gift View

Use AV_DS_SMRY_G_VW to select all constituents that have given gifts to a particular designation and their associated primary constituent type. ------------------------------------------------------------------------------------------------------------------ This is how the Select looked prior to the last change on 03/31/99-JM SELECT DISTINCT A.INSTITUTION, A.EMPLID, A.EXT_ORG_ID, A.DESIGNATION, A.GIFT_DT, A.RECOGNITION_TYPE, A.RCG_DES_AMT FROM PS_AV_RCG_DES A WHERE A.STATUS='A' AND (A.AV_SESS_TYPE='G' OR A.AV_SESS_TYPE='AG') ----------------------------------------------------------------------------------------------------------------- before 8.1.00 SELECT DISTINCT A.INSTITUTION, A.EMPLID, A.EXT_ORG_ID, A.DESIGNATION, A.GIFT_DT, A.RECOGNITION_TYPE, A.RCG_DES_AMT, A.CURRENCY_CD, A.CNST_TYPE FROM PS_AV_RCG_DES A WHERE A.STATUS='A' AND (A.AV_SESS_TYPE='G' OR A.AV_SESS_TYPE='AG')

SELECT A.INSTITUTION , A.AV_DES_BU , A.EMPLID , A.EXT_ORG_ID , A.DESIGNATION , A.GIFT_DT , A.RECOGNITION_TYPE , A.RCG_DES_AMT , A.CURRENCY_CD , A.CNST_TYPE FROM PS_AV_RCG_DES A , PS_AV_SESSION_TBL D WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.SESSION_NO = D.SESSION_NO AND A.STATUS='A' AND (A.AV_SESS_TYPE='G' OR A.AV_SESS_TYPE='AG' OR A.AV_SESS_TYPE='M' OR A.AV_SESS_TYPE='AM') AND D.SESS_STATUS = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 AV_DES_BU Character(5) VARCHAR2(5) NOT NULL Business Unit
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
5 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation
6 GIFT_DT Date(10) DATE Gift Date
7 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type
8 RCG_DES_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 CNST_TYPE Number(3,0) SMALLINT NOT NULL Constituent Type