Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

Banner Operational Data Store
Composite View Target: AA_CONSTITUENT

Description Source composite view contains biographic and demographic information for all persons, including summary detail on total to-date giving and institutional involvment.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ADDRESS_NAME Name to be used with the preferred address type. VARCHAR2(120)

APBCONS

APBCONS_ADDR_NAME

NO

NO
BUSINESS This field specifies the organizations general category of business. VARCHAR2(30)

NA

NA

NO

NO
COMBINED_MAILING_NAME Combined mailing name for the constituent. VARCHAR2(120)

APBCONS

APBCONS_CM_NAME

NO

NO
COMB_MAILING_ADDR_TYPE Address type to be used for the combined mailing. VARCHAR2(2)

APBCONS

APBCONS_ATYP_CODE_CM

NO

NO
COMB_MAILING_ADDR_TYPE_DESC Address type description. VARCHAR2(30)

STVATYP

STVATYP_DESC

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
DONOR_IND Indicates whether the organization constituent or constituent has been a donor. VARCHAR2(1)

FUNCTION

F_DONOR_IND

NO

NO
ENTITY_IND This is the indicator that specifies if the consituent is a 'P'erson or 'O'rganization. VARCHAR2(1)

CONSTANT

'P'

NO

NO
ENTITY_UID System generated number that is internally generated to uniquely identify the person. NUMBER

APBCONS

APBCONS_PIDM

NO

NO
FEDERAL_IDENTIFICATION This field specifies the organizations federal identification number. VARCHAR2(9)

NA

NA

NO

NO
GRADUATION_NAME Constituent's name at the time of college graduation. VARCHAR2(120)

APBCONS

APBCONS_GRAD_NAME

NO

NO
HIGHEST_GIFT_AMOUNT Highest gift ever received from the constituent. NUMBER

APBGHIS

APBGHIS_HIGH_GIFT_AMT

NO

NO
HIGHEST_GIFT_DATE Date of the highest gift ever received from the constituent. DATE

APBGHIS

APBGHIS_HIGH_GIFT_DATE

NO

NO
HIGHEST_GIFT_FISCAL_YEAR Fiscal year associated with the highest gift ever received from the constituent. NUMBER

APBGHIS

APBGHIS_FISC_CODE_HIGH_GIFT

NO

NO
HIGHEST_GIFT_FISCAL_YEAR_DESC Description of the highest fiscal year. VARCHAR2(30)

ATVFISC

ATVFISC_DESC

NO

NO
HIGHEST_GIFT_NUMBER Gift number of the highest gift ever received from the constituent. VARCHAR2(7)

AGBGIFT

AGBGIFT_GIFT_NO

NO

NO
HOMETOWN Constituent's hometown. VARCHAR2(50)

APBCONS

APBCONS_HOME_CITY

NO

NO
HOMETOWN_NATION Country of the constituent's hometown. VARCHAR2(5)

APBCONS

APBCONS_NATN_CODE_HOME

NO

NO
HOMETOWN_NATION_DESC Nation/country description. VARCHAR2(30)

STVNATN

STVNATN_NATION

NO

NO
HOMETOWN_STATE State of the constituent's hometown. VARCHAR2(3)

APBCONS

APBCONS_STAT_CODE_HOME

NO

NO
HOMETOWN_STATE_DESC State/province name. VARCHAR2(30)

STVSTAT

STVSTAT_DESC

NO

NO
INCOME_LEVEL Constituent's income level. VARCHAR2(2)

APBCONS

APBCONS_INCM_CODE

NO

NO
INCOME_LEVEL_DESC Income level code description. VARCHAR2(30)

ATVINCM

ATVINCM_DESC

NO

NO
JOB_CATEGORY This field specifies the job category associated with the organizational contacts title. VARCHAR2(3)

NA

NA

NO

NO
JOB_CATEGORY_DESC This field specifies the description of the job category code. VARCHAR2(30)

NA

NA

NO

NO
LIFE_GIFT_SOCIETY Lifetime gift society. VARCHAR2(4)

FUNCTION

AOKODSF.F_LIFE_GIFT_SOCIETY

NO

NO
LIFE_GIFT_SOCIETY_DESC Lifetime gift society description. VARCHAR2(60)

ATVDCNP

ATVDCNP_DESC

NO

NO
LIFE_GIFT_SOCIETY_TYPE Lifetime gift society type. VARCHAR2(2)

FUNCTION

AOKODSF.F_LIFE_GIFT_SOCIETY

NO

NO
LIFE_GIFT_SOCIETY_TYPE_DESC Lifetime gift society type description. VARCHAR2(30)

ATVDCST

ATVDCST_DESC

NO

NO
LIFE_TOTAL_COMMITMENT Lifetime total commitments. NUMBER

FUNCTION

F_LIFE_TOTAL_COMMITMENT

NO

NO
LIFE_TOTAL_GIVING Lifetime total giving. NUMBER

FUNCTION

F_LIFE_TOTAL_GIVING

NO

NO
LIFE_TOTAL_PLEDGE_AMT Lifetime total pledged amount. NUMBER

FUNCTION

F_LIFE_TOTAL_PLEDGED_AMOUNT

NO

NO
LIFE_TOTAL_PLEDGE_PAY Lifetime total pledge payments. NUMBER

FUNCTION

F_LIFE_TOTAL_PLEDGE_PAYMENT

NO

NO
LOST_ALUMNUS_IND Lost alumnus indicator. VARCHAR2(1)

FUNCTION

F_LOST_AL_IND

NO

NO
MAIDEN_LAST_NAME Constituent's maiden name. VARCHAR2(25)

