| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| AOBORGN_BUSINESS |
AOAORGN |
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT |
BUSINESS |
NO |
NA |
| AOBORGN_EIN |
AOAORGN |
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT |
FEDERAL_IDENTIFICATION |
NO |
NA |
| AOBORGN_FIRST_NAME_CONTACT |
AOAORGN |
NO |
REPORTING VIEW |
CONSTITUENT_ENTITY |
PRIMARY_CONTACT_FIRST_NAME |
NO |
NA |
| AOBORGN_JOBC_CODE |
AOAORGN |
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT |
JOB_CATEGORY |
NO |
NA |
| AOBORGN_LAST_NAME_CONTACT |
AOAORGN |
NO |
REPORTING VIEW |
CONSTITUENT_ENTITY |
PRIMARY_CONTACT_LAST_NAME |
NO |
NA |
| AOBORGN_MATCH_MAXIMUM |
AOAORGN |
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT |
MATCH_MAXIMUM |
NO |
NA |
| AOBORGN_MATCH_MINIMUM |
AOAORGN |
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT |
MATCH_MINIMUM |
NO |
NA |
| AOBORGN_MATCH_ORG_EMPL_YR |
AOAORGN |
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT |
MAX_MATCH_ORG_EMPL_YEAR |
NO |
NA |
| AOBORGN_MATCH_ORG_MAX |
AOAORGN |
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT |
MAX_YEAR_DONATE_AMOUNT |
NO |
NA |
| AOBORGN_MATCH_PCT |
AOAORGN |
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT |
MATCHING_GIFT_PERCENT |
NO |
NA |
| AOBORGN_MATCH_PERSON_MAX |
AOAORGN |
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT |
MAX_PERSON_MATCH_AMOUNT |
NO |
NA |
| AOBORGN_MG_PIDM |
NA |
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT CURRENT_EMPLOYMENT RELATIONSHIP |
MATCHING_GIFT_UID MATCHING_GIFT_COMPANY_UID RELATED_MATCHING_GIFT_UID |
NO NO NO |
NA |
| AOBORGN_MI_CONTACT |
AOAORGN |
NO |
REPORTING VIEW |
CONSTITUENT_ENTITY ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT |
PRIMARY_CONTACT_MIDDLE_INITIAL CONTACT_MIDDLE_INITIAL_1 CONTACT_MIDDLE_INITIAL_2 |
NO NO NO |
NA |
| AOBORGN_PIDM |
NA |
NO |
REPORTING VIEW |
ORGANIZATION_CONTACT_SLOT ORGANIZATIONAL_CONSTITUENT |
ENTITY_UID ENTITY_UID |
NO NO |
NA |
| AOBORGN_PREFIX_CONTACT |
AOAORGN |
NO |
REPORTING VIEW |
CONSTITUENT_ENTITY |
PRIMARY_CONTACT_NAME_PREFIX |
NO |
NA |
| AOBORGN_PREF_ATYP_CODE |
AOAORGN |
NO |
REPORTING VIEW |
CONSTITUENT_ENTITY ORGANIZATIONAL_CONSTITUENT |
PREF_ADDRESS_TYPE PREF_ADDRESS_TYPE |
NO NO |
|
| AOBORGN_PREF_ATYP_SEQNO |
AOAORGN |
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT CONSTITUENT_ENTITY |
PREF_ADDRESS_NUMBER PREF_ADDRESS_NUMBER |
NO NO |
|
| AOBORGN_SICC_CODE |
|
NO |
REPORTING VIEW |
ORGANIZATIONAL_CONSTITUENT |
STANDARD_INDUSTRY_CODE |
NO |
|
| AOBORGN_SUFFIX_CONTACT |
AOAORGN |
NO |
REPORTING VIEW |
CONSTITUENT_ENTITY |
PRIMARY_CONTACT_NAME_SUFFIX |
NO |
NA |
| AOBORGN_TITLE_CONTACT |
AOAORGN |
NO |
REPORTING VIEW |
CONSTITUENT_ENTITY |
PRIMARY_CONTACT_JOB_TITLE |
NO |
NA |