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_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_PREF_ATYP_CODE AOAORGN

REPORTING VIEW

CONSTITUENT_ENTITY

ORGANIZATIONAL_CONSTITUENT

PREF_ADDRESS_TYPE

PREF_ADDRESS_TYPE

 
AOBORGN_PREF_ATYP_SEQNO AOAORGN

REPORTING VIEW

CONSTITUENT_ENTITY

ORGANIZATIONAL_CONSTITUENT

PREF_ADDRESS_NUMBER

PREF_ADDRESS_NUMBER

 
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
AOBORGN_USER_ID AOAORGN        


Ver: 9.0