INSTITUTIONEMPLIDGIFT_NOO=Organization
P=Person
AV_PGIFT_365_VW(SQL View) |
Index Back |
|---|---|
Gift Recog in last 365 daysSelects the gifts that a person has been recognized for. |
| SELECT DISTINCT A.INSTITUTION , B.EMPLID , A.GIFT_NO , A.SESSION_NO , B.SA_ID_TYPE , A.GIFT_AMT , A.GIFT_DT , A.DATA_ENTRY_DT , A.PLEDGE_GIFT_NO FROM PS_AV_GIFT_DTL A , PS_AV_RECOGNITION B , PS_AV_SESSION_TBL C WHERE A.INSTITUTION = B.INSTITUTION AND A.SESSION_NO = B.SESSION_NO AND A.GIFT_NO = B.GIFT_NO AND C.INSTITUTION = A.INSTITUTION AND C.SESSION_NO = A.SESSION_NO AND C.SESS_STATUS = 'P' AND A.ADJUSTMENT_FLG = 'N' AND A.GIFT_DT >= %DateAdd(%CurrentDateIn,-365) AND B.EMPLID <> ' ' |
| # | 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 | GIFT_NO |
Character(11) | VARCHAR2(11) NOT NULL | Gift Nbr |
| 4 | SESSION_NO | Character(11) | VARCHAR2(11) NOT NULL | Session Nbr |
| 5 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 6 | GIFT_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Gift Amount |
| 7 | GIFT_DT | Date(10) | DATE | Gift Date |
| 8 | DATA_ENTRY_DT | Date(10) | DATE | Data Entry Date |
| 9 | PLEDGE_GIFT_NO | Character(11) | VARCHAR2(11) NOT NULL | Pledge Number |