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 |
|
|
|
|
|
| HARD_CREDIT_AMOUNT_EXPRESSION |
|
|
|
|
AGRPMLT_CREDIT_AGG |
| OVERALL_PLEDGE_BALANCE_EXPRESSION |
|
|
|
|
|
| OVERALL_TRANSACTION_AMOUNT_EXPRESSION |
|
|
|
|
|
| PLEDGE_AMOUNT_PAID_EXPRESSION |
|
|
|
|
CASE WHEN ( SOURCE_TABLE = 'AGRPDES' ) THEN ( CASE WHEN ( PLEDGE_AMT > 0 ) THEN ( nvl ( ( ( PLEDGE_AMT - nvl ( AGRPMLT_CREDIT_AGG , 0 ) ) / AGRPDES_AMT ) , 0 ) * AGRPDES_AMT_PAID ) ELSE 0 END ) 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 |
|
|
|
|
|
| TRANSACTION_COUNT_EXPRESSION |
|
|
|
|
|