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_ADVANCEMENT_DEG_COMMENTS WDT_EMAIL	ADVISOR_NAME THESIS_TITLE DISSERTATION_TITLE FORWARDING_EMAIL_ADDRESS	ADVANCEMENT DEGREE ADVANCEMENT DEGREE ADVANCEMENT DEGREE EMAIL	NO NO NO NO
'NO'	NO	DIMENSION TABLE	WDT_CONSTITUENT_ENTITY_ATTRIB WDT_CONSTITUENT_ENTITY_ATTRIB WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_GIFT WDT_PLEDGE WDT_PLEDGE WDT_PROPOSAL_ATTRIBUTE WDT_PROPOSAL_ATTRIBUTE WDT_DESIGNATION_DETAIL WDT_PROSPECT_SHARED_ATTRIBUTE WDT_PROSPECT_SHARED_ATTRIBUTE WDT_CONSTITUENT_ENTITY_ATTRIB WDT_CONSTITUENT_ENTITY_ATTRIB WDT_CONSTITUENT_ENTITY_ATTRIB WDT_GIFT WDT_DESIGNATION_DETAIL WDT_CONSTITUENT_ENTITY_ATTRIB WDT_PROSPECT_SHARED_ATTRIBUTE WDT_CONSTITUENT_ENTITY_ATTRIB WDT_PROSPECT_SHARED_ATTRIBUTE WDT_CONSTITUENT_ENTITY_ATTRIB WDT_PLEDGE WDT_GIFT WDT_GIFT WDT_PROSPECT_SHARED_ATTRIBUTE WDT_PLEDGE WDT_PROSPECT_SHARED_ATTRIBUTE	ASSIGNED_IND_SD MAJOR_PROSPECT_IND_SD ATHLETICS_DESIGNATION_IND_SD EXTRAMURAL_ATHLETICS_IND_SD GIFT_EXCLUDE_IND_LD PLEDGE_BINDING_IND_LD PLEDGE_RECORDABLE_IND_LD PROPOSAL_PLAN_GIFT_IND_SD PROPOSAL_PLAN_GIFT_IND_LD ATHLETICS_DESIGNATION_IND_LD PLANNED_GIVING_PROSPECT_IND_SD PROSPECT_CONTACT_RESULT_IND_LD PRIMARY_PROSPECT_ENTITY_IND_LD PROGRAM_PROSPECT_IND_SD PRIMARY_PROSPECT_ENTITY_IND_SD REALIZED_BEQUEST_IND_LD EXTRAMURAL_ATHLETICS_IND_LD MAJOR_PROSPECT_IND_LD MAJOR_PROSPECT_IND_LD ASSIGNED_IND_LD PROSPECT_CONTACT_RESULT_IND_SD PROGRAM_PROSPECT_IND_LD PLEDGE_BINDING_IND_SD GIFT_EXCLUDE_IND_SD REALIZED_BEQUEST_IND_SD MAJOR_PROSPECT_IND_SD PLEDGE_RECORDABLE_IND_SD PLANNED_GIVING_PROSPECT_IND_LD	ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY 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, GIFT ANALYZE FUNDRAISING, PLEDGE ANALYZE FUNDRAISING, PLEDGE CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE MANAGE PROSPECT PIPELINE, PROSPECT MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, GIFT ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY ANALYZE FUNDRAISING, PLEDGE ANALYZE FUNDRAISING, GIFT ANALYZE FUNDRAISING, GIFT MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, PLEDGE MANAGE PROSPECT PIPELINE, PROSPECT	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_PROPOSAL WDT_PROPOSAL WDT_PROPOSAL WDT_CONTACT_REPORT WDT_CONTACT_REPORT WDT_CONTACT_REPORT WDT_PROPOSAL_PURPOSE	PROS_PGM_YR_ID PROPOSAL_DESCRIPTION PROPOSAL_TITLE CONTACTED_SORT_NAME REPRESENTATIVE_NAME CONTACTED_NAME PROS_PGM_YR_ID	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 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_EMAIL_ADDRESS STAFF_NAME_SORT	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_LD EVALUATION_CATEGORY_SD	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_ASSIGNMENT WDT_ASSIGNMENT WDT_STAFF WDT_STAFF	ACTIVE_ASSIGNMENT_IND_SD ACTIVE_ASSIGNMENT_IND_LD STAFF_IND_LD STAFF_IND_SD	ANALYZE FUNDRAISING, ASSIGNMENT, 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, COMMITTEE, CONSTITUENT EVALUATION, CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE, PROSPECT	NO NO NO NO
0	NO	AGGREGATE FACT TABLE DIMENSION TABLE FACT TABLE	0 0" face="Arial" size="2">WDT_CONSTITUENT_ENTITY_ATTRIB WDT_CONSTITUENT_ENTITY_ATTRIB WDT_CONSTITUENT_ENTITY_ATTRIB WDT_PLEDGE WDT_PROPOSAL WDT_PROSPECT_SHARED_ATTRIBUTE WDT_PROSPECT_SHARED_ATTRIBUTE WDT_PROSPECT_SHARED_ATTRIBUTE WDT_MATCHING_CLAIM_DETAIL WDT_GIFT_DETAIL WDT_GIFT_DETAIL WDT_GIFT_DETAIL WFT_CONTACT_REPORT_CREDIT WFT_MATCHING_CLAIM WFT_PROSPECT_INTEREST WFT_PROSPECT_INTEREST WFT_CONTACT_REPORT WFT_CONTACT_REPORT WFT_CONTACT_REPORT WFT_CONTACT_REPORT WFT_MATCHING_CLAIM WFT_CONTACT_REPORT WFT_PROSPECT_INTEREST WFT_CONTACT_REPORT WFT_MATCHING_CLAIM WFT_PROPOSAL_STAGE WFT_CONTACT_REPORT WFT_CONTACT_REPORT WFT_PROSPECT WFT_MATCHING_CLAIM WFT_MATCHING_CLAIM WFT_PROSPECT WFT_MATCHING_CLAIM WFT_PROSPECT	0 0000" face="Arial" size="2">JOINT_CONTACT_REPORT_IND PERSON_IND ATHLETICS_DESIGNATION_IND XSEQUENCE PROGRAM_PROSPECT_IND PLANNED_GIVING_PROSPECT_IND PRIMARY_PROSPECT_ENTITY_IND PLEDGE_BINDING_IND PROSPECT_ID MAJOR_PROSPECT_IND PROSPECT_CONTACT_RESULT_IND PLANNED_GIVING_PROSPECT_IND GIFT_SEQUENCE MATCHING_GIFT_IND DONOR_MATCHED_GIFT_NUMBER GIFT_CHECK_NUMBER UNIT_KEY FUNDRAISING_INITIATIVE_KEY ADVANCEMENT_PROGRAM_KEY PROSPECT_INTEREST_UNIT_KEY ADVANCEMENT_PROGRAM_KEY AUTHOR_ENTITY_KEY AUTHOR_ENTITY_UID ID2_ENTITY_KEY CONSTITUENT_ENTITY_TYPE_KEY REP_ID_ENTITY_KEY ADVANCEMENT_PROGRAM_YEAR_KEY ID2_ENTITY_UID REUNION_CAMPAIGN_KEY STAGE_ID CONTACT_REPORT_UNIT_KEY REP_ID_ENTITY_UID PROSPECT_CAMPAIGN_KEY CLASS_SCHOOL_KEY JOINT_CONTACT_REPORT_IND PERSON_IND ATHLETICS_DESIGNATION_IND XSEQUENCE PROGRAM_PROSPECT_IND PLANNED_GIVING_PROSPECT_IND PRIMARY_PROSPECT_ENTITY_IND PLEDGE_BINDING_IND PROSPECT_ID MAJOR_PROSPECT_IND PROSPECT_CONTACT_RESULT_IND PLANNED_GIVING_PROSPECT_IND GIFT_SEQUENCE MATCHING_GIFT_IND DONOR_MATCHED_GIFT_NUMBER GIFT_CHECK_NUMBER UNIT_KEY FUNDRAISING_INITIATIVE_KEY ADVANCEMENT_PROGRAM_KEY PROSPECT_INTEREST_UNIT_KEY ADVANCEMENT_PROGRAM_KEY AUTHOR_ENTITY_KEY AUTHOR_ENTITY_UID ID2_ENTITY_KEY CONSTITUENT_ENTITY_TYPE_KEY REP_ID_ENTITY_KEY ADVANCEMENT_PROGRAM_YEAR_KEY ID2_ENTITY_UID REUNION_CAMPAIGN_KEY STAGE_ID CONTACT_REPORT_UNIT_KEY REP_ID_ENTITY_UID PROSPECT_CAMPAIGN_KEY CLASS_SCHOOL_KEY PROPOSAL_KEY PROSPECT_UNIT_KEY ADVANCEMENT_PROGRAM_KEY PROSPECT_RESULT_AMOUNT	> >PROSPECT MATCHING CLAIM MATCHING CLAIM PROSPECT MATCHING CLAIM PROSPECT	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 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_INSTITUTION WAT_RQPP_YEARLY_DES_DEPT WAT_MANAGE_PROSPECT_PIPELINE_A WDT_GIFT_DETAIL WDT_ASSIGNMENT WDT_STAFF WFT_PROPOSAL_PURPOSE_STAGE WFT_PROPOSAL_STAGE WFT_CONTACT_REPORT_CREDIT	AVAIL_CONST_IND AVAIL_CONST_IND AVAIL_CONST_IND PROSPECT_INT_ASK_MADE_IND GIFT_IND ACTIVE_ASSIGNMENT_IND STAFF_IND LATEST_PROPOSAL_PURP_STAGE_IND LATEST_PROPOSAL_STAGE_IND CONTACT_AUTHOR_IND	RQPP YEARLY DES COLL RQPP YEARLY INSTITUTION RQPP YEARLY DES DEPT MANAGE PROSPECT PIPELINE A ANALYZE FUNDRAISING, GIFT ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT ANALYZE FUNDRAISING, ASSIGNMENT, COMMITTEE, CONSTITUENT EVALUATION, CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE, PROSPECT PROPOSAL PURPOSE STAGE PROPOSAL STAGE CONTACT REPORT CREDIT	NO NO NO NO NO NO NO NO NO NO
NULL	NO	AGGREGATE FACT TABLE DIMENSION TABLE FACT TABLE	W WDT_ASSIGNMENT_EDW_target.html">WDT_ASSIGNMENT WDT_NON_ENTITY_RELATION WDT_NON_ENTITY_RELATION WDT_NON_ENTITY_RELATION WFT_CONSTITUENT_ENTITY_TYPE WFT_PROSPECT WFT_CONSTITUENT_ENTITY WFT_CONSTITUENT_ENTITY WFT_CONSTITUENT_ENTITY WFT_CONSTITUENT_ENTITY	# #ASSIGNMENT_PRIORITY_SD">ASSIGNMENT_PRIORITY_SD RELATION_PREFIX LARGEST_GIFT_ID RELATION_DECEASED_DATE ASSIGNMENT_PRIORITY MARITAL_STATUS RELATION_MI RELATION_SUFFIX XSEQUENCE PROS_PGM_YR_ID MAJOR_PROSPECT_ENTITY_COUNT PG_PROSPECT_ENTITY_COUNT RATED_ENTITY_COUNT PROGRAM_PROSPECT_ENTITY_COUNT	MANAGE PROSPECT PIPELINE A 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 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 A MANAGE PROSPECT PIPELINE B MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE A 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, 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, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT 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, 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, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP CONSTITUENT ENTITY TYPE PROSPECT CONSTITUENT ENTITY CONSTITUENT ENTITY CONSTITUENT ENTITY CONSTITUENT 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 NO NO NO NO NO NO NO NO NO NO NO NO
TO_DATE('31-DEC-2099','DD-MON-YYYY')	NO	AGGREGATE FACT TABLE	WAT_MANAGE_PROSPECT_PIPELINE_A WAT_MANAGE_PROSPECT_PIPELINE_A WAT_MANAGE_PROSPECT_PIPELINE_A WAT_MANAGE_PROSPECT_PIPELINE_A WAT_MANAGE_PROSPECT_PIPELINE_A	PROSPECT_INTEREST_START_DATE PROSPECT_INTEREST_END_DATE PROSPECT_INTEREST_TARGET_DATE LAST_PROSP_INT_ASK_DATE PROSPECT_INTEREST_STATUS_DATE	MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE A	NO NO NO NO NO
TRUNC ( TO_DATE ( '31-DEC-2099' , 'DD- MON-YYYY' ) )	NO	FACT TABLE	WFT_PROSPECT WFT_PROSPECT WFT_PROSPECT	PROSPECT_STOP_DATE PROSPECT_RESULT_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_A WAT_MANAGE_PROSPECT_PIPELINE_B	SYSTEM_LOAD_TMSTMP SYSTEM_LOAD_TMSTMP	MANAGE PROSPECT PIPELINE A MANAGE PROSPECT PIPELINE B	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: 9.0