RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE 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
ADDRESS_NAME Name to be used with the preferred address type. VARCHAR2(35)

APBCONS

APBCONS_ADDR_NAME

BUSINESS This field specifies the organizations general category of business. VARCHAR2(30)    
COMBINED_MAILING_NAME Combined mailing name for the constituent. VARCHAR2(50)

APBCONS

APBCONS_CM_NAME

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

APBCONS

APBCONS_ATYP_CODE_CM

COMB_MAILING_ADDR_TYPE_DESC Address type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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 number that is internally generated to uniquely identify the person. NUMBER(8)    
FEDERAL_IDENTIFICATION This field specifies the organizations federal identification number. VARCHAR2(9)    
GRADUATION_NAME Constituent's name at the time of college graduation. VARCHAR2(60)

APBCONS

APBCONS_GRAD_NAME

HIGHEST_GIFT_AMOUNT Highest gift ever received from the constituent. NUMBER(11, 2)

APBGHIS

APBGHIS_HIGH_GIFT_AMT

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

APBGHIS

APBGHIS_HIGH_GIFT_DATE

HIGHEST_GIFT_FISCAL_YEAR Fiscal year associated with the highest gift ever received from the constituent. NUMBER(4)

APBGHIS

APBGHIS_FISC_CODE_HIGH_GIFT

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

FUNCTION

GOKODSF.F_GET_DESC

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

AGBGIFT

AGBGIFT_GIFT_NO

HOMETOWN Constituent's hometown. VARCHAR2(20)

APBCONS

APBCONS_HOME_CITY

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

APBCONS

APBCONS_NATN_CODE_HOME

HOMETOWN_NATION_DESC Nation/country description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

APBCONS

APBCONS_STAT_CODE_HOME

HOMETOWN_STATE_DESC State/province name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

INCOME_LEVEL Constituent's income level. VARCHAR2(2)

APBCONS

APBCONS_INCM_CODE

INCOME_LEVEL_DESC Income level code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

JOB_CATEGORY This field specifies the job category associated with the organizational contacts title. VARCHAR2(3)    
JOB_CATEGORY_DESC This field specifies the description of the job category code. VARCHAR2(30)    
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 Lost alumnus indicator. VARCHAR2(1)

FUNCTION

F_LOST_AL_IND

MAIDEN_LAST_NAME Constituent's maiden name. VARCHAR2(25)

APBCONS

APBCONS_MAIDEN_LAST_NAME

MATCHING_GIFT_PERCENT This field specifies the organizations matching gift percentage. NUMBER(3)    
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(8)    
MATCH_MAXIMUM The maximum matching gift amount allowed. NUMBER(11, 2)    
MATCH_MINIMUM Minimum amount organization will match. NUMBER(11, 2)    
MAX_MATCH_ORG_EMPL_YEAR Maximum corporate matching gift payout per employee per year. NUMBER(11, 2)    
MAX_PERSON_MATCH_AMOUNT Amount an employee can be matched per year. NUMBER(11, 2)    
MAX_YEAR_DONATE_AMOUNT Amount the organization will donate to an institution per year. NUMBER(11, 2)    
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 This field specifies if multiple ratios exist for the id. VARCHAR2(1)    
NICKNAME Nickname used by the constituent. VARCHAR2(40)

APBCONS

APBCONS_NICKNAME

OCCUPATIONAL_TITLE Constituent's occupational title. VARCHAR2(4)

APBCONS

APBCONS_DOTT_CODE

OCCUPATIONAL_TITLE_DESC Occupation code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

APBCONS

APBCONS_PARENTS_NAME

PREF_ADDRESS_TYPE This field specifies the address to use for the organizational contact. VARCHAR2(2)    
PREF_ADDRESS_TYPE_DESC This field identifies the address type associated with the type code. VARCHAR2(30)    
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

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

FUNCTION

GOKODSF.F_GET_DESC

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

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

APBCONS

APBCONS_COLL_CODE_PREF

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

FUNCTION

GOKODSF.F_GET_DESC

PREF_FIRST_NAME Preferred first name of the constituent. VARCHAR2(15)

APBCONS

APBCONS_PREF_FIRST_NAME

PREF_LAST_NAME Preferred last name of the constituent. VARCHAR2(25)

APBCONS

APBCONS_PREF_LAST_NAME

PREF_MIDDLE_INITIAL Preferred middle initial of the constituent. VARCHAR2(1)

APBCONS

APBCONS_PREF_MI

PRIMARY_DONOR_CATEGORY This is the preferred donor code VARCHAR2(4)    
PRIMARY_DONOR_CATEGORY_DESC This is the description of preferred donor code VARCHAR2(30)    
PROSPECT_IND Indicates whether the person has a prospect record. VARCHAR2(1)

FUNCTION

F_PROSPECT_IND

SOCIETY_NAME Gift society name. VARCHAR2(60)

APBCONS

APBCONS_SOCIETY_NAME

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 Institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(6)

NA

NA



Ver: 3.1