Reporting View Source: APBCONS

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

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
APBCONS_ADDR_NAME	APACONS	CONSTITUENT_ENTITY CONSTITUENT	MAILING_NAME ADDRESS_NAME
APBCONS_ATYP_CODE_CM	APACONS	CONSTITUENT	COMB_MAILING_ADDR_TYPE
APBCONS_ATYP_CODE_GEOR	APACONS	CONSTITUENT PROSPECT_INFO	PREF_ADDR_TYPE_GEOR PREF_GEO_REGION_ADDR_TYPE
APBCONS_ATYP_CODE_PREF	APACONS	CONSTITUENT	PREF_ADDR_TYPE
APBCONS_CM_NAME	APACONS	CONSTITUENT CONSTITUENT_ENTITY	COMBINED_MAILING_NAME COMBINED_MAILING_NAME
APBCONS_COLL_CODE_PREF	APACONS	GIFT_TRANSACTION CONSTITUENT GIFT	PREFER_COLLEGE PREF_COLLEGE PREFER_COLLEGE
APBCONS_DOTT_CODE	APACONS	CONSTITUENT	OCCUPATIONAL_TITLE
APBCONS_GRAD_NAME	APACONS	CONSTITUENT	GRADUATION_NAME
APBCONS_HOME_CITY	APACONS	CONSTITUENT	HOMETOWN
APBCONS_INCM_CODE	APACONS	CONSTITUENT	INCOME_LEVEL
APBCONS_MAIDEN_LAST_NAME	APACONS	CONSTITUENT	MAIDEN_LAST_NAME
APBCONS_NATN_CODE_HOME	APACONS	CONSTITUENT	HOMETOWN_NATION
APBCONS_NICKNAME	APACONS	CONSTITUENT	NICKNAME
APBCONS_PARENTS_NAME	APACONS	CONSTITUENT	PARENTS_NAME
APBCONS_PIDM	NA	CONSTITUENT	PERSON_UID
APBCONS_PREF_CLAS	APACONS	GIFT GIFT_TRANSACTION GIFT CONSTITUENT	PRIMARY_DONOR_CATEGORY PREFER_CLASS_YEAR PREFER_CLASS_YEAR PREF_CLASS
APBCONS_PREF_FIRST_NAME	APACONS	CONSTITUENT	PREF_FIRST_NAME
APBCONS_PREF_LAST_NAME	APACONS	CONSTITUENT	PREF_LAST_NAME
APBCONS_PREF_MI	APACONS	CONSTITUENT	PREF_MIDDLE_INITIAL
APBCONS_SOCIETY_NAME	APACONS	CONSTITUENT	SOCIETY_NAME
APBCONS_STAT_CODE_HOME	APACONS	CONSTITUENT	HOMETOWN_STATE

Ver: 8.3