SGHE Banner Operational Data Store
Composite View Source: CALCULATION - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| ( TRUNC(SYSDATE) - NVL( CONT_LAST_REC.CONTACT_DATE,TRUNC( SYSDATE)) ); |
NA |
|
|
|
|
| (MAKFUNC.F_ORG_TOTAL_DONOR_COUNT / ORGANIZATION_DONOR_COUNT_GOAL * 100 |
NA |
|
|
|
|
| DECODE(FORCIRR_DATA_ORIGIN) |
NA |
|
|
|
|
| NVL(FTPREXPS.PCARD_ID, FTTVPAYM.PCARD_ID) |
NA |
COMPOSITE VIEW |
AE_EXPENSE_ITEM |
PURCHASE_CARD_ID |
|
| NVL(SFRSTCR_APPR_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_ATTS_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_CAMP_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_CAPC_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_CHRT_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_CLAS_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_COLL_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_CORQ_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_DEGC_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_DEPT_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_DUPL_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_LEVL_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_LINK_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_MAJR_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_MEXC_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_PREQ_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_PROG_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_REPT_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_RPTH_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_TEST_OVER,'N') |
NA |
|
|
|
|
| NVL(SFRSTCR_TIME_OVER,'N') |
NA |
|
|
|
|
| SIGN(SUM(NVL((SELECT 0 FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = EDW EXTRACT PARAMETERS AND MTVPARM_INTERNAL_CODE = MINORITY_IND AND MTVPARM_INTERNAL_CODE_2 = NON_MINORITY_RACE_CATEGORY AND MTVPARM_EXTERNAL_CODE = RACE_CATEGORY), 1))) |
NA |
|
|
|
|