Banner Operational Data Store
Composite View Source: EXPRESSION_0 - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| ACTIVE_EXCLUSION_COUNT_EXPRESSION |
|
|
|
|
DECODE ( ACTIVE_EXCL_IND , 1 , ( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( EXCLUSION_KEY * .001 ) , NULL ) |
| ACTIVE_MATCHING_CLAIM_COUNT_EXPRESSION |
|
|
|
|
CASE WHEN MATCHING_CLAIM_ACTIVE_IND = 1 THEN ( MATCHING_COMPANY_ENTITY_KEY * 100 ) + MATCHING_CLAIM_DETAIL_KEY + ( ENTITY_KEY * 0.001 ) END |
| ACTIVITY_COMMENT_EXPRESSION |
|
|
|
|
APRACTY_COMMENT |
| ACTIVITY_LEADERSHIP_COMMENT_EXPRESSION |
|
|
|
|
APRACLD_COMMENT |
| ALL_PROSPECT_ENTITY_COUNT_EXPRESSION |
|
|
|
|
|
| ALUM_ENTITY_COUNT_EXPRESSION |
|
|
|
|
ATVDONR_ALUM_IND |
| ASSIGNED_ENTITY_COUNT_EXPRESSION |
|
|
|
|
|
| CONTACTED_CONSTITUENT_COUNT_EXPRESSION |
|
|
|
|
( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY |
| CONTACTED_ENTITY_COUNT_EXPRESSION |
|
|
|
|
CONTACT_REPORT_IND |
| CONTACTED_PROSPECT_COUNT_EXPRESSION |
|
|
|
|
case when PROSPECT_KEY > 0 then ( ( PROSPECT_KEY * 100 ) + MULTI_SOURCE_KEY ) else NULL end |
| CONTACT_COUNT_EXPRESSION |
|
|
|
|
( CONTACT_REPORT_KEY * 100 ) + MULTI_SOURCE_KEY |
| CONTACT_CREDIT_COUNT_EXPRESSION |
|
|
|
|
( CONTACT_REPORT_KEY * 100 ) + MULTI_SOURCE_KEY + ( STAFF_KEY * .0001 ) |
| CONT_REP_CREDIT_GROUP_KEY_EXPRESSION |
|
|
|
|
MULTI_SOURCE_KEY + ( CONTACT_REPORT_KEY * 100 ) |
| CONT_REP_ENTITY_GROUP_KEY_EXPRESSION |
|
|
|
|
MULTI_SOURCE_KEY + ( ENTITY_KEY * 100 ) |
| CONT_REP_PROSPECT_GROUP_KEY_EXPRESSION |
|
|
|
|
case when PROSPECT_KEY > 0 then ( MULTI_SOURCE_KEY + ( PROSPECT_KEY * 100 ) ) else NULL end |
| DESIGNATION_COUNT_EXPRESSION |
|
|
|
|
to_number ( AGRMDES_GIFT_NO ) + ( DESIGNATION_DETAIL_KEY * .0001 ) |
| EMAIL_ADDRESS_STATUS_LD_EXPRESSION |
|
|
|
|
GOREMAL_STATUS_IND |
| EMAIL_ADDRESS_STATUS_SD_EXPRESSION |
|
|
|
|
GOREMAL_STATUS_IND |
| ENTITY_CONTACT_COUNT_EXPRESSION |
|
|
|
|
CASE WHEN ENTITY_KEY IS NULL THEN NULL ELSE ( ( CONTACT_REPORT_KEY * 100 ) + MULTI_SOURCE_KEY ) END |
| EXCLUSION_COUNT_EXPRESSION |
|
|
|
|
( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( EXCLUSION_KEY * .001 ) |
| EXCLUSION_RECORD_COUNT_EXPRESSION |
|
|
|
|
( ENTITY_KEY * 10000000000 ) + ( to_number ( TO_CHAR ( APREXCL_DATE , 'YYYYDDMM' ) ) * 100 ) + MULTI_SOURCE_KEY + ( EXCLUSION_KEY * .001 ) |
| INACTIVE_EXCLUSION_IND_EXPRESSION |
|
|
|
|
PENDING_EXCL_IND |
| INTEREST_ASK_CONTACT_IND_EXPRESSION |
|
|
|
|
AMRCONT_ASK_AMT |
| LAST_PROSP_INT_ASK_DATE_EXPRESSION |
|
|
|
|
|
| MAILING_HISTORY_GROUP_KEY_EXPRESSION |
|
|
|
|
( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY |
| MAIL_PRINT_DATE_EXPRESSION |
|
|
|
|
GURMAIL_DATE_PRINTED |
| MAIL_RECORD_COUNT_EXPRESSION |
|
|
|
|
( to_number ( NVL ( TO_CHAR ( GURMAIL_DATE_PRINTED , 'YYYYDDMM' ) , '20991231' ) ) * 10000000000 ) + ( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( MAILING_ATTRIBUTE_KEY * 0.01 ) |
| MATCHING_CLAIM_COUNT_EXPRESSION |
|
|
|
|
( MATCHING_COMPANY_ENTITY_KEY * 100 ) + MATCHING_CLAIM_DETAIL_KEY + ( ENTITY_KEY * 0.001 ) |
| MEMBERSHIP_INTEREST_GROUP_KEY_EXPRESSION |
|
|
|
|
|
| MEMBER_START_DATE_EXPRESSION |
|
|
|
|
AARMEMB_ENTRY_DATE |
| MEMBER_STOP_DATE_EXPRESSION |
|
|
|
|
AARMEMB_EXP_DATE |
| PHONE_COMMENT_EXPRESSION |
|
|
|
|
SPRTELE_COMMENT |
| PLEDGE_BATCH_NUMBER_EXPRESSION |
|
|
|
|
AGBPLDG_FEED_DOC_CODE |
| PRIMARY_PROSPECT_ENTITY_COUNT_EXPRESSION |
|
|
|
|
PRIMARY_PROSPECT_ENTITY_IND |
| PROPOSAL_ASK_CONTACT_IND_EXPRESSION |
|
|
|
|
AMRCONT_ASK_AMT |
| PROPOSAL_CONTACT_COUNT_EXPRESSION |
|
|
|
|
CASE WHEN ( PROPOSAL_KEY = 0 ) THEN NULL ELSE ( ( CONTACT_REPORT_KEY * 100 ) + MULTI_SOURCE_KEY ) END |
| PROPOSAL_PURPOSE_ASK_CONT_IND_EXPRESSION |
|
|
|
|
AMRCONT_ASK_AMT |
| PROSPECT_CONTACT_COUNT_EXPRESSION |
|
|
|
|
CASE WHEN AMRCONT_GEN_CONTACT_IND = 'N' THEN ( ( CONTACT_REPORT_KEY * 100 ) + MULTI_SOURCE_KEY ) ELSE NULL END |
| PROSPECT_ENTITY_COUNT_EXPRESSION |
|
|
|
|
|
| PROSPECT_INTEREST_END_DATE_EXPRESSION |
|
|
|
|
|
| PROSPECT_INTEREST_START_DATE_EXPRESSION |
|
|
|
|
|
| PROSPECT_INTEREST_STATUS_DATE_EXPRESSION |
|
|
|
|
|
| PROSPECT_INTEREST_TARGET_DATE_EXPRESSION |
|
|
|
|
|
| PROSPECT_VISIT_COUNT_EXPRESSION |
|
|
|
|
CASE WHEN AMRCONT_GEN_CONTACT_IND = 'N' THEN CASE WHEN CONTACT_ACTIVITY = '3' THEN ( ( CONTACT_REPORT_KEY * 100 ) + MULTI_SOURCE_KEY ) ELSE NULL END ELSE NULL END |
| RATED_PROSPECT_ENTITY_COUNT_EXPRESSION |
|
|
|
|
|
| SOLICITOR_IND_EXPRESSION |
|
|
|
|
AMRSTAF_SOLICIT_IND |
| SOLICITOR_IND_LD_EXPRESSION |
|
|
|
|
AMRSTAF_SOLICIT_IND |
| SOLICITOR_IND_SD_EXPRESSION |
|
|
|
|
AMRSTAF_SOLICIT_IND |
| VISIT_COUNT_EXPRESSION |
|
|
|
|
CASE WHEN CONTACT_ACTIVITY = '3' THEN ( ( CONTACT_REPORT_KEY * 100 ) + MULTI_SOURCE_KEY ) ELSE NULL END |
| VISIT_CREDIT_COUNT_EXPRESSION |
|
|
|
|
CASE WHEN CONTACT_CREDIT_ACTIVITY = 3 THEN ( CONTACT_REPORT_KEY * 100 ) + MULTI_SOURCE_KEY + ( STAFF_KEY * .0001 ) END |