RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: APBCONS Advancement Composite View Reports
SGHE Operational Data Store Composite View Source: APBCONS

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_PROSPECT_INFO

AA_CONSTITUENT

PREF_GEO_REGION_ADDR_TYPE

PREF_ADDR_TYPE_GEOR

NA
APBCONS_ATYP_CODE_PREF APACONS       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       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: 3.1