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**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
APBCONS_ADDR_NAME	APACONS	REPORTING VIEW	CONSTITUENT_ENTITY CONSTITUENT	MAILING_NAME ADDRESS_NAME	NA
APBCONS_ATYP_CODE_CM	APACONS	REPORTING VIEW	CONSTITUENT	COMB_MAILING_ADDR_TYPE	NA
APBCONS_ATYP_CODE_GEOR	APACONS	REPORTING VIEW	CONSTITUENT PROSPECT_INFO	PREF_ADDR_TYPE_GEOR PREF_GEO_REGION_ADDR_TYPE	NA
APBCONS_ATYP_CODE_PREF	APACONS	REPORTING VIEW	CONSTITUENT	PREF_ADDR_TYPE	NA
APBCONS_CM_NAME	APACONS	REPORTING VIEW	CONSTITUENT CONSTITUENT_ENTITY	COMBINED_MAILING_NAME COMBINED_MAILING_NAME	NA
APBCONS_COLL_CODE_PREF	APACONS	REPORTING VIEW	GIFT_TRANSACTION CONSTITUENT GIFT	PREFER_COLLEGE PREF_COLLEGE PREFER_COLLEGE	NA
APBCONS_DOTT_CODE	APACONS	REPORTING VIEW	CONSTITUENT	OCCUPATIONAL_TITLE	NA
APBCONS_GRAD_NAME	APACONS	REPORTING VIEW	CONSTITUENT	GRADUATION_NAME	NA
APBCONS_HOME_CITY	APACONS	REPORTING VIEW	CONSTITUENT	HOMETOWN	NA
APBCONS_INCM_CODE	APACONS	REPORTING VIEW	CONSTITUENT	INCOME_LEVEL	NA
APBCONS_MAIDEN_LAST_NAME	APACONS	REPORTING VIEW	CONSTITUENT	MAIDEN_LAST_NAME	NA
APBCONS_NATN_CODE_HOME	APACONS	REPORTING VIEW	CONSTITUENT	HOMETOWN_NATION	NA
APBCONS_NICKNAME	APACONS	REPORTING VIEW	CONSTITUENT	NICKNAME	NA
APBCONS_PARENTS_NAME	APACONS	REPORTING VIEW	CONSTITUENT	PARENTS_NAME	NA
APBCONS_PIDM	NA	REPORTING VIEW	CONSTITUENT	PERSON_UID	NA
APBCONS_PREF_CLAS	APACONS	REPORTING VIEW	GIFT_TRANSACTION GIFT CONSTITUENT	PREFER_CLASS_YEAR PREFER_CLASS_YEAR PREF_CLASS	NA
APBCONS_PREF_FIRST_NAME	APACONS	REPORTING VIEW	CONSTITUENT	PREF_FIRST_NAME	NA
APBCONS_PREF_LAST_NAME	APACONS	REPORTING VIEW	CONSTITUENT	PREF_LAST_NAME	NA
APBCONS_PREF_MI	APACONS	REPORTING VIEW	CONSTITUENT	PREF_MIDDLE_INITIAL	NA
APBCONS_SOCIETY_NAME	APACONS	REPORTING VIEW	CONSTITUENT	SOCIETY_NAME	NA
APBCONS_STAT_CODE_HOME	APACONS	REPORTING VIEW	CONSTITUENT	HOMETOWN_STATE	NA

Ver: 9.0