Reporting View Source: AORCONT

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
AORCONT_ACTIVITY_DATE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_ACTIVITY_DATE
AORCONT_ADDR_CITY	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT	CITY_2 CITY_1 CITY	NA
AORCONT_ADDR_LINE1	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT	STREET_LINE1 STREET_LINE1_2 STREET_LINE1_1	NA
AORCONT_ADDR_LINE2	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT	STREET_LINE2 STREET_LINE2_2 STREET_LINE2_1	NA
AORCONT_ADDR_LINE3	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT	STREET_LINE3_1 STREET_LINE3 STREET_LINE3_2	NA
AORCONT_ADDR_LINE4	AOACONT	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT	STREET_LINE4_1 STREET_LINE4_2 STREET_LINE4
AORCONT_ATYP_CODE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT ORGANIZATIONAL_CONSTITUENT ORGANIZATION_CONTACT	ADDRESS_TYPE_1 ADDRESS_TYPE_2 PREF_ADDRESS_TYPE ADDRESS_TYPE	NA
AORCONT_CARRIER_ROUTE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CARRIER_ROUTE	NA
AORCONT_CNTY_CODE_ADDR	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT	COUNTY_2 COUNTY COUNTY_1	NA
AORCONT_CONTACT_PIDM	NA	REPORTING VIEW	ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT	CONTACT_UID CONTACT_UID_2 CONTACT_UID_1	NA
AORCONT_CONT_ORG_IND	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_ADDRESS_SOURCE
AORCONT_CORRECTION_DIGIT	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CORRECTION_DIGIT	NA
AORCONT_CTRY_CODE_FAX	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	FAX_COUNTRY_CODE
AORCONT_CTRY_CODE_PHONE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	PHONE_COUNTRY_CODE
AORCONT_DATE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_START_DATE
AORCONT_DECEASED_IND	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_DECEASED_IND
AORCONT_DELIVERY_POINT	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	DELIVERY_POINT	NA
AORCONT_EMAIL_ADDRESS	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	EMAIL_ADDRESS
AORCONT_EMAL_CODE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	EMAIL_TYPE
AORCONT_EMAL_SRC_IND	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_EMAIL_SOURCE
AORCONT_END_DATE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_END_DATE
AORCONT_FAX_AREA	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	FAX_AREA
AORCONT_FAX_CODE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	FAX_TYPE
AORCONT_FAX_EXT	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	FAX_EXT
AORCONT_FAX_NUMBER	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	FAX_NUMBER
AORCONT_FAX_SRC_IND	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_FAX_SOURCE
AORCONT_FIRST_NAME	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT	CONTACT_FIRST_NAME CONTACT_FIRST_NAME_2 CONTACT_FIRST_NAME_1	NA
AORCONT_HOUSE_NUMBER	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	HOUSE_NUMBER
AORCONT_JOBC_CODE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT ORGANIZATIONAL_CONSTITUENT	JOB_CATEGORY JOB_CATEGORY	NA
AORCONT_LAST_NAME	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT	CONTACT_LAST_NAME_2 CONTACT_LAST_NAME CONTACT_LAST_NAME_1	NA
AORCONT_MI	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT	CONTACT_MIDDLE_INITIAL_2 CONTACT_MIDDLE_INITIAL_1 CONTACT_MIDDLE_INITIAL	NA
AORCONT_NAME_PREFIX	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_NAME_PREFIX	NA
AORCONT_NAME_SUFFIX	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_NAME_SUFFIX	NA
AORCONT_NATN_CODE_ADDR	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT	NATION_1 NATION_2 NATION	NA
AORCONT_NOTES	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_COMMENT
AORCONT_OCON_CODE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT	CONTACT_TYPE_1 CONTACT_TYPE CONTACT_TYPE_2	NA
AORCONT_PHONE_AREA	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT	PHONE_AREA_2 PHONE_AREA PHONE_AREA_1	NA
AORCONT_PHONE_EXT	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT	PHONE_EXT PHONE_EXT_1 PHONE_EXT_2	NA
AORCONT_PHONE_NUMBER	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT	PHONE_NUMBER_2 PHONE_NUMBER PHONE_NUMBER_1	NA
AORCONT_PIDM	NA	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT	ENTITY_UID ENTITY_UID	NA
AORCONT_SEQ_NO	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_SEQUENCE_NUMBER
AORCONT_STAT_CODE_ADDR	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT	STATE_PROVINCE STATE_PROVINCE_1 STATE_PROVINCE_2	NA
AORCONT_SURNAME_PREFIX	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_LAST_NAME_PREFIX
AORCONT_TELE_CODE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	PHONE_TYPE
AORCONT_TELE_SRC_IND	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	CONTACT_PHONE_SOURCE
AORCONT_TITLE	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT	JOB_TITLE	NA
AORCONT_ZIPC_CODE_ADDR	AOAORGN	REPORTING VIEW	ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT_SLOT	POSTAL_CODE POSTAL_CODE_2 POSTAL_CODE_1	NA

Ver: 9.0