SGHE Banner Operational Data Store
Reporting View Source: AMOUNT_CALCULATIONS - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| CAMPAIGN_TRANSACTION_AMOUNT_EXPRESSION |
TBD |
|
|
|
PIDM_PLDG_CAMP_AMT |
| HARD_CREDIT_AMOUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN (SOURCE_TABLE = 'AGRPDES') THEN (PLEDGE_AMT - NVL(AGRPMLT_CREDIT_AGG,0)) WHEN (SOURCE_TABLE = 'AGRPMLT') THEN NVL(PLEDGE_AMT, 0) WHEN (SOURCE_TABLE = 'AGRPMMO') THEN 0 END |
| OVERALL_PLEDGE_BALANCE_EXPRESSION |
TBD |
|
|
|
CASE WHEN ( PIDM_PLDG_AMT - PIDM_PLDG_AMT_PAID < 0) THEN 0 ELSE (PIDM_PLDG_AMT - PIDM_PLDG_AMT_PAID) END |
| OVERALL_TRANSACTION_AMOUNT_EXPRESSION |
TBD |
|
|
|
PIDM_PLDG_AMT |
| PLEDGE_AMOUNT_PAID_EXPRESSION |
TBD |
|
|
|
CASE WHEN (SOURCE_TABLE = 'AGRPDES') THEN ( (nvl(((PLEDGE_AMT - nvl(AGRPMLT_CREDIT_AGG,0))/ AGRPDES_AMT) ,0)* AGRPDES_AMT_PAID)) WHEN (SOURCE_TABLE = 'AGRPMMO') THEN 0 WHEN (SOURCE_TABLE = 'AGRPMLT') THEN (CASE WHEN (PLEDGE_AMT > 0) THEN (nvl(( PLEDGE_AMT / AGRPDES_AMT ),0) * AGRPDES_AMT_PAID) ELSE 0 END) END |
| SOFT_CREDIT_AMOUNT_EXPRESSION |
TBD |
|
|
|
CASE WHEN (SOURCE_TABLE = 'AGRPMMO') THEN NVL(PLEDGE_AMT,0) ELSE 0 END |