AV_RCG_DES_4_VW (SQL View)	Index Back
Min Gift Date This is a view of AV_RCG_DES that returns the Minimum Gift Date for the specified keys. It is used to determine if a donor is new or not.

AV_RCG_DES_4_VW

(SQL View)

Min Gift Date

This is a view of AV_RCG_DES that returns the Minimum Gift Date for the specified keys. It is used to determine if a donor is new or not.

SELECT INSTITUTION, EMPLID, EXT_ORG_ID, INTV_CD, MIN(GIFT_DT) FROM PS_AV_RCG_DES WHERE STATUS = 'A' AND RECOGNITION_TYPE = 'H' GROUP BY INSTITUTION, EMPLID, EXT_ORG_ID, INTV_CD

# 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 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

5 GIFT_DT Date(10) DATE Gift Date

#	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	INTV_CD	Character(10)	VARCHAR2(10) NOT NULL	Initiative Code
5	GIFT_DT	Date(10)	DATE	Gift Date