BUSINESS_UNITGIFT_NOAV_PLDG_ADJ_VW(SQL View) |
Index Back |
|---|---|
Pledge Adjustment Check VWView which returns only pledges which have pledge payments totaling $0.00 and have all pledge payments already posted. This used to determine whether or not you may edit designations and or recognitions for a given pledge when adjusting it. 7.27.00 SELECT A.INSTITUTION, A.GIFT_NO, A.GIFT_AMT, A.PLDG_EFFDT, A.PLEDGE_PMT_RCVD, A.LAST_PMT_DT FROM PS_AV_PLEDGE_DTL A WHERE A.PLEDGE_PMT_RCVD = 0 AND A.GIFT_NO NOT IN (SELECT B.PLEDGE_GIFT_NO FROM PS_AV_GIFT_DTL B, PS_AV_SESSION_TBL C WHERE B.SESSION_NO = C.SESSION_NO AND A.INSTITUTION = B.INSTITUTION AND B.INSTITUTION = C.INSTITUTION AND C.SESS_STATUS <> 'P') |
| SELECT A.BUSINESS_UNIT, A.GIFT_NO, A.GIFT_AMT, A.PLDG_EFFDT, A.PLEDGE_PMT_RCVD, A.LAST_PMT_DT FROM PS_AV_PLEDGE_DTL A WHERE A.PLEDGE_PMT_RCVD = 0 AND A.GIFT_NO NOT IN (SELECT B.PLEDGE_GIFT_NO FROM PS_AV_GIFT_DTL B, PS_AV_SESSION_TBL C WHERE B.SESSION_NO = C.SESSION_NO AND B.BUSINESS_UNIT= C.BUSINESS_UNIT AND A.BUSINESS_UNIT= B.BUSINESS_UNIT AND C.SESS_STATUS <> 'P') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | GIFT_NO |
Character(11) | VARCHAR2(11) NOT NULL | Gift Nbr |
| 3 | GIFT_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Gift Amount |
| 4 | PLDG_EFFDT | Date(10) | DATE | Effective Date |
| 5 | PLEDGE_PMT_RCVD | Number(16,2) | DECIMAL(15,2) NOT NULL | Payments Received |
| 6 | LAST_PMT_DT | Date(10) | DATE | Last Payment Date |