Banner EDW Source: CONSTANT_0

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
'NO'	NO	DIMENSION TABLE	WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE	BOARD_MEMBER_IND_SD CORPORATION_IND_SD DAF_OTHER_ORGANIZATION_IND_LD FUND_RAISING_CONSORTIA_IND_LD STUDENT_IND_LD FACULTY_STAFF_IND_LD FACULTY_STAFF_IND_SD OTHER_FOUNDATION_IND_SD GRANDPARENT_IND_SD PARENT_IND_SD CORPORATION_IND_LD DAF_OTHER_ORGANIZATION_IND_SD GRANDPARENT_IND_LD BOARD_MEMBER_IND_LD OTHER_INDIVIDUAL_IND_LD RELIGIOUS_ORGANIZATION_IND_LD STUDENT_IND_SD OTHER_FOUNDATION_IND_LD RELIGIOUS_ORGANIZATION_IND_SD FAMILY_FOUNDATION_IND_SD FUND_RAISING_CONSORTIA_IND_SD FAMILY_FOUNDATION_IND_LD PARENT_IND_LD OTHER_ORGANIZATION_IND_LD OTHER_INDIVIDUAL_IND_SD OTHER_ORGANIZATION_IND_SD	b bsp;PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
'OTHER RELATION'	NO	FACT TABLE	WFT_RELATIONSHIP	RELATION_SOURCE	RELATIONSHIP	NO
0	NO	DIMENSION TABLE FACT TABLE	WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WDT_CONSTITUENT_ENTITY_TYPE WFT_CONSTITUENT_EVALUATION WFT_CONSTITUENT_EVALUATION WFT_CONSTITUENT_EVALUATION WFT_MEMBERSHIP WFT_ADVANCEMENT_DEGREE WFT_EMAIL WFT_ADVANCEMENT_DEGREE WFT_CONSTITUENT_EMPLOYMENT WFT_GIFT_SOCIETY WFT_ADVANCEMENT_DEGREE WFT_ADVANCEMENT_DEGREE WFT_MEMBERSHIP WFT_GIFT_SOCIETY	DAF_OTHER_ORGANIZATION_IND CORPORATION_IND FACULTY_STAFF_IND OTHER_INDIVIDUAL_IND BOARD_MEMBER_IND OTHER_FOUNDATION_IND OTHER_ORGANIZATION_IND FUND_RAISING_CONSORTIA_IND GRANDPARENT_IND RELIGIOUS_ORGANIZATION_IND STUDENT_IND PARENT_IND FAMILY_FOUNDATION_IND ADVANCEMENT_PROGRAM_KEY ADVANCEMENT_PROGRAM_YEAR_KEY EVALUATOR_UNIT_KEY MEMB_PREV_NUMBER ADVANCEMENT_HON_DEGREE_KEY EMAIL_SEQ_NUMBER HONORARY_DEGREE_IND CONST_EMPLOYMENT_POSITION_KEY UNIT_KEY ADVANCEMENT_ADMISSION_YEAR_KEY ADVANCEMENT_DEG_ATTR_KEY MEMBERSHIP_CLUB_GROUP_KEY GIFT_SOCIETY_JOINT_UID	ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY CONSTITUENT EVALUATION CONSTITUENT EVALUATION CONSTITUENT EVALUATION MEMBERSHIP ADVANCEMENT DEGREE EMAIL ADVANCEMENT DEGREE CONSTITUENT EMPLOYMENT GIFT SOCIETY ADVANCEMENT DEGREE ADVANCEMENT DEGREE MEMBERSHIP GIFT SOCIETY	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
1	NO	FACT TABLE	WFT_CONSTITUENT_EMPLOYMENT WFT_MEMBERSHIP WFT_CONSTITUENT_EVALUATION WFT_GIFT_SOCIETY WFT_CONSTITUENT_EMPLOYMENT WFT_GIFT_SOCIETY	EMPLR_REL_ACTIVE_IND NEW_MEMBER_IND ACTIVE_EVALUATION_IND GIFT_SOCIETY_SEQ_NUMBER SELF_EMPLOYED_IND GIFT_SOCIETY_JOINT_MEMBER_IND	CONSTITUENT EMPLOYMENT MEMBERSHIP CONSTITUENT EVALUATION GIFT SOCIETY CONSTITUENT EMPLOYMENT GIFT SOCIETY	NO NO NO NO NO NO
NULL	NO	FACT TABLE	WFT_RELATIONSHIP WFT_RELATIONSHIP WFT_RELATIONSHIP	CHILD_SEQ_NUMBER MARRIAGE_CHANGE_DATE MARRIAGE_DATE	RELATIONSHIP RELATIONSHIP RELATIONSHIP	NO NO NO

Ver: 9.0