RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Advancement Reporting View Reports

SGHE Operational Data Store
Reporting View Target: CONSTITUENT

Description Contains profile information relevant to persons who have had an association or philanthropic interest in the institution. Data includes donor and prospect indicators, class, college, donor category, spouse, child and hometown details, summary giving information and confidentiality and deceased indicators.
Key & Frequency One row per person.
Recommended Search Columns PERSON_UID

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

FUNCTION

MSKFUNC.F_COUNT_ADDRESSES

ADDRESS_NAME Name to be used with the preferred address type. VARCHAR2(255)

APBCONS

APBCONS_ADDR_NAME

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

NA

NA

CHILD_COUNT Count of child relationships recorded for the person. NUMBER

FUNCTION

MAKFUNC.F_COUNT_RELATION

COMBINED_MAILING_NAME Combined mailing name for the constituent. VARCHAR2(255)

APBCONS

APBCONS_CM_NAME

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

APBCONS

APBCONS_ATYP_CODE_CM

COMB_MAILING_ADDR_TYPE_DESC Address type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CONFIDENTIALITY_IND Specifies whether the person has requested the institution keep some of their information confidential. VARCHAR2(1)

SPBPERS

SPBPERS_CONFID_IND

CROSS_REFERENCE_COUNT Count of the number of cross reference records associated with this person. NUMBER

FUNCTION

MAKFUNC.F_COUNT_RELATION

CURRENT_AGE Current age of the constituent NUMBER

FUNCTION

F_CALCULATE_AGE

DECEASED_IND Indicates whether a person is deceased. VARCHAR2(1)

SPBPERS

SPBPERS_DEAD_IND

DEGREE_COUNT Count of the number of degrees or awards for this constituent. NUMBER

FUNCTION

MAKFUNC.F_COUNT_DEGREES

DONOR_CATEGORY_COUNT Count of donor categories associated with this constituent. NUMBER

FUNCTION

MAKFUNC.F_COUNT_DONOR_CATEGORY

DONOR_IND Indicates whether this person has been a donor. VARCHAR2(1)

FUNCTION

F_DONOR_IND

EMAIL_PREFERRED_ADDRESS The preferred email address of the person. VARCHAR2(90)

GOREMAL

GOREMAL_EMAIL_ADDRESS

EMPLOYMENT_COUNT Employment count. NUMBER

FUNCTION

MAKFUNC.F_COUNT_PREV_EMPLOYMENT

EXCLUSION_COUNT Count of the number of events, mailings, contacts, etc. for which the person or entity requests not to be informed or associated with. NUMBER

FUNCTION

MAKFUNC.F_COUNT_EXCLUSION

EXTERNAL_SOURCE_COUNT Count of the number of external source ratings associated with the constituent's record. NUMBER

FUNCTION

MAKFUNC.F_COUNT_ADVANCEMENT_RATING

GENDER The gender code of the person. VARCHAR2(63)

SPBPERS

SPBPERS_SEX

GENDER_DESC The gender code of the person. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

GRADUATION_NAME Constituent's name at the time of college graduation. VARCHAR2(255)

APBCONS

APBCONS_GRAD_NAME

HIGHEST_GIFT_AMOUNT Highest gift ever received from the constituent. NUMBER

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

APBGHIS

APBGHIS_FISC_CODE_HIGH_GIFT

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

FUNCTION

GOKODSF.F_GET_DESC

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

AGBGIFT

AGBGIFT_GIFT_NO

HOMETOWN Constituent's hometown. VARCHAR2(63)

APBCONS

APBCONS_HOME_CITY

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

APBCONS

APBCONS_NATN_CODE_HOME

HOMETOWN_NATION_DESC Nation/country description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

APBCONS

APBCONS_STAT_CODE_HOME

HOMETOWN_STATE_DESC State/province name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ID Person's or organization's current identification number. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

INCOME_LEVEL Constituent's income level. VARCHAR2(63)

APBCONS

APBCONS_INCM_CODE

INCOME_LEVEL_DESC Income level code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

LIFE_GIFT_SOCIETY Lifetime gift society. VARCHAR2(63)

FUNCTION

F_LIFE_GIFT_SOCIETY

LIFE_GIFT_SOCIETY_DESC Lifetime gift society description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

LIFE_GIFT_SOCIETY_TYPE Lifetime gift society type. VARCHAR2(63)

FUNCTION

F_LIFE_GIFT_SOCIETY

LIFE_GIFT_SOCIETY_TYPE_DESC Lifetime gift society type description. VARCHAR2(255)

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

APBCONS

APBCONS_MAIDEN_LAST_NAME

MAIL_COUNT Count of mailings, materials or publications to be sent to a constituent. NUMBER

