RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse Banner EDW Source: EXPRESSION_1 - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
ACTIVE_PROGRAM_PROSPECT_COUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

ACTIVE_PROGRAM_PROSPECT_COUNT

MANAGE PROSPECT PIPELINE 

NO

ACTIVE_PROPOSAL_COUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

ACTIVE_PROPOSAL_COUNT

MANAGE PROSPECT PIPELINE 

NO

ACTIVE_PROSPECT_COUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

ACTIVE_PROSPECT_COUNT

MANAGE PROSPECT PIPELINE 

NO

ADDRESS_COUNT_EXPRESSION NO

FACT TABLE

WFT_ADDRESS

ADDRESS_COUNT

ADDRESS 

NO

ADDRESS_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE


FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

WFT_ADDRESS

ADDRESS_GROUP_KEY

ADDRESS_GROUP_KEY

MANAGE PROSPECT PIPELINE 

ADDRESS 

NO

NO

ADVANCEMENT_ACTIVITY_GROUP_KEY_EXPRESSIO N NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

ADVANCEMENT_ACTIVITY_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

ADVANCEMENT_DEGREE_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

ADVANCEMENT_DEGREE_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

ADVANCEMENT_PROGRAM_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

ADVANCEMENT_PROGRAM_KEY

MANAGE PROSPECT PIPELINE 

NO

ADVANCEMENT_PROGRAM_YEAR_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

ADVANCEMENT_PROGRAM_YEAR_KEY

MANAGE PROSPECT PIPELINE 

NO

AFFILIATION_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

AFFILIATION_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

AWARD_HONOR_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

AWARD_HONOR_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

CE_TYPE_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

CE_TYPE_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

CLEARANCE_START_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

CLEARANCE_START_DATE

MANAGE PROSPECT PIPELINE 

NO

CLEARANCE_STOP_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

CLEARANCE_STOP_DATE

MANAGE PROSPECT PIPELINE 

NO

COMMITTEE_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

COMMITTEE_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

CONSTITUENT_ENTITY_ATTRIB_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

CONSTITUENT_ENTITY_ATTRIB_KEY

MANAGE PROSPECT PIPELINE 

NO

CONSTITUENT_EVAL_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

CONSTITUENT_EVAL_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

CONSTITUENT_INTEREST_GROUP_KEY_EXPRESSIO N NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

CONSTITUENT_INTEREST_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

CONSTITUENT_PROFILE_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

CONSTITUENT_PROFILE_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

CONST_EMPLOYMENT_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

CONST_EMPLOYMENT_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

CONT_REP_PROSPECT_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

CONT_REP_PROSPECT_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

CURRENT_ADDRESS_COUNT_EXPRESSION NO

FACT TABLE

WFT_ADDRESS

CURRENT_ADDRESS_COUNT

ADDRESS 

NO

CURRENT_ADDRESS_IND_EXPRESSION NO

FACT TABLE

WFT_ADDRESS

CURRENT_ADDRESS_IND

ADDRESS 

NO

CURRENT_GIVING_TOTAL_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

CURRENT_GIVING_TOTAL_KEY

MANAGE PROSPECT PIPELINE 

NO

CURRENT_SEASONAL_ADDRESS_COUNT_EXPRESSIO N NO

FACT TABLE

WFT_ADDRESS

CURRENT_SEASONAL_ADDRESS_COUNT

ADDRESS 

NO

CURRENT_SP_GIVING_TOTAL_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

CURRENT_SP_GIVING_TOTAL_KEY

MANAGE PROSPECT PIPELINE 

NO

DEMOGRAPHIC_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

DEMOGRAPHIC_KEY

MANAGE PROSPECT PIPELINE 

NO

EMAIL_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

EMAIL_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

ENTITY_ID_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

ENTITY_ID

MANAGE PROSPECT PIPELINE 

NO

EXCLUSION_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

EXCLUSION_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

FIRST_PROPOSAL_RESULT_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

FIRST_PROPOSAL_RESULT_DATE

MANAGE PROSPECT PIPELINE 

NO

FIRST_PROP_PURPOSE_RESULT_DATE_EXPRESSIO N NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_B

FIRST_PROP_PURPOSE_RESULT_DATE

MANAGE PROSPECT PIPELINE B 

