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