Composite View Source: AORCONT

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

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
AORCONT_ADDR_CITY	AOAORGN	AA_ORGANIZATION_CONTACT	CITY
AORCONT_ADDR_LINE1	AOAORGN	AA_ORGANIZATION_CONTACT	STREET_LINE1
AORCONT_ADDR_LINE2	AOAORGN	AA_ORGANIZATION_CONTACT	STREET_LINE2
AORCONT_ADDR_LINE3	AOAORGN	AA_ORGANIZATION_CONTACT	STREET_LINE3
AORCONT_ADDR_LINE4	AOACONT	AA_ORGANIZATION_CONTACT	STREET_LINE4
AORCONT_ATYP_CODE	AOAORGN	AA_ORGANIZATION_CONTACT	ADDRESS_TYPE
AORCONT_CARRIER_ROUTE	AOAORGN	AA_ORGANIZATION_CONTACT	CARRIER_ROUTE
AORCONT_CNTY_CODE_ADDR	AOAORGN	AA_ORGANIZATION_CONTACT	COUNTY
AORCONT_CONTACT_PIDM	NA	AA_ORGANIZATION_CONTACT	CONTACT_UID
AORCONT_CORRECTION_DIGIT	AOAORGN	AA_ORGANIZATION_CONTACT	CORRECTION_DIGIT
AORCONT_DELIVERY_POINT	AOAORGN	AA_ORGANIZATION_CONTACT	DELIVERY_POINT
AORCONT_FIRST_NAME	AOAORGN	AA_ORGANIZATION_CONTACT	CONTACT_FIRST_NAME
AORCONT_JOBC_CODE	AOAORGN	AA_ORGANIZATION_CONTACT	JOB_CATEGORY
AORCONT_LAST_NAME	AOAORGN	AA_ORGANIZATION_CONTACT	CONTACT_LAST_NAME
AORCONT_MI	AOAORGN	AA_ORGANIZATION_CONTACT	CONTACT_MIDDLE_INITIAL
AORCONT_NAME_PREFIX	AOAORGN	AA_ORGANIZATION_CONTACT	CONTACT_NAME_PREFIX
AORCONT_NAME_SUFFIX	AOAORGN	AA_ORGANIZATION_CONTACT	CONTACT_NAME_SUFFIX
AORCONT_NATN_CODE_ADDR	AOAORGN	AA_ORGANIZATION_CONTACT	NATION
AORCONT_OCON_CODE	AOAORGN	AA_ORGANIZATION_CONTACT	CONTACT_TYPE
AORCONT_PHONE_AREA	AOAORGN	AA_ORGANIZATION_CONTACT	PHONE_AREA
AORCONT_PHONE_EXT	AOAORGN	AA_ORGANIZATION_CONTACT	PHONE_EXT
AORCONT_PHONE_NUMBER	AOAORGN	AA_ORGANIZATION_CONTACT	PHONE_NUMBER
AORCONT_PIDM	NA	AA_ORGANIZATION_CONTACT	ENTITY_UID
AORCONT_STAT_CODE_ADDR	AOAORGN	AA_ORGANIZATION_CONTACT	STATE_PROVINCE
AORCONT_TITLE	AOAORGN	AA_ORGANIZATION_CONTACT	JOB_TITLE
AORCONT_ZIPC_CODE_ADDR	AOAORGN	AA_ORGANIZATION_CONTACT	POSTAL_CODE

Ver: 8.3