APBCONS

APBCONS_MAIDEN_LAST_NAME

NO

NO
MATCHING_GIFT_PERCENT This field specifies the organizations matching gift percentage. NUMBER

NA

NA

NO

NO
MATCHING_GIFT_UID Internal Id number for the matching gift company associated with the organization. The id may be the same id or the parent id. NUMBER

NA

NA

NO

NO
MATCH_MAXIMUM The maximum matching gift amount allowed. NUMBER

NA

NA

NO

NO
MATCH_MINIMUM Minimum amount organization will match. NUMBER

NA

NA

NO

NO
MAX_MATCH_ORG_EMPL_YEAR Maximum corporate matching gift payout per employee per year. NUMBER

NA

NA

NO

NO
MAX_PERSON_MATCH_AMOUNT Amount an employee can be matched per year. NUMBER

NA

NA

NO

NO
MAX_YEAR_DONATE_AMOUNT Amount the organization will donate to an institution per year. NUMBER

NA

NA

NO

NO
MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
MOST_RECENT_GIFT_AMT Most recent gift amount. NUMBER

AGBGIFT

AGBGIFT_AMT_TOT

NO

NO
MOST_RECENT_GIFT_DATE Most recent gift date. DATE

AGBGIFT

AGBGIFT_GIFT_DATE

NO

NO
MOST_RECENT_GIFT_NUMBER Most recent gift number. VARCHAR2(7)

AGBGIFT

AGBGIFT_GIFT_NO

NO

NO
MOST_RECENT_PLEDGE_AMT Most recent pledge amount. NUMBER

AGBPLDG

AGBPLDG_AMT_PLEDGED

NO

NO
MOST_RECENT_PLEDGE_DATE Most recent pledge date. DATE

AGBPLDG

AGBPLDG_PLEDGE_DATE

NO

NO
MOST_RECENT_PLEDGE_NUMBER Most recent pledge number. VARCHAR2(7)

AGBPLDG

AGBPLDG_PLEDGE_NO

NO

NO
MULTIPLE_RATIOS_IND This field specifies if multiple ratios exist for the id. VARCHAR2(1)

NA

NA

NO

NO
NICKNAME Nickname used by the constituent. VARCHAR2(40)

APBCONS

APBCONS_NICKNAME

NO

NO
OCCUPATIONAL_TITLE Constituent's occupational title. VARCHAR2(4)

APBCONS

APBCONS_DOTT_CODE

NO

NO
OCCUPATIONAL_TITLE_DESC Occupation code description. VARCHAR2(60)

ATVDOTT

ATVDOTT_DESC

NO

NO
PARENTS_NAME Name of the constituent's parents. VARCHAR2(50)

APBCONS

APBCONS_PARENTS_NAME

NO

NO
PREF_ADDRESS_TYPE This field specifies the address to use for the organizational contact. VARCHAR2(2)

APBCONS

APBCONS_ATYP_CODE_PREF

NO

NO
PREF_ADDRESS_TYPE_DESC This field identifies the address type associated with the type code. VARCHAR2(30)

STVATYP

STVATYP_DESC

NO

NO
PREF_ADDR_TYPE_GEOR Address type for the address to be used as the preferred geographic region address. VARCHAR2(2)

APBCONS

APBCONS_ATYP_CODE_GEOR

NO

NO
PREF_ADDR_TYPE_GEOR_DESC Geographic region for the address description. VARCHAR2(30)

STVATYP

STVATYP_DESC

NO

NO
PREF_CLASS Year in which the constituent received the first degree, or the year of expected graduation if the first degree has not been earned. VARCHAR2(4)

APBCONS

APBCONS_PREF_CLAS

NO

NO
PREF_CLASS_DESC This field specifies the class (e.g. freshman, sophomore, first year law, etc.) associated with the class code. VARCHAR2(30)

NA

NA

NO

NO
PREF_COLLEGE College within the institution with which the constituent prefers to be associated. VARCHAR2(2)

APBCONS

APBCONS_COLL_CODE_PREF

NO

NO
PREF_COLLEGE_DESC College, faculty or school name. VARCHAR2(30)

STVCOLL

STVCOLL_DESC

NO

NO
PREF_FIRST_NAME Preferred first name of the constituent. VARCHAR2(60)

APBCONS

APBCONS_PREF_FIRST_NAME

NO

NO
PREF_LAST_NAME Preferred last name of the constituent. VARCHAR2(60)

APBCONS

APBCONS_PREF_LAST_NAME

NO

NO
PREF_MIDDLE_INITIAL Preferred middle initial of the constituent. VARCHAR2(60)

APBCONS

APBCONS_PREF_MI

NO

NO
PRIMARY_DONOR_CATEGORY This is the preferred donor code. VARCHAR2(4)

ATVDONR

ATVDONR_CODE

NO

NO
PRIMARY_DONOR_CATEGORY_DESC This is the description of preferred donor code. VARCHAR2(30)

ATVDONR

ATVDONR_DESC

NO

NO
PROSPECT_IND Indicates whether the person has a prospect record. VARCHAR2(1)

FUNCTION

F_PROSPECT_IND

NO

NO
SOCIETY_NAME Gift society name. VARCHAR2(120)

APBCONS

APBCONS_SOCIETY_NAME

NO

NO
STANDARD_INDUSTRY This field specifies the organizations standard industry code. VARCHAR2(4)

NA

NA

NO

NO
STANDARD_INDUSTRY_DESC This field specifies the description of the SIC. VARCHAR2(30)

NA

NA

NO

NO
ZONE_VALUE Institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(6)

NA

NA

NO

NO


Ver: