SGHE Enterprise Data Warehouse
Banner EDW Source: AMRPRIN - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| AMRPRIN_ACTIVITY_DATE |
NO |
REPORTING VIEW |
PROJECT_INTEREST |
ACTIVITY_DATE |
NA |
NO |
| AMRPRIN_GIVH_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_FUNDRAISING_INITIATIVE FUNDING_INTEREST PROJECT_INTEREST |
PROJECT_GIVING_VEHICLE GIVING_VEHICLE GIVING_VEHICLE |
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 NA NA |
NO NO NO |
| AMRPRIN_PIDM |
NO |
REPORTING VIEW |
FUNDING_INTEREST_SLOT PROJECT_INTEREST FUNDING_INTEREST |
ENTITY_UID ENTITY_UID ENTITY_UID |
NA NA NA |
NO NO NO |
| AMRPRIN_PROJ_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_FUNDRAISING_INITIATIVE WDT_FUNDRAISING_INITIATIVE PROJECT_INTEREST |
PROPOSAL_PURPOSE ADVANCEMENT_INTEREST PROJECT |
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 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 NA |
NO NO NO |
| AMRPRIN_PROJ_EFF_FROM_DATE |
NO |
REPORTING VIEW |
PROJECT_INTEREST |
PROJECT_START_DATE |
NA |
NO |
| AMRPRIN_PROJ_EFF_TO_DATE |
NO |
REPORTING VIEW |
PROJECT_INTEREST |
PROJECT_END_DATE |
NA |
NO |
| AMRPRIN_PROJ_TEXT |
NO |
REPORTING VIEW |
FUNDING_INTEREST PROJECT_INTEREST |
PROJECT_COMMENT PROJECT_COMMENT |
NA NA |
NO NO |
| AMRPRIN_PRST_CODE |
NO |
REPORTING VIEW |
FUNDING_INTEREST PROJECT_INTEREST |
PROJECT_STATUS PROJECT_STATUS |
NA NA |
NO NO |
| AMRPRIN_PRST_DATE |
NO |
REPORTING VIEW |
PROJECT_INTEREST FUNDING_INTEREST |
PROJECT_STATUS_DATE PROJECT_STATUS_DATE |
NA NA |
NO NO |
| AMRPRIN_TARGET_ASK_AMT |
NO |
REPORTING VIEW |
PROJECT_INTEREST FUNDING_INTEREST |
PROJECT_TARGET_ASK_AMOUNT TARGET_ASK_AMOUNT |
NA NA |
NO NO |
| AMRPRIN_TARGET_ASK_DATE |
NO |
REPORTING VIEW |
PROJECT_INTEREST FUNDING_INTEREST |
PROJECT_TARGET_ASK_DATE TARGET_ASK_DATE |
NA NA |
NO NO |
| AMRPRIN_USER |
NO |
REPORTING VIEW |
PROJECT_INTEREST |
LAST_UPDATE_USER_ID |
NA |
NO |