SGHE Banner Operational Data Store
Composite View Source: AGVPLG1
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| AGVPLG1_CAMPAIGN |
TBD |
|
|
|
|
| AGVPLG1_DESIGNATION |
TBD |
|
|
|
|
| AGVPLG1_ENTITY_UID |
TBD |
|
|
|
|
| AGVPLG1_PLEDGE_AMOUNT |
TBD |
|
|
|
|
| AGVPLG1_PLEDGE_AMOUNT - AGVPLG1_PLEDGE_AMOUNT_PAID |
TBD |
|
|
|
|
| AGVPLG1_PLEDGE_AMOUNT_PAID |
TBD |
|
|
|
|
| AGVPLG1_PLEDGE_CREDIT |
TBD |
|
|
|
|
| AGVPLG1_PLEDGE_NUMBER |
TBD |
|
|
|
|
| DECODE ( NVL (AGVPLG1_PLEDGE_AMOUNT, 0) - NVL (AGVPLG1_PLEDGE_AMOUNT_PAID, 0), 0, 'Y', 'N') |
TBD |
|
|
|
|
| DECODE (NVL (AGVPLG1_PLEDGE_AMOUNT_PAID, 0), 0, 'N', NVL (AGVPLG1_PLEDGE_AMOUNT, 0), 'N', 'Y' ) |
TBD |
|
|
|
|