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

Source Column Source Form Target Type Target Target Column Calculation Formula
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

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       NA
AOBORGN_PIDM NA COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

ENTITY_UID

NA
AOBORGN_PREFIX_CONTACT AOAORGN       NA
AOBORGN_PREF_ATYP_CODE AOAORGN        
AOBORGN_PREF_ATYP_SEQNO AOAORGN        
AOBORGN_SICC_CODE COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

AA_PREVIOUS_EMPLOYMENT

STANDARD_INDUSTRY

EMPLOYER_INDUSTRIAL_TYPE

 
AOBORGN_SUFFIX_CONTACT AOAORGN       NA
AOBORGN_TITLE_CONTACT AOAORGN       NA
AOBORGN_USER_ID AOAORGN        


Ver: