INSTITUTIONDefault Value: AV_OPR_DEF_TBL.INSTITUTION
Prompt Table: INSTITUTN_SCRTY
SESSION_NOPrompt Table: AV_SESSION_TBL
GIFT_NOPrompt Table: %EDITTABLE2
Prompt Table: AV_EXT_ORG_SRCH
AV_GP_SPLITE_VW(SQL View) |
Index Back |
|---|---|
Gift Detail view-OrgContains all gift records for Organizations that have split recognition with another constituent. |
| SELECT A.INSTITUTION ,A.SESSION_NO ,A.GIFT_NO ,A.EXT_ORG_ID 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.EMPLID=' ' AND A.EXT_ORG_ID<>B.EXT_ORG_ID 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 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: AV_EXT_ORG_SRCH |