Composite View Target: AA_ORGANIZATIONAL

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Advancement Composite View Reports

SGHE 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

ADDRESS_NAME This field specifies the name to be used with the preferred address type. VARCHAR2(35)
NA

NA

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

AOBORGN_BUSINESS

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

NA

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

NA

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

NA

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

SYSDATE

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

NA

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

F_DONOR_IND

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

'O'

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER(8)
AOBORGN

AOBORGN_PIDM

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

AOBORGN_EIN

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

NA

HIGHEST_GIFT_AMOUNT This is the highest gift ever received from the constituent. NUMBER(11, 2)
NA

NA

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

NA

HIGHEST_GIFT_FISCAL_YEAR This is the fiscal year associated with the highest gift ever received from the constituent. NUMBER(4)
NA

NA

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

NA

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

NA

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

NA

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

NA

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

NA

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

NA

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

NA

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

NA

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

NA

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

AOBORGN_JOBC_CODE

JOB_CATEGORY_DESC Job category code description. VARCHAR2(60)
ATVJOBC

ATVJOBC_DESC

LIFE_GIFT_SOCIETY Lifetime gift society. VARCHAR2(4)
FUNCTION

AOKODSF.F_LIFE_GIFT_SOCIETY

LIFE_GIFT_SOCIETY_DESC Lifetime gift society description. VARCHAR2(30)
ATVDCNP

ATVDCNP_DESC

LIFE_GIFT_SOCIETY_TYPE Lifetime gift society type. VARCHAR2(2)
FUNCTION

AOKODSF.F_LIFE_GIFT_SOCIETY

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

ATVDCST_DESC

LIFE_TOTAL_COMMITMENT Lifetime total commitments. NUMBER
FUNCTION

F_LIFE_TOTAL_COMMITMENT

LIFE_TOTAL_GIVING Lifetime total giving. NUMBER
FUNCTION

F_LIFE_TOTAL_GIVING

LIFE_TOTAL_PLEDGE_AMT Lifetime total pledged amount. NUMBER
FUNCTION

F_LIFE_TOTAL_PLEDGED_AMOUNT

LIFE_TOTAL_PLEDGE_PAY Lifetime total pledge payments. NUMBER
FUNCTION

F_LIFE_TOTAL_PLEDGE_PAYMENT

LOST_ALUMNUS_IND This is the lost alumnus indicator VARCHAR2(1)
NA

NA

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

NA

MATCHING_GIFT_PERCENT Organization's matching gift percentage. NUMBER(3)
AOBORGN

AOBORGN_MATCH_PCT

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(8)
AOBORGN

AOBORGN_MG_PIDM

MATCH_MAXIMUM Maximum matching gift amount allowed. NUMBER(11, 2)
AOBORGN

AOBORGN_MATCH_MAXIMUM

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(11, 2)
AOBORGN

AOBORGN_MATCH_MINIMUM

MAX_MATCH_ORG_EMPL_YEAR Maximum corporate matching gift payout per employee per year. NUMBER(11, 2)
AOBORGN

AOBORGN_MATCH_ORG_EMPL_YR

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(11, 2)
AOBORGN

AOBORGN_MATCH_PERSON_MAX

MAX_YEAR_DONATE_AMOUNT Maximum amount the organization will donate to an institution per year. NUMBER(11, 2)
AOBORGN

AOBORGN_MATCH_ORG_MAX

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

NA

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

NA

MOST_RECENT_GIFT_AMT Most recent gift amount. NUMBER(11, 2)
AGBGIFT

AGBGIFT_AMT_TOT

MOST_RECENT_GIFT_DATE Most recent gift date. DATE
AGBGIFT

AGBGIFT_GIFT_DATE

MOST_RECENT_GIFT_NUMBER Most recent gift number. VARCHAR2(7)
AGBGIFT

AGBGIFT_GIFT_NO

MOST_RECENT_PLEDGE_AMT Most recent pledge amount. NUMBER(11, 2)
AGBPLDG

AGBPLDG_AMT_PLEDGED

MOST_RECENT_PLEDGE_DATE Most recent pledge date. DATE
AGBPLDG

AGBPLDG_PLEDGE_DATE

MOST_RECENT_PLEDGE_NUMBER Most recent pledge number. VARCHAR2(7)
AGBPLDG

AGBPLDG_PLEDGE_NO

MULTIPLE_RATIOS_IND Specifies whether multiple ratios exist for this organization constituent. VARCHAR2(1)
FUNCTION

F_MULTIPLE_RATIOS

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

NA

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

NA

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

NA

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

NA

PREF_ADDRESS_TYPE Address to use for the organizational contact. VARCHAR2(2)
AOBORGN

AOBORGN_ATYP_CODE

PREF_ADDRESS_TYPE_DESC Address type description. VARCHAR2(30)
STVATYP

