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	DAF_OTHER_ORGANIZATION_IND_LD OTHER_INDIVIDUAL_IND_SD PARENT_IND_LD FACULTY_STAFF_IND_LD GRANDPARENT_IND_LD RELIGIOUS_ORGANIZATION_IND_SD FAMILY_FOUNDATION_IND_LD CORPORATION_IND_LD DAF_OTHER_ORGANIZATION_IND_SD FUND_RAISING_CONSORTIA_IND_SD FAMILY_FOUNDATION_IND_SD PARENT_IND_SD CORPORATION_IND_SD STUDENT_IND_SD STUDENT_IND_LD BOARD_MEMBER_IND_SD OTHER_INDIVIDUAL_IND_LD RELIGIOUS_ORGANIZATION_IND_LD BOARD_MEMBER_IND_LD FUND_RAISING_CONSORTIA_IND_LD OTHER_ORGANIZATION_IND_LD GRANDPARENT_IND_SD OTHER_FOUNDATION_IND_LD FACULTY_STAFF_IND_SD OTHER_ORGANIZATION_IND_SD OTHER_FOUNDATION_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_GIFT_SOCIETY WFT_MEMBERSHIP WFT_MEMBERSHIP WFT_ADVANCEMENT_DEGREE WFT_CONSTITUENT_EMPLOYMENT WFT_ADVANCEMENT_DEGREE WFT_ADVANCEMENT_DEGREE WFT_EMAIL WFT_GIFT_SOCIETY WFT_ADVANCEMENT_DEGREE WFT_CONSTITUENT_EVALUATION	BOARD_MEMBER_IND OTHER_INDIVIDUAL_IND PARENT_IND GRANDPARENT_IND FUND_RAISING_CONSORTIA_IND FAMILY_FOUNDATION_IND RELIGIOUS_ORGANIZATION_IND OTHER_FOUNDATION_IND OTHER_ORGANIZATION_IND DAF_OTHER_ORGANIZATION_IND FACULTY_STAFF_IND CORPORATION_IND STUDENT_IND EVALUATOR_UNIT_KEY ADVANCEMENT_PROGRAM_KEY UNIT_KEY MEMBERSHIP_CLUB_GROUP_KEY MEMB_PREV_NUMBER ADVANCEMENT_HON_DEGREE_KEY CONST_EMPLOYMENT_POSITION_KEY ADVANCEMENT_DEG_ATTR_KEY HONORARY_DEGREE_IND EMAIL_SEQ_NUMBER GIFT_SOCIETY_JOINT_UID ADVANCEMENT_ADMISSION_YEAR_KEY ADVANCEMENT_PROGRAM_YEAR_KEY	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 GIFT SOCIETY MEMBERSHIP MEMBERSHIP ADVANCEMENT DEGREE CONSTITUENT EMPLOYMENT ADVANCEMENT DEGREE ADVANCEMENT DEGREE EMAIL GIFT SOCIETY ADVANCEMENT DEGREE CONSTITUENT EVALUATION	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_MEMBERSHIP WFT_CONSTITUENT_EMPLOYMENT WFT_CONSTITUENT_EVALUATION WFT_GIFT_SOCIETY WFT_CONSTITUENT_EMPLOYMENT WFT_GIFT_SOCIETY	NEW_MEMBER_IND EMPLR_REL_ACTIVE_IND ACTIVE_EVALUATION_IND GIFT_SOCIETY_JOINT_MEMBER_IND SELF_EMPLOYED_IND GIFT_SOCIETY_SEQ_NUMBER	MEMBERSHIP CONSTITUENT EMPLOYMENT 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_DATE MARRIAGE_CHANGE_DATE	RELATIONSHIP RELATIONSHIP RELATIONSHIP	NO NO NO

Ver: 8.4.2