Reporting View Source: AOBORGN

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: AOBORGN Advancement Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
AOBORGN_ATYP_CODE	AOAORGN	ORGANIZATIONAL_CONSTITUENT	PREF_ADDRESS_TYPE
AOBORGN_BUSINESS	AOAORGN	ORGANIZATIONAL_CONSTITUENT	BUSINESS
AOBORGN_EIN	AOAORGN	ORGANIZATIONAL_CONSTITUENT	FEDERAL_IDENTIFICATION
AOBORGN_FIRST_NAME_CONTACT	AOAORGN	CONSTITUENT_ENTITY	PRIMARY_CONTACT_FIRST_NAME
AOBORGN_JOBC_CODE	AOAORGN	ORGANIZATIONAL_CONSTITUENT ORGANIZATION_CONTACT	JOB_CATEGORY JOB_CATEGORY
AOBORGN_LAST_NAME_CONTACT	AOAORGN	CONSTITUENT_ENTITY	PRIMARY_CONTACT_LAST_NAME
AOBORGN_MATCH_MAXIMUM	AOAORGN	ORGANIZATIONAL_CONSTITUENT	MATCH_MAXIMUM
AOBORGN_MATCH_MINIMUM	AOAORGN	ORGANIZATIONAL_CONSTITUENT	MATCH_MINIMUM
AOBORGN_MATCH_ORG_EMPL_YR	AOAORGN	ORGANIZATIONAL_CONSTITUENT	MAX_MATCH_ORG_EMPL_YEAR
AOBORGN_MATCH_ORG_MAX	AOAORGN	ORGANIZATIONAL_CONSTITUENT	MAX_YEAR_DONATE_AMOUNT
AOBORGN_MATCH_PCT	AOAORGN	ORGANIZATIONAL_CONSTITUENT	MATCHING_GIFT_PERCENT
AOBORGN_MATCH_PERSON_MAX	AOAORGN	ORGANIZATIONAL_CONSTITUENT	MAX_PERSON_MATCH_AMOUNT
AOBORGN_MG_PIDM	NA	ORGANIZATIONAL_CONSTITUENT CURRENT_EMPLOYMENT RELATIONSHIP	MATCHING_GIFT_UID MATCHING_GIFT_COMPANY_UID RELATED_MATCHING_GIFT_UID
AOBORGN_MI_CONTACT	AOAORGN	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT CONSTITUENT_ENTITY ORGANIZATION_CONTACT	CONTACT_MIDDLE_INITIAL_2 CONTACT_MIDDLE_INITIAL_1 PRIMARY_CONTACT_MIDDLE_INITIAL CONTACT_MIDDLE_INITIAL
AOBORGN_PIDM	NA	ORGANIZATIONAL_CONSTITUENT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT	ENTITY_UID ENTITY_UID ENTITY_UID
AOBORGN_PREFIX_CONTACT	AOAORGN	CONSTITUENT_ENTITY	PRIMARY_CONTACT_NAME_PREFIX
AOBORGN_SICC_CODE	AOAORGN	ORGANIZATIONAL_CONSTITUENT	STANDARD_INDUSTRY_CODE
AOBORGN_SUFFIX_CONTACT	AOAORGN	CONSTITUENT_ENTITY	PRIMARY_CONTACT_NAME_SUFFIX
AOBORGN_TITLE_CONTACT	AOAORGN	ORGANIZATION_CONTACT CONSTITUENT_ENTITY	JOB_TITLE PRIMARY_CONTACT_JOB_TITLE

Ver: 8.3