Banner Operational Data Store
Composite View Source: EXPRESSION - NULL
Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
(CAMPAIGN_SOLICITOR_GOAL / CAMPAIGN_GOAL * 100) |
TBD |
|
|
|
|
CAMPAIGN_ACTIVE_IND_EXPRESSION |
NA |
|
|
|
|
CAMPAIGN_ACTIVE_IND_LD_EXPRESSION |
NA |
|
|
|
|
CAMPAIGN_ACTIVE_IND_SD_EXPRESSION |
NA |
|
|
|
|
CAMP_INCLUDE_IN_GIVING_IND_EXPRESSION |
NA |
|
|
|
|
CAMP_INCLUDE_IN_GIVING_IND_LD_EXPRESSION |
NA |
|
|
|
|
CAMP_INCLUDE_IN_GIVING_IND_SD_EXPRESSION |
NA |
|
|
|
|
CAPITAL_CAMPAIGN_IND_EXPRESSION |
NA |
|
|
|
|
CAPITAL_CAMPAIGN_IND_LD_EXPRESSION |
NA |
|
|
|
|
CAPITAL_CAMPAIGN_IND_SD_EXPRESSION |
NA |
|
|
|
|
CASE WHEN (CAMPAIGN_GOAL > 0 |
TBD |
|
|
|
|
CREDIT_CARD_PAYMENT_IND_EXPRESSION |
NA |
|
|
|
|
CREDIT_CARD_PAYMENT_IND_LD_EXPRESSION |
NA |
|
|
|
|
CREDIT_CARD_PAYMENT_IND_SD_EXPRESSION |
NA |
|
|
|
|
DECODE (APRIGRP_DISP_WEB_IND, 'Y', 'Y', 'N') |
NA |
|
|
|
|
GIFT_ACKNOWLEDGED_IND_EXPRESSION |
NA |
|
|
|
|
GIFT_ACKNOWLEDGED_IND_LD_EXPRESSION |
NA |
|
|
|
|
GIFT_ACKNOWLEDGED_IND_SD_EXPRESSION |
NA |
|
|
|
|
GIFT_ADJUSTED_IND_EXPRESSION |
NA |
|
|
|
|
GIFT_ADJUSTED_IND_LD_EXPRESSION |
NA |
|
|
|
|
GIFT_ADJUSTED_IND_SD_EXPRESSION |
NA |
|
|
|
|
GIFT_ANONYMOUS_IND_EXPRESSION |
NA |
|
|
|
|
GIFT_ANONYMOUS_IND_LD_EXPRESSION |
NA |
|
|
|
|
GIFT_ANONYMOUS_IND_SD_EXPRESSION |
NA |
|
|
|
|
GIFT_CAE_TYPE_LD_EXPRESSION |
NA |
|
|
|
|
GIFT_CAE_TYPE_SD_EXPRESSION |
NA |
|
|
|
|
MATCH_CLAIM_EXISTS_IND_EXPRESSION |
NA |
|
|
|
|
MATCH_CLAIM_EXISTS_IND_LD_EXPRESSION |
NA |
|
|
|
|
MATCH_CLAIM_EXISTS_IND_SD_EXPRESSION |
NA |
|
|
|
|
MATCH_GIFT_EXISTS_IND_EXPRESSION |
NA |
|
|
|
|
MATCH_GIFT_EXISTS_IND_LD_EXPRESSION |
NA |
|
|
|
|
MATCH_GIFT_EXISTS_IND_SD_EXPRESSION |
NA |
|
|
|
|
NVL(CASE WHEN(CAMPAIGN_SOLICITOR_GOAL > 0 |
TBD |
|
|
|
|
PLDG_INCLUDE_IN_GIVING_IND_EXPRESSION |
NA |
|
|
|
|
PLDG_INCLUDE_IN_GIVING_IND_LD_EXPRESSION |
NA |
|
|
|
|
PLDG_INCLUDE_IN_GIVING_IND_SD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_ACTIVE_IND_EXPRESSION |
NA |
|
|
|
|
PLEDGE_ACTIVE_IND_LD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_ACTIVE_IND_SD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_ADJUSTED_IND_EXPRESSION |
NA |
|
|
|
|
PLEDGE_ADJUSTED_IND_LD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_ADJUSTED_IND_SD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_ANONYMOUS_IND_EXPRESSION |
NA |
|
|
|
|
PLEDGE_ANONYMOUS_IND_LD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_ANONYMOUS_IND_SD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_CAE_TYPE_LD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_CAE_TYPE_SD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_CONDITIONAL_IND_EXPRESSION |
NA |
|
|
|
|
PLEDGE_CONDITIONAL_IND_LD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_CONDITIONAL_IND_SD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_PAID_STATUS_EXPRESSION |
NA |
|
|
|
|
PLEDGE_PAID_STATUS_LD_EXPRESSION |
NA |
|
|
|
|
PLEDGE_PAID_STATUS_SD_EXPRESSION |
NA |
|
|
|
|
RECEIPT_REQUIRED_IND_EXPRESSION |
NA |
|
|
|
|
RECEIPT_REQUIRED_IND_LD_EXPRESSION |
NA |
|
|
|
|
RECEIPT_REQUIRED_IND_SD_EXPRESSION |
NA |
|
|
|
|