Composite View Source: APBCONS

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

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
APBCONS_ADDR_NAME	APACONS	AA_CONSTITUENT	ADDRESS_NAME
APBCONS_ATYP_CODE_CM	APACONS	AA_CONSTITUENT	COMB_MAILING_ADDR_TYPE
APBCONS_ATYP_CODE_GEOR	APACONS	AA_CONSTITUENT AA_PROSPECT_INFO	PREF_ADDR_TYPE_GEOR PREF_GEO_REGION_ADDR_TYPE
APBCONS_ATYP_CODE_PREF	APACONS	AA_CONSTITUENT	PREF_ADDRESS_TYPE
APBCONS_CM_NAME	APACONS	AA_CONSTITUENT	COMBINED_MAILING_NAME
APBCONS_COLL_CODE_PREF	APACONS	AA_CONSTITUENT	PREF_COLLEGE
APBCONS_DOTT_CODE	APACONS	AA_CONSTITUENT	OCCUPATIONAL_TITLE
APBCONS_GRAD_NAME	APACONS	AA_CONSTITUENT	GRADUATION_NAME
APBCONS_HOME_CITY	APACONS	AA_CONSTITUENT	HOMETOWN
APBCONS_INCM_CODE	APACONS	AA_CONSTITUENT	INCOME_LEVEL
APBCONS_MAIDEN_LAST_NAME	APACONS	AA_CONSTITUENT	MAIDEN_LAST_NAME
APBCONS_NATN_CODE_HOME	APACONS	AA_CONSTITUENT	HOMETOWN_NATION
APBCONS_NICKNAME	APACONS	AA_CONSTITUENT	NICKNAME
APBCONS_PARENTS_NAME	APACONS	AA_CONSTITUENT	PARENTS_NAME
APBCONS_PIDM	NA	AA_CONSTITUENT	ENTITY_UID
APBCONS_PREF_CLAS	APACONS	AA_CONSTITUENT	PREF_CLASS
APBCONS_PREF_FIRST_NAME	APACONS	AA_CONSTITUENT	PREF_FIRST_NAME
APBCONS_PREF_LAST_NAME	APACONS	AA_CONSTITUENT	PREF_LAST_NAME
APBCONS_PREF_MI	APACONS	AA_CONSTITUENT	PREF_MIDDLE_INITIAL
APBCONS_SOCIETY_NAME	APACONS	AA_CONSTITUENT	SOCIETY_NAME
APBCONS_STAT_CODE_HOME	APACONS	AA_CONSTITUENT	HOMETOWN_STATE

Ver: 8.3