Banner Operational Data Store
Reporting 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 |
|
|
|
|
|