NO

GIFT_DATE_OF_RECORD_EXPRESSION NO

FACT TABLE

WFT_MATCHING_CLAIM

GIFT_DATE_OF_RECORD

MATCHING CLAIM 

NO

GIFT_RECEIPT_DATE_EXPRESSION NO

FACT TABLE

WFT_MATCHING_CLAIM

GIFT_RECEIPT_DATE

MATCHING CLAIM 

NO

GIFT_SOCIETY_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

GIFT_SOCIETY_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

LAST_ENT_CRPT_ATTRIB_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LAST_ENT_CRPT_ATTRIB_KEY

MANAGE PROSPECT PIPELINE 

NO

LAST_ENT_CRPT_AUTH_STAFF_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LAST_ENT_CRPT_AUTH_STAFF_KEY

MANAGE PROSPECT PIPELINE 

NO

LAST_ENT_CRPT_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LAST_ENT_CRPT_KEY

MANAGE PROSPECT PIPELINE 

NO

LAST_PROPOSAL_PURPOSE_ASK_DATE_EXPRESSIO N NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_B

LAST_PROPOSAL_PURPOSE_ASK_DATE

MANAGE PROSPECT PIPELINE B 

NO

LAST_PROS_CRPT_ATTRIB_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LAST_PROS_CRPT_ATTRIB_KEY

MANAGE PROSPECT PIPELINE 

NO

LAST_PROS_CRPT_AUTH_STAFF_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LAST_PROS_CRPT_AUTH_STAFF_KEY

MANAGE PROSPECT PIPELINE 

NO

LAST_PROS_CRPT_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LAST_PROS_CRPT_KEY

MANAGE PROSPECT PIPELINE 

NO

LATEST_ENTITY_CONTACT_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LATEST_ENTITY_CONTACT_DATE

MANAGE PROSPECT PIPELINE 

NO

LATEST_PROPOSAL_ASK_AMOUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LATEST_PROPOSAL_ASK_AMOUNT

MANAGE PROSPECT PIPELINE 

NO

LATEST_PROSPECT_CONTACT_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LATEST_PROSPECT_CONTACT_DATE

MANAGE PROSPECT PIPELINE 

NO

LATEST_VISIT_IND_EXPRESSION NO

FACT TABLE

WFT_CONTACT_REPORT

LATEST_VISIT_IND

CONTACT REPORT 

NO

LG_HARD_GIVING_TOTAL_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LG_HARD_GIVING_TOTAL_KEY

MANAGE PROSPECT PIPELINE 

NO

LG_HARD_SP_GIVING_TOTAL_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LG_HARD_SP_GIVING_TOTAL_KEY

MANAGE PROSPECT PIPELINE 

NO

LG_SOFT_GIVING_TOTAL_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LG_SOFT_GIVING_TOTAL_KEY

MANAGE PROSPECT PIPELINE 

NO

LG_SOFT_SP_GIVING_TOTAL_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

LG_SOFT_SP_GIVING_TOTAL_KEY

MANAGE PROSPECT PIPELINE 

NO

MAILING_HISTORY_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

MAILING_HISTORY_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

MAILING_LIST_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

MAILING_LIST_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

MAIL_TRACKING_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

MAIL_TRACKING_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

MEMBERSHIP_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

MEMBERSHIP_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

PGM_PROSPECT_EVAL_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PGM_PROSPECT_EVAL_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

PGM_PROSPECT_SHARED_ATTRIB_KEY_EXPRESSIO N NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PGM_PROSPECT_SHARED_ATTRIB_KEY

MANAGE PROSPECT PIPELINE 

NO

PGM_PROSPECT_STAGE_START_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PGM_PROSPECT_STAGE_START_DATE

MANAGE PROSPECT PIPELINE 

NO

PHONE_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PHONE_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

PREFERRED_ADDRESS_IND_EXPRESSION NO

FACT TABLE

WFT_ADDRESS

PREFERRED_ADDRESS_IND

ADDRESS 

NO

PREFERRED_ADDRESS_TYPE_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PREFERRED_ADDRESS_TYPE_KEY

MANAGE PROSPECT PIPELINE 

NO

PREFERRED_CLASS_SCHOOL_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PREFERRED_CLASS_SCHOOL_KEY

