SGHE Enterprise Data Warehouse
Banner EDW Source: SYSTEM_LOAD_PROCESS - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| 'ADDRESS_F1B' |
NO |
FACT TABLE |
WFT_ADDRESS |
SYSTEM_LOAD_PROCESS |
ADDRESS |
NO |
| 'ADDRESS_TYPE_D1B' |
NO |
DIMENSION TABLE |
WDT_ADDRESS_TYPE |
SYSTEM_LOAD_PROCESS |
ADDRESS, ANALYZE FUNDRAISING, COMMITTEE, CONSTITUENT ENTITY, GEOGRAPHIC REGION, MAIL TRACKING, MAILING LIST, MANAGE PROSPECT PIPELINE, PHONE, PLEDGE |
NO |
| 'ADVANCEMENT_ACTIVITY_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_ACTIVITY |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT ACTIVITY |
NO |
| 'ADVANCEMENT_ACTIVITY_F1B' |
NO |
FACT TABLE |
WFT_ADVANCEMENT_ACTIVITY |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT ACTIVITY |
NO |
| 'ADVANCEMENT_ACT_COMMENT_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_ACT_COMMENT |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT ACTIVITY |
NO |
| 'ADVANCEMENT_ACT_LEADERSHIP_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_ACT_LEADERSHIP |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT ACTIVITY |
NO |
| 'ADVANCEMENT_APPEAL_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_APPEAL |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE |
NO |
| 'ADVANCEMENT_DEGREE_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_DEGREE |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEGREE |
NO |
| 'ADVANCEMENT_DEGREE_F1B' |
NO |
FACT TABLE |
WFT_ADVANCEMENT_DEGREE |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEGREE |
NO |
| 'ADVANCEMENT_DEG_COMMENTS_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_DEG_COMMENTS |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEGREE |
NO |
| 'ADVANCEMENT_DEG_CONC_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_DEG_CONC |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEG CONC |
NO |
| 'ADVANCEMENT_DEG_CONC_F1B' |
NO |
FACT TABLE |
WFT_ADVANCEMENT_DEG_CONC |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEG CONC |
NO |
| 'ADVANCEMENT_DEG_DEPT_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_DEG_DEPT |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEG DEPT |
NO |
| 'ADVANCEMENT_DEG_DEPT_F1B' |
NO |
FACT TABLE |
WFT_ADVANCEMENT_DEG_DEPT |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEG DEPT |
NO |
| 'ADVANCEMENT_DEG_HONR_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_DEG_HONR |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEG HONR |
NO |
| 'ADVANCEMENT_DEG_HONR_F1B' |
NO |
FACT TABLE |
WFT_ADVANCEMENT_DEG_HONR |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEG HONR |
NO |
| 'ADVANCEMENT_DEG_MAJR_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_DEG_MAJR |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEG MAJR |
NO |
| 'ADVANCEMENT_DEG_MAJR_F1B' |
NO |
FACT TABLE |
WFT_ADVANCEMENT_DEG_MAJR |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEG MAJR |
NO |
| 'ADVANCEMENT_DEG_MINR_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_DEG_MINR |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEG MINR |
NO |
| 'ADVANCEMENT_DEG_MINR_F1B' |
NO |
FACT TABLE |
WFT_ADVANCEMENT_DEG_MINR |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEG MINR |
NO |
| 'ADVANCEMENT_DEG_YEAR_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_DEG_YEAR |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEGREE |
NO |
| 'ADVANCEMENT_INSTITUTION_D1B' |
NO |
DIMENSION TABLE |
WDT_ADVANCEMENT_INSTITUTION |
SYSTEM_LOAD_PROCESS |
ADVANCEMENT DEGREE |
NO |
| 'ANALYZE_FUNDRAISING_A1' |
NO |
AGGREGATE FACT TABLE |
WAT_ANALYZE_FUNDRAISING |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING |
NO |
| 'ASSIGNMENT_D1B' |
NO |
DIMENSION TABLE |
WDT_ASSIGNMENT |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT |
NO |
| 'CALENDAR_DATE_D3' |
NO |
DIMENSION TABLE |
WDT_FISCAL_DATE |
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 |
| 'CAMPAIGN_D1B' |
NO |
DIMENSION TABLE |
WDT_CAMPAIGN |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT |
NO |
| 'CLASS_SCHOOL_D1B' |
NO |
DIMENSION TABLE |
WDT_CLASS_SCHOOL |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY |
NO |
| 'CONSTITUENT_EMPLOYMENT_JOB_D1B' |
NO |
DIMENSION TABLE |
WDT_CONST_EMPLOYMENT_JOB |
SYSTEM_LOAD_PROCESS |
CONSTITUENT EMPLOYMENT |
NO |
| 'CONSTITUENT_ENTITY_ATTRIB_D1B' |
NO |
DIMENSION TABLE |
WDT_CONSTITUENT_ENTITY_ATTRIB |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RQPP ENTITY |
NO |
| 'CONSTITUENT_ENTITY_TYPE_D1B' |
NO |
DIMENSION TABLE |
WDT_CONSTITUENT_ENTITY_TYPE |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY |
NO |
| 'CONSTITUENT_EVALUATION_D1B' |
NO |
DIMENSION TABLE |
WDT_CONSTITUENT_EVALUATION |
SYSTEM_LOAD_PROCESS |
CONSTITUENT EVALUATION |
NO |
| 'CONSTITUENT_EVAL_DETAIL_D1B' |
NO |
DIMENSION TABLE |
WDT_CONSTITUENT_EVAL_DETAIL |
SYSTEM_LOAD_PROCESS |
CONSTITUENT EVALUATION |
NO |
| 'CONSTITUENT_INTEREST_D1B' |
NO |
DIMENSION TABLE |
WDT_CONSTITUENT_INTEREST |
SYSTEM_LOAD_PROCESS |
CONSTITUENT INTEREST |
NO |
| 'CONSTITUENT_PROFILE_D1B' |
NO |
DIMENSION TABLE |
WDT_CONSTITUENT_PROFILE |
SYSTEM_LOAD_PROCESS |
CONSTITUENT PROFILE |
NO |
| 'CONSTITUENT_PROFILE_DETAIL_D1B' |
NO |
DIMENSION TABLE |
WDT_CONSTITUENT_PROFILE_DETAIL |
SYSTEM_LOAD_PROCESS |
CONSTITUENT PROFILE |
NO |
| 'CONST_EMPLOYMENT_POSITION_D1B' |
NO |
DIMENSION TABLE |
WDT_CONST_EMPLOYMENT_POSITION |
SYSTEM_LOAD_PROCESS |
CONSTITUENT EMPLOYMENT |
NO |
| 'CONTACT_REPORT_ATTRIBUTE_D1B' |
NO |
DIMENSION TABLE |
WDT_CONTACT_REPORT_ATTRIBUTE |
SYSTEM_LOAD_PROCESS |
CONTACT REPORT, MANAGE PROSPECT PIPELINE |
NO |
| 'CONTACT_REPORT_CREDIT_D1B' |
NO |
DIMENSION TABLE |
WDT_CONTACT_REPORT_CREDIT |
SYSTEM_LOAD_PROCESS |
CONTACT REPORT CREDIT |
NO |
| 'CONTACT_REPORT_D1B' |
NO |
DIMENSION TABLE |
WDT_CONTACT_REPORT |
SYSTEM_LOAD_PROCESS |
CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE |
NO |
| 'DEMOGRAPHIC_D1B' |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| 'DESIGNATION_ATTRIBUTE_D1B' |
NO |
DIMENSION TABLE |
WDT_DESIGNATION_ATTRIBUTE |
SYSTEM_LOAD_PROCESS |
DESIGNATION ATTRIBUTE |
NO |
| 'DESIGNATION_D1B' |
NO |
DIMENSION TABLE |
WDT_DESIGNATION |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE |
NO |
| 'DESIGNATION_DETAIL_D1B' |
NO |
DIMENSION TABLE |
WDT_DESIGNATION_DETAIL |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE |
NO |
| 'EMAIL_ATTRIBUTE_D1B' |
NO |
DIMENSION TABLE |
WDT_EMAIL_ATTRIBUTE |
SYSTEM_LOAD_PROCESS |
EMAIL |
NO |
| 'EMAIL_COMMENT_D1B' |
NO |
DIMENSION TABLE |
WDT_EMAIL_COMMENT |
SYSTEM_LOAD_PROCESS |
EMAIL |
NO |
| 'EMAIL_D1B' |
NO |
DIMENSION TABLE |
WDT_EMAIL |
SYSTEM_LOAD_PROCESS |
EMAIL |
NO |
| 'EMAIL_F1B' |
NO |
FACT TABLE |
WFT_EMAIL |
SYSTEM_LOAD_PROCESS |
EMAIL |
NO |
| 'EMAIL_TYPE_D1B' |
NO |
DIMENSION TABLE |
WDT_EMAIL_TYPE |
SYSTEM_LOAD_PROCESS |
COMMITTEE, EMAIL, MAILING LIST |
NO |
| 'EXCLUSION_COMMENT_D1B' |
NO |
DIMENSION TABLE |
WDT_EXCLUSION_COMMENT |
SYSTEM_LOAD_PROCESS |
EXCLUSION |
NO |
| 'EXCLUSION_D1B' |
NO |
DIMENSION TABLE |
WDT_EXCLUSION |
SYSTEM_LOAD_PROCESS |
EXCLUSION |
NO |
| 'EXCLUSION_F1B' |
NO |
FACT TABLE |
WFT_EXCLUSION |
SYSTEM_LOAD_PROCESS |
EXCLUSION |
NO |
| 'GEOGRAPHIC_REGION_D1B' |
NO |
DIMENSION TABLE |
WDT_GEOGRAPHIC_REGION |
SYSTEM_LOAD_PROCESS |
COMMITTEE, GEOGRAPHIC REGION |
NO |
| 'GIFT_D1B' |
NO |
DIMENSION TABLE |
WDT_GIFT |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, GIFT |
NO |
| 'GIFT_SOCIETY_D1B' |
NO |
DIMENSION TABLE |
WDT_GIFT_SOCIETY |
SYSTEM_LOAD_PROCESS |
GIFT SOCIETY, GIFT SOCIETY PREMIUM |
NO |
| 'GIFT_SOCIETY_PREMIUM_D1B' |
NO |
DIMENSION TABLE |
WDT_GIFT_SOCIETY_PREMIUM |
SYSTEM_LOAD_PROCESS |
GIFT SOCIETY PREMIUM |
NO |
| 'GIFT_SOCIETY_YEAR_D1B' |
NO |
DIMENSION TABLE |
WDT_GIFT_SOCIETY_YEAR |
SYSTEM_LOAD_PROCESS |
GIFT SOCIETY, GIFT SOCIETY PREMIUM |
NO |
| 'GIVING_ATTRIBUTE_D1B' |
NO |
DIMENSION TABLE |
WDT_GIVING_ATTRIBUTE |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE |
NO |
| 'MAILING_ATTRIBUTE_D1B' |
NO |
DIMENSION TABLE |
WDT_MAILING_ATTRIBUTE |
SYSTEM_LOAD_PROCESS |
MAILING HISTORY |
NO |
| 'MAILING_HISTORY_F1B' |
NO |
FACT TABLE |
WFT_MAILING_HISTORY |
SYSTEM_LOAD_PROCESS |
MAILING HISTORY |
NO |
| 'MAIL_CODE_D1B' |
NO |
DIMENSION TABLE |
WDT_MAIL_CODE |
SYSTEM_LOAD_PROCESS |
MAIL TRACKING, MAILING LIST |
NO |
| 'MANAGE_PROSPECT_PIPELINE_B_A1' |
NO |
AGGREGATE FACT TABLE |
WAT_MANAGE_PROSPECT_PIPELINE_B |
SYSTEM_LOAD_PROCESS |
MANAGE PROSPECT PIPELINE B |
NO |
| 'MATCHING_CLAIM_D1B' |
NO |
DIMENSION TABLE |
WDT_MATCHING_CLAIM |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, MATCHING CLAIM |
NO |
| 'MATCHING_CLAIM__DETAIL_D1B' |
NO |
DIMENSION TABLE |
WDT_MATCHING_CLAIM_DETAIL |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, MATCHING CLAIM |
NO |
| 'MEMBERSHIP_CLUB_D1B' |
NO |
DIMENSION TABLE |
WDT_MEMBERSHIP_CLUB |
SYSTEM_LOAD_PROCESS |
MEMBERSHIP CLUB |
NO |
| 'MEMBERSHIP_D1B' |
NO |
DIMENSION TABLE |
WDT_MEMBERSHIP |
SYSTEM_LOAD_PROCESS |
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST |
NO |
| 'MEMBERSHIP_INTEREST_D1B' |
NO |
DIMENSION TABLE |
WDT_MEMBERSHIP_INTEREST |
SYSTEM_LOAD_PROCESS |
MEMBERSHIP INTEREST |
NO |
| 'MULTI_SOURCE_D1B' |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
SYSTEM_LOAD_PROCESS |
ADDRESS, ADV STUDENT ACTIVITY, ADVANCEMENT ACTIVITY, ADVANCEMENT DEG CONC, ADVANCEMENT DEG DEPT, ADVANCEMENT DEG HONR, ADVANCEMENT DEG MAJR, ADVANCEMENT DEG MINR, ADVANCEMENT DEGREE, AFFILIATION, ANALYZE FUNDRAISING, ASSIGNMENT, AWARD HONOR, COMMITTEE, CONSTITUENT EMPLOYMENT, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, CONSTITUENT EVALUATION, CONSTITUENT INTEREST, CONSTITUENT PROFILE, CONTACT REPORT, CONTACT REPORT CREDIT, DESIGNATION ATTRIBUTE, EMAIL, EXCLUSION, GEOGRAPHIC REGION, GIFT, GIFT SOCIETY, GIFT SOCIETY PREMIUM, GIVING CODE, MAIL TRACKING, MAILING HISTORY, MAILING LIST, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST, PHONE, PLEDGE, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, PROSPECT STAGE, RELATIONSHIP, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION, SPECIAL PURPOSE, SPORT, VARIABLE PURPOSE |
NO |
| 'NON_ENTITY_RELATION_D1B' |
NO |
DIMENSION TABLE |
WDT_NON_ENTITY_RELATION |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP |
NO |
| 'PHONE_COMMENT_D1B' |
NO |
DIMENSION TABLE |
WDT_PHONE_COMMENT |
SYSTEM_LOAD_PROCESS |
PHONE |
NO |
| 'PHONE_F1B' |
NO |
FACT TABLE |
WFT_PHONE |
SYSTEM_LOAD_PROCESS |
PHONE |
NO |
| 'PHONE_TYPE_D1B' |
NO |
DIMENSION TABLE |
WDT_PHONE_TYPE |
SYSTEM_LOAD_PROCESS |
COMMITTEE, MAILING LIST, PHONE |
NO |
| 'PLEDGE_D1B' |
NO |
DIMENSION TABLE |
WDT_PLEDGE |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, PLEDGE |
NO |
| 'PLEDGE_DETAIL_D1B' |
NO |
DIMENSION TABLE |
WDT_PLEDGE_DETAIL |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, PLEDGE |
NO |
| 'PLEDGE_F1B' |
NO |
FACT TABLE |
WFT_PLEDGE |
SYSTEM_LOAD_PROCESS |
PLEDGE |
NO |
| 'POSTAL_D1B' |
NO |
DIMENSION TABLE |
WDT_POSTAL |
SYSTEM_LOAD_PROCESS |
ADDRESS, ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE |
NO |
| 'PROPOSAL_ATTRIBUTE_D1B' |
NO |
DIMENSION TABLE |
WDT_PROPOSAL_ATTRIBUTE |
SYSTEM_LOAD_PROCESS |
CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL |
NO |
| 'PROPOSAL_D1B' |
NO |
DIMENSION TABLE |
WDT_PROPOSAL |
SYSTEM_LOAD_PROCESS |
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 |
NO |
| 'PROPOSAL_PURPOSE_D1B' |
NO |
DIMENSION TABLE |
WDT_PROPOSAL_PURPOSE |
SYSTEM_LOAD_PROCESS |
MANAGE PROSPECT PIPELINE B, PROPOSAL PURPOSE, PROPOSAL PURPOSE STAGE |
NO |
| 'PROSPECT_ATTRIBUTE_D1B' |
NO |
DIMENSION TABLE |
WDT_PROSPECT_ATTRIBUTE |
SYSTEM_LOAD_PROCESS |
MANAGE PROSPECT PIPELINE, PROSPECT |
NO |
| 'PROSPECT_D1B' |
NO |
DIMENSION TABLE |
WDT_PROSPECT |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, ASSIGNMENT, CONSTITUENT EVALUATION, CONTACT REPORT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, PROSPECT STAGE |
NO |
| 'PROSPECT_SHARED_ATTRIBUTE_D1B' |
NO |
DIMENSION TABLE |
WDT_PROSPECT_SHARED_ATTRIBUTE |
SYSTEM_LOAD_PROCESS |
MANAGE PROSPECT PIPELINE, PROSPECT |
NO |
| 'PROSPECT_STAGE_F1B' |
NO |
FACT TABLE |
WFT_PROSPECT_STAGE |
SYSTEM_LOAD_PROCESS |
PROSPECT STAGE |
NO |
| 'RELATIONSHIP_D1B' |
NO |
DIMENSION TABLE |
WDT_RELATIONSHIP |
SYSTEM_LOAD_PROCESS |
CONSTITUENT EMPLOYMENT, RELATIONSHIP |
NO |
| 'RQPP_ENTITY_A1' |
NO |
AGGREGATE FACT TABLE |
WAT_RQPP_ENTITY |
SYSTEM_LOAD_PROCESS |
RQPP ENTITY |
NO |
| 'SPECIAL_PURPOSE_D1B' |
NO |
DIMENSION TABLE |
WDT_SPECIAL_PURPOSE |
SYSTEM_LOAD_PROCESS |
SPECIAL PURPOSE |
NO |
| 'SPECIAL_PURPOSE_F1B' |
NO |
FACT TABLE |
WFT_SPECIAL_PURPOSE |
SYSTEM_LOAD_PROCESS |
SPECIAL PURPOSE |
NO |
| 'SPECIAL_PURPOSE_TYPE_D1B' |
NO |
DIMENSION TABLE |
WDT_SPECIAL_PURPOSE_TYPE |
SYSTEM_LOAD_PROCESS |
SPECIAL PURPOSE |
NO |
| 'STAFF_D1B' |
NO |
DIMENSION TABLE |
WDT_STAFF |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, ASSIGNMENT, COMMITTEE, CONSTITUENT EVALUATION, CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE, PROSPECT |
NO |
| 'STAGE_D1B' |
NO |
DIMENSION TABLE |
WDT_STAGE |
SYSTEM_LOAD_PROCESS |
MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT INTEREST, PROSPECT STAGE |
NO |
| 'STREET_ADDRESS_D1B' |
NO |
DIMENSION TABLE |
WDT_STREET_ADDRESS |
SYSTEM_LOAD_PROCESS |
ADDRESS, ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE |
NO |
| 'VARIABLE_PURPOSE_D1B' |
NO |
DIMENSION TABLE |
WDT_VARIABLE_PURPOSE |
SYSTEM_LOAD_PROCESS |
VARIABLE PURPOSE |
NO |
| 'VARIABLE_PURPOSE_F1B' |
NO |
FACT TABLE |
WFT_VARIABLE_PURPOSE |
SYSTEM_LOAD_PROCESS |
VARIABLE PURPOSE |
NO |
| 'YEAR_OF_GIVING_D1B' |
NO |
DIMENSION TABLE |
WDT_YEAR_OF_GIVING |
SYSTEM_LOAD_PROCESS |
ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION |
NO |