SGHE Banner Operational Data Store
Reporting View Source: GIFT_EXPRESSIONS - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| OUTRIGHT_GIFT_AMOUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN (PLEDGE_PAYMENT_IND = 0 AND MATCHING_GIFT_IND = 0) THEN HARD_CREDIT_AMOUNT ELSE 0 END |
| OUTRIGHT_GIFT_SOFT_CREDIT_AMT_EXPRESSION |
TBD |
|
|
|
CASE WHEN (PLEDGE_PAYMENT_IND = 0 AND MATCHING_GIFT_IND = 0) THEN SOFT_CREDIT_AMOUNT ELSE 0 END |
| PLEDGE_PAYMENT_AMOUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN PLEDGE_PAYMENT_IND = 1 THEN HARD_CREDIT_AMOUNT ELSE 0 END |
| PLEDGE_PAYMENT_SOFT_CREDIT_AMT_EXPRESSIO N |
TBD |
|
|
|
CASE WHEN PLEDGE_PAYMENT_IND = 1 THEN SOFT_CREDIT_AMOUNT ELSE 0 END |
| TOTAL_COMMITTED_AMOUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN PLEDGE_PAYMENT_IND = 0 THEN HARD_CREDIT_AMOUNT ELSE 0 END |