Composite View Source: AORCONT

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

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

Ver: