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	GIFT PLEDGE DESIGNATION_ACCOUNTING	DESG_ACCOUNT DESG_ACCOUNT GIFT_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_ACCOUNTING DESIGNATION	ACTIVITY_DATE ACTIVITY_DATE
ADBDESG_ACTV_CODE	ADADESG	REPORTING VIEW	PLEDGE GIFT DESIGNATION_ACCOUNTING	DESG_ACTIVITY DESG_ACTIVITY GIFT_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		REPORTING VIEW	DESIGNATION GIFT_MEMO CAMPAIGN_DESIGNATION GIFT_MATCHING GIFT_MULTIPLE DESIGNATION_GIVING_HISTORY GIFT PLEDGE PLEDGE_MATCHING	DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE DESG_VSE
ADBDESG_COAS_CODE	ADADESG	REPORTING VIEW	PLEDGE GIFT DESIGNATION_ACCOUNTING	DESG_CHART_OF_ACCOUNT DESG_CHART_OF_ACCOUNT GIFT_CHART_OF_ACCOUNTS	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		REPORTING VIEW	DESIGNATION_GIVING_HISTORY GIFT_MULTIPLE GIFT PLEDGE DESIGNATION GIFT_MATCHING PLEDGE_MATCHING DESIGNATION_GIVING_HISTORY GIFT_MEMO	DESG_GROUP_DESC DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE DESG_COLLEGE
ADBDESG_DEPT_CODE		REPORTING VIEW	DESIGNATION GIFT PLEDGE GIFT_MATCHING PLEDGE_MATCHING	DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT
ADBDESG_DESG		REPORTING VIEW	DESIGNATION_ACCOUNTING DESIGNATION	DESIGNATION DESIGNATION
ADBDESG_DGRP_CODE		REPORTING VIEW	DESIGNATION DESIGNATION_CLASS_YEAR DESIGNATION_ATTRIBUTE GIFT_MATCHING PLEDGE_MATCHING DESIGNATION_ACCOUNTING DESIGNATION_ID GIFT PLEDGE DESIGNATION_ADJUSTMENT DESIGNATION_COMMENT DESIGNATION_FINAID_FUND CAMPAIGN_DESIGNATION DESIGNATION_GIVING_HISTORY	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
ADBDESG_DSTA_CODE		REPORTING VIEW	GIFT DESIGNATION GIFT_MATCHING PLEDGE_MATCHING PLEDGE	DESG_STATUS DESG_STATUS DESG_STATUS DESG_STATUS DESG_STATUS
ADBDESG_DSTP_CODE		REPORTING VIEW	DESIGNATION_ADJUSTMENT DESIGNATION_CLASS_YEAR DESIGNATION_FINAID_FUND DESIGNATION_GIVING_HISTORY CAMPAIGN_DESIGNATION DESIGNATION_ACCOUNTING DESIGNATION_ID PLEDGE DESIGNATION_ATTRIBUTE GIFT_MATCHING DESIGNATION_COMMENT GIFT_MEMO GIFT_MULTIPLE GIFT PLEDGE_MATCHING	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	REPORTING VIEW	DESIGNATION	DESIGNATION_END_DATE
ADBDESG_FUND_CODE	ADADESG	REPORTING VIEW	DESIGNATION_ACCOUNTING GIFT	GIFT_FUND DESG_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	DESIGNATION_ACCOUNTING GIFT PLEDGE	GIFT_EXTERNAL_ACCOUNT DESG_GENERAL_LEDGER_NUMBER DESG_GENERAL_LEDGER_NUMBER	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	GIFT PLEDGE DESIGNATION_ACCOUNTING	DESG_LOCATION DESG_LOCATION GIFT_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		REPORTING VIEW	GIFT_MATCHING DESIGNATION_COMMENT GIFT_MULTIPLE GIFT_MEMO PLEDGE CAMPAIGN_DESIGNATION PLEDGE_MATCHING GIFT PROSPECT_PROPOSAL_RESULT DESIGNATION_ACCOUNTING DESIGNATION_GIVING_HISTORY DESIGNATION_ADJUSTMENT DESIGNATION_ATTRIBUTE DESIGNATION_FINAID_FUND DESIGNATION_ID DESIGNATION_CLASS_YEAR DESIGNATION_COMMENT_SUBJ	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
ADBDESG_ORGN_CODE	ADADESG	REPORTING VIEW	PLEDGE DESIGNATION_ACCOUNTING GIFT	DESG_ORGANIZATION GIFT_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	DESIGNATION_ACCOUNTING PLEDGE GIFT	GIFT_PROGRAM DESG_PROGRAM DESG_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	NA	REPORTING VIEW	GIFT CAMPAIGN_DESIGNATION	RESTRICTED_IND RESTRICTED_IND
ADBDESG_START_DATE	ADADESG	REPORTING VIEW	DESIGNATION	DESIGNATION_START_DATE
ADBDESG_USER	ADADESG	REPORTING VIEW	DESIGNATION_ACCOUNTING DESIGNATION	DESIGNATION_USER_ID DESIGNATION_USER_ID

Ver: 8.5