Banner Operational Data Store
Composite View Source: EXPRESSION_1 - NULL
Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
ACTIVE_PROGRAM_PROSPECT_COUNT_EXPRESSION |
|
|
|
|
|
ACTIVE_PROPOSAL_COUNT_EXPRESSION |
|
|
|
|
|
ACTIVE_PROSPECT_COUNT_EXPRESSION |
|
|
|
|
|
ADDRESS_COUNT_EXPRESSION |
|
|
|
|
( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( ADDRESS_TYPE_KEY * .001 ) + ( SEQNO * .000001 ) |
ADDRESS_GROUP_KEY_EXPRESSION |
|
|
|
|
( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY |
ADVANCEMENT_ACTIVITY_GROUP_KEY_EXPRESSIO N |
|
|
|
|
|
ADVANCEMENT_DEGREE_GROUP_KEY_EXPRESSION |
|
|
|
|
|
ADVANCEMENT_PROGRAM_KEY_EXPRESSION |
|
|
|
|
|
ADVANCEMENT_PROGRAM_YEAR_KEY_EXPRESSION |
|
|
|
|
|
AFFILIATION_GROUP_KEY_EXPRESSION |
|
|
|
|
|
AWARD_HONOR_GROUP_KEY_EXPRESSION |
|
|
|
|
|
CE_TYPE_GROUP_KEY_EXPRESSION |
|
|
|
|
CE_TYPE_GROUP_KEY |
CLEARANCE_START_DATE_EXPRESSION |
|
|
|
|
|
CLEARANCE_STOP_DATE_EXPRESSION |
|
|
|
|
|
COMMITTEE_GROUP_KEY_EXPRESSION |
|
|
|
|
|
CONSTITUENT_ENTITY_ATTRIB_KEY_EXPRESSION |
|
|
|
|
|
CONSTITUENT_EVAL_GROUP_KEY_EXPRESSION |
|
|
|
|
|
CONSTITUENT_INTEREST_GROUP_KEY_EXPRESSIO N |
|
|
|
|
|
CONSTITUENT_PROFILE_GROUP_KEY_EXPRESSION |
|
|
|
|
|
CONST_EMPLOYMENT_GROUP_KEY_EXPRESSION |
|
|
|
|
|
CONT_REP_PROSPECT_GROUP_KEY_EXPRESSION |
|
|
|
|
|
CURRENT_ADDRESS_COUNT_EXPRESSION |
|
|
|
|
case when CURRENT_ADDRESS_IND = 1 then ( ( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( ADDRESS_TYPE_KEY * .001 ) + ( SEQNO * .000001 ) ) else null end |
CURRENT_ADDRESS_IND_EXPRESSION |
|
|
|
|
CURRENT_ADDRESS_IND |
CURRENT_GIVING_TOTAL_KEY_EXPRESSION |
|
|
|
|
|
CURRENT_SEASONAL_ADDRESS_COUNT_EXPRESSIO N |
|
|
|
|
CASE WHEN ( CURRENT_ADDRESS_IND = 1 AND SEASONAL_ADDRESS_IND = 1 ) THEN ( ( ENTITY_KEY * 100 ) + MULTI_SOURCE_KEY + ( ADDRESS_TYPE_KEY * .001 ) + ( SEQNO * .000001 ) ) ELSE NULL END |
CURRENT_SP_GIVING_TOTAL_KEY_EXPRESSION |
|
|
|
|
|
DEMOGRAPHIC_KEY_EXPRESSION |
|
|
|
|
|
EMAIL_GROUP_KEY_EXPRESSION |
|
|
|
|
|
ENTITY_ID_EXPRESSION |
|
|
|
|
|
EXCLUSION_GROUP_KEY_EXPRESSION |
|
|
|
|
|
FIRST_PROPOSAL_RESULT_DATE_EXPRESSION |
|
|
|
|
|
FIRST_PROP_PURPOSE_RESULT_DATE_EXPRESSIO N |
|
|
|
|
|
GIFT_DATE_OF_RECORD_EXPRESSION |
|
|
|
|
AGBGIFT_GIFT_DATE |
GIFT_RECEIPT_DATE_EXPRESSION |
|
|
|
|
AGBGIFT_RECEIPT_DATE |
GIFT_SOCIETY_GROUP_KEY_EXPRESSION |
|
|
|
|
|
LAST_ENT_CRPT_ATTRIB_KEY_EXPRESSION |
|
|
|
|
CONTACT_REPORT_ATTRIBUTE_KEY |
LAST_ENT_CRPT_AUTH_STAFF_KEY_EXPRESSION |
|
|
|
|
|
LAST_ENT_CRPT_KEY_EXPRESSION |
|
|
|
|
CONTACT_REPORT_KEY |
LAST_PROPOSAL_PURPOSE_ASK_DATE_EXPRESSIO N |
|
|
|
|
|
LAST_PROS_CRPT_ATTRIB_KEY_EXPRESSION |
|
|
|
|
CONTACT_REPORT_ATTRIBUTE_KEY_1 |
LAST_PROS_CRPT_AUTH_STAFF_KEY_EXPRESSION |
|
|
|
|
|
LAST_PROS_CRPT_KEY_EXPRESSION |
|
|
|
|
CONTACT_REPORT_KEY_1 |
LATEST_ENTITY_CONTACT_DATE_EXPRESSION |
|
|
|
|
CONTACT_DATE |
LATEST_PROPOSAL_ASK_AMOUNT_EXPRESSION |
|
|
|
|
|
LATEST_PROSPECT_CONTACT_DATE_EXPRESSION |
|
|
|
|
CONTACT_DATE_1 |
LATEST_VISIT_IND_EXPRESSION |
|
|
|
|
CONTACT_ACTIVITY |
LG_HARD_GIVING_TOTAL_KEY_EXPRESSION |
|
|
|
|
LG_HARD_GIVING_TOTAL_KEY |
LG_HARD_SP_GIVING_TOTAL_KEY_EXPRESSION |
|
|
|
|
LG_HARD_SP_GIVING_TOTAL_KEY |
LG_SOFT_GIVING_TOTAL_KEY_EXPRESSION |
|
|
|
|
LG_SOFT_GIVING_TOTAL_KEY |
LG_SOFT_SP_GIVING_TOTAL_KEY_EXPRESSION |
|
|
|
|
LG_SOFT_SP_GIVING_TOTAL_KEY |
MAILING_HISTORY_GROUP_KEY_EXPRESSION |
|
|
|
|
MAILING_HISTORY_GROUP_KEY |
MAILING_LIST_GROUP_KEY_EXPRESSION |
|
|
|
|
MAILING_LIST_GROUP_KEY |
MAIL_TRACKING_GROUP_KEY_EXPRESSION |
|
|
|
|
|
MEMBERSHIP_GROUP_KEY_EXPRESSION |
|
|
|
|
|
PGM_PROSPECT_EVAL_GROUP_KEY_EXPRESSION |
|
|
|
|
|
PGM_PROSPECT_SHARED_ATTRIB_KEY_EXPRESSIO N |
|
|
|
|
|
PGM_PROSPECT_STAGE_START_DATE_EXPRESSION |
|
|
|
|
|
PHONE_GROUP_KEY_EXPRESSION |
|
|
|
|
|
PREFERRED_ADDRESS_IND_EXPRESSION |
|
|
|
|
CURRENT_ADDRESS_IND * ADDR_PREF_IND |
PREFERRED_ADDRESS_TYPE_KEY_EXPRESSION |
|
|
|
|
|
PREFERRED_CLASS_SCHOOL_KEY_EXPRESSION |
|
|
|
|
|
PREFERRED_POSTAL_KEY_EXPRESSION |
|
|
|
|
|
PREFERRED_STREET_LINE_KEY_EXPRESSION |
|
|
|
|
|
PRIMARY_ASSIGNMENT_ENTITY_KEY_EXPRESSION |
|
|
|
|
|
PRIMARY_ASSIGNMENT_ENTITY_UID_EXPRESSION |
|
|
|
|
|
PRIMARY_ASSIGNMENT_KEY_EXPRESSION |
|
|
|
|
|
PRIMARY_ASSIGNMENT_OFFICE_KEY_EXPRESSION |
|
|
|
|
|
PRIMARY_ASSIGNMENT_STAFF_KEY_EXPRESSION |
|
|
|
|
|
PRIMARY_ASSIGNMENT_UNIT_KEY_EXPRESSION |
|
|
|
|
|
PRIMARY_CE_TYPE_KEY_EXPRESSION |
|
|
|
|
PRIMARY_CE_TYPE_KEY |
PRIMARY_PROSPECT_ENTITY_COUNT_EXPRESSION |
|
|
|
|
PRIMARY_PROSPECT_ENTITY_COUNT |
PROGRAM_ASSIGNMENT_GROUP_KEY_EXPRESSION |
|
|
|
|
PROGRAM_ASSIGNMENT_GROUP_KEY |
PROGRAM_PROSPECT_ASSIGNED_IND_EXPRESSION |
|
|
|
|
PROGRAM_PROSPECT_ASSIGNED_IND |
PROGRAM_PROSPECT_ATTRIBUTE_KEY_EXPRESSIO N |
|
|
|
|
PROGRAM_PROSPECT_ATTRIBUTE_KEY |
PROGRAM_PROSPECT_COUNT_EXPRESSION |
|
|
|
|
PROGRAM_PROSPECT_COUNT |
PROGRAM_PROSPECT_RATED_AMOUNT_EXPRESSION |
|
|
|
|
PROGRAM_PROSPECT_RATED_AMOUNT |
PROGRAM_PROSPECT_RESULT_AMOUNT_EXPRESSIO N |
|
|
|
|
PROGRAM_PROSPECT_RESULT_AMOUNT |
PROGRAM_PROSPECT_RESULT_DATE_EXPRESSION |
|
|
|
|
PROGRAM_PROSPECT_RESULT_DATE |
PROGRAM_PROSPECT_STAGE_KEY_EXPRESSION |
|
|
|
|
PROGRAM_PROSPECT_STAGE_KEY_1 |
PROGRAM_PROSPECT_START_DATE_EXPRESSION |
|
|
|
|
PROGRAM_PROSPECT_START_DATE |
PROGRAM_PROSPECT_STOP_DATE_EXPRESSION |
|
|
|
|
PROGRAM_PROSPECT_STOP_DATE |
PROGRAM_PROSPECT_TARGET_DATE_EXPRESSION |
|
|
|
|
PROGRAM_PROSPECT_TARGET_DATE |
PROGRAM_PROSPECT_UNIT_KEY_EXPRESSION |
|
|
|
|
PROGRAM_PROSPECT_UNIT_KEY |
PROPOSAL_ASK_AMOUNT_EXPRESSION |
|
|
|
|
|
PROPOSAL_ASK_DATE_EXPRESSION |
|
|
|
|
|
PROPOSAL_ASK_MADE_IND_EXPRESSION |
|
|
|
|
|
PROPOSAL_ASSIGNED_IND_EXPRESSION |
|
|
|
|
|
PROPOSAL_ASSIGNMENT_GROUP_KEY_EXPRESSION |
|
|
|
|
|
PROPOSAL_ATTRIBUTE_KEY_EXPRESSION |
|
|
|
|
|
PROPOSAL_CAMPAIGN_KEY_EXPRESSION |
|
|
|
|
|
PROPOSAL_COUNT_EXPRESSION |
|
|
|
|
|
PROPOSAL_DURATION_EXPRESSION |
|
|
|
|
|
PROPOSAL_GRANTED_AMOUNT_EXPRESSION |
|
|
|
|
|
PROPOSAL_GRANTED_IND_EXPRESSION |
|
|
|
|
|
PROPOSAL_INIT_CONTRIB_AMOUNT_EXPRESSION |
|
|
|
|
|
PROPOSAL_INIT_CONTRIB_DATE_EXPRESSION |
|
|
|
|
|
PROPOSAL_KEY_EXPRESSION |
|
|
|
|
|
PROPOSAL_ORIGINAL_ASK_AMOUNT_EXPRESSION |
|
|
|
|
|
PROPOSAL_PURPOSE_ACTIVE_IND_EXPRESSION |
|
|
|
|
|
PROPOSAL_PURPOSE_ASK_MADE_IND_EXPRESSION |
|
|
|
|
|
PROPOSAL_PURPOSE_END_DATE_EXPRESSION |
|
|
|
|
|
PROPOSAL_PURPOSE_GRANTED_IND_EXPRESSION |
|
|
|
|
|
PROPOSAL_PURPOSE_RESULT_IND_EXPRESSION |
|
|
|
|
|
PROPOSAL_PURPOSE_STAGE_DATE_EXPRESSION |
|
|
|
|
|
PROPOSAL_PURPOSE_START_DATE_EXPRESSION |
|
|
|
|
|
PROPOSAL_PURPOSE_TARGET_DATE_EXPRESSION |
|
|
|
|
|
PROPOSAL_RESULT_IND_EXPRESSION |
|
|
|
|
|
PROPOSAL_STAGE_KEY_EXPRESSION |
|
|
|
|
|
PROPOSAL_STAGE_START_DATE_EXPRESSION |
|
|
|
|
|
PROPOSAL_START_DATE_EXPRESSION |
|
|
|
|
|
PROPOSAL_STOP_DATE_EXPRESSION |
|
|
|
|
|
PROPOSAL_TARGET_AMOUNT_EXPRESSION |
|
|
|
|
|
PROPOSAL_TARGET_DATE_EXPRESSION |
|
|
|
|
|
PROPOSAL_TOTAL_RESULT_AMOUNT_EXPRESSION |
|
|
|
|
|
PROPOSAL_UNIT_KEY_EXPRESSION |
|
|
|
|
|
PROSPECT_ASSIGNED_IND_EXPRESSION |
|
|
|
|
|
PROSPECT_ASSIGNMENT_GROUP_KEY_EXPRESSION |
|
|
|
|
|
PROSPECT_ATTRIBUTE_KEY_EXPRESSION |
|
|
|
|
|
PROSPECT_CAMPAIGN_KEY_EXPRESSION |
|
|
|
|
|
PROSPECT_CATEGORY_GROUP_KEY_EXPRESSION |
|
|
|
|
|
PROSPECT_COUNT_EXPRESSION |
|
|
|
|
|
PROSPECT_ENTITY_COUNT_EXPRESSION |
|
|
|
|
|
PROSPECT_EVAL_GROUP_KEY_EXPRESSION |
|
|
|
|
|
PROSPECT_KEY_EXPRESSION |
|
|
|
|
|
PROSPECT_PIPELINE_GROUP_A_KEY_EXPRESSION |
|
|
|
|
|
PROSPECT_PIPELINE_GROUP_B_KEY_EXPRESSION |
|
|
|
|
|
PROSPECT_RATED_AMOUNT_EXPRESSION |
|
|
|
|
|
PROSPECT_RATE_ENTRY_DATE_EXPRESSION |
|
|
|
|
|
PROSPECT_RESULT_AMOUNT_EXPRESSION |
|
|
|
|
|
PROSPECT_RESULT_DATE_EXPRESSION |
|
|
|
|
|
PROSPECT_SHARED_ATTRIBUTE_KEY_EXPRESSION |
|
|
|
|
|
PROSPECT_STAGE_KEY_EXPRESSION |
|
|
|
|
|
PROSPECT_STAGE_START_DATE_EXPRESSION |
|
|
|
|
|
PROSPECT_START_DATE_EXPRESSION |
|
|
|
|
|
PROSPECT_STOP_DATE_EXPRESSION |
|
|
|
|
|
PROSPECT_TARGET_DATE_EXPRESSION |
|
|
|
|
|
PROSPECT_UNIT_KEY_EXPRESSION |
|
|
|
|
|
PROS_INT_MEASURE_FILTER_IND_EXPRESSION |
|
|
|
|
|
RELATIONSHIP_GROUP_KEY_EXPRESSION |
|
|
|
|
|
SEASONAL_ADDRESS_EXISTS_IND_EXPRESSION |
|
|
|
|
SUM ( CURRENT_ADDRESS_IND * SEASONAL_ADDRESS_IND ) OVER ( PARTITION BY ENTITY_KEY ) |
SPECIAL_PURPOSE_GROUP_KEY_EXPRESSION |
|
|
|
|
SPECIAL_PURPOSE_GROUP_KEY |
SPORT_GROUP_KEY_EXPRESSION |
|
|
|
|
|
SPOUSE_ENTITY_KEY_EXPRESSION |
|
|
|
|
RELATED_ENTITY_KEY |
SPOUSE_NON_ENTITY_KEY_EXPRESSION |
|
|
|
|
|
SPOUSE_UID_EXPRESSION |
|
|
|
|
RELATED_ENTITY_UID |
STUDENT_ACTIVITY_GROUP_KEY_EXPRESSION |
|
|
|
|
STUDENT_ACTIVITY_GROUP_KEY |
VARIABLE_PURPOSE_GROUP_KEY_EXPRESSION |
|
|
|
|
|