RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: AOBORGN Advancement Composite View Reports
SGHE Operational Data Store Composite View Source: AOBORGN

Source Column Source Form Target Type Target Target Column Calculation Formula
AOBORGN_ATYP_CODE AOAORGN COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

PREF_ADDRESS_TYPE

NA
AOBORGN_BUSINESS AOAORGN COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

BUSINESS

NA
AOBORGN_EIN AOAORGN COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

FEDERAL_IDENTIFICATION

NA
AOBORGN_FIRST_NAME_CONTACT AOAORGN       NA
AOBORGN_JOBC_CODE AOAORGN COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

AA_ORGANIZATION_CONTACT

JOB_CATEGORY

JOB_CATEGORY

NA
AOBORGN_LAST_NAME_CONTACT AOAORGN       NA
AOBORGN_MATCH_MAXIMUM AOAORGN COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

MATCH_MAXIMUM

NA
AOBORGN_MATCH_MINIMUM AOAORGN COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

MATCH_MINIMUM

NA
AOBORGN_MATCH_ORG_EMPL_YR AOAORGN COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

MAX_MATCH_ORG_EMPL_YEAR

NA
AOBORGN_MATCH_ORG_MAX AOAORGN COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

MAX_YEAR_DONATE_AMOUNT

NA
AOBORGN_MATCH_PCT AOAORGN COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

MATCHING_GIFT_PERCENT

NA
AOBORGN_MATCH_PERSON_MAX AOAORGN COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

MAX_PERSON_MATCH_AMOUNT

NA
AOBORGN_MG_PIDM NA COMPOSITE VIEW

AA_RELATIONSHIP

AA_ORGANIZATIONAL_CONSTITUENT

RELATED_MATCHING_GIFT_UID

MATCHING_GIFT_UID

NA
AOBORGN_MI_CONTACT AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_MIDDLE_INITIAL

NA
AOBORGN_PIDM NA COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

AA_ORGANIZATION_CONTACT

ENTITY_UID

ENTITY_UID

NA
AOBORGN_PREFIX_CONTACT AOAORGN       NA
AOBORGN_SICC_CODE AOAORGN COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYER_INDUSTRIAL_TYPE

NA
AOBORGN_SUFFIX_CONTACT AOAORGN       NA
AOBORGN_TITLE_CONTACT AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

JOB_TITLE

NA


Ver: 3.1