Banner EDW Source: TRANSLATIONS

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_ANALYZE_FUNDRAISING	ADDRESS_GROUP_KEY	ANALYZE FUNDRAISING	NO
ADVANCEMENT_ACTIVITY_GROUP_KEY_EXPRESSIO N	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	ADVANCEMENT_ACTIVITY_GROUP_KEY	ANALYZE FUNDRAISING	NO
ADVANCEMENT_DEGREE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	ADVANCEMENT_DEGREE_GROUP_KEY	ANALYZE FUNDRAISING	NO
AFFILIATION_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	AFFILIATION_GROUP_KEY	ANALYZE FUNDRAISING	NO
AWARD_HONOR_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	AWARD_HONOR_GROUP_KEY	ANALYZE FUNDRAISING	NO
COMMITTEE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	COMMITTEE_GROUP_KEY	ANALYZE FUNDRAISING	NO
CONSTITUENT_EVAL_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	CONSTITUENT_EVAL_GROUP_KEY	ANALYZE FUNDRAISING	NO
CONSTITUENT_INTEREST_GROUP_KEY_EXPRESSIO N	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	CONSTITUENT_INTEREST_GROUP_KEY	ANALYZE FUNDRAISING	NO
CONSTITUENT_PROFILE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	CONSTITUENT_PROFILE_GROUP_KEY	ANALYZE FUNDRAISING	NO
CONST_EMPLOYMENT_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	CONST_EMPLOYMENT_GROUP_KEY	ANALYZE FUNDRAISING	NO
CONT_REP_ENTITY_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	CONT_REP_ENTITY_GROUP_KEY	ANALYZE FUNDRAISING	NO
DESIGNATION_ATTRIB_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	DESIGNATION_ATTRIB_GROUP_KEY	ANALYZE FUNDRAISING	NO
DONOR_CE_TYPE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	DONOR_CE_TYPE_GROUP_KEY	ANALYZE FUNDRAISING	NO
EMAIL_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	EMAIL_GROUP_KEY	ANALYZE FUNDRAISING	NO
ENTITY_ASSIGNMENT_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	ENTITY_ASSIGNMENT_GROUP_KEY	ANALYZE FUNDRAISING	NO
ENTITY_PROS_INTEREST_GROUP_KEY_EXPRESSIO N	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	ENTITY_PROS_INTEREST_GROUP_KEY	ANALYZE FUNDRAISING	NO
EXCLUSION_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	EXCLUSION_GROUP_KEY	ANALYZE FUNDRAISING	NO
FIRST_GIFT_DATE_OF_RECORD_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	FIRST_GIFT_DATE_OF_RECORD	ANALYZE FUNDRAISING	NO
FIRST_GIFT_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	FIRST_GIFT_IND	ANALYZE FUNDRAISING	NO
FIRST_GIFT_OR_PLEDGE_IND_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	FIRST_GIFT_OR_PLEDGE_IND	ANALYZE FUNDRAISING	NO
FIRST_GIFT_OR_PLEDGE_REC_DATE_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	FIRST_GIFT_OR_PLEDGE_REC_DATE	ANALYZE FUNDRAISING	NO
FUNDING_PURPOSE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	FUNDING_PURPOSE_GROUP_KEY	ANALYZE FUNDRAISING	NO
GIFT_SOCIETY_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	GIFT_SOCIETY_GROUP_KEY	ANALYZE FUNDRAISING	NO
GIVING_CODE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	GIVING_CODE_GROUP_KEY	ANALYZE FUNDRAISING	NO
MAILING_HISTORY_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	MAILING_HISTORY_GROUP_KEY	ANALYZE FUNDRAISING	NO
MAILING_LIST_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	MAILING_LIST_GROUP_KEY	ANALYZE FUNDRAISING	NO
MAIL_TRACKING_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	MAIL_TRACKING_GROUP_KEY	ANALYZE FUNDRAISING	NO
MEMBERSHIP_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	MEMBERSHIP_GROUP_KEY	ANALYZE FUNDRAISING	NO
MG_CREDIT_GROUP_IDENTIFIER_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	MG_CREDIT_GROUP_IDENTIFIER	ANALYZE FUNDRAISING	NO
NEW_GIFT_DONOR_COUNT_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	NEW_GIFT_DONOR_COUNT	ANALYZE FUNDRAISING	NO
NEW_GIFT_OR_PLEDGE_DONOR_COUNT_EXPRESSIO N	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	NEW_GIFT_OR_PLEDGE_DONOR_COUNT	ANALYZE FUNDRAISING	NO
PHONE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PHONE_GROUP_KEY	ANALYZE FUNDRAISING	NO
PLEDGE_GROUP_IDENTIFIER_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PLEDGE_GROUP_IDENTIFIER	ANALYZE FUNDRAISING	NO
PLEDGE_WRITTEN_OFF_DATE_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PLEDGE_WRITTEN_OFF_DATE	ANALYZE FUNDRAISING	NO
PRIMARY_ASSIGNMENT_ENTITY_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PRIMARY_ASSIGNMENT_ENTITY_KEY	ANALYZE FUNDRAISING	NO
PRIMARY_ASSIGNMENT_ENTITY_UID_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PRIMARY_ASSIGNMENT_ENTITY_UID	ANALYZE FUNDRAISING	NO
PRIMARY_ASSIGNMENT_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PRIMARY_ASSIGNMENT_KEY	ANALYZE FUNDRAISING	NO
PRIMARY_ASSIGNMENT_OFFICE_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PRIMARY_ASSIGNMENT_OFFICE_KEY	ANALYZE FUNDRAISING	NO
PRIMARY_ASSIGNMENT_STAFF_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PRIMARY_ASSIGNMENT_STAFF_KEY	ANALYZE FUNDRAISING	NO
PRIMARY_ASSIGNMENT_UNIT_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	PRIMARY_ASSIGNMENT_UNIT_KEY	ANALYZE FUNDRAISING	NO
RELATIONSHIP_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	RELATIONSHIP_GROUP_KEY	ANALYZE FUNDRAISING	NO
SOURCE_CE_TYPE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	SOURCE_CE_TYPE_GROUP_KEY	ANALYZE FUNDRAISING	NO
SPECIAL_PURPOSE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	SPECIAL_PURPOSE_GROUP_KEY	ANALYZE FUNDRAISING	NO
SPORT_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	SPORT_GROUP_KEY	ANALYZE FUNDRAISING	NO
STUDENT_ACTIVITY_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	STUDENT_ACTIVITY_GROUP_KEY	ANALYZE FUNDRAISING	NO
TRANSACTION_NUMBER_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	TRANSACTION_NUMBER	ANALYZE FUNDRAISING	NO
TRANSACTION_RECEIPT_DATE_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	TRANSACTION_RECEIPT_DATE	ANALYZE FUNDRAISING	NO
VARIABLE_PURPOSE_GROUP_KEY_EXPRESSION	NO	AGGREGATE FACT TABLE	WAT_ANALYZE_FUNDRAISING	VARIABLE_PURPOSE_GROUP_KEY	ANALYZE FUNDRAISING	NO

Ver: 9.0