STVATYP_DESC

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

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

NA

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

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

PREF_COLLEGE This field specifies the college within the institution with which the constituent prefers to be associated. VARCHAR2(2)
NA

NA

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

NA

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

NA

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

NA

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

NA

PRIMARY_DONOR_CATEGORY Primary donor code. VARCHAR2(4)
APRCATG

APRCATG_DONR_CODE

PRIMARY_DONOR_CATEGORY_DESC Preferred donor description. VARCHAR2(30)
ATVDONR

ATVDONR_DESC

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

F_PROSPECT_IND

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

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

AOBORGN_SICC_CODE

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

ATVSICC_DESC

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

NA

Ver: 8.1

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_NAME	This field specifies the name to be used with the preferred address type.	VARCHAR2(35)	NA	NA
BUSINESS	Organization's general category of business.	VARCHAR2(30)	AOBORGN	AOBORGN_BUSINESS
COMBINED_MAILING_NAME	This field specifies the combined mailing name for the constituent.	VARCHAR2(50)	NA	NA
COMB_MAILING_ADDR_TYPE	This field specifies the address type to be used for the combined mailing.	VARCHAR2(21)	NA	NA
COMB_MAILING_ADDR_TYPE_DESC	This field identifies the address type associated with the type code.	VARCHAR2(30)	NA	NA
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
DONOR_IND	Indicates whether the organization constituent or constituent has been a donor.	VARCHAR2(1)	FUNCTION	F_DONOR_IND
ENTITY_IND	This is the indicator that specifies if the consituent is a 'P'erson or 'O'rganization.	VARCHAR2(1)	CONSTANT	'O'
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)	AOBORGN	AOBORGN_PIDM
FEDERAL_IDENTIFICATION	Organization's federal government assigned identification number.	VARCHAR2(9)	AOBORGN	AOBORGN_EIN
GRADUATION_NAME	This field specifies the constituents name at the time of college graduation.	VARCHAR2(60)	NA	NA
HIGHEST_GIFT_AMOUNT	This is the highest gift ever received from the constituent.	NUMBER(11, 2)	NA	NA
HIGHEST_GIFT_DATE	This is the date of the highest gift ever received from the constituent.	DATE	NA	NA
HIGHEST_GIFT_FISCAL_YEAR	This is the fiscal year associated with the highest gift ever received from the constituent.	NUMBER(4)	NA	NA
HIGHEST_GIFT_FISCAL_YEAR_DESC	This is the description of the highest fiscal year.	VARCHAR2(30)	NA	NA
HIGHEST_GIFT_NUMBER	This is the gift number of the highest gift ever received from the constituent.	VARCHAR2(7)	NA	NA
HOMETOWN	This field specifies the constituents hometown.	VARCHAR2(20)	NA	NA
HOMETOWN_NATION	This field specifies the country of the constituents hometown.	VARCHAR2(5)	NA	NA
HOMETOWN_NATION_DESC	This field specifies the nation/country associated with the nation code.	VARCHAR2(30)	NA	NA
HOMETOWN_STATE	This field specifies the state of the constituents hometown.	VARCHAR2(3)	NA	NA
HOMETOWN_STATE_DESC	This field specifies the state associated with the state code.	VARCHAR2(30)	NA	NA
INCOME_LEVEL	This field specifies the constituents income level.	VARCHAR2(2)	NA	NA
INCOME_LEVEL_DESC	This field specifies the description of the income level code.	VARCHAR2(30)	NA	NA
JOB_CATEGORY	Job category associated with the organizational contact's title.	VARCHAR2(3)	AOBORGN	AOBORGN_JOBC_CODE
JOB_CATEGORY_DESC	Job category code description.	VARCHAR2(60)	ATVJOBC	ATVJOBC_DESC
LIFE_GIFT_SOCIETY	Lifetime gift society.	VARCHAR2(4)	FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY
LIFE_GIFT_SOCIETY_DESC	Lifetime gift society description.	VARCHAR2(30)	ATVDCNP	ATVDCNP_DESC
LIFE_GIFT_SOCIETY_TYPE	Lifetime gift society type.	VARCHAR2(2)	FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY
LIFE_GIFT_SOCIETY_TYPE_DESC	Lifetime gift society type description.	VARCHAR2(30)	ATVDCST	ATVDCST_DESC
LIFE_TOTAL_COMMITMENT	Lifetime total commitments.	NUMBER	FUNCTION	F_LIFE_TOTAL_COMMITMENT
LIFE_TOTAL_GIVING	Lifetime total giving.	NUMBER	FUNCTION	F_LIFE_TOTAL_GIVING
LIFE_TOTAL_PLEDGE_AMT	Lifetime total pledged amount.	NUMBER	FUNCTION	F_LIFE_TOTAL_PLEDGED_AMOUNT
LIFE_TOTAL_PLEDGE_PAY	Lifetime total pledge payments.	NUMBER	FUNCTION	F_LIFE_TOTAL_PLEDGE_PAYMENT
LOST_ALUMNUS_IND	This is the lost alumnus indicator	VARCHAR2(1)	NA	NA
MAIDEN_LAST_NAME	This field specifies the constituents maiden name.	VARCHAR2(25)	NA	NA
MATCHING_GIFT_PERCENT	Organization's matching gift percentage.	NUMBER(3)	AOBORGN	AOBORGN_MATCH_PCT
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(8)	AOBORGN	AOBORGN_MG_PIDM
MATCH_MAXIMUM	Maximum matching gift amount allowed.	NUMBER(11, 2)	AOBORGN	AOBORGN_MATCH_MAXIMUM
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(11, 2)	AOBORGN	AOBORGN_MATCH_MINIMUM
MAX_MATCH_ORG_EMPL_YEAR	Maximum corporate matching gift payout per employee per year.	NUMBER(11, 2)	AOBORGN	AOBORGN_MATCH_ORG_EMPL_YR
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(11, 2)	AOBORGN	AOBORGN_MATCH_PERSON_MAX
MAX_YEAR_DONATE_AMOUNT	Maximum amount the organization will donate to an institution per year.	NUMBER(11, 2)	AOBORGN	AOBORGN_MATCH_ORG_MAX
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
MOST_RECENT_GIFT_AMT	Most recent gift amount.	NUMBER(11, 2)	AGBGIFT	AGBGIFT_AMT_TOT
MOST_RECENT_GIFT_DATE	Most recent gift date.	DATE	AGBGIFT	AGBGIFT_GIFT_DATE
MOST_RECENT_GIFT_NUMBER	Most recent gift number.	VARCHAR2(7)	AGBGIFT	AGBGIFT_GIFT_NO
MOST_RECENT_PLEDGE_AMT	Most recent pledge amount.	NUMBER(11, 2)	AGBPLDG	AGBPLDG_AMT_PLEDGED
MOST_RECENT_PLEDGE_DATE	Most recent pledge date.	DATE	AGBPLDG	AGBPLDG_PLEDGE_DATE
MOST_RECENT_PLEDGE_NUMBER	Most recent pledge number.	VARCHAR2(7)	AGBPLDG	AGBPLDG_PLEDGE_NO
MULTIPLE_RATIOS_IND	Specifies whether multiple ratios exist for this organization constituent.	VARCHAR2(1)	FUNCTION	F_MULTIPLE_RATIOS
NICKNAME	This field specifies the nickname used by the constituent.	VARCHAR2(40)	NA	NA
OCCUPATIONAL_TITLE	This field specifies the constituents occupational title.	VARCHAR2(4)	NA	NA
OCCUPATIONAL_TITLE_DESC	This field specifies the description of the occupation code.	VARCHAR2(30)	NA	NA
PARENTS_NAME	This field specifies the name of the constituents parents.	VARCHAR2(50)	NA	NA
PREF_ADDRESS_TYPE	Address to use for the organizational contact.	VARCHAR2(2)	AOBORGN	AOBORGN_ATYP_CODE
PREF_ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(30)	STVATYP	STVATYP_DESC
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
PREF_ADDR_TYPE_GEOR_DESC	This field identifies the address type associated with the type code.	VARCHAR2(30)	NA	NA
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
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
PREF_COLLEGE	This field specifies the college within the institution with which the constituent prefers to be associated.	VARCHAR2(2)	NA	NA
PREF_COLLEGE_DESC	This field specifies the college or school associated with the college code.	VARCHAR2(30)	NA	NA
PREF_FIRST_NAME	This field specifies the preferred first name of the constituent.	VARCHAR2(15)	NA	NA
PREF_LAST_NAME	This field specifies the preferred last name of the constituent.	VARCHAR2(25)	NA	NA
PREF_MIDDLE_INITIAL	This field specifies the preferred middle initial of the constituent.	VARCHAR2(1)	NA	NA
PRIMARY_DONOR_CATEGORY	Primary donor code.	VARCHAR2(4)	APRCATG	APRCATG_DONR_CODE
PRIMARY_DONOR_CATEGORY_DESC	Preferred donor description.	VARCHAR2(30)	ATVDONR	ATVDONR_DESC
PROSPECT_IND	Indicates whether this entity has a prospect record.	VARCHAR2(1)	FUNCTION	F_PROSPECT_IND
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
STANDARD_INDUSTRY	This field specifies the organizations standard industry code.	VARCHAR2(4)	AOBORGN	AOBORGN_SICC_CODE
STANDARD_INDUSTRY_DESC	This field specifies the description of the SIC.	VARCHAR2(60)	ATVSICC	ATVSICC_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA