Banner EDW Source: ADBDESG

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
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 DESIGNATION_ACCOUNTING	ACTIVITY_DATE ACTIVITY_DATE	NA NA	NO NO
ADBDESG_ACTV_CODE	NO	REPORTING VIEW	DESIGNATION_ACCOUNTING PLEDGE GIFT	GIFT_ACTIVITY DESG_ACTIVITY DESG_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	REPORTING VIEW	DESIGNATION_GIVING_HISTORY DESIGNATION PLEDGE GIFT_MATCHING CAMPAIGN_DESIGNATION GIFT_MULTIPLE GIFT PLEDGE_MATCHING GIFT_MEMO	DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE	NA NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO
ADBDESG_COAS_CODE	NO	REPORTING VIEW	DESIGNATION_ACCOUNTING GIFT PLEDGE	GIFT_CHART_OF_ACCOUNTS DESG_CHART_OF_ACCOUNT DESG_CHART_OF_ACCOUNT	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	REPORTING VIEW	DESIGNATION_GIVING_HISTORY DESIGNATION_GIVING_HISTORY GIFT GIFT_MEMO GIFT_MULTIPLE PLEDGE_MATCHING PLEDGE DESIGNATION GIFT_MATCHING	DESG_GROUP_DESC DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE	NA NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO
ADBDESG_DEPT_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_DESIGNATION PLEDGE GIFT DESIGNATION PLEDGE_MATCHING GIFT_MATCHING	DESIGNATION_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT	ADVANCEMENT GIFT NA NA NA NA NA	NO NO NO NO NO NO
ADBDESG_DESG	NO	DIMENSION TABLE REPORTING VIEW	WDT_DESIGNATION_DETAIL DESIGNATION DESIGNATION_ACCOUNTING	DESIGNATION DESIGNATION DESIGNATION	ADVANCEMENT GIFT NA NA	NO NO NO
ADBDESG_DGRP_CODE	NO	REPORTING VIEW	CAMPAIGN_DESIGNATION DESIGNATION_ADJUSTMENT DESIGNATION_COMMENT DESIGNATION_FINAID_FUND DESIGNATION_CLASS_YEAR PLEDGE DESIGNATION_ACCOUNTING GIFT_MATCHING PLEDGE_MATCHING GIFT DESIGNATION_ATTRIBUTE DESIGNATION_GIVING_HISTORY DESIGNATION_ID	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	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
ADBDESG_DSTA_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_DESIGNATION_DETAIL PLEDGE GIFT DESIGNATION GIFT_MATCHING PLEDGE_MATCHING	DESIGNATION_STATUS DESG_STATUS DESG_STATUS DESG_STATUS DESG_STATUS DESG_STATUS	ADVANCEMENT GIFT 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 CAMPAIGN_DESIGNATION DESIGNATION_ADJUSTMENT DESIGNATION_CLASS_YEAR DESIGNATION_COMMENT GIFT_MULTIPLE PLEDGE_MATCHING DESIGNATION_ACCOUNTING DESIGNATION_ATTRIBUTE GIFT_MATCHING DESIGNATION_FINAID_FUND DESIGNATION_GIVING_HISTORY GIFT_MEMO DESIGNATION_ID GIFT PLEDGE	DESIGNATION_SORT DESIGNATION_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 DESG_TYPE	ADVANCEMENT GIFT ADVANCEMENT GIFT 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 PLEDGE DESIGNATION_ACCOUNTING	DESG_FUND DESG_FUND GIFT_FUND	NA NA NA	NO 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_FUND	NA	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	DESIGNATION_ACCOUNTING PLEDGE GIFT	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_ID DESIGNATION DESIGNATION_ADJUSTMENT DESIGNATION_COMMENT_SUBJ PLEDGE DESIGNATION_ACCOUNTING DESIGNATION_ATTRIBUTE DESIGNATION_COMMENT GIFT_MEMO DESIGNATION_GIVING_HISTORY DESIGNATION_FINAID_FUND GIFT GIFT_MATCHING GIFT_MULTIPLE PLEDGE_MATCHING PROSPECT_PROPOSAL_RESULT CAMPAIGN_DESIGNATION DESIGNATION_CLASS_YEAR	DESIGNATION_LD DESIGNATION_SD 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 DESIGNATION_NAME DESIGNATION_NAME PROPOSAL_RESULT_DESG_NAME DESIGNATION_NAME DESIGNATION_NAME	ADVANCEMENT GIFT ADVANCEMENT GIFT NA 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 NO
ADBDESG_ORGN_CODE	NO	REPORTING VIEW	DESIGNATION_ACCOUNTING GIFT PLEDGE	GIFT_ORGANIZATION DESG_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	GIFT PLEDGE DESIGNATION_ACCOUNTING	DESG_PROGRAM DESG_PROGRAM GIFT_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 DESIGNATION_RESTRICTED_IND_SD 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 DESIGNATION_ACCOUNTING	DESIGNATION_USER_ID DESIGNATION_USER_ID	NA NA	NO NO

Ver: 8.4.3