Banner Operational Data Store
Reporting View Source: EXPRESSION - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| (CAMPAIGN_SOLICITOR_GOAL / CAMPAIGN_GOAL * 100) |
TBD |
REPORTING VIEW |
CAMPAIGN_FUNDRAISER |
SOLICITOR_PCT_OF_CAMPAIGN_GOAL |
|
| 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 |
REPORTING VIEW |
CAMPAIGN_FUNDRAISER |
PCT_SOLC_PROGRESS_CAMP_GOAL |
|
| 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 |
REPORTING VIEW |
INTEREST |
DISPLAY_WEB_IND |
|
| 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 |
REPORTING VIEW |
CAMPAIGN_FUNDRAISER |
PCT_PROGRESS_SOLICITOR_GOAL |
|
| 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 |
|
|
|
|