| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| AOBORGN_BUSINESS |
AOAORGN |
NO |
COMPOSITE VIEW |
AA_ORGANIZATIONAL_CONSTITUENT |
BUSINESS |
NO |
NA |
| AOBORGN_EIN |
AOAORGN |
NO |
COMPOSITE VIEW |
AA_ORGANIZATIONAL_CONSTITUENT |
FEDERAL_IDENTIFICATION |
NO |
NA |
| AOBORGN_FIRST_NAME_CONTACT |
AOAORGN |
NO |
|
|
|
|
NA |
| AOBORGN_JOBC_CODE |
AOAORGN |
NO |
COMPOSITE VIEW |
AA_ORGANIZATION_CONTACT AA_ORGANIZATIONAL_CONSTITUENT |
JOB_CATEGORY JOB_CATEGORY |
NO NO |
NA |
| AOBORGN_LAST_NAME_CONTACT |
AOAORGN |
NO |
|
|
|
|
NA |
| AOBORGN_MATCH_MAXIMUM |
AOAORGN |
NO |
COMPOSITE VIEW |
AA_ORGANIZATIONAL_CONSTITUENT |
MATCH_MAXIMUM |
NO |
NA |
| AOBORGN_MATCH_MINIMUM |
AOAORGN |
NO |
COMPOSITE VIEW |
AA_ORGANIZATIONAL_CONSTITUENT |
MATCH_MINIMUM |
NO |
NA |
| AOBORGN_MATCH_ORG_EMPL_YR |
AOAORGN |
NO |
COMPOSITE VIEW |
AA_ORGANIZATIONAL_CONSTITUENT |
MAX_MATCH_ORG_EMPL_YEAR |
NO |
NA |
| AOBORGN_MATCH_ORG_MAX |
AOAORGN |
NO |
COMPOSITE VIEW |
AA_ORGANIZATIONAL_CONSTITUENT |
MAX_YEAR_DONATE_AMOUNT |
NO |
NA |
| AOBORGN_MATCH_PCT |
AOAORGN |
NO |
COMPOSITE VIEW |
AA_ORGANIZATIONAL_CONSTITUENT |
MATCHING_GIFT_PERCENT |
NO |
NA |
| AOBORGN_MATCH_PERSON_MAX |
AOAORGN |
NO |
COMPOSITE VIEW |
AA_ORGANIZATIONAL_CONSTITUENT |
MAX_PERSON_MATCH_AMOUNT |
NO |
NA |
| AOBORGN_MG_PIDM |
NA |
NO |
COMPOSITE VIEW |
AA_RELATIONSHIP AA_ORGANIZATIONAL_CONSTITUENT |
RELATED_MATCHING_GIFT_UID MATCHING_GIFT_UID |
NO NO |
NA |
| AOBORGN_MI_CONTACT |
AOAORGN |
NO |
|
|
|
|
NA |
| AOBORGN_PIDM |
NA |
NO |
COMPOSITE VIEW |
AA_ORGANIZATIONAL_CONSTITUENT |
ENTITY_UID |
NO |
NA |
| AOBORGN_PREFIX_CONTACT |
AOAORGN |
NO |
|
|
|
|
NA |
| AOBORGN_PREF_ATYP_CODE |
AOAORGN |
NO |
|
|
|
|
|
| AOBORGN_PREF_ATYP_SEQNO |
AOAORGN |
NO |
|
|
|
|
|
| AOBORGN_SICC_CODE |
|
NO |
COMPOSITE VIEW |
AA_ORGANIZATIONAL_CONSTITUENT AA_PREVIOUS_EMPLOYMENT |
STANDARD_INDUSTRY EMPLOYER_INDUSTRIAL_TYPE |
NO NO |
|
| AOBORGN_SUFFIX_CONTACT |
AOAORGN |
NO |
|
|
|
|
NA |
| AOBORGN_TITLE_CONTACT |
AOAORGN |
NO |
|
|
|
|
NA |