Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: EXPRESSION_1 Advancement
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        


Ver: