Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: APBCONS Advancement Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: APBCONS - NULL

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

PROSPECT_INFO

CONSTITUENT

PREF_GEO_REGION_ADDR_TYPE

PREF_ADDR_TYPE_GEOR

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

GIFT_TRANSACTION

CONSTITUENT

PREFER_COLLEGE

PREFER_COLLEGE

PREF_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

PERSON

NICKNAME

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

GIFT

GIFT_TRANSACTION

CONSTITUENT

PREFER_CLASS_YEAR

PRIMARY_DONOR_CATEGORY

PREFER_CLASS_YEAR

PREF_CLASS

NA
APBCONS_PREF_FIRST_NAME APACONS

REPORTING VIEW

CONSTITUENT

PERSON

PREF_FIRST_NAME

FIRST_NAME

NA
APBCONS_PREF_LAST_NAME APACONS

REPORTING VIEW

CONSTITUENT

PERSON

PREF_LAST_NAME

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: 8.0