Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: AOBORGN Advancement Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: AOBORGN - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
AOBORGN_ATYP_CODE AOAORGN       NA
AOBORGN_BUSINESS AOAORGN

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

BUSINESS

NA
AOBORGN_EIN AOAORGN

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

FEDERAL_IDENTIFICATION

NA
AOBORGN_FIRST_NAME_CONTACT AOAORGN

REPORTING VIEW

CONSTITUENT_ENTITY

PRIMARY_CONTACT_FIRST_NAME

NA
AOBORGN_JOBC_CODE AOAORGN       NA
AOBORGN_LAST_NAME_CONTACT AOAORGN

REPORTING VIEW

CONSTITUENT_ENTITY

PRIMARY_CONTACT_LAST_NAME

NA
AOBORGN_MATCH_MAXIMUM AOAORGN

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MATCH_MAXIMUM

NA
AOBORGN_MATCH_MINIMUM AOAORGN

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MATCH_MINIMUM

NA
AOBORGN_MATCH_ORG_EMPL_YR AOAORGN

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MAX_MATCH_ORG_EMPL_YEAR

NA
AOBORGN_MATCH_ORG_MAX AOAORGN

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MAX_YEAR_DONATE_AMOUNT

NA
AOBORGN_MATCH_PCT AOAORGN

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MATCHING_GIFT_PERCENT

NA
AOBORGN_MATCH_PERSON_MAX AOAORGN

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

MAX_PERSON_MATCH_AMOUNT

NA
AOBORGN_MG_PIDM NA

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

CURRENT_EMPLOYMENT

RELATIONSHIP

MATCHING_GIFT_UID

MATCHING_GIFT_COMPANY_UID

RELATED_MATCHING_GIFT_UID

NA
AOBORGN_MI_CONTACT AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

CONSTITUENT_ENTITY

CONTACT_MIDDLE_INITIAL_2

CONTACT_MIDDLE_INITIAL_1

PRIMARY_CONTACT_MIDDLE_INITIAL

NA
AOBORGN_PIDM NA

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

ORGANIZATION_CONTACT_SLOT

ENTITY_UID

ENTITY_UID

NA
AOBORGN_PREFIX_CONTACT AOAORGN

REPORTING VIEW

CONSTITUENT_ENTITY

PRIMARY_CONTACT_NAME_PREFIX

NA
AOBORGN_SICC_CODE AOAORGN

REPORTING VIEW

ORGANIZATIONAL_CONSTITUENT

STANDARD_INDUSTRY_CODE

NA
AOBORGN_SUFFIX_CONTACT AOAORGN

REPORTING VIEW

CONSTITUENT_ENTITY

PRIMARY_CONTACT_NAME_SUFFIX

NA
AOBORGN_TITLE_CONTACT AOAORGN

REPORTING VIEW

CONSTITUENT_ENTITY

PRIMARY_CONTACT_JOB_TITLE

NA
NA AOAORGN

REPORTING VIEW

ADVANCEMENT_ADDRESS_KSU

ADVANCEMENT_ADDRESS_SLOT_KSU

CONTACT_NAME

CONTACT_NAME

NA


Ver: 8.4.1