Composite View Source: AOBORGN

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: AOBORGN Advancement

**SGHE Banner Operational Data Store**
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_ORGANIZATIONAL_CONSTITUENT AA_RELATIONSHIP	MATCHING_GIFT_UID RELATED_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_ORGANIZATIONAL_CONSTITUENT AA_PREVIOUS_EMPLOYMENT	STANDARD_INDUSTRY EMPLOYER_INDUSTRIAL_TYPE	NA
AOBORGN_SUFFIX_CONTACT	AOAORGN				NA
AOBORGN_TITLE_CONTACT	AOAORGN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	JOB_TITLE	NA

Ver: 8.1