MANAGE PROSPECT PIPELINE 

NO

PREFERRED_POSTAL_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PREFERRED_POSTAL_KEY

MANAGE PROSPECT PIPELINE 

NO

PREFERRED_STREET_LINE_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PREFERRED_STREET_LINE_KEY

MANAGE PROSPECT PIPELINE 

NO

PRIMARY_ASSIGNMENT_ENTITY_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PRIMARY_ASSIGNMENT_ENTITY_KEY

MANAGE PROSPECT PIPELINE 

NO

PRIMARY_ASSIGNMENT_ENTITY_UID_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PRIMARY_ASSIGNMENT_ENTITY_UID

MANAGE PROSPECT PIPELINE 

NO

PRIMARY_ASSIGNMENT_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PRIMARY_ASSIGNMENT_KEY

MANAGE PROSPECT PIPELINE 

NO

PRIMARY_ASSIGNMENT_OFFICE_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PRIMARY_ASSIGNMENT_OFFICE_KEY

MANAGE PROSPECT PIPELINE 

NO

PRIMARY_ASSIGNMENT_STAFF_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PRIMARY_ASSIGNMENT_STAFF_KEY

MANAGE PROSPECT PIPELINE 

NO

PRIMARY_ASSIGNMENT_UNIT_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PRIMARY_ASSIGNMENT_UNIT_KEY

MANAGE PROSPECT PIPELINE 

NO

PRIMARY_CE_TYPE_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PRIMARY_CE_TYPE_KEY

MANAGE PROSPECT PIPELINE 

NO

PRIMARY_PROSPECT_ENTITY_COUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PRIMARY_PROSPECT_ENTITY_COUNT

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_ASSIGNMENT_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_ASSIGNMENT_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_PROSPECT_ASSIGNED_IND_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_PROSPECT_ASSIGNED_IND

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_PROSPECT_ATTRIBUTE_KEY_EXPRESSIO N NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_PROSPECT_ATTRIBUTE_KEY

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_PROSPECT_COUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_PROSPECT_COUNT

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_PROSPECT_RATED_AMOUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_PROSPECT_RATED_AMOUNT

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_PROSPECT_RESULT_AMOUNT_EXPRESSIO N NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_PROSPECT_RESULT_AMOUNT

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_PROSPECT_RESULT_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_PROSPECT_RESULT_DATE

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_PROSPECT_STAGE_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_PROSPECT_STAGE_KEY

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_PROSPECT_START_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_PROSPECT_START_DATE

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_PROSPECT_STOP_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_PROSPECT_STOP_DATE

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_PROSPECT_TARGET_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_PROSPECT_TARGET_DATE

MANAGE PROSPECT PIPELINE 

NO

PROGRAM_PROSPECT_UNIT_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROGRAM_PROSPECT_UNIT_KEY

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_ASK_AMOUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_ASK_AMOUNT

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_ASK_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_ASK_DATE

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_ASK_MADE_IND_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_ASK_MADE_IND

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_ASSIGNED_IND_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_ASSIGNED_IND

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_ASSIGNMENT_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_ASSIGNMENT_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_ATTRIBUTE_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_ATTRIBUTE_KEY

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_CAMPAIGN_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_CAMPAIGN_KEY

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_COUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_COUNT

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_DURATION_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_DURATION

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_GRANTED_AMOUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_GRANTED_AMOUNT

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_GRANTED_IND_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_GRANTED_IND

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_INIT_CONTRIB_AMOUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_INIT_CONTRIB_AMOUNT

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_INIT_CONTRIB_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_INIT_CONTRIB_DATE

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_KEY

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_ORIGINAL_ASK_AMOUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_ORIGINAL_ASK_AMOUNT

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_PURPOSE_ACTIVE_IND_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_B

PROPOSAL_PURPOSE_ACTIVE_IND

MANAGE PROSPECT PIPELINE B 

NO

PROPOSAL_PURPOSE_ASK_MADE_IND_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_B

PROPOSAL_PURPOSE_ASK_MADE_IND

MANAGE PROSPECT PIPELINE B 

NO

PROPOSAL_PURPOSE_END_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_B

PROPOSAL_PURPOSE_END_DATE

