Banner EDW Source: GROUP_COUNT_EXPRESSIONS

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
ACTIVE_PHONE_IND_EXPRESSION	NO	FACT TABLE	WFT_PHONE	ACTIVE_PHONE_IND	PHONE	NO
ACTIVITY_COUNT_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_ACTIVITY	ACTIVITY_COUNT	ADVANCEMENT ACTIVITY	NO
ACTIVITY_RECORD_COUNT_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_ACTIVITY	ACTIVITY_RECORD_COUNT	ADVANCEMENT ACTIVITY	NO
ADVANCEMENT_ACT_GROUP_KEY_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_ACTIVITY	ADVANCEMENT_ACT_GROUP_KEY	ADVANCEMENT ACTIVITY	NO
ADVANCEMENT_DEGREE_GROUP_KEY_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_DEGREE	ADVANCEMENT_DEGREE_GROUP_KEY	ADVANCEMENT DEGREE	NO
ADVANCEMENT_DEG_CONC_GRP_KEY_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_DEG_CONC	ADVANCEMENT_DEG_CONC_GRP_KEY	ADVANCEMENT DEG CONC	NO
ADVANCEMENT_DEG_DEPT_GRP_KEY_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_DEG_DEPT	ADVANCEMENT_DEG_DEPT_GRP_KEY	ADVANCEMENT DEG DEPT	NO
ADVANCEMENT_DEG_HONR_COUNT_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_DEG_HONR	ADVANCEMENT_DEG_HONR_COUNT	ADVANCEMENT DEG HONR	NO
ADVANCEMENT_DEG_HONR_GRP_KEY_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_DEG_HONR	ADVANCEMENT_DEG_HONR_GRP_KEY	ADVANCEMENT DEG HONR	NO
ADVANCEMENT_DEG_MAJR_COUNT_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_DEG_MAJR	ADVANCEMENT_DEG_MAJR_COUNT	ADVANCEMENT DEG MAJR	NO
ADVANCEMENT_DEG_MAJR_GRP_KEY_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_DEG_MAJR	ADVANCEMENT_DEG_MAJR_GRP_KEY	ADVANCEMENT DEG MAJR	NO
ADVANCEMENT_DEG_MINR_GRP_KEY_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_DEG_MINR	ADVANCEMENT_DEG_MINR_GRP_KEY	ADVANCEMENT DEG MINR	NO
CONSTITUENT_INTEREST_COUNT_KEY_EXPRESSIO N	NO	FACT TABLE	WFT_CONSTITUENT_INTEREST	CONSTITUENT_INTEREST_COUNT_KEY	CONSTITUENT INTEREST	NO
CONSTITUENT_INTEREST_GROUP_KEY_EXPRESSIO N	NO	FACT TABLE	WFT_CONSTITUENT_INTEREST	CONSTITUENT_INTEREST_GROUP_KEY	CONSTITUENT INTEREST	NO
CONSTITUENT_PROFILE_COUNT_KEY_EXPRESSION	NO	FACT TABLE	WFT_CONSTITUENT_PROFILE	CONSTITUENT_PROFILE_COUNT_KEY	CONSTITUENT PROFILE	NO
CONSTITUENT_PROFILE_GROUP_KEY_EXPRESSION	NO	FACT TABLE	WFT_CONSTITUENT_PROFILE	CONSTITUENT_PROFILE_GROUP_KEY	CONSTITUENT PROFILE	NO
DEGREE_COUNT_EXPRESSION	NO	FACT TABLE	WFT_ADVANCEMENT_DEGREE	DEGREE_COUNT	ADVANCEMENT DEGREE	NO
EMAIL_COUNT_EXPRESSION	NO	FACT TABLE	WFT_EMAIL	EMAIL_COUNT	EMAIL	NO
EMAIL_GROUP_KEY_EXPRESSION	NO	FACT TABLE	WFT_EMAIL	EMAIL_GROUP_KEY	EMAIL	NO
EXCLUSION_GROUP_KEY_EXPRESSION	NO	FACT TABLE	WFT_EXCLUSION	EXCLUSION_GROUP_KEY	EXCLUSION	NO
GIFT_SOCIETY_COUNT_EXPRESSION	NO	FACT TABLE	WFT_GIFT_SOCIETY	GIFT_SOCIETY_COUNT	GIFT SOCIETY	NO
GIFT_SOCIETY_GROUP_KEY_EXPRESSION	NO	FACT TABLE	WFT_GIFT_SOCIETY	GIFT_SOCIETY_GROUP_KEY	GIFT SOCIETY	NO
GIFT_SOCIETY_PREMIUM_GROUP_KEY_EXPRESSIO N	NO	FACT TABLE	WFT_GIFT_SOCIETY	GIFT_SOCIETY_PREMIUM_GROUP_KEY	GIFT SOCIETY	NO
GIFT_SOCIETY_RECORD_COUNT_EXPRESSION	NO	FACT TABLE	WFT_GIFT_SOCIETY	GIFT_SOCIETY_RECORD_COUNT	GIFT SOCIETY	NO
PHONE_COUNT_EXPRESSION	NO	FACT TABLE	WFT_PHONE	PHONE_COUNT	PHONE	NO
PHONE_GROUP_KEY_EXPRESSION	NO	FACT TABLE	WFT_PHONE	PHONE_GROUP_KEY	PHONE	NO
PHONE_UNLISTED_IND_EXPRESSION	NO	FACT TABLE	WFT_PHONE	PHONE_UNLISTED_IND	PHONE	NO
PRIMARY_PHONE_IND_EXPRESSION	NO	FACT TABLE	WFT_PHONE	PRIMARY_PHONE_IND	PHONE	NO
SPECIAL_PURPOSE_COUNT_EXPRESSION	NO	FACT TABLE	WFT_SPECIAL_PURPOSE	SPECIAL_PURPOSE_COUNT	SPECIAL PURPOSE	NO
SPECIAL_PURPOSE_GROUP_KEY_EXPRESSION	NO	FACT TABLE	WFT_SPECIAL_PURPOSE	SPECIAL_PURPOSE_GROUP_KEY	SPECIAL PURPOSE	NO
SPECIAL_PURPOSE_RECORD_COUNT_EXPRESSION	NO	FACT TABLE	WFT_SPECIAL_PURPOSE	SPECIAL_PURPOSE_RECORD_COUNT	SPECIAL PURPOSE	NO
SPECIAL_PURPOSE_TYPE_COUNT_EXPRESSION	NO	FACT TABLE	WFT_SPECIAL_PURPOSE	SPECIAL_PURPOSE_TYPE_COUNT	SPECIAL PURPOSE	NO
VARIABLE_PURPOSE_COUNT_EXPRESSION	NO	FACT TABLE	WFT_VARIABLE_PURPOSE	VARIABLE_PURPOSE_COUNT	VARIABLE PURPOSE	NO
VARIABLE_PURPOSE_GROUP_KEY_EXPRESSION	NO	FACT TABLE	WFT_VARIABLE_PURPOSE	VARIABLE_PURPOSE_GROUP_KEY	VARIABLE PURPOSE	NO

Ver: 9.0