Composite View Source: AORCONT

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

**Banner Operational Data Store**
Source Column	Source Form	Local Source	Target Type	Target	Target Column	Local Target	Calculation Formula
AORCONT_ACTIVITY_DATE	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_ACTIVITY_DATE	NO
AORCONT_ADDR_CITY	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CITY	NO	NA
AORCONT_ADDR_LINE1	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	STREET_LINE1	NO	NA
AORCONT_ADDR_LINE2	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	STREET_LINE2	NO	NA
AORCONT_ADDR_LINE3	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	STREET_LINE3	NO	NA
AORCONT_ADDR_LINE4	AOACONT	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	STREET_LINE4	NO
AORCONT_ATYP_CODE	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	ADDRESS_TYPE	NO	NA
AORCONT_CARRIER_ROUTE	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CARRIER_ROUTE	NO	NA
AORCONT_CNTY_CODE_ADDR	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	COUNTY	NO	NA
AORCONT_CONTACT_PIDM	NA	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_UID	NO	NA
AORCONT_CONT_ORG_IND	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_ADDRESS_SOURCE	NO
AORCONT_CORRECTION_DIGIT	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CORRECTION_DIGIT	NO	NA
AORCONT_CTRY_CODE_FAX	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	FAX_COUNTRY_CODE	NO
AORCONT_CTRY_CODE_PHONE	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	PHONE_COUNTRY_CODE	NO
AORCONT_DATE	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_START_DATE	NO
AORCONT_DECEASED_IND	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_DECEASED_IND	NO
AORCONT_DELIVERY_POINT	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	DELIVERY_POINT	NO	NA
AORCONT_EMAIL_ADDRESS	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	EMAIL_ADDRESS	NO
AORCONT_EMAL_CODE	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	EMAIL_TYPE	NO
AORCONT_EMAL_SRC_IND	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_EMAIL_SOURCE	NO
AORCONT_END_DATE	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_END_DATE	NO
AORCONT_FAX_AREA	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	FAX_AREA	NO
AORCONT_FAX_CODE	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	FAX_TYPE	NO
AORCONT_FAX_EXT	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	FAX_EXT	NO
AORCONT_FAX_NUMBER	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	FAX_NUMBER	NO
AORCONT_FAX_SRC_IND	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_FAX_SOURCE	NO
AORCONT_FIRST_NAME	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_FIRST_NAME	NO	NA
AORCONT_HOUSE_NUMBER	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	HOUSE_NUMBER	NO
AORCONT_JOBC_CODE	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	JOB_CATEGORY	NO	NA
AORCONT_LAST_NAME	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_LAST_NAME	NO	NA
AORCONT_MI	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_MIDDLE_INITIAL	NO	NA
AORCONT_NAME_PREFIX	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_NAME_PREFIX	NO	NA
AORCONT_NAME_SUFFIX	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_NAME_SUFFIX	NO	NA
AORCONT_NATN_CODE_ADDR	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	NATION	NO	NA
AORCONT_NOTES	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_COMMENT	NO
AORCONT_OCON_CODE	AOAORGN	NO					NA
AORCONT_PHONE_AREA	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	PHONE_AREA	NO	NA
AORCONT_PHONE_EXT	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	PHONE_EXT	NO	NA
AORCONT_PHONE_NUMBER	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	PHONE_NUMBER	NO	NA
AORCONT_PIDM	NA	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	ENTITY_UID	NO	NA
AORCONT_SEQ_NO	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_SEQUENCE_NUMBER	NO
AORCONT_STAT_CODE_ADDR	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	STATE_PROVINCE	NO	NA
AORCONT_SURNAME_PREFIX	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_LAST_NAME_PREFIX	NO
AORCONT_TELE_CODE	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	PHONE_TYPE	NO
AORCONT_TELE_SRC_IND	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CONTACT_PHONE_SOURCE	NO
AORCONT_TITLE	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	JOB_TITLE	NO	NA
AORCONT_ZIPC_CODE_ADDR	AOAORGN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	POSTAL_CODE	NO	NA

Ver: