Banner EDW Source: EXP_GROUP_KEYS

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
ADDRESS_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	ADDRESS_GROUP_KEY	RQPP ENTITY	NO
ADVANCEMENT_ACTIVITY_GROUP_KEY_EXPRESSIO N	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	ADVANCEMENT_ACTIVITY_GROUP_KEY	RQPP ENTITY	NO
ADVANCEMENT_DEGREE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	ADVANCEMENT_DEGREE_GROUP_KEY	RQPP ENTITY	NO
AFFILIATION_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	AFFILIATION_GROUP_KEY	RQPP ENTITY	NO
AWARD_HONOR_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	AWARD_HONOR_GROUP_KEY	RQPP ENTITY	NO
COMMITTEE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	COMMITTEE_GROUP_KEY	RQPP ENTITY	NO
CONSTITUENT_EVAL_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	CONSTITUENT_EVAL_GROUP_KEY	RQPP ENTITY	NO
CONSTITUENT_INTEREST_GROUP_KEY_EXPRESSIO N	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	CONSTITUENT_INTEREST_GROUP_KEY	RQPP ENTITY	NO
CONSTITUENT_PROFILE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	CONSTITUENT_PROFILE_GROUP_KEY	RQPP ENTITY	NO
CONST_EMPLOYMENT_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	CONST_EMPLOYMENT_GROUP_KEY	RQPP ENTITY	NO
CONST_ENTITY_TYPE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	CONST_ENTITY_TYPE_GROUP_KEY	RQPP ENTITY	NO
CONT_REP_ENTITY_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	CONT_REP_ENTITY_GROUP_KEY	RQPP ENTITY	NO
EMAIL_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	EMAIL_GROUP_KEY	RQPP ENTITY	NO
ENTITY_ASSIGNMENT_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	ENTITY_ASSIGNMENT_GROUP_KEY	RQPP ENTITY	NO
ENTITY_PROS_INTEREST_GROUP_KEY_EXPRESSIO N	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	ENTITY_PROS_INTEREST_GROUP_KEY	RQPP ENTITY	NO
EXCLUSION_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	EXCLUSION_GROUP_KEY	RQPP ENTITY	NO
GIFT_SOCIETY_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	GIFT_SOCIETY_GROUP_KEY	RQPP ENTITY	NO
LAST_ENT_CRPT_ATTRIB_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	LAST_ENT_CRPT_ATTRIB_KEY	RQPP ENTITY	NO
LAST_ENT_CRPT_AUTH_STAFF_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	LAST_ENT_CRPT_AUTH_STAFF_KEY	RQPP ENTITY	NO
LAST_ENT_CRPT_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	LAST_ENT_CRPT_KEY	RQPP ENTITY	NO
LATEST_ENTITY_CONTACT_DATE_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	LATEST_ENTITY_CONTACT_DATE	RQPP ENTITY	NO
MAILING_HISTORY_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	MAILING_HISTORY_GROUP_KEY	RQPP ENTITY	NO
MAILING_LIST_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	MAILING_LIST_GROUP_KEY	RQPP ENTITY	NO
MAIL_TRACKING_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	MAIL_TRACKING_GROUP_KEY	RQPP ENTITY	NO
MEMBERSHIP_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	MEMBERSHIP_GROUP_KEY	RQPP ENTITY	NO
PHONE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	PHONE_GROUP_KEY	RQPP ENTITY	NO
SPECIAL_PURPOSE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	SPECIAL_PURPOSE_GROUP_KEY	RQPP ENTITY	NO
SPORT_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	SPORT_GROUP_KEY	RQPP ENTITY	NO
STUDENT_ACTIVITY_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	STUDENT_ACTIVITY_GROUP_KEY	RQPP ENTITY	NO
VARIABLE_PURPOSE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_RQPP_ENTITY	VARIABLE_PURPOSE_GROUP_KEY	RQPP ENTITY	NO

Ver: 9.0