Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: ORGANIZATIONAL_CONSTITUENT

Description Contains profile information relevant to organizations that have had an association or philanthropic interest in the institution. Data includes donor and prospect indicators, primary donor category, matching gift rules and summary giving information.
Key & Frequency One row per entity.
Recommended Search Columns ENTITY_UID

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ADDRESS_COUNT Count of current active addresses for this person or entity. NUMBER

FUNCTION

MSKFUNC.F_COUNT_ADDRESSES

NO

NO
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

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

AOBORGN

AOBORGN_BUSINESS

NO

NO
CONTACT_COUNT Count the number of contacts made by the institution to this constituent organization. NUMBER

FUNCTION

MAKFUNC.F_COUNT_ORGN_CONTACT

NO

NO
DONOR_CATEGORY_COUNT Count of donor categories associated with this constituent that is an organization entity. NUMBER

FUNCTION

MAKFUNC.F_COUNT_DONOR_CATEGORY

NO

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

FUNCTION

F_DONOR_IND

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(63)

AOBORGN

AOBORGN_EIN

NO

NO
FUND_COUNT Count of number of institution funding activities that the organization constituent has expressed interest. NUMBER

FUNCTION

MAKFUNC.F_COUNT_FUNDING_INT

NO

NO
ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

NO

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

AOBORGN

AOBORGN_JOBC_CODE

NO

NO
JOB_CATEGORY_DESC Job category code description. VARCHAR2(255)

ATVJOBC

ATVJOBC_DESC

NO

NO
LIFE_GIFT_SOCIETY Lifetime gift society. VARCHAR2(63)

FUNCTION

AOKODSF.F_LIFE_GIFT_SOCIETY

NO

NO
LIFE_GIFT_SOCIETY_DESC Lifetime gift society description. VARCHAR2(255)

ATVDCNP

ATVDCNP_DESC

NO

NO
LIFE_GIFT_SOCIETY_TYPE Lifetime gift society type. VARCHAR2(63)

FUNCTION

AOKODSF.F_LIFE_GIFT_SOCIETY

NO

NO
LIFE_GIFT_SOCIETY_TYPE_DESC Lifetime gift society type description.G14244. VARCHAR2(255)

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
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 The annual total an organization will match per employee. This field is for information only. 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 will give. NUMBER

AOBORGN

AOBORGN_MATCH_PERSON_MAX

NO

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

AOBORGN

AOBORGN_MATCH_ORG_MAX

NO

NO
MOST_RECENT_GIFT_AMT Most recent gift amount. NUMBER

FUNCTION

F_MOST_RECENT_GIFT_AMOUNT

NO

NO
MOST_RECENT_GIFT_DATE Most recent gift date. DATE

FUNCTION

F_MOST_RECENT_GIFT_AMOUNT

NO

NO
MOST_RECENT_GIFT_NUMBER Most recent gift number. VARCHAR2(63)

AGBGIFT

AGBGIFT_GIFT_NO

NO

NO
MOST_RECENT_PLEDGE_AMT Most recent pledge amount. NUMBER

FUNCTION

F_MOST_RECENT_PLEDGE_AMOUNT

NO

NO
MOST_RECENT_PLEDGE_DATE Most recent pledge date. DATE

FUNCTION

F_MOST_RECENT_PLEDGE_AMOUNT

NO

NO
MOST_RECENT_PLEDGE_NUMBER Most recent pledge number. VARCHAR2(63)

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
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(63)

FUNCTION

F_FORMAT_NAME

NO

NO
PHONE_COUNT Count of phone records. NUMBER

FUNCTION

MSKFUNC.F_COUNT_TELEPHONES

NO

NO
PREF_ADDRESS_NUMBER Sequence used to identify different addresses within the same address type. NUMBER

AOBORGN

AOBORGN_PREF_ATYP_SEQNO

NO

NO
PREF_ADDRESS_TYPE Address to use for the organizational contact. VARCHAR2(63)

AOBORGN

AOBORGN_PREF_ATYP_CODE

NO

NO
PREF_ADDRESS_TYPE_DESC Address type description. VARCHAR2(255)

STVATYP

STVATYP_DESC

NO

NO
PRIMARY_DONOR_CATEGORY Primary donor code. VARCHAR2(63)

APRCATG

APRCATG_DONR_CODE

NO

NO
PRIMARY_DONOR_CATEGORY_DESC Preferred donor description. VARCHAR2(255)

ATVDONR

ATVDONR_DESC

NO

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

NA

NA

NO

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

FUNCTION

F_PROSPECT_IND

NO

NO
STANDARD_INDUSTRY_CODE Organization's standard industry code (sic). VARCHAR2(63)

AOBORGN

AOBORGN_SICC_CODE

NO

NO
STANDARD_INDUSTRY_CODE_DESC Standard industry code (sic) description. VARCHAR2(255)

ATVSICC

ATVSICC_DESC

NO

NO


Ver: 9.2