SGHE Enterprise Data Warehouse
Banner EDW Source: ADBDESG - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ADBDESG_ACCI_CODE |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING GIFT PLEDGE |
GIFT_ACCOUNT_INDEX DESG_ACCOUNT_INDEX DESG_ACCOUNT_INDEX |
NA NA NA |
NO NO NO |
| ADBDESG_ACCI_CODE_EXPND |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
EXPEND_ACCOUNT_INDEX |
NA |
NO |
| ADBDESG_ACCI_CODE_PLDG |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PLEDGE_ACCOUNT_INDEX |
NA |
NO |
| ADBDESG_ACCI_CODE_PYMNT |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PAYMENT_ACCOUNT_INDEX |
NA |
NO |
| ADBDESG_ACCT_CODE |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING GIFT PLEDGE |
GIFT_ACCOUNT DESG_ACCOUNT DESG_ACCOUNT |
NA NA NA |
NO NO NO |
| ADBDESG_ACCT_CODE_EXPND |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
EXPEND_ACCOUNT |
NA |
NO |
| ADBDESG_ACCT_CODE_PLDG |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PLEDGE_ACCOUNT |
NA |
NO |
| ADBDESG_ACCT_CODE_PYMNT |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PAYMENT_ACCOUNT |
NA |
NO |
| ADBDESG_ACTIVITY_DATE |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING DESIGNATION |
ACTIVITY_DATE ACTIVITY_DATE |
NA NA |
NO NO |
| ADBDESG_ACTV_CODE |
NO |
REPORTING VIEW |
GIFT PLEDGE DESIGNATION_ACCOUNTING |
DESG_ACTIVITY DESG_ACTIVITY GIFT_ACTIVITY |
NA NA NA |
NO NO NO |
| ADBDESG_ACTV_CODE_EXPND |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
EXPEND_ACTIVITY |
NA |
NO |
| ADBDESG_ACTV_CODE_PLDG |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PLEDGE_ACTIVITY |
NA |
NO |
| ADBDESG_ACTV_CODE_PYMNT |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PAYMENT_ACTIVITY |
NA |
NO |
| ADBDESG_CFAE_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION_DETAIL CAMPAIGN_DESIGNATION GIFT_MULTIPLE PLEDGE PLEDGE_MATCHING GIFT GIFT_MATCHING GIFT_MEMO DESIGNATION_GIVING_HISTORY |
CAE_PURPOSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE |
ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO |
| ADBDESG_COAS_CODE |
NO |
REPORTING VIEW |
PLEDGE GIFT DESIGNATION_ACCOUNTING |
DESG_CHART_OF_ACCOUNT DESG_CHART_OF_ACCOUNT GIFT_CHART_OF_ACCOUNTS |
NA NA NA |
NO NO NO |
| ADBDESG_COAS_CODE_EXPND |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
EXPEND_CHART_OF_ACCOUNTS |
NA |
NO |
| ADBDESG_COAS_CODE_PLDG |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PLEDGE_CHART_OF_ACCOUNTS |
NA |
NO |
| ADBDESG_COAS_CODE_PYMNT |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PAYMENT_CHART_OF_ACCOUNTS |
NA |
NO |
| ADBDESG_COLL_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION DESIGNATION_GIVING_HISTORY GIFT GIFT_MEMO DESIGNATION DESIGNATION_GIVING_HISTORY GIFT_MULTIPLE PLEDGE PLEDGE_MATCHING GIFT_MATCHING |
DESIGNATION_COLLEGE DESG_GROUP_DESC DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE |
ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE NA NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO |
| ADBDESG_DEPT_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION DESIGNATION PLEDGE GIFT_MATCHING GIFT PLEDGE_MATCHING |
DESIGNATION_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT |
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE NA NA NA NA NA |
NO NO NO NO NO NO |
| ADBDESG_DESG |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION_DETAIL DESIGNATION_ACCOUNTING DESIGNATION |
DESIGNATION DESIGNATION DESIGNATION |
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE NA NA |
NO NO NO |
| ADBDESG_DGRP_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION DESIGNATION_COMMENT DESIGNATION_ADJUSTMENT DESIGNATION_CLASS_YEAR PLEDGE_MATCHING DESIGNATION_ID CAMPAIGN_DESIGNATION GIFT_MATCHING DESIGNATION_FINAID_FUND DESIGNATION_GIVING_HISTORY DESIGNATION_ACCOUNTING DESIGNATION_ATTRIBUTE GIFT PLEDGE |
DESIGNATION_PURPOSE DESG_GROUP DESG_GROUP DESG_GROUP DESG_GROUP DESG_GROUP DESG_GROUP DESG_GROUP DESG_GROUP DESG_GROUP DESG_GROUP DESG_GROUP DESG_GROUP DESG_GROUP |
ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE NA NA NA NA NA NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| ADBDESG_DSTA_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION_DETAIL GIFT_MATCHING PLEDGE_MATCHING GIFT DESIGNATION PLEDGE |
DESIGNATION_STATUS DESG_STATUS DESG_STATUS DESG_STATUS DESG_STATUS DESG_STATUS |
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE NA NA NA NA NA |
NO NO NO NO NO NO |
| ADBDESG_DSTP_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL PLEDGE DESIGNATION_ACCOUNTING CAMPAIGN_DESIGNATION DESIGNATION_ADJUSTMENT GIFT DESIGNATION_ATTRIBUTE DESIGNATION_CLASS_YEAR DESIGNATION_COMMENT DESIGNATION_FINAID_FUND DESIGNATION_ID GIFT_MATCHING GIFT_MEMO GIFT_MULTIPLE DESIGNATION_GIVING_HISTORY PLEDGE_MATCHING |
DESIGNATION_TYPE DESIGNATION_SORT DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE DESG_TYPE |
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| ADBDESG_END_DATE |
NO |
REPORTING VIEW |
DESIGNATION |
DESIGNATION_END_DATE |
NA |
NO |
| ADBDESG_FUND_CODE |
NO |
REPORTING VIEW |
GIFT DESIGNATION_ACCOUNTING |
DESG_FUND GIFT_FUND |
NA NA |
NO NO |
| ADBDESG_FUND_CODE_EXPND |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
EXPEND_FUND |
NA |
NO |
| ADBDESG_FUND_CODE_PLDG |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING PLEDGE |
PLEDGE_FUND DESG_FUND |
NA NA |
NO NO |
| ADBDESG_FUND_CODE_PYMNT |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PAYMENT_FUND |
NA |
NO |
| ADBDESG_GL_NO_CREDIT |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING PLEDGE GIFT |
GIFT_EXTERNAL_ACCOUNT DESG_GENERAL_LEDGER_NUMBER DESG_GENERAL_LEDGER_NUMBER |
NA NA NA |
NO NO NO |
| ADBDESG_GL_NO_CREDIT_EXPND |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
EXPENDITURE_EXTERNAL_ACCOUNT |
NA |
NO |
| ADBDESG_GL_NO_CREDIT_PLDG |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PLEDGE_EXTERNAL_ACCOUNT |
NA |
NO |
| ADBDESG_GL_NO_CREDIT_PYMNT |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PAYMENT_EXTERNAL_ACCOUNT |
NA |
NO |
| ADBDESG_LOCN_CODE |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING GIFT PLEDGE |
GIFT_LOCATION DESG_LOCATION DESG_LOCATION |
NA NA NA |
NO NO NO |
| ADBDESG_LOCN_CODE_EXPND |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
EXPEND_LOCATION |
NA |
NO |
| ADBDESG_LOCN_CODE_PLDG |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PLEDGE_LOCATION |
NA |
NO |
| ADBDESG_LOCN_CODE_PYMNT |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PAYMENT_LOCATION |
NA |
NO |
| ADBDESG_NAME |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL DESIGNATION_FINAID_FUND PLEDGE_MATCHING DESIGNATION_CLASS_YEAR PROSPECT_PROPOSAL_RESULT DESIGNATION_ATTRIBUTE GIFT DESIGNATION_ADJUSTMENT DESIGNATION_COMMENT CAMPAIGN_DESIGNATION DESIGNATION_ACCOUNTING GIFT_MULTIPLE DESIGNATION_COMMENT_SUBJ DESIGNATION_ID GIFT_MATCHING GIFT_MEMO DESIGNATION_GIVING_HISTORY PLEDGE |
DESIGNATION_LD DESIGNATION_SD DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME PROPOSAL_RESULT_DESG_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME |
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| ADBDESG_ORGN_CODE |
NO |
REPORTING VIEW |
GIFT DESIGNATION_ACCOUNTING PLEDGE |
DESG_ORGANIZATION GIFT_ORGANIZATION DESG_ORGANIZATION |
NA NA NA |
NO NO NO |
| ADBDESG_ORGN_CODE_EXPND |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
EXPEND_ORGANIZATION |
NA |
NO |
| ADBDESG_ORGN_CODE_PLDG |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PLEDGE_ORGANIZATION |
NA |
NO |
| ADBDESG_ORGN_CODE_PYMNT |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PAYMENT_ORGANIZATION |
NA |
NO |
| ADBDESG_PROG_CODE |
NO |
REPORTING VIEW |
PLEDGE DESIGNATION_ACCOUNTING GIFT |
DESG_PROGRAM GIFT_PROGRAM DESG_PROGRAM |
NA NA NA |
NO NO NO |
| ADBDESG_PROG_CODE_EXPND |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
EXPEND_PROGRAM |
NA |
NO |
| ADBDESG_PROG_CODE_PLDG |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PLEDGE_PROGRAM |
NA |
NO |
| ADBDESG_PROG_CODE_PYMNT |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING |
PAYMENT_PROGRAM |
NA |
NO |
| ADBDESG_RESTR_IND |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL DESIGNATION GIFT CAMPAIGN_DESIGNATION |
DESIGNATION_RESTRICTED_IND DESIGNATION_RESTRICTED_IND_SD DESIGNATION_RESTRICTED_IND_LD RESTRICTED_IND RESTRICTED_IND RESTRICTED_IND |
ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT NA NA NA |
NO NO NO NO NO NO |
| ADBDESG_START_DATE |
NO |
REPORTING VIEW |
DESIGNATION |
DESIGNATION_START_DATE |
NA |
NO |
| ADBDESG_USER |
NO |
REPORTING VIEW |
DESIGNATION_ACCOUNTING DESIGNATION |
DESIGNATION_USER_ID DESIGNATION_USER_ID |
NA NA |
NO NO |