Composite View Source: APBCONS

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

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

Ver: 8.1