Banner EDW Source: APBCONS

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
APBCONS_ADDR_NAME	NO	REPORTING VIEW	CONSTITUENT_ENTITY CONSTITUENT	MAILING_NAME ADDRESS_NAME	NA NA	NO NO
APBCONS_ATYP_CODE_CM	NO	REPORTING VIEW	CONSTITUENT	COMB_MAILING_ADDR_TYPE	NA	NO
APBCONS_ATYP_CODE_GEOR	NO	REPORTING VIEW	CONSTITUENT PROSPECT_INFO	PREF_ADDR_TYPE_GEOR PREF_GEO_REGION_ADDR_TYPE	NA NA	NO NO
APBCONS_ATYP_CODE_PREF	NO	REPORTING VIEW	CONSTITUENT	PREF_ADDR_TYPE	NA	NO
APBCONS_CM_NAME	NO	REPORTING VIEW	CONSTITUENT CONSTITUENT_ENTITY	COMBINED_MAILING_NAME COMBINED_MAILING_NAME	NA NA	NO NO
APBCONS_COLL_CODE_PREF	NO	REPORTING VIEW	CONSTITUENT GIFT GIFT_TRANSACTION	PREF_COLLEGE PREFER_COLLEGE PREFER_COLLEGE	NA NA NA	NO NO NO
APBCONS_DOTT_CODE	NO	REPORTING VIEW	CONSTITUENT	OCCUPATIONAL_TITLE	NA	NO
APBCONS_GRAD_NAME	NO	REPORTING VIEW	CONSTITUENT	GRADUATION_NAME	NA	NO
APBCONS_HOME_CITY	NO	REPORTING VIEW	CONSTITUENT	HOMETOWN	NA	NO
APBCONS_INCM_CODE	NO	REPORTING VIEW	CONSTITUENT	INCOME_LEVEL	NA	NO
APBCONS_MAIDEN_LAST_NAME	NO	REPORTING VIEW	CONSTITUENT	MAIDEN_LAST_NAME	NA	NO
APBCONS_NATN_CODE_HOME	NO	REPORTING VIEW	CONSTITUENT	HOMETOWN_NATION	NA	NO
APBCONS_NICKNAME	NO	REPORTING VIEW	CONSTITUENT	NICKNAME	NA	NO
APBCONS_PARENTS_NAME	NO	REPORTING VIEW	CONSTITUENT	PARENTS_NAME	NA	NO
APBCONS_PIDM	NO	REPORTING VIEW	CONSTITUENT	PERSON_UID	NA	NO
APBCONS_PREF_CLAS	NO	REPORTING VIEW	GIFT_TRANSACTION CONSTITUENT GIFT	PREFER_CLASS_YEAR PREF_CLASS PREFER_CLASS_YEAR	NA NA NA	NO NO NO
APBCONS_PREF_FIRST_NAME	NO	REPORTING VIEW	CONSTITUENT	PREF_FIRST_NAME	NA	NO
APBCONS_PREF_LAST_NAME	NO	REPORTING VIEW	CONSTITUENT	PREF_LAST_NAME	NA	NO
APBCONS_PREF_MI	NO	REPORTING VIEW	CONSTITUENT	PREF_MIDDLE_INITIAL	NA	NO
APBCONS_SOCIETY_NAME	NO	REPORTING VIEW	CONSTITUENT	SOCIETY_NAME	NA	NO
APBCONS_STAT_CODE_HOME	NO	REPORTING VIEW	CONSTITUENT	HOMETOWN_STATE	NA	NO

Ver: 9.0