RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE 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)    
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)    
COMB_MAILING_ADDR_TYPE This field specifies the address type to be used for the combined mailing. VARCHAR2(21)    
COMB_MAILING_ADDR_TYPE_DESC This field identifies the address type associated with the type code. VARCHAR2(30)    
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)    
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)    
HIGHEST_GIFT_AMOUNT This is the highest gift ever received from the constituent. NUMBER(11, 2)    
HIGHEST_GIFT_DATE This is the date of the highest gift ever received from the constituent. DATE    
HIGHEST_GIFT_FISCAL_YEAR This is the fiscal year associated with the highest gift ever received from the constituent. NUMBER(4)    
HIGHEST_GIFT_FISCAL_YEAR_DESC This is the description of the highest fiscal year. VARCHAR2(30)    
HIGHEST_GIFT_NUMBER This is the gift number of the highest gift ever received from the constituent. VARCHAR2(7)    
HOMETOWN This field specifies the constituents hometown. VARCHAR2(20)    
HOMETOWN_NATION This field specifies the country of the constituents hometown. VARCHAR2(5)    
HOMETOWN_NATION_DESC This field specifies the nation/country associated with the nation code. VARCHAR2(30)    
HOMETOWN_STATE This field specifies the state of the constituents hometown. VARCHAR2(3)    
HOMETOWN_STATE_DESC This field specifies the state associated with the state code. VARCHAR2(30)    
INCOME_LEVEL This field specifies the constituents income level. VARCHAR2(2)    
INCOME_LEVEL_DESC This field specifies the description of the income level code. VARCHAR2(30)    
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(30)

FUNCTION

GOKODSF.F_GET_DESC

LIFE_GIFT_SOCIETY Lifetime gift society. VARCHAR2(4)

FUNCTION

F_LIFE_GIFT_SOCIETY

LIFE_GIFT_SOCIETY_DESC Lifetime gift society description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

LIFE_GIFT_SOCIETY_TYPE Lifetime gift society type. VARCHAR2(2)

FUNCTION

F_LIFE_GIFT_SOCIETY

LIFE_GIFT_SOCIETY_TYPE_DESC Lifetime gift society type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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)    
MAIDEN_LAST_NAME This field specifies the constituents maiden name. VARCHAR2(25)    
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)    
OCCUPATIONAL_TITLE This field specifies the constituents occupational title. VARCHAR2(4)    
OCCUPATIONAL_TITLE_DESC This field specifies the description of the occupation code. VARCHAR2(30)    
PARENTS_NAME This field specifies the name of the constituents parents. VARCHAR2(50)    
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)

FUNCTION

GOKODSF.F_GET_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)    
PREF_ADDR_TYPE_GEOR_DESC This field identifies the address type associated with the type code. VARCHAR2(30)    
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)    
PREF_CLASS_DESC This field specifies the class (e.g. freshman, sophomore, first year law, etc.) associated with the class code. VARCHAR2(30)    
PREF_COLLEGE This field specifies the college within the institution with which the constituent prefers to be associated. VARCHAR2(2)    
PREF_COLLEGE_DESC This field specifies the college or school associated with the college code. VARCHAR2(30)    
PREF_FIRST_NAME This field specifies the preferred first name of the constituent. VARCHAR2(15)    
PREF_LAST_NAME This field specifies the preferred last name of the constituent. VARCHAR2(25)    
PREF_MIDDLE_INITIAL This field specifies the preferred middle initial of the constituent. VARCHAR2(1)    
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)    
STANDARD_INDUSTRY This field specifies the organizations standard industry code. VARCHAR2(4)    
STANDARD_INDUSTRY_DESC This field specifies the description of the SIC. VARCHAR2(30)    
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 3.1