RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse Banner EDW Source: CLN_ENTITY - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
ENTITY_KEY NO

FACT TABLE

WFT_CONSTITUENT_ENTITY_TYPE

WFT_CONSTITUENT_EVALUATION

WFT_CONSTITUENT_PROFILE

WFT_GIFT

WFT_EMAIL

WFT_GIFT_SOCIETY

WFT_PROPOSAL_PURPOSE_RESULT

WFT_PROSPECT_INTEREST

WFT_RELATIONSHIP

WFT_ADVANCEMENT_DEGREE

WFT_EXCLUSION

WFT_GEOGRAPHIC_REGION

WFT_ASSIGNMENT

WFT_CONSTITUENT_ENTITY

WFT_CONSTITUENT_EVALUATION

WFT_GIFT

WFT_MAILING_HISTORY

WFT_VARIABLE_PURPOSE

WFT_CONSTITUENT_INTEREST

WFT_MATCHING_CLAIM

WFT_MEMBERSHIP

WFT_CONTACT_REPORT

WFT_MATCHING_CLAIM

WFT_RELATIONSHIP

WFT_PHONE

WFT_PLEDGE

WFT_SPECIAL_PURPOSE

WFT_ASSIGNMENT

WFT_ADDRESS

WFT_CONSTITUENT_EMPLOYMENT

WFT_CONSTITUENT_EMPLOYMENT

WFT_PLEDGE

WFT_PROSPECT_ENTITY

ENTITY_KEY

EVALUATOR_ENTITY_KEY

ENTITY_KEY

SOURCE_DONOR_ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

RELATED_ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

DONOR_ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

MATCHING_COMPANY_ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

DONOR_MATCHED_ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

SOURCE_DONOR_ENTITY_KEY

ENTITY_KEY

ASSIGNMENT_ENTITY_KEY

ENTITY_KEY

ENTITY_KEY

EMPLOYER_KEY

DONOR_ENTITY_KEY

ENTITY_KEY

CONSTITUENT ENTITY TYPE 

CONSTITUENT EVALUATION 

CONSTITUENT PROFILE 

GIFT 

EMAIL 

GIFT SOCIETY 

PROPOSAL PURPOSE RESULT 

PROSPECT INTEREST 

RELATIONSHIP 

ADVANCEMENT DEGREE 

EXCLUSION 

GEOGRAPHIC REGION 

ASSIGNMENT 

CONSTITUENT ENTITY 

CONSTITUENT EVALUATION 

GIFT 

MAILING HISTORY 

VARIABLE PURPOSE 

CONSTITUENT INTEREST 

MATCHING CLAIM 

MEMBERSHIP 

CONTACT REPORT 

MATCHING CLAIM 

RELATIONSHIP 

PHONE 

PLEDGE 

SPECIAL PURPOSE 

ASSIGNMENT 

ADDRESS 

CONSTITUENT EMPLOYMENT 

CONSTITUENT EMPLOYMENT 

PLEDGE 

PROSPECT 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

NO

NO

NO

NO

NO

NO

NO



Ver: 8.4.2