Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER			APBCONS	APBCONS_PIDM	NO	NO
ID	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
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)			FUNCTION	F_FORMAT_NAME	NO	NO
DONOR_IND	Donor Indicator	Indicates whether this person has been a donor.	VARCHAR2(1)			FUNCTION	F_DONOR_IND	NO	NO
PROSPECT_IND	Prospect Indicator	Indicates whether this person has a prospect record.	VARCHAR2(1)			FUNCTION	F_PROSPECT_IND	NO	NO
LOST_ALUMNUS_IND	Lost Alumnus Indicator	Lost alumnus indicator.	VARCHAR2(1)			FUNCTION	F_LOST_AL_IND	NO	NO
PREF_LAST_NAME	Pref Last Name	Preferred last name of the constituent.	VARCHAR2(255)			APBCONS	APBCONS_PREF_LAST_NAME	NO	NO
PREF_FIRST_NAME	Pref First Name	Preferred first name of the constituent.	VARCHAR2(255)			APBCONS	APBCONS_PREF_FIRST_NAME	NO	NO
PREF_MIDDLE_INITIAL	Pref Middle Initial	Preferred middle initial of the constituent.	VARCHAR2(63)			APBCONS	APBCONS_PREF_MI	NO	NO
NICKNAME	Nickname	Nickname used by the constituent.	VARCHAR2(255)			APBCONS	APBCONS_NICKNAME	NO	NO
GRADUATION_NAME	Graduation Name	Constituent's name at the time of college graduation.	VARCHAR2(255)			APBCONS	APBCONS_GRAD_NAME	NO	NO
PARENTS_NAME	Parents Name	Name of the constituent's parents.	VARCHAR2(255)			APBCONS	APBCONS_PARENTS_NAME	NO	NO
MAIDEN_LAST_NAME	Maiden Last Name	Constituent's maiden name.	VARCHAR2(255)			APBCONS	APBCONS_MAIDEN_LAST_NAME	NO	NO
MARITAL_STATUS	Marital Status	Marital status code of the person.	VARCHAR2(63)			SPBPERS	SPBPERS_MRTL_CODE	NO	NO
CONFIDENTIALITY_IND	Confidentiality Indicator	Specifies whether the person has requested the institution keep some of their information confidential.	VARCHAR2(1)			SPBPERS	SPBPERS_CONFID_IND	NO	NO
DECEASED_IND	Deceased Indicator	Indicates whether a person is deceased.	VARCHAR2(1)			SPBPERS	SPBPERS_DEAD_IND	NO	NO
CURRENT_AGE	Current Age	Current age of the constituent.	NUMBER			FUNCTION	F_CALCULATE_AGE	NO	NO
GENDER	Gender	Identifies the gender of the person.	VARCHAR2(63)			SPBPERS	SPBPERS_SEX	NO	NO
GENDER_DESC	Gender description	The gender code of the person.	VARCHAR2(63)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GENDER_DESIGNATION	Gender Designation	This gender identity of the person.	VARCHAR2(63)			SPBPERS	SPBPERS_GNDR_CODE	NO	NO
GENDER_DESIGNATION_DESC	Gender Designation Description	The description of the gender identity.	VARCHAR2(255)			GTVGNDR	GTVGNDR_GNDR_DESC	NO	NO
PERSONAL_PRONOUN	Personal Pronoun	The personal pronoun of the person.	VARCHAR2(63)			SPBPERS	SPBPERS_PPRN_CODE	NO	NO
PERSONAL_PRONOUN_DESC	Personal Pronoun Desc	The description of the personal pronoun.	VARCHAR2(255)			GTVPPRN	GTVPPRN_PPRN_DESC	NO	NO
SPOUSE_NAME	Spouse Name	Full name of the constituent's spouse LFM.	VARCHAR2(100)			FUNCTION	MAKFUNC.F_GET_SPOUSE_NAME	NO	NO
NAME_PREFIX	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)	NO	NO
NAME_SUFFIX	Name Suffix	Suffix for the person's name.	VARCHAR2(20)			SPBPERS	SPBPERS_NAME_SUFFIX	NO	NO
PREF_CLASS	Preferred Class Year	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	NO	NO
PREF_CLASS_DESC	Preferred Class Year Description	Constituent's preferred class description.	VARCHAR2(255)			NA	NA	NO	NO
PREF_COLLEGE	Pref College	College within the institution with which the constituent prefers to be associated.	VARCHAR2(63)			APBCONS	APBCONS_COLL_CODE_PREF	NO	NO
PREF_COLLEGE_DESC	Pref College Description	College, faculty or school name.	VARCHAR2(255)			STVCOLL	STVCOLL_DESC	NO	NO
PREF_DONOR_CATEGORY	Preferred Donor Category	Primary or preferred donor category associated with this constituent.	VARCHAR2(63)			APRCATG	APRCATG_DONR_CODE	NO	NO
PREF_DONOR_CATEGORY_DESC	Preferred Donor Category Description	Primary or preferred donor category description.	VARCHAR2(255)			ATVDONR	ATVDONR_DESC	NO	NO
DONOR_CATEGORY_COUNT	Donor Category Count	Count of donor categories associated with this constituent.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_DONOR_CATEGORY	NO	NO
HOMETOWN	Hometown	Constituent's hometown.	VARCHAR2(63)			APBCONS	APBCONS_HOME_CITY	NO	NO
HOMETOWN_STATE	Hometown State	State of the constituent's hometown.	VARCHAR2(63)			APBCONS	APBCONS_STAT_CODE_HOME	NO	NO
HOMETOWN_STATE_DESC	Hometown State Description	State/province name.	VARCHAR2(255)			STVSTAT	STVSTAT_DESC	NO	NO
HOMETOWN_NATION	Hometown Nation	Country of the constituent's hometown.	VARCHAR2(63)			APBCONS	APBCONS_NATN_CODE_HOME	NO	NO
HOMETOWN_NATION_DESC	Hometown Nation Description	Nation/country description.	VARCHAR2(255)			STVNATN	STVNATN_NATION	NO	NO
OCCUPATIONAL_TITLE	Occupational Title	Constituent's occupational title.	VARCHAR2(63)			APBCONS	APBCONS_DOTT_CODE	NO	NO
OCCUPATIONAL_TITLE_DESC	Occupational Title Description	Occupation code description.	VARCHAR2(255)			ATVDOTT	ATVDOTT_DESC	NO	NO
INCOME_LEVEL	Income Level	Constituent's income level.	VARCHAR2(63)			APBCONS	APBCONS_INCM_CODE	NO	NO
INCOME_LEVEL_DESC	Income Level Description	Income level code description.	VARCHAR2(255)			ATVINCM	ATVINCM_DESC	NO	NO
SOCIETY_NAME	Society Name	Gift society name.	VARCHAR2(255)			APBCONS	APBCONS_SOCIETY_NAME	NO	NO
COMBINED_MAILING_NAME	Combined Mailing Name	Combined mailing name for the constituent.	VARCHAR2(255)			APBCONS	APBCONS_CM_NAME	NO	NO
COMB_MAILING_ADDR_TYPE	Comb Mailing Addr Type	Address type to be used for the combined mailing.	VARCHAR2(63)			APBCONS	APBCONS_ATYP_CODE_CM	NO	NO
COMB_MAILING_ADDR_TYPE_DESC	Comb Mailing Addr Type Description	Address type description.	VARCHAR2(255)			STVATYP	STVATYP_DESC	NO	NO
ADDRESS_NAME	Address Name	Name to be used with the preferred address type.	VARCHAR2(255)			APBCONS	APBCONS_ADDR_NAME	NO	NO
PREF_ADDR_TYPE	Pref Addr Type	Constituent's preferred address for solicitations and acknowledgements.	VARCHAR2(63)			APBCONS	APBCONS_ATYP_CODE_PREF	NO	NO
PREF_ADDR_TYPE_DESC	Pref Addr Type Description	Address type description. Identified type within the ERP system. For example, mailing, special purpose, summer break, billing, employment.	VARCHAR2(255)			STVATYP	STVATYP_DESC	NO	NO
PREF_ADDR_TYPE_GEOR	Pref Addr Type Geographic	Address type of the address to be used as the preferred geographic region address.	VARCHAR2(63)			APBCONS	APBCONS_ATYP_CODE_GEOR	NO	NO
PREF_ADDR_TYPE_GEOR_DESC	Pref Addr Type Geographic Description	Address geographic region description.	VARCHAR2(255)			STVATYP	STVATYP_DESC	NO	NO
EMAIL_PREFERRED_ADDRESS	Preferred email address	The preferred email address of the person.	VARCHAR2(255)			GOREMAL	GOREMAL_EMAIL_ADDRESS	NO	NO
ADDRESS_COUNT	Address Count	Count of current active addresses for this person or entity.	NUMBER			FUNCTION	MSKFUNC.F_COUNT_ADDRESSES	NO	NO
PHONE_COUNT	Phone Count	Count of phone records.	NUMBER			FUNCTION	MSKFUNC.F_COUNT_TELEPHONES	NO	NO
SPOUSE_IND	Spouse Indicator	Indicates if a separate record for the constituent's spouse exists in the system.	VARCHAR2(63)			FUNCTION	MAKFUNC.F_GET_SPOUSE_IND	NO	NO
DEGREE_COUNT	Degree Count	Count of the number of degrees or awards for this constituent.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_DEGREES	NO	NO
EMPLOYMENT_COUNT	Employment Count	Employment count.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_PREV_EMPLOYMENT	NO	NO
CHILD_COUNT	Child Count	Count of child relationships recorded for the person.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_RELATION	NO	NO
SPECIAL_PURPOSE_GROUP_COUNT	Special Purpose Group Count	Special purpose group count.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_SPECIAL_PURP	NO	NO
MAIL_COUNT	Mail Count	Count of mailings, materials or publications to be sent to a constituent.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_MAIL	NO	NO
EXCLUSION_COUNT	Exclusion Count	Count of the number of active events, mailings, contacts, etc. for which the person or entity requests not to be informed or associated with.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_EXCLUSION	NO	NO
SPECIAL_ACTIVITY_COUNT	Special Activity Count	Count of special activities.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_SPECIAL_ACTIVITY	NO	NO
CROSS_REFERENCE_COUNT	Cross Reference Count	Count of the number of cross reference records associated with this person.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_RELATION	NO	NO
EXTERNAL_SOURCE_COUNT	External Source Count	Count of the number of external source ratings associated with the constituent's record.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_ADVANCEMENT_RATING	NO	NO
LIFE_TOTAL_GIVING	Life Total Giving	Lifetime total giving.	NUMBER			FUNCTION	F_LIFE_TOTAL_GIVING	NO	NO
MOST_RECENT_GIFT_NUMBER	Most Recent Gift Number	Most recent gift number.	VARCHAR2(63)			AGBGIFT	AGBGIFT_GIFT_NO	NO	NO
MOST_RECENT_GIFT_DATE	Most Recent Gift Date	Most recent gift date.	DATE			FUNCTION	F_MOST_RECENT_GIFT_AMOUNT	NO	NO
MOST_RECENT_GIFT_AMT	Most Recent Gift Amount	Most recent gift amount.	NUMBER			FUNCTION	F_MOST_RECENT_GIFT_AMOUNT	NO	NO
LIFE_TOTAL_PLEDGE_AMT	Life Total Pledge Amount	Lifetime total pledged amount.	NUMBER			FUNCTION	F_LIFE_TOTAL_PLEDGED_AMOUNT	NO	NO
MOST_RECENT_PLEDGE_NUMBER	Most Recent Pledge Number	Most recent pledge number.	VARCHAR2(63)			AGBPLDG	AGBPLDG_PLEDGE_NO	NO	NO
MOST_RECENT_PLEDGE_DATE	Most Recent Pledge Date	Most recent pledge date.	DATE			FUNCTION	F_MOST_RECENT_PLEDGE_AMOUNT	NO	NO
MOST_RECENT_PLEDGE_AMT	Most Recent Pledge Amount	Most recent pledge amount.	NUMBER			FUNCTION	F_MOST_RECENT_PLEDGE_AMOUNT	NO	NO
LIFE_TOTAL_PLEDGE_PAY	Life Total Pledge Pay	Lifetime total pledge payments.	NUMBER			FUNCTION	F_LIFE_TOTAL_PLEDGE_PAYMENT	NO	NO
LIFE_GIFT_SOCIETY_TYPE	Life Gift Society Type	Lifetime gift society type.	VARCHAR2(63)			FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY	NO	NO
LIFE_GIFT_SOCIETY_TYPE_DESC	Life Gift Society Type Description	Lifetime gift society type description.	VARCHAR2(255)			ATVDCST	ATVDCST_DESC	NO	NO
LIFE_GIFT_SOCIETY	Life Gift Society	Lifetime gift society.	VARCHAR2(63)			FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY	NO	NO
LIFE_GIFT_SOCIETY_DESC	Life Gift Society Description	Lifetime gift society description.	VARCHAR2(255)			ATVDCNP	ATVDCNP_DESC	NO	NO
LIFE_TOTAL_COMMITMENT	Life Total Commitment	Lifetime total commitments.	NUMBER			FUNCTION	F_LIFE_TOTAL_COMMITMENT	NO	NO
HIGHEST_GIFT_NUMBER	Highest Gift Number	Gift number of the highest gift ever received from the constituent.	VARCHAR2(63)			AGBGIFT	AGBGIFT_GIFT_NO	NO	NO
HIGHEST_GIFT_AMOUNT	Highest Gift Amount	Highest gift ever received from the constituent.	NUMBER			APBGHIS	APBGHIS_HIGH_GIFT_AMT	NO	NO
HIGHEST_GIFT_DATE	Highest Gift Date	Date of the highest gift ever received from the constituent.	DATE			APBGHIS	APBGHIS_HIGH_GIFT_DATE	NO	NO
HIGHEST_GIFT_FISCAL_YEAR	Highest Gift Fiscal Year	Fiscal year associated with the highest gift ever received from the constituent.	VARCHAR2(63)			APBGHIS	APBGHIS_FISC_CODE_HIGH_GIFT	NO	NO
HIGHEST_GIFT_FISCAL_YEAR_DESC	Highest Gift Fiscal Year Description	Description of the highest fiscal year.	VARCHAR2(255)			ATVFISC	ATVFISC_DESC	NO	NO
MULTI_SOURCE	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	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO

Ver: 9.2