INSTITUTIONEXT_ORG_IDAV_MTCH_OE_VW(SQL View) |
Index Back |
|---|---|
Organization Expected MatchOrganization Expected Match |
| SELECT A.INSTITUTION , B.EXT_ORG_ID , SUM(B.EXPT_MTCH_AMT) FROM PS_AV_GIFT_DTL A , PS_AV_MTCH_GIFT 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 A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.SESSION_NO = C.SESSION_NO AND A.ADJUSTMENT_FLG = 'N' AND B.ACTL_MTCH_AMT = 0 AND B.MTCH_DENIED_DT IS NULL AND C.SESS_STATUS = 'P' GROUP BY A.INSTITUTION, B.EXT_ORG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 3 | EXPT_MTCH_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | Expected Match Amount |