FUNCTION

MAKFUNC.F_COUNT_MAIL

MARITAL_STATUS Marital status code of the person. VARCHAR2(63)

SPBPERS

SPBPERS_MRTL_CODE

MOST_RECENT_GIFT_AMT Most recent gift amount. NUMBER

FUNCTION

F_MOST_RECENT_GIFT_AMOUNT

MOST_RECENT_GIFT_DATE Most recent gift date. DATE

FUNCTION

F_MOST_RECENT_GIFT_AMOUNT

MOST_RECENT_GIFT_NUMBER Most recent gift number VARCHAR2(63)

AGBGIFT

AGBGIFT_GIFT_NO

MOST_RECENT_PLEDGE_AMT Most recent pledge amount. NUMBER

FUNCTION

F_MOST_RECENT_PLEDGE_AMOUNT

MOST_RECENT_PLEDGE_DATE Most recent pledge date. DATE

FUNCTION

F_MOST_RECENT_PLEDGE_AMOUNT

MOST_RECENT_PLEDGE_NUMBER Most recent pledge number VARCHAR2(63)

AGBPLDG

AGBPLDG_PLEDGE_NO

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

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

NA

NA

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

FUNCTION

F_FORMAT_NAME

NAME_PREFIX Prefix associated with the person's name. VARCHAR2(20)

CALCULATION

DECODE(SPBPERS_NAME_PREFIX,NULL,DECODE(SPBPERS_SEX,'M','MR.','F','MS.'),SPBPERS_NAME_PREFIX)

NAME_SUFFIX Suffix for the person's name. VARCHAR2(20)

SPBPERS

SPBPERS_NAME_SUFFIX

NICKNAME Nickname used by the constituent. VARCHAR2(255)

APBCONS

APBCONS_NICKNAME

OCCUPATIONAL_TITLE Constituent's occupational title. VARCHAR2(63)

APBCONS

APBCONS_DOTT_CODE

OCCUPATIONAL_TITLE_DESC Occupation code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

APBCONS

APBCONS_PARENTS_NAME

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

APBCONS

APBCONS_PIDM

PHONE_COUNT Count of phone records. NUMBER

FUNCTION

MSKFUNC.F_COUNT_TELEPHONES

PREF_ADDR_TYPE Constituent's preferred address for solicitations and acknowledgements. VARCHAR2(63)

APBCONS

APBCONS_ATYP_CODE_PREF

PREF_ADDR_TYPE_DESC Address type description. Identified type within the ERP system. For example, mailing, special purpose, summer break, billing, employment. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PREF_ADDR_TYPE_GEOR Address type of the address to be used as the preferred geographic region address. VARCHAR2(63)

APBCONS

APBCONS_ATYP_CODE_GEOR

PREF_ADDR_TYPE_GEOR_DESC Address geographic region description. VARCHAR2(255)

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 yet been earned. VARCHAR2(63)

APBCONS

APBCONS_PREF_CLAS

PREF_CLASS_DESC Constituent's preferred class description. VARCHAR2(255)

NA

NA

PREF_COLLEGE College within the institution with which the constituent prefers to be associated. VARCHAR2(63)

APBCONS

APBCONS_COLL_CODE_PREF

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

FUNCTION

GOKODSF.F_GET_DESC

PREF_DONOR_CATEGORY Primary or preferred donor category associated with this constituent. VARCHAR2(63)

APRCATG

APRCATG_DONR_CODE

PREF_DONOR_CATEGORY_DESC Primary or preferred donor category description. VARCHAR2(255)

ATVDONR

ATVDONR_DESC

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

APBCONS

APBCONS_PREF_FIRST_NAME

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

APBCONS

APBCONS_PREF_LAST_NAME

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

APBCONS

APBCONS_PREF_MI

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

NA

NA

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

FUNCTION

F_PROSPECT_IND

SOCIETY_NAME Gift society name. VARCHAR2(255)

APBCONS

APBCONS_SOCIETY_NAME

SPECIAL_ACTIVITY_COUNT Count of special activities. NUMBER

FUNCTION

MAKFUNC.F_COUNT_SPECIAL_ACTIVITY

SPECIAL_PURPOSE_GROUP_COUNT Special purpose group count. NUMBER

FUNCTION

MAKFUNC.F_COUNT_SPECIAL_PURP

SPOUSE_IND Indicates if a separate record for the constituent's spouse exists in the system. VARCHAR2(63)

FUNCTION

MAKFUNC.F_GET_SPOUSE_IND

SPOUSE_NAME Full name of the constituent's spouse LFM. VARCHAR2(100)

FUNCTION

MAKFUNC.F_GET_SPOUSE_NAME



Ver: 3.1