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 |
GIFT PLEDGE DESIGNATION_ACCOUNTING |
DESG_ACCOUNT DESG_ACCOUNT GIFT_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 |
PLEDGE GIFT 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 GIFT_MEMO DESIGNATION GIFT_MATCHING CAMPAIGN_DESIGNATION GIFT_MULTIPLE DESIGNATION_GIVING_HISTORY GIFT PLEDGE PLEDGE_MATCHING |
CAE_PURPOSE DESG_VSE 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 NA |
NO 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 GIFT_MULTIPLE DESIGNATION_GIVING_HISTORY GIFT PLEDGE GIFT_MATCHING DESIGNATION PLEDGE_MATCHING DESIGNATION_GIVING_HISTORY GIFT_MEMO |
DESIGNATION_COLLEGE DESG_COLLEGE DESG_GROUP_DESC 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 GIFT PLEDGE GIFT_MATCHING 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 DESIGNATION_CLASS_YEAR GIFT_MATCHING PLEDGE_MATCHING DESIGNATION_ATTRIBUTE GIFT PLEDGE DESIGNATION_ID DESIGNATION_ACCOUNTING DESIGNATION_COMMENT DESIGNATION_ADJUSTMENT DESIGNATION_FINAID_FUND CAMPAIGN_DESIGNATION DESIGNATION_GIVING_HISTORY |
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 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 NA |
NO 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 GIFT_MATCHING DESIGNATION PLEDGE_MATCHING 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 DESIGNATION_CLASS_YEAR DESIGNATION_ADJUSTMENT DESIGNATION_GIVING_HISTORY DESIGNATION_FINAID_FUND CAMPAIGN_DESIGNATION DESIGNATION_ACCOUNTING PLEDGE DESIGNATION_ID GIFT_MATCHING DESIGNATION_ATTRIBUTE GIFT_MEMO DESIGNATION_COMMENT GIFT_MULTIPLE GIFT 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 |
DESIGNATION_ACCOUNTING GIFT |
GIFT_FUND DESG_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 |
GIFT PLEDGE DESIGNATION_ACCOUNTING |
DESG_GENERAL_LEDGER_NUMBER DESG_GENERAL_LEDGER_NUMBER GIFT_EXTERNAL_ACCOUNT |
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 |
GIFT PLEDGE DESIGNATION_ACCOUNTING |
DESG_LOCATION DESG_LOCATION GIFT_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 GIFT_MATCHING GIFT_MULTIPLE DESIGNATION_COMMENT GIFT_MEMO PLEDGE PLEDGE_MATCHING CAMPAIGN_DESIGNATION GIFT PROSPECT_PROPOSAL_RESULT DESIGNATION_GIVING_HISTORY DESIGNATION_ACCOUNTING DESIGNATION_FINAID_FUND DESIGNATION_ID DESIGNATION_ADJUSTMENT DESIGNATION_ATTRIBUTE DESIGNATION_CLASS_YEAR DESIGNATION_COMMENT_SUBJ |
DESIGNATION_SD DESIGNATION_LD DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME DESIGNATION_NAME 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 |
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 |
PLEDGE DESIGNATION_ACCOUNTING GIFT |
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 |
DESIGNATION_ACCOUNTING PLEDGE GIFT |
GIFT_PROGRAM DESG_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 GIFT CAMPAIGN_DESIGNATION |
DESIGNATION_RESTRICTED_IND_LD DESIGNATION_RESTRICTED_IND_SD DESIGNATION_RESTRICTED_IND RESTRICTED_IND RESTRICTED_IND |
ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT NA NA |
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 |