Reporting View Source: ADBDESG

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: ADBDESG Advancement Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
ADBDESG_ACCI_CODE	ADADESG	DESIGNATION_ACCOUNTING GIFT PLEDGE	GIFT_ACCOUNT_INDEX DESG_ACCOUNT_INDEX DESG_ACCOUNT_INDEX
ADBDESG_ACCI_CODE_EXPND	ADADESG	DESIGNATION_ACCOUNTING	EXPEND_ACCOUNT_INDEX
ADBDESG_ACCI_CODE_PLDG	ADADESG	DESIGNATION_ACCOUNTING	PLEDGE_ACCOUNT_INDEX
ADBDESG_ACCI_CODE_PYMNT	ADADESG	DESIGNATION_ACCOUNTING	PAYMENT_ACCOUNT_INDEX
ADBDESG_ACCT_CODE	ADADESG	DESIGNATION_ACCOUNTING GIFT PLEDGE	GIFT_ACCOUNT DESG_ACCOUNT DESG_ACCOUNT
ADBDESG_ACCT_CODE_EXPND	ADADESG	DESIGNATION_ACCOUNTING	EXPEND_ACCOUNT
ADBDESG_ACCT_CODE_PLDG	ADADESG	DESIGNATION_ACCOUNTING	PLEDGE_ACCOUNT
ADBDESG_ACCT_CODE_PYMNT	ADADESG	DESIGNATION_ACCOUNTING	PAYMENT_ACCOUNT
ADBDESG_ACTIVITY_DATE	ADADESG	DESIGNATION DESIGNATION_ACCOUNTING	ACTIVITY_DATE ACTIVITY_DATE
ADBDESG_ACTV_CODE	ADADESG	DESIGNATION_ACCOUNTING PLEDGE GIFT	GIFT_ACTIVITY DESG_ACTIVITY DESG_ACTIVITY
ADBDESG_ACTV_CODE_EXPND	ADADESG	DESIGNATION_ACCOUNTING	EXPEND_ACTIVITY
ADBDESG_ACTV_CODE_PLDG	ADADESG	DESIGNATION_ACCOUNTING	PLEDGE_ACTIVITY
ADBDESG_ACTV_CODE_PYMNT	ADADESG	DESIGNATION_ACCOUNTING	PAYMENT_ACTIVITY
ADBDESG_CFAE_CODE	ADADESG	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
ADBDESG_COAS_CODE	ADADESG	DESIGNATION_ACCOUNTING GIFT PLEDGE	GIFT_CHART_OF_ACCOUNTS DESG_CHART_OF_ACCOUNT DESG_CHART_OF_ACCOUNT
ADBDESG_COAS_CODE_EXPND	ADADESG	DESIGNATION_ACCOUNTING	EXPEND_CHART_OF_ACCOUNTS
ADBDESG_COAS_CODE_PLDG	ADADESG	DESIGNATION_ACCOUNTING	PLEDGE_CHART_OF_ACCOUNTS
ADBDESG_COAS_CODE_PYMNT	ADADESG	DESIGNATION_ACCOUNTING	PAYMENT_CHART_OF_ACCOUNTS
ADBDESG_COLL_CODE	ADADESG	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
ADBDESG_DEPT_CODE	ADADESG	PLEDGE GIFT DESIGNATION PLEDGE_MATCHING GIFT_MATCHING	DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT
ADBDESG_DESG	ADADESG	DESIGNATION DESIGNATION_ACCOUNTING	DESIGNATION DESIGNATION
ADBDESG_DGRP_CODE	ADADESG	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
ADBDESG_DSTA_CODE	ADADESG	PLEDGE GIFT DESIGNATION GIFT_MATCHING PLEDGE_MATCHING	DESG_STATUS DESG_STATUS DESG_STATUS DESG_STATUS DESG_STATUS
ADBDESG_DSTP_CODE	ADADESG	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	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
ADBDESG_END_DATE	ADADESG	DESIGNATION	DESIGNATION_END_DATE
ADBDESG_FUND_CODE	ADADESG	GIFT PLEDGE DESIGNATION_ACCOUNTING	DESG_FUND DESG_FUND GIFT_FUND
ADBDESG_FUND_CODE_EXPND	ADADESG	DESIGNATION_ACCOUNTING	EXPEND_FUND
ADBDESG_FUND_CODE_PLDG	ADADESG	DESIGNATION_ACCOUNTING	PLEDGE_FUND
ADBDESG_FUND_CODE_PYMNT	ADADESG	DESIGNATION_ACCOUNTING	PAYMENT_FUND
ADBDESG_GL_NO_CREDIT	ADADESG	GIFT PLEDGE DESIGNATION_ACCOUNTING	DESG_GENERAL_LEDGER_NUMBER DESG_GENERAL_LEDGER_NUMBER GIFT_EXTERNAL_ACCOUNT
ADBDESG_GL_NO_CREDIT_EXPND	ADADESG	DESIGNATION_ACCOUNTING	EXPENDITURE_EXTERNAL_ACCOUNT
ADBDESG_GL_NO_CREDIT_PLDG	ADADESG	DESIGNATION_ACCOUNTING	PLEDGE_EXTERNAL_ACCOUNT
ADBDESG_GL_NO_CREDIT_PYMNT	ADADESG	DESIGNATION_ACCOUNTING	PAYMENT_EXTERNAL_ACCOUNT
ADBDESG_LOCN_CODE	ADADESG	DESIGNATION_ACCOUNTING PLEDGE GIFT	GIFT_LOCATION DESG_LOCATION DESG_LOCATION
ADBDESG_LOCN_CODE_EXPND	ADADESG	DESIGNATION_ACCOUNTING	EXPEND_LOCATION
ADBDESG_LOCN_CODE_PLDG	ADADESG	DESIGNATION_ACCOUNTING	PLEDGE_LOCATION
ADBDESG_LOCN_CODE_PYMNT	ADADESG	DESIGNATION_ACCOUNTING	PAYMENT_LOCATION
ADBDESG_NAME	ADADESG	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 CAMPAIGN_DESIGNATION DESIGNATION_CLASS_YEAR	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 DESIGNATION_NAME DESIGNATION_NAME
ADBDESG_ORGN_CODE	ADADESG	DESIGNATION_ACCOUNTING GIFT PLEDGE	GIFT_ORGANIZATION DESG_ORGANIZATION DESG_ORGANIZATION
ADBDESG_ORGN_CODE_EXPND	ADADESG	DESIGNATION_ACCOUNTING	EXPEND_ORGANIZATION
ADBDESG_ORGN_CODE_PLDG	ADADESG	DESIGNATION_ACCOUNTING	PLEDGE_ORGANIZATION
ADBDESG_ORGN_CODE_PYMNT	ADADESG	DESIGNATION_ACCOUNTING	PAYMENT_ORGANIZATION
ADBDESG_PROG_CODE	ADADESG	GIFT PLEDGE DESIGNATION_ACCOUNTING	DESG_PROGRAM DESG_PROGRAM GIFT_PROGRAM
ADBDESG_PROG_CODE_EXPND	ADADESG	DESIGNATION_ACCOUNTING	EXPEND_PROGRAM
ADBDESG_PROG_CODE_PLDG	ADADESG	DESIGNATION_ACCOUNTING	PLEDGE_PROGRAM
ADBDESG_PROG_CODE_PYMNT	ADADESG	DESIGNATION_ACCOUNTING	PAYMENT_PROGRAM
ADBDESG_RESTR_IND	ADADESG	GIFT CAMPAIGN_DESIGNATION	RESTRICTED_IND RESTRICTED_IND
ADBDESG_START_DATE	ADADESG	DESIGNATION	DESIGNATION_START_DATE
ADBDESG_USER	ADADESG	DESIGNATION DESIGNATION_ACCOUNTING	DESIGNATION_USER_ID DESIGNATION_USER_ID

Ver: 8.3