SGHE Enterprise Data Warehouse
Banner EDW Source: EXPRESSIONS - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ASIAN_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
ASIAN_IND |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| BLACK_OR_AFRICAN_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
BLACK_OR_AFRICAN_IND |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| CITIZENSHIP_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
CITIZENSHIP_IND |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| DECEASED_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
DECEASED_IND |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| FIRST_PROPOSAL_RESULT_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_PROPOSAL |
FIRST_PROPOSAL_RESULT_DATE |
PROPOSAL |
NO |
| GENDER_LD_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
GENDER_LD |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| GENDER_SD_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
GENDER_SD |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| HOME_INSTITUTION_IND_EXPRESSION |
NO |
FACT TABLE |
WFT_ADVANCEMENT_DEGREE |
HOME_INSTITUTION_IND |
ADVANCEMENT DEGREE |
NO |
| LATEST_PROPOSAL_ASK_AMOUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_PROPOSAL |
LATEST_PROPOSAL_ASK_AMOUNT |
PROPOSAL |
NO |
| LATEST_PROPOSAL_ASK_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_PROPOSAL |
LATEST_PROPOSAL_ASK_DATE |
PROPOSAL |
NO |
| LIFETIME_GIFT_SOCIETY_IND_EXPRESSION |
NO |
FACT TABLE |
WFT_GIFT_SOCIETY |
LIFETIME_GIFT_SOCIETY_IND |
GIFT SOCIETY |
NO |
| MINORITY_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
MINORITY_IND |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| NON_RESIDENT_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
NON_RESIDENT_IND |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| PACIFIC_ISLANDER_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
PACIFIC_ISLANDER_IND |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| PRIMARY_DISABILITY_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
PRIMARY_DISABILITY |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| PRIMARY_DISABILITY_LD_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
PRIMARY_DISABILITY_LD |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| PRIMARY_DISABILITY_SD_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
PRIMARY_DISABILITY_SD |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| PROFILE_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_CONSTITUENT_PROFILE |
PROFILE_DATE |
CONSTITUENT PROFILE |
NO |
| PROPOSAL_ASK_AMOUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_PROPOSAL |
PROPOSAL_ASK_AMOUNT |
PROPOSAL |
NO |
| PROPOSAL_ASK_MADE_IND_EXPRESSION |
NO |
FACT TABLE |
WFT_PROPOSAL |
PROPOSAL_ASK_MADE_IND |
PROPOSAL |
NO |
| PROPOSAL_ASSIGNED_IND_EXPRESSION |
NO |
FACT TABLE |
WFT_PROPOSAL |
PROPOSAL_ASSIGNED_IND |
PROPOSAL |
NO |
| PROPOSAL_DURATION_EXPRESSION |
NO |
FACT TABLE |
WFT_PROPOSAL |
PROPOSAL_DURATION |
PROPOSAL |
NO |
| PROPOSAL_START_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_PROPOSAL |
PROPOSAL_START_DATE |
PROPOSAL |
NO |
| PROPOSAL_STOP_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_PROPOSAL |
PROPOSAL_STOP_DATE |
PROPOSAL |
NO |
| PROPOSAL_TARGET_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_PROPOSAL |
PROPOSAL_TARGET_DATE |
PROPOSAL |
NO |
| PROPOSAL_TOTAL_RESULT_AMOUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_PROPOSAL |
PROPOSAL_TOTAL_RESULT_AMOUNT |
PROPOSAL |
NO |
| PROSPECT_INT_ACTIVE_IND_EXPRESSION |
NO |
FACT TABLE |
WFT_PROSPECT_INTEREST |
PROSPECT_INT_ACTIVE_IND |
PROSPECT INTEREST |
NO |
| PROSPECT_INT_ASK_AMOUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_PROSPECT_INTEREST |
PROSPECT_INT_ASK_AMOUNT |
PROSPECT INTEREST |
NO |
| PROSPECT_INT_END_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_PROSPECT_INTEREST |
PROSPECT_INT_END_DATE |
PROSPECT INTEREST |
NO |
| PROSPECT_INT_LATEST_ASK_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_PROSPECT_INTEREST |
PROSPECT_INT_LATEST_ASK_DATE |
PROSPECT INTEREST |
NO |
| PROSPECT_INT_LATEST_ASK_EXPRESSION |
NO |
FACT TABLE |
WFT_PROSPECT_INTEREST |
PROSPECT_INT_LATEST_ASK |
PROSPECT INTEREST |
NO |
| PROSPECT_INT_START_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_PROSPECT_INTEREST |
PROSPECT_INT_START_DATE |
PROSPECT INTEREST |
NO |
| PROSPECT_INT_STATUS_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_PROSPECT_INTEREST |
PROSPECT_INT_STATUS_DATE |
PROSPECT INTEREST |
NO |
| PROSPECT_INT_TARGET_AMOUNT_EXPRESSION |
NO |
FACT TABLE |
WFT_PROSPECT_INTEREST |
PROSPECT_INT_TARGET_AMOUNT |
PROSPECT INTEREST |
NO |
| PROSPECT_INT_TARGET_DATE_EXPRESSION |
NO |
FACT TABLE |
WFT_PROSPECT_INTEREST |
PROSPECT_INT_TARGET_DATE |
PROSPECT INTEREST |
NO |
| RACE_ETHNICITY_CONFIRM_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
RACE_ETHNICITY_CONFIRM_IND |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| RACE_ETHNICITY_UNKNOWN_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
RACE_ETHNICITY_UNKNOWN_IND |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| TWO_OR_MORE_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
TWO_OR_MORE_IND |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| VETERAN_CATEGORY_LD_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
VETERAN_CATEGORY_LD |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| VETERAN_CATEGORY_SD_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
VETERAN_CATEGORY_SD |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |
| WHITE_IND_EXPRESSION |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
WHITE_IND |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY |
NO |