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

Ver: 9.0