Banner EDW Source: CONSTANT

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
'0'	NO	DIMENSION TABLE	WDT_ADVANCEMENT_DEG_HONR	ADVANCEMENT_DEG_HONR_TYPE	ADVANCEMENT DEG HONR	NO
'CONSTITUENT_ENTITY_F1B'	NO	FACT TABLE	WFT_CONSTITUENT_ENTITY	SYSTEM_LOAD_PROCESS	CONSTITUENT ENTITY	NO
'CONSTITUENT_ENTITY_TYPE_F1B'	NO	FACT TABLE	WFT_CONSTITUENT_ENTITY_TYPE	SYSTEM_LOAD_PROCESS	CONSTITUENT ENTITY TYPE	NO
'CONTACT_REPORT_CREDIT_F1B'	NO	FACT TABLE	WFT_CONTACT_REPORT_CREDIT	SYSTEM_LOAD_PROCESS	CONTACT REPORT CREDIT	NO
'CONTACT_REPORT_F1B'	NO	FACT TABLE	WFT_CONTACT_REPORT	SYSTEM_LOAD_PROCESS	CONTACT REPORT	NO
'DESIGNATION_ATTRIBUTE_F1B'	NO	FACT TABLE	WFT_DESIGNATION_ATTRIBUTE	SYSTEM_LOAD_PROCESS	DESIGNATION ATTRIBUTE	NO
'DONOR_SUMMARY_D3B'	NO	DIMENSION TABLE	WDT_DONOR_SUMMARY	SYSTEM_LOAD_PROCESS	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION	NO
'ENTITY_D1B'	NO	DIMENSION TABLE	WDT_ENTITY	SYSTEM_LOAD_PROCESS	ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL PURPOSE RESULT, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE	NO
'FUNDRAISING_INITIATIVE_D1B'	NO	DIMENSION TABLE	WDT_FUNDRAISING_INITIATIVE	SYSTEM_LOAD_PROCESS	ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST	NO
'GIFT_DETAIL_D1B'	NO	DIMENSION TABLE	WDT_GIFT_DETAIL	SYSTEM_LOAD_PROCESS	ANALYZE FUNDRAISING, GIFT	NO
'GIVING_TOTAL_D3B'	NO	DIMENSION TABLE	WDT_GIVING_TOTAL	SYSTEM_LOAD_PROCESS	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION	NO
'MANAGE_PROSPECT_PIPELINE_A1'	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE	SYSTEM_LOAD_PROCESS	MANAGE PROSPECT PIPELINE	NO
'MANAGE_PROSPECT_PIPELINE_A_A1'	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A	SYSTEM_LOAD_PROCESS	MANAGE PROSPECT PIPELINE A	NO
'NO DATA'	NO	DIMENSION TABLE	WDT_ADVANCEMENT_DEG_COMMENTS WDT_ADVANCEMENT_DEG_COMMENTS WDT_EMAIL WDT_ADVANCEMENT_DEG_COMMENTS	ADVISOR_NAME THESIS_TITLE FORWARDING_EMAIL_ADDRESS DISSERTATION_TITLE	ADVANCEMENT DEGREE ADVANCEMENT DEGREE EMAIL ADVANCEMENT DEGREE	NO NO NO NO
'NO'	NO	DIMENSION TABLE	WDT_CONSTITUENT_ENTITY_ATTRIB WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_PROSPECT_SHARED_ATTRIBUTE WDT_PROSPECT_SHARED_ATTRIBUTE WDT_PROPOSAL_ATTRIBUTE WDT_CONSTITUENT_ENTITY_ATTRIB WDT_CONSTITUENT_ENTITY_ATTRIB WDT_PLEDGE WDT_PLEDGE WDT_PROSPECT_SHARED_ATTRIBUTE WDT_CONSTITUENT_ENTITY_ATTRIB WDT_GIFT WDT_CONSTITUENT_ENTITY_ATTRIB WDT_PLEDGE WDT_GIFT WDT_CONSTITUENT_ENTITY_ATTRIB WDT_PROSPECT_SHARED_ATTRIBUTE WDT_GIFT WDT_PROSPECT_SHARED_ATTRIBUTE WDT_CONSTITUENT_ENTITY_ATTRIB WDT_CONSTITUENT_ENTITY_ATTRIB WDT_GIFT WDT_PLEDGE WDT_PROSPECT_SHARED_ATTRIBUTE WDT_PROPOSAL_ATTRIBUTE	MAJOR_PROSPECT_IND_LD ATHLETICS_DESIGNATION_IND_SD EXTRAMURAL_ATHLETICS_IND_LD ATHLETICS_DESIGNATION_IND_LD EXTRAMURAL_ATHLETICS_IND_SD PLANNED_GIVING_PROSPECT_IND_LD PROSPECT_CONTACT_RESULT_IND_LD PROPOSAL_PLAN_GIFT_IND_LD PRIMARY_PROSPECT_ENTITY_IND_SD PROGRAM_PROSPECT_IND_LD PLEDGE_RECORDABLE_IND_SD PLEDGE_RECORDABLE_IND_LD PLANNED_GIVING_PROSPECT_IND_SD ASSIGNED_IND_SD REALIZED_BEQUEST_IND_SD ASSIGNED_IND_LD PLEDGE_BINDING_IND_SD REALIZED_BEQUEST_IND_LD PROGRAM_PROSPECT_IND_SD PROSPECT_CONTACT_RESULT_IND_SD GIFT_EXCLUDE_IND_SD MAJOR_PROSPECT_IND_LD MAJOR_PROSPECT_IND_SD PRIMARY_PROSPECT_ENTITY_IND_LD GIFT_EXCLUDE_IND_LD PLEDGE_BINDING_IND_LD MAJOR_PROSPECT_IND_SD PROPOSAL_PLAN_GIFT_IND_SD	ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE MANAGE PROSPECT PIPELINE, PROSPECT MANAGE PROSPECT PIPELINE, PROSPECT CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, PLEDGE ANALYZE FUNDRAISING, PLEDGE MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, GIFT ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, PLEDGE ANALYZE FUNDRAISING, GIFT ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, GIFT MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, GIFT ANALYZE FUNDRAISING, PLEDGE MANAGE PROSPECT PIPELINE, PROSPECT CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL	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
'NOT APPLICABLE'	NO	DIMENSION TABLE	WDT_CONTACT_REPORT WDT_PROPOSAL WDT_PROPOSAL WDT_PROPOSAL WDT_CONTACT_REPORT WDT_CONTACT_REPORT WDT_PROPOSAL_PURPOSE	REPRESENTATIVE_NAME PROS_PGM_YR_ID PROPOSAL_TITLE PROPOSAL_DESCRIPTION CONTACTED_SORT_NAME CONTACTED_NAME PROS_PGM_YR_ID	CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE MANAGE PROSPECT PIPELINE B, PROPOSAL PURPOSE, PROPOSAL PURPOSE STAGE	NO NO NO NO NO NO NO
'NOT AVAILABLE'	NO	DIMENSION TABLE	WDT_STAFF WDT_STAFF	STAFF_NAME_SORT STAFF_EMAIL_ADDRESS	ANALYZE FUNDRAISING, ASSIGNMENT, COMMITTEE, CONSTITUENT EVALUATION, CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, ASSIGNMENT, COMMITTEE, CONSTITUENT EVALUATION, CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE, PROSPECT	NO NO
'PROPOSAL_PURPOSE_RESULT_F1B'	NO	FACT TABLE	WFT_PROPOSAL_PURPOSE_RESULT	SYSTEM_LOAD_PROCESS	PROPOSAL PURPOSE RESULT	NO
'PROPOSAL_PURPOSE_STAGE_F1B'	NO	FACT TABLE	WFT_PROPOSAL_PURPOSE_STAGE	SYSTEM_LOAD_PROCESS	PROPOSAL PURPOSE STAGE	NO
'PROPOSAL_STAGE_F1B'	NO	FACT TABLE	WFT_PROPOSAL_STAGE	SYSTEM_LOAD_PROCESS	PROPOSAL STAGE	NO
'PROSPECT_F1B'	NO	FACT TABLE	WFT_PROSPECT	SYSTEM_LOAD_PROCESS	PROSPECT	NO
'PROSPECT_INTEREST_F1B'	NO	FACT TABLE	WFT_PROSPECT_INTEREST	SYSTEM_LOAD_PROCESS	PROSPECT INTEREST	NO
'PROSPECT'	NO	DIMENSION TABLE	WDT_CONSTITUENT_EVAL_DETAIL WDT_CONSTITUENT_EVAL_DETAIL WDT_CONSTITUENT_EVAL_DETAIL	EVALUATION_CATEGORY EVALUATION_CATEGORY_SD EVALUATION_CATEGORY_LD	CONSTITUENT EVALUATION CONSTITUENT EVALUATION CONSTITUENT EVALUATION	NO NO NO
'RELATIONSHIP_F1B'	NO	FACT TABLE	WFT_RELATIONSHIP	SYSTEM_LOAD_PROCESS	RELATIONSHIP	NO
'RQPP_YEARLY_DES_COLL_A1'	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT	SYSTEM_LOAD_PROCESS SYSTEM_LOAD_PROCESS	RQPP YEARLY DES COLL RQPP YEARLY DES DEPT	NO NO
'RQPP_YEARLY_INSTITUTION_A1'	NO	AGGREGATE FACT TABLE	WAT_RQPP_YEARLY_INSTITUTION	SYSTEM_LOAD_PROCESS	RQPP YEARLY INSTITUTION	NO
'YES'	NO	DIMENSION TABLE	WDT_STAFF WDT_ASSIGNMENT WDT_STAFF WDT_ASSIGNMENT	STAFF_IND_SD ACTIVE_ASSIGNMENT_IND_LD STAFF_IND_LD ACTIVE_ASSIGNMENT_IND_SD	ANALYZE FUNDRAISING, ASSIGNMENT, COMMITTEE, CONSTITUENT EVALUATION, CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, ASSIGNMENT, COMMITTEE, CONSTITUENT EVALUATION, CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT	NO NO NO NO
0	NO	AGGREGATE FACT TABLE DIMENSION TABLE FACT TABLE	W WDT_PLEDGE_DETAIL WFT_MATCHING_CLAIM WFT_PROSPECT WFT_CONTACT_REPORT WFT_PROSPECT WFT_MATCHING_CLAIM WFT_CONTACT_REPORT WFT_MATCHING_CLAIM WFT_PROSPECT WFT_CONTACT_REPORT WFT_CONTACT_REPORT WFT_PROSPECT_INTEREST WFT_CONTACT_REPORT_CREDIT WFT_CONTACT_REPORT WFT_MATCHING_CLAIM WFT_MATCHING_CLAIM WFT_MATCHING_CLAIM WFT_PROSPECT_INTEREST WFT_PROSPECT_INTEREST WFT_CONTACT_REPORT WFT_CONTACT_REPORT WFT_CONTACT_REPORT WFT_PROPOSAL_STAGE	T T_DETAIL_EDW_target.html#MATCHING_GIFT_IND">MATCHING_GIFT_IND XSEQUENCE PLEDGE_BINDING_IND GIFT_CHECK_NUMBER PLEDGE_SEQUENCE CONSTITUENT_ENTITY_TYPE_KEY PROSPECT_CAMPAIGN_KEY ID2_ENTITY_UID PROSPECT_RESULT_AMOUNT ADVANCEMENT_PROGRAM_KEY CONTACT_REPORT_UNIT_KEY PROPOSAL_KEY PROSPECT_UNIT_KEY ADVANCEMENT_PROGRAM_KEY ID2_ENTITY_KEY PROSPECT_INTEREST_UNIT_KEY UNIT_KEY AUTHOR_ENTITY_KEY FUNDRAISING_INITIATIVE_KEY CLASS_SCHOOL_KEY REUNION_CAMPAIGN_KEY ADVANCEMENT_PROGRAM_KEY ADVANCEMENT_PROGRAM_YEAR_KEY REP_ID_ENTITY_KEY REP_ID_ENTITY_UID AUTHOR_ENTITY_UID STAGE_ID	MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ANALYZE FUNDRAISING, GIFT ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, PLEDGE ANALYZE FUNDRAISING, GIFT ANALYZE FUNDRAISING, MATCHING CLAIM ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ANALYZE FUNDRAISING, GIFT MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, GIFT MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, GIFT MANAGE PROSPECT PIPELINE B, PROPOSAL PURPOSE, PROPOSAL PURPOSE STAGE ANALYZE FUNDRAISING, PLEDGE ANALYZE FUNDRAISING, GIFT ANALYZE FUNDRAISING, PLEDGE MATCHING CLAIM PROSPECT CONTACT REPORT PROSPECT MATCHING CLAIM CONTACT REPORT MATCHING CLAIM PROSPECT CONTACT REPORT CONTACT REPORT PROSPECT INTEREST CONTACT REPORT CREDIT CONTACT REPORT MATCHING CLAIM MATCHING CLAIM MATCHING CLAIM PROSPECT INTEREST PROSPECT INTEREST CONTACT REPORT CONTACT REPORT CONTACT REPORT PROPOSAL STAGE	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 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	AGGREGATE FACT TABLE DIMENSION TABLE FACT TABLE	WAT_RQPP_YEARLY_DES_COLL WAT_RQPP_YEARLY_DES_DEPT WAT_RQPP_YEARLY_INSTITUTION WDT_ASSIGNMENT WDT_STAFF WDT_GIFT_DETAIL WFT_PROPOSAL_STAGE WFT_CONTACT_REPORT_CREDIT WFT_PROPOSAL_PURPOSE_STAGE	AVAIL_CONST_IND AVAIL_CONST_IND AVAIL_CONST_IND ACTIVE_ASSIGNMENT_IND STAFF_IND GIFT_IND LATEST_PROPOSAL_STAGE_IND CONTACT_AUTHOR_IND LATEST_PROPOSAL_PURP_STAGE_IND	RQPP YEARLY DES COLL RQPP YEARLY DES DEPT RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, ASSIGNMENT, COMMITTEE, CONSTITUENT EVALUATION, CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, GIFT PROPOSAL STAGE CONTACT REPORT CREDIT PROPOSAL PURPOSE STAGE	NO NO NO NO NO NO NO NO NO
NULL	NO	AGGREGATE FACT TABLE DIMENSION TABLE FACT TABLE	N NT> WFT_CONSTITUENT_ENTITY WFT_CONSTITUENT_ENTITY WFT_CONSTITUENT_ENTITY WFT_CONSTITUENT_ENTITY_TYPE	a arget.html#RELATION_MI">RELATION_MI ASSIGNMENT_PRIORITY PG_PROSPECT_ENTITY_COUNT PROS_PGM_YR_ID PROGRAM_PROSPECT_ENTITY_COUNT RATED_ENTITY_COUNT MAJOR_PROSPECT_ENTITY_COUNT XSEQUENCE	MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE B ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT CONSTITUENT ENTITY PROSPECT CONSTITUENT ENTITY CONSTITUENT ENTITY CONSTITUENT ENTITY CONSTITUENT ENTITY TYPE	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 NO NO NO NO NO NO NO
TRUNC ( TO_DATE ( '31-DEC-2099' , 'DD- MON-YYYY' ) )	NO	FACT TABLE	WFT_PROSPECT WFT_PROSPECT WFT_PROSPECT	PROSPECT_RESULT_DATE PROSPECT_STOP_DATE PROSPECT_START_DATE	PROSPECT PROSPECT PROSPECT	NO NO NO
NULL	NO	DIMENSION TABLE	WDT_GIFT_DETAIL	MATCH_GIFT_NUMBER	ANALYZE FUNDRAISING, GIFT	NO
SYSDATE	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_B WAT_MANAGE_PROSPECT_PIPELINE_A	SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP	MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE A	NO NO
TO_DATE ( '31-DEC-2099' , 'DD-MON-YYYY' )	NO	FACT TABLE	WFT_PROPOSAL_PURPOSE_STAGE WFT_PROPOSAL_STAGE	PROPOSAL_PURP_STAGE_END_DATE PROPOSAL_STAGE_END_DATE	PROPOSAL PURPOSE STAGE PROPOSAL STAGE	NO NO

Ver: 8.4.2