INSTITUTIONDefault Value: AV_OPR_DEF_TBL.INSTITUTION
Prompt Table: INSTITUTN_SCRTY
SESSION_NOPrompt Table: AV_SESSION_TBL
GIFT_NOPrompt Table: %EDITTABLE2
Prompt Table: AV_PEOPLE_SRCH
AV_GP_SPLIT_VW(SQL View) |
Index Back |
|---|---|
Gift Detail view-PersonContains all gift records for Persons that have split recognition with another constituent. |
| SELECT A.INSTITUTION , A.SESSION_NO , A.GIFT_NO , A.EMPLID FROM PS_AV_RECOGNITION A , PS_AV_RECOGNITION B , PS_AV_SESSION_TBL C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SESSION_NO=B.SESSION_NO AND A.GIFT_NO=B.GIFT_NO AND A.EXT_ORG_ID=' ' AND A.EMPLID<>B.EMPLID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.SESSION_NO = C.SESSION_NO AND C.SESS_STATUS = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTN_SCRTY |
| 2 | SESSION_NO |
Character(11) | VARCHAR2(11) NOT NULL |
Session Nbr
Prompt Table: AV_SESSION_TBL |
| 3 | GIFT_NO |
Character(11) | VARCHAR2(11) NOT NULL |
Gift Nbr
Prompt Table: %EDITTABLE2 |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: AV_PEOPLE_SRCH |