Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDRESS_COUNT	Count of current active addresses for this person or entity.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADDRESSES	NO	NO
ADDRESS_NAME	Name to be used with the preferred address type.	VARCHAR2(255)	APBCONS	APBCONS_ADDR_NAME	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CHILD_COUNT	Count of child relationships recorded for the person.	NUMBER	FUNCTION	MAKFUNC.F_COUNT_RELATION	NO	NO
COMBINED_MAILING_NAME	Combined mailing name for the constituent.	VARCHAR2(255)	APBCONS	APBCONS_CM_NAME	NO	NO
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	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC	NO	NO
CONFIDENTIALITY_IND	Specifies whether the person has requested the institution keep some of their information confidential.	VARCHAR2(1)	SPBPERS	SPBPERS_CONFID_IND	NO	NO
CROSS_REFERENCE_COUNT	Count of the number of cross reference records associated with this person.	NUMBER	FUNCTION	MAKFUNC.F_COUNT_RELATION	NO	NO
CURRENT_AGE	Current age of the constituent.	NUMBER	FUNCTION	F_CALCULATE_AGE	NO	NO
DECEASED_IND	Indicates whether a person is deceased.	VARCHAR2(1)	SPBPERS	SPBPERS_DEAD_IND	NO	NO
DEGREE_COUNT	Count of the number of degrees or awards for this constituent.	NUMBER	FUNCTION	MAKFUNC.F_COUNT_DEGREES	NO	NO
DONOR_CATEGORY_COUNT	Count of donor categories associated with this constituent.	NUMBER	FUNCTION	MAKFUNC.F_COUNT_DONOR_CATEGORY	NO	NO
DONOR_IND	Indicates whether this person has been a donor.	VARCHAR2(1)	FUNCTION	F_DONOR_IND	NO	NO
EMAIL_PREFERRED_ADDRESS	The preferred email address of the person.	VARCHAR2(255)	GOREMAL	GOREMAL_EMAIL_ADDRESS	NO	NO
EMPLOYMENT_COUNT	Employment count.	NUMBER	FUNCTION	MAKFUNC.F_COUNT_PREV_EMPLOYMENT	NO	NO
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
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
GENDER	Identifies the gender of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_SEX	NO	NO
GENDER_DESC	The gender code of the person.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GENDER_DESIGNATION	This gender identity of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_GNDR_CODE	NO	NO
GENDER_DESIGNATION_DESC	The description of the gender identity.	VARCHAR2(255)	GTVGNDR	GTVGNDR_GNDR_DESC	NO	NO
GRADUATION_NAME	Constituent's name at the time of college graduation.	VARCHAR2(255)	APBCONS	APBCONS_GRAD_NAME	NO	NO
HIGHEST_GIFT_AMOUNT	Highest gift ever received from the constituent.	NUMBER	APBGHIS	APBGHIS_HIGH_GIFT_AMT	NO	NO
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	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	Description of the highest fiscal year.	VARCHAR2(255)	ATVFISC	ATVFISC_DESC	NO	NO
HIGHEST_GIFT_NUMBER	Gift number of the highest gift ever received from the constituent.	VARCHAR2(63)	AGBGIFT	AGBGIFT_GIFT_NO	NO	NO
HOMETOWN	Constituent's hometown.	VARCHAR2(63)	APBCONS	APBCONS_HOME_CITY	NO	NO
HOMETOWN_NATION	Country of the constituent's hometown.	VARCHAR2(63)	APBCONS	APBCONS_NATN_CODE_HOME	NO	NO
HOMETOWN_NATION_DESC	Nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
HOMETOWN_STATE	State of the constituent's hometown.	VARCHAR2(63)	APBCONS	APBCONS_STAT_CODE_HOME	NO	NO
HOMETOWN_STATE_DESC	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
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
INCOME_LEVEL	Constituent's income level.	VARCHAR2(63)	APBCONS	APBCONS_INCM_CODE	NO	NO
INCOME_LEVEL_DESC	Income level code description.	VARCHAR2(255)	ATVINCM	ATVINCM_DESC	NO	NO
LIFE_GIFT_SOCIETY	Lifetime gift society.	VARCHAR2(63)	FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY	NO	NO
LIFE_GIFT_SOCIETY_DESC	Lifetime gift society description.	VARCHAR2(255)	ATVDCNP	ATVDCNP_DESC	NO	NO
LIFE_GIFT_SOCIETY_TYPE	Lifetime gift society type.	VARCHAR2(63)	FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY	NO	NO
LIFE_GIFT_SOCIETY_TYPE_DESC	Lifetime gift society type description.	VARCHAR2(255)	ATVDCST	ATVDCST_DESC	NO	NO
LIFE_TOTAL_COMMITMENT	Lifetime total commitments.	NUMBER	FUNCTION	F_LIFE_TOTAL_COMMITMENT	NO	NO
LIFE_TOTAL_GIVING	Lifetime total giving.	NUMBER	FUNCTION	F_LIFE_TOTAL_GIVING	NO	NO
LIFE_TOTAL_PLEDGE_AMT	Lifetime total pledged amount.	NUMBER	FUNCTION	F_LIFE_TOTAL_PLEDGED_AMOUNT	NO	NO
LIFE_TOTAL_PLEDGE_PAY	Lifetime total pledge payments.	NUMBER	FUNCTION	F_LIFE_TOTAL_PLEDGE_PAYMENT	NO	NO
LOST_ALUMNUS_IND	Lost alumnus indicator.	VARCHAR2(1)	FUNCTION	F_LOST_AL_IND	NO	NO
MAIDEN_LAST_NAME	Constituent's maiden name.	VARCHAR2(255)	APBCONS	APBCONS_MAIDEN_LAST_NAME	NO	NO
MAIL_COUNT	Count of mailings, materials or publications to be sent to a constituent.	NUMBER	FUNCTION	MAKFUNC.F_COUNT_MAIL	NO	NO
MARITAL_STATUS	Marital status code of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_MRTL_CODE	NO	NO
MOST_RECENT_GIFT_AMT	Most recent gift amount.	NUMBER	FUNCTION	F_MOST_RECENT_GIFT_AMOUNT	NO	NO
MOST_RECENT_GIFT_DATE	Most recent gift date.	DATE	FUNCTION	F_MOST_RECENT_GIFT_AMOUNT	NO	NO
MOST_RECENT_GIFT_NUMBER	Most recent gift number.	VARCHAR2(63)	AGBGIFT	AGBGIFT_GIFT_NO	NO	NO
MOST_RECENT_PLEDGE_AMT	Most recent pledge amount.	NUMBER	FUNCTION	F_MOST_RECENT_PLEDGE_AMOUNT	NO	NO
MOST_RECENT_PLEDGE_DATE	Most recent pledge date.	DATE	FUNCTION	F_MOST_RECENT_PLEDGE_AMOUNT	NO	NO
MOST_RECENT_PLEDGE_NUMBER	Most recent pledge number.	VARCHAR2(63)	AGBPLDG	AGBPLDG_PLEDGE_NO	NO	NO
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	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME	NO	NO
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	Suffix for the person's name.	VARCHAR2(20)	SPBPERS	SPBPERS_NAME_SUFFIX	NO	NO
NICKNAME	Nickname used by the constituent.	VARCHAR2(255)	APBCONS	APBCONS_NICKNAME	NO	NO
OCCUPATIONAL_TITLE	Constituent's occupational title.	VARCHAR2(63)	APBCONS	APBCONS_DOTT_CODE	NO	NO
OCCUPATIONAL_TITLE_DESC	Occupation code description.	VARCHAR2(255)	ATVDOTT	ATVDOTT_DESC	NO	NO
PARENTS_NAME	Name of the constituent's parents.	VARCHAR2(255)	APBCONS	APBCONS_PARENTS_NAME	NO	NO
PERSONAL_PRONOUN	The personal pronoun of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_PPRN_CODE	NO	NO
PERSONAL_PRONOUN_DESC	The description of the personal pronoun.	VARCHAR2(255)	GTVPPRN	GTVPPRN_PPRN_DESC	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	APBCONS	APBCONS_PIDM	NO	NO
PHONE_COUNT	Count of phone records.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TELEPHONES	NO	NO
PREF_ADDR_TYPE	Constituent's preferred address for solicitations and acknowledgements.	VARCHAR2(63)	APBCONS	APBCONS_ATYP_CODE_PREF	NO	NO
PREF_ADDR_TYPE_DESC	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	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	Address geographic region description.	VARCHAR2(255)	STVATYP	STVATYP_DESC	NO	NO
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	NO	NO
PREF_CLASS_DESC	Constituent's preferred class description.	VARCHAR2(255)	NA	NA	NO	NO
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	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO
PREF_DONOR_CATEGORY	Primary or preferred donor category associated with this constituent.	VARCHAR2(63)	APRCATG	APRCATG_DONR_CODE	NO	NO
PREF_DONOR_CATEGORY_DESC	Primary or preferred donor category description.	VARCHAR2(255)	ATVDONR	ATVDONR_DESC	NO	NO
PREF_FIRST_NAME	Preferred first name of the constituent.	VARCHAR2(255)	APBCONS	APBCONS_PREF_FIRST_NAME	NO	NO
PREF_LAST_NAME	Preferred last name of the constituent.	VARCHAR2(255)	APBCONS	APBCONS_PREF_LAST_NAME	NO	NO
PREF_MIDDLE_INITIAL	Preferred middle initial of the constituent.	VARCHAR2(63)	APBCONS	APBCONS_PREF_MI	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROSPECT_IND	Indicates whether this person has a prospect record.	VARCHAR2(1)	FUNCTION	F_PROSPECT_IND	NO	NO
SOCIETY_NAME	Gift society name.	VARCHAR2(255)	APBCONS	APBCONS_SOCIETY_NAME	NO	NO
SPECIAL_ACTIVITY_COUNT	Count of special activities.	NUMBER	FUNCTION	MAKFUNC.F_COUNT_SPECIAL_ACTIVITY	NO	NO
SPECIAL_PURPOSE_GROUP_COUNT	Special purpose group count.	NUMBER	FUNCTION	MAKFUNC.F_COUNT_SPECIAL_PURP	NO	NO
SPOUSE_IND	Indicates if a separate record for the constituent's spouse exists in the system.	VARCHAR2(63)	FUNCTION	MAKFUNC.F_GET_SPOUSE_IND	NO	NO
SPOUSE_NAME	Full name of the constituent's spouse LFM.	VARCHAR2(100)	FUNCTION	MAKFUNC.F_GET_SPOUSE_NAME	NO	NO

Ver: 9.2