SGHE Banner Operational Data Store
Composite View Source: DEPENDANT_EXPRESSIONS - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| GIFT_DESIGNATION_COUNT_EXPRESSION |
TBD |
|
|
|
GIFT_DETAIL_KEY + ( DESIGNATION_KEY * .0001) |
| HARD_CREDIT_DONOR_COUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN ( HARD_CREDIT > 0) THEN WAREHOUSE_ENTITY_UID ELSE NULL END |
| PLEDGE_BALANCE_EXPRESSION |
TBD |
|
|
|
CASE WHEN ((HARD_CREDIT_AMOUNT - PLEDGE_AMOUNT_PAID) > 0) THEN (HARD_CREDIT_AMOUNT - PLEDGE_AMOUNT_PAID) ELSE 0 END |
| PLEDGE_DESIGNATION_COUNT_EXPRESSION |
TBD |
|
|
|
PLEDGE_DETAIL_KEY + (DESIGNATION_KEY * .0001) |
| SOFT_CREDIT_DONOR_COUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN ( SOFT_CREDIT > 0) THEN WAREHOUSE_ENTITY_UID ELSE NULL END |