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 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 PLEDGE DESIGNATION GIFT_MATCHING GIFT_MULTIPLE CAMPAIGN_DESIGNATION 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	TBD	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
ADBDESG_DEPT_CODE	NA	REPORTING VIEW	PLEDGE GIFT DESIGNATION PLEDGE_MATCHING GIFT_MATCHING	DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT DESG_DEPARTMENT
ADBDESG_DESG	NA	REPORTING VIEW	DESIGNATION DESIGNATION_ACCOUNTING	DESIGNATION DESIGNATION
ADBDESG_DGRP_CODE	TBD	REPORTING VIEW	CAMPAIGN_DESIGNATION DESIGNATION_COMMENT DESIGNATION_FINAID_FUND DESIGNATION_ADJUSTMENT PLEDGE DESIGNATION_CLASS_YEAR DESIGNATION_ACCOUNTING GIFT_MATCHING PLEDGE_MATCHING GIFT DESIGNATION_GIVING_HISTORY DESIGNATION_ATTRIBUTE 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	NA	REPORTING VIEW	PLEDGE GIFT DESIGNATION GIFT_MATCHING PLEDGE_MATCHING	DESG_STATUS DESG_STATUS DESG_STATUS DESG_STATUS DESG_STATUS
ADBDESG_DSTP_CODE	NA	REPORTING VIEW	GIFT_MULTIPLE PLEDGE_MATCHING CAMPAIGN_DESIGNATION DESIGNATION_CLASS_YEAR DESIGNATION_COMMENT DESIGNATION_ADJUSTMENT GIFT_MATCHING DESIGNATION_ACCOUNTING DESIGNATION_ATTRIBUTE DESIGNATION_GIVING_HISTORY GIFT_MEMO DESIGNATION_FINAID_FUND GIFT PLEDGE DESIGNATION_ID	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	GIFT PLEDGE DESIGNATION_ACCOUNTING	DESG_FUND 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_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	PLEDGE DESIGNATION_ACCOUNTING GIFT	DESG_LOCATION GIFT_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	NA	REPORTING VIEW	DESIGNATION_ID PLEDGE DESIGNATION DESIGNATION_COMMENT_SUBJ DESIGNATION_ADJUSTMENT GIFT_MEMO DESIGNATION_COMMENT DESIGNATION_ACCOUNTING DESIGNATION_ATTRIBUTE DESIGNATION_GIVING_HISTORY GIFT GIFT_MATCHING DESIGNATION_FINAID_FUND 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
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	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 DESIGNATION_ACCOUNTING	DESIGNATION_USER_ID DESIGNATION_USER_ID

Ver: 8.4.1