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

Banner Operational Data Store
Composite View Target: AA_ORGANIZATIONAL_CONSTITUENT

Description Source composite view contains biographic and demographic information for all organizations, including donor categories, matching gift rules, institutional affiliations and summary detail on giving history.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ADDRESS_NAME This field specifies the name to be used with the preferred address type. VARCHAR2(35)

NA

NA

NO

NO
BUSINESS Organization's general category of business. VARCHAR2(30)

AOBORGN

AOBORGN_BUSINESS

NO

NO
COMBINED_MAILING_NAME This field specifies the combined mailing name for the constituent. VARCHAR2(50)

NA

NA

NO

NO
COMB_MAILING_ADDR_TYPE This field specifies the address type to be used for the combined mailing. VARCHAR2(21)

NA

NA

NO

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

NA

NA

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

'O'

NO

NO
ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

AOBORGN

AOBORGN_PIDM

NO

NO
FEDERAL_IDENTIFICATION Organization's federal government assigned identification number. VARCHAR2(9)

AOBORGN

AOBORGN_EIN

NO

NO
GRADUATION_NAME This field specifies the constituents name at the time of college graduation. VARCHAR2(60)

NA

NA

NO

NO
HIGHEST_GIFT_AMOUNT This is the highest gift ever received from the constituent. NUMBER

NA

NA

NO

NO
HIGHEST_GIFT_DATE This is the date of the highest gift ever received from the constituent. DATE

NA

NA

NO

NO
HIGHEST_GIFT_FISCAL_YEAR This is the fiscal year associated with the highest gift ever received from the constituent. NUMBER

NA

NA

NO

NO
HIGHEST_GIFT_FISCAL_YEAR_DESC This is the description of the highest fiscal year. VARCHAR2(30)

NA

NA

NO

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

NA

NA

NO

NO
HOMETOWN This field specifies the constituents hometown. VARCHAR2(20)

NA

NA

NO

NO
HOMETOWN_NATION This field specifies the country of the constituents hometown. VARCHAR2(5)

NA

NA

NO

NO
HOMETOWN_NATION_DESC This field specifies the nation/country associated with the nation code. VARCHAR2(30)

NA

NA

NO

NO
HOMETOWN_STATE This field specifies the state of the constituents hometown. VARCHAR2(3)

NA

NA

NO

NO
HOMETOWN_STATE_DESC This field specifies the state associated with the state code. VARCHAR2(30)

NA

NA

NO

NO
INCOME_LEVEL This field specifies the constituents income level. VARCHAR2(2)

NA

NA

NO

NO
INCOME_LEVEL_DESC This field specifies the description of the income level code. VARCHAR2(30)

NA

NA

NO

NO
JOB_CATEGORY Job category associated with the organizational contact's title. VARCHAR2(3)

AOBORGN

AOBORGN_JOBC_CODE

NO

NO
JOB_CATEGORY_DESC Job category code description. VARCHAR2(60)

ATVJOBC

ATVJOBC_DESC

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 This is the lost alumnus indicator. VARCHAR2(1)

NA

NA

NO

NO
MAIDEN_LAST_NAME This field specifies the constituents maiden name. VARCHAR2(25)

NA

NA

NO

NO
MATCHING_GIFT_PERCENT Organization's matching gift percentage. NUMBER

AOBORGN

AOBORGN_MATCH_PCT

NO

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

AOBORGN

AOBORGN_MG_PIDM

NO

NO
MATCH_MAXIMUM Maximum matching gift amount allowed. NUMBER

AOBORGN

AOBORGN_MATCH_MAXIMUM

NO

NO
MATCH_MINIMUM Smallest amount a company matches. If a gift goes toward multiple designations, then the designation amount is compared to this amount in the Matching Gift Allocations Process. NUMBER

AOBORGN

AOBORGN_MATCH_MINIMUM

NO

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

AOBORGN

AOBORGN_MATCH_ORG_EMPL_YR

NO

NO
MAX_PERSON_MATCH_AMOUNT Annual total an organization matches per employee. This is different than the annual total company payout per employee in that it identifies how much of donors' gifts will be matched, and not the matching gift amount that the company gives. This field is for information only. NUMBER

AOBORGN

AOBORGN_MATCH_PERSON_MAX

NO

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

AOBORGN

AOBORGN_MATCH_ORG_MAX

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 Specifies whether multiple ratios exist for this organization constituent. VARCHAR2(1)

FUNCTION

F_MULTIPLE_RATIOS

NO

NO
NICKNAME This field specifies the nickname used by the constituent. VARCHAR2(40)

NA

NA

NO

NO
OCCUPATIONAL_TITLE This field specifies the constituents occupational title. VARCHAR2(4)

NA

NA

NO

NO
OCCUPATIONAL_TITLE_DESC This field specifies the description of the occupation code. VARCHAR2(30)

NA

NA

NO

NO
PARENTS_NAME This field specifies the name of the constituents parents. VARCHAR2(50)

NA

NA

NO

NO
PREF_ADDRESS_TYPE Address to use for the organizational contact. VARCHAR2(2)       NO
PREF_ADDRESS_TYPE_DESC Address type description. VARCHAR2(30)

STVATYP

STVATYP_DESC

NO

NO
PREF_ADDR_TYPE_GEOR This field specifies the address type of the address to be used as the preferred geographic region address. VARCHAR2(2)

NA

NA

NO

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

NA

NA

NO

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

NA

NA

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 This field specifies the college within the institution with which the constituent prefers to be associated. VARCHAR2(2)

NA

NA

NO

NO
PREF_COLLEGE_DESC This field specifies the college or school associated with the college code. VARCHAR2(30)

NA

NA

NO

NO
PREF_FIRST_NAME This field specifies the preferred first name of the constituent. VARCHAR2(15)

NA

NA

NO

NO
PREF_LAST_NAME This field specifies the preferred last name of the constituent. VARCHAR2(25)

NA

NA

NO

NO
PREF_MIDDLE_INITIAL This field specifies the preferred middle initial of the constituent. VARCHAR2(1)

NA

NA

NO

NO
PRIMARY_DONOR_CATEGORY Primary donor code. VARCHAR2(4)

APRCATG

APRCATG_DONR_CODE

NO

NO
PRIMARY_DONOR_CATEGORY_DESC Preferred donor description. VARCHAR2(30)

ATVDONR

ATVDONR_DESC

NO

NO
PROSPECT_IND Indicates whether this entity has a prospect record. VARCHAR2(1)

FUNCTION

F_PROSPECT_IND

NO

NO
SOCIETY_NAME Gift Society name. This name will default to gift societies when they memberships are created. The name may be modified on the society form. VARCHAR2(60)

NA

NA

NO

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

AOBORGN

AOBORGN_SICC_CODE

NO

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

ATVSICC

ATVSICC_DESC

NO

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

NA

NA

NO

NO


Ver: