SPS_TAS_BETC_VW(SQL View) |
Index Back |
|---|
| SELECT SPS_TAS , SUM(CASE WHEN ADJUSTMENT = 'N' THEN 1 ELSE 0 END) , SUM(CASE WHEN ADJUSTMENT = 'Y' THEN 1 ELSE 0 END) , CASE WHEN SUM(CASE WHEN ADJUSTMENT = 'N' THEN 1 ELSE 0 END) = 1 THEN MAX(CASE WHEN ADJUSTMENT = 'N' THEN BETC_CD ELSE ' ' END) ELSE ' ' END , CASE WHEN SUM(CASE WHEN ADJUSTMENT = 'Y' THEN 1 ELSE 0 END) = 1 THEN MAX(CASE WHEN ADJUSTMENT = 'Y' THEN BETC_CD ELSE ' ' END) ELSE ' ' END FROM PS_SPS_GWABETC_VW WHERE PYMNT_OR_CLLCTN = 'P' AND ACTIVE_INACTIVE = 'A' GROUP BY SPS_TAS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SPS_TAS | Character(27) | VARCHAR2(27) NOT NULL | Sender Treasury Account Symbol |
| 2 | PMT_COUNT | Number(6,0) | INTEGER NOT NULL | Number of Payments |
| 3 | ADJ_COUNT | Number(3,0) | SMALLINT NOT NULL | Adjustment Counter |
| 4 | BETC_CD | Character(8) | VARCHAR2(8) NOT NULL | Business Event Type Code |
| 5 | SPS_BETC | Character(8) | VARCHAR2(8) NOT NULL | Sender Business Event Type |