MANAGE PROSPECT PIPELINE B 

NO

PROPOSAL_PURPOSE_GRANTED_IND_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_B

PROPOSAL_PURPOSE_GRANTED_IND

MANAGE PROSPECT PIPELINE B 

NO

PROPOSAL_PURPOSE_RESULT_IND_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_B

PROPOSAL_PURPOSE_RESULT_IND

MANAGE PROSPECT PIPELINE B 

NO

PROPOSAL_PURPOSE_STAGE_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_B

PROPOSAL_PURPOSE_STAGE_DATE

MANAGE PROSPECT PIPELINE B 

NO

PROPOSAL_PURPOSE_START_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_B

PROPOSAL_PURPOSE_START_DATE

MANAGE PROSPECT PIPELINE B 

NO

PROPOSAL_PURPOSE_TARGET_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE_B

PROPOSAL_PURPOSE_TARGET_DATE

MANAGE PROSPECT PIPELINE B 

NO

PROPOSAL_RESULT_IND_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_RESULT_IND

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_STAGE_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_STAGE_KEY

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_STAGE_START_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_STAGE_START_DATE

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_START_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_START_DATE

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_STOP_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_STOP_DATE

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_TARGET_AMOUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_TARGET_AMOUNT

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_TARGET_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_TARGET_DATE

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_TOTAL_RESULT_AMOUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_TOTAL_RESULT_AMOUNT

MANAGE PROSPECT PIPELINE 

NO

PROPOSAL_UNIT_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROPOSAL_UNIT_KEY

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_ASSIGNED_IND_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_ASSIGNED_IND

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_ASSIGNMENT_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_ASSIGNMENT_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_ATTRIBUTE_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_ATTRIBUTE_KEY

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_CAMPAIGN_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_CAMPAIGN_KEY

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_CATEGORY_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_CATEGORY_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_COUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_COUNT

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_ENTITY_COUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_ENTITY_COUNT

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_EVAL_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_EVAL_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_KEY

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_PIPELINE_GROUP_A_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_PIPELINE_GROUP_A_KEY

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_PIPELINE_GROUP_B_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_PIPELINE_GROUP_B_KEY

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_RATED_AMOUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_RATED_AMOUNT

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_RATE_ENTRY_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_RATE_ENTRY_DATE

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_RESULT_AMOUNT_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_RESULT_AMOUNT

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_RESULT_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_RESULT_DATE

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_SHARED_ATTRIBUTE_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_SHARED_ATTRIBUTE_KEY

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_STAGE_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_STAGE_KEY

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_STAGE_START_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_STAGE_START_DATE

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_START_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_START_DATE

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_STOP_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_STOP_DATE

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_TARGET_DATE_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_TARGET_DATE

MANAGE PROSPECT PIPELINE 

NO

PROSPECT_UNIT_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROSPECT_UNIT_KEY

MANAGE PROSPECT PIPELINE 

NO

PROS_INT_MEASURE_FILTER_IND_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

PROS_INT_MEASURE_FILTER_IND

MANAGE PROSPECT PIPELINE 

NO

RELATIONSHIP_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

RELATIONSHIP_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

SEASONAL_ADDRESS_EXISTS_IND_EXPRESSION NO

FACT TABLE

WFT_ADDRESS

SEASONAL_ADDRESS_EXISTS_IND

ADDRESS 

NO

SPECIAL_PURPOSE_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

SPECIAL_PURPOSE_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

SPORT_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

SPORT_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

SPOUSE_ENTITY_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

SPOUSE_ENTITY_KEY

MANAGE PROSPECT PIPELINE 

NO

SPOUSE_NON_ENTITY_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

SPOUSE_NON_ENTITY_KEY

MANAGE PROSPECT PIPELINE 

NO

SPOUSE_UID_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

SPOUSE_UID

MANAGE PROSPECT PIPELINE 

NO

STUDENT_ACTIVITY_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

STUDENT_ACTIVITY_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO

VARIABLE_PURPOSE_GROUP_KEY_EXPRESSION NO

AGGREGATE FACT TABLE

WAT_MANAGE_PROSPECT_PIPELINE

VARIABLE_PURPOSE_GROUP_KEY

MANAGE PROSPECT PIPELINE 

NO



Ver: 9.0