Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADDRESS_COUNT	Address Count	Count of current active addresses for this person or entity.	NUMBER		FUNCTION	MSKFUNC.F_COUNT_ADDRESSES
ADDRESS_NAME	Address Name	Name to be used with the preferred address type.	VARCHAR2(255)		APBCONS	APBCONS_ADDR_NAME
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
CHILD_COUNT	Child Count	Count of child relationships recorded for the person.	NUMBER		FUNCTION	MAKFUNC.F_COUNT_RELATION
COMBINED_MAILING_NAME	Combined Mailing Name	Combined mailing name for the constituent.	VARCHAR2(255)		APBCONS	APBCONS_CM_NAME
COMB_MAILING_ADDR_TYPE	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	Comb Mailing Addr Type Description	Address type description.	VARCHAR2(255)		STVATYP	STVATYP_DESC
CONFIDENTIALITY_IND	Confidentiality Indicator	Specifies whether the person has requested the institution keep some of their information confidential.	VARCHAR2(1)		SPBPERS	SPBPERS_CONFID_IND
CROSS_REFERENCE_COUNT	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	Current age of the constituent	NUMBER		FUNCTION	F_CALCULATE_AGE
DECEASED_IND	Deceased Indicator	Indicates whether a person is deceased.	VARCHAR2(1)		SPBPERS	SPBPERS_DEAD_IND
DEGREE_COUNT	Degree Count	Count of the number of degrees or awards for this constituent.	NUMBER		FUNCTION	MAKFUNC.F_COUNT_DEGREES
DONOR_CATEGORY_COUNT	Donor Category Count	Count of donor categories associated with this constituent.	NUMBER		FUNCTION	MAKFUNC.F_COUNT_DONOR_CATEGORY
DONOR_IND	Donor Indicator	Indicates whether this person has been a donor.	VARCHAR2(1)		FUNCTION	F_DONOR_IND
EMAIL_PREFERRED_ADDRESS	Preferred email address	The preferred email address of the person.	VARCHAR2(255)		GOREMAL	GOREMAL_EMAIL_ADDRESS
EMPLOYMENT_COUNT	Employment Count	Employment count.	NUMBER		FUNCTION	MAKFUNC.F_COUNT_PREV_EMPLOYMENT
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
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
GENDER	Gender	The gender code of the person.	VARCHAR2(63)		SPBPERS	SPBPERS_SEX
GENDER_DESC	Gender description	The gender code of the person.	VARCHAR2(63)		FUNCTION	GOKODSF.F_GET_DESC
GRADUATION_NAME	Graduation Name	Constituent's name at the time of college graduation.	VARCHAR2(255)		APBCONS	APBCONS_GRAD_NAME
HIGHEST_GIFT_AMOUNT	Highest Gift Amount	Highest gift ever received from the constituent.	NUMBER		APBGHIS	APBGHIS_HIGH_GIFT_AMT
HIGHEST_GIFT_DATE	Highest Gift Date	Date of the highest gift ever received from the constituent.	DATE		APBGHIS	APBGHIS_HIGH_GIFT_DATE
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
HIGHEST_GIFT_FISCAL_YEAR_DESC	Highest Gift Fiscal Year Description	Description of the highest fiscal year.	VARCHAR2(255)		ATVFISC	ATVFISC_DESC
HIGHEST_GIFT_NUMBER	Highest Gift Number	Gift number of the highest gift ever received from the constituent.	VARCHAR2(63)		AGBGIFT	AGBGIFT_GIFT_NO
HOMETOWN	Hometown	Constituent's hometown.	VARCHAR2(63)		APBCONS	APBCONS_HOME_CITY
HOMETOWN_NATION	Hometown Nation	Country of the constituent's hometown.	VARCHAR2(63)		APBCONS	APBCONS_NATN_CODE_HOME
HOMETOWN_NATION_DESC	Hometown Nation Description	Nation/country description.	VARCHAR2(255)		STVNATN	STVNATN_NATION
HOMETOWN_STATE	Hometown State	State of the constituent's hometown.	VARCHAR2(63)		APBCONS	APBCONS_STAT_CODE_HOME
HOMETOWN_STATE_DESC	Hometown State Description	State/province name.	VARCHAR2(255)		STVSTAT	STVSTAT_DESC
ID	ID	Person's or organization's current identification number.	VARCHAR2(63)		SPRIDEN	SPRIDEN_ID
INCOME_LEVEL	Income Level	Constituent's income level.	VARCHAR2(63)		APBCONS	APBCONS_INCM_CODE
INCOME_LEVEL_DESC	Income Level Description	Income level code description.	VARCHAR2(255)		ATVINCM	ATVINCM_DESC
LIFE_GIFT_SOCIETY	Life Gift Society	Lifetime gift society.	VARCHAR2(63)		FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY
LIFE_GIFT_SOCIETY_DESC	Life Gift Society Description	Lifetime gift society description.	VARCHAR2(255)		ATVDCNP	ATVDCNP_DESC
LIFE_GIFT_SOCIETY_TYPE	Life Gift Society Type	Lifetime gift society type.	VARCHAR2(63)		FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY
LIFE_GIFT_SOCIETY_TYPE_DESC	Life Gift Society Type Description	Lifetime gift society type description.	VARCHAR2(255)		ATVDCST	ATVDCST_DESC
LIFE_TOTAL_COMMITMENT	Life Total Commitment	Lifetime total commitments.	NUMBER		FUNCTION	F_LIFE_TOTAL_COMMITMENT
LIFE_TOTAL_GIVING	Life Total Giving	Lifetime total giving.	NUMBER		FUNCTION	F_LIFE_TOTAL_GIVING
LIFE_TOTAL_PLEDGE_AMT	Life Total Pledge Amount	Lifetime total pledged amount.	NUMBER		FUNCTION	F_LIFE_TOTAL_PLEDGED_AMOUNT
LIFE_TOTAL_PLEDGE_PAY	Life Total Pledge Pay	Lifetime total pledge payments.	NUMBER		FUNCTION	F_LIFE_TOTAL_PLEDGE_PAYMENT
LOST_ALUMNUS_IND	Lost Alumnus Indicator	Lost alumnus indicator.	VARCHAR2(1)		FUNCTION	F_LOST_AL_IND
MAIDEN_LAST_NAME	Maiden Last Name	Constituent's maiden name.	VARCHAR2(255)		APBCONS	APBCONS_MAIDEN_LAST_NAME
MAIL_COUNT	Mail Count	Count of mailings, materials or publications to be sent to a constituent.	NUMBER		FUNCTION	MAKFUNC.F_COUNT_MAIL
MARITAL_STATUS	Marital Status	Marital status code of the person.	VARCHAR2(63)		SPBPERS	SPBPERS_MRTL_CODE
MOST_RECENT_GIFT_AMT	Most Recent Gift Amount	Most recent gift amount.	NUMBER		FUNCTION	F_MOST_RECENT_GIFT_AMOUNT
MOST_RECENT_GIFT_DATE	Most Recent Gift Date	Most recent gift date.	DATE		FUNCTION	F_MOST_RECENT_GIFT_AMOUNT
MOST_RECENT_GIFT_NUMBER	Most Recent Gift Number	Most recent gift number	VARCHAR2(63)		AGBGIFT	AGBGIFT_GIFT_NO
MOST_RECENT_PLEDGE_AMT	Most Recent Pledge Amount	Most recent pledge amount.	NUMBER		FUNCTION	F_MOST_RECENT_PLEDGE_AMOUNT
MOST_RECENT_PLEDGE_DATE	Most Recent Pledge Date	Most recent pledge date.	DATE		FUNCTION	F_MOST_RECENT_PLEDGE_AMOUNT
MOST_RECENT_PLEDGE_NUMBER	Most Recent Pledge Number	Most recent pledge number	VARCHAR2(63)		AGBPLDG	AGBPLDG_PLEDGE_NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)		FUNCTION	F_FORMAT_NAME
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)
NAME_SUFFIX	Name Suffix	A name suffix, in the western naming tradition, follows a person's full name and provides additional information about the person. There are academic, honorary, professional and inherited (social) name suffixes.	VARCHAR2(20)		SPBPERS	SPBPERS_NAME_SUFFIX
NICKNAME	Nickname	Nickname used by the constituent.	VARCHAR2(255)		APBCONS	APBCONS_NICKNAME
OCCUPATIONAL_TITLE	Occupational Title	Constituent's occupational title.	VARCHAR2(63)		APBCONS	APBCONS_DOTT_CODE
OCCUPATIONAL_TITLE_DESC	Occupational Title Description	Occupation code description.	VARCHAR2(255)		ATVDOTT	ATVDOTT_DESC
PARENTS_NAME	Parents Name	Name of the constituent's parents.	VARCHAR2(255)		APBCONS	APBCONS_PARENTS_NAME
PERSON_UID	Person UID	System generated Banner unique ID which gets assigned to all person and non-person records within Banner.	NUMBER		APBCONS	APBCONS_PIDM
PHONE_COUNT	Phone Count	Count of phone records.	NUMBER		FUNCTION	MSKFUNC.F_COUNT_TELEPHONES
PREF_ADDR_TYPE	Pref Addr Type	Constituent's preferred address for solicitations and acknowledgements.	VARCHAR2(63)		APBCONS	APBCONS_ATYP_CODE_PREF
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
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
PREF_ADDR_TYPE_GEOR_DESC	Pref Addr Type Geographic Description	Address geographic region description.	VARCHAR2(255)		STVATYP	STVATYP_DESC
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
PREF_CLASS_DESC	Preferred Class Year Description	Constituent's preferred class description.	VARCHAR2(255)		NA	NA
PREF_COLLEGE	Pref College	College within the institution with which the constituent prefers to be associated.	VARCHAR2(63)		APBCONS	APBCONS_COLL_CODE_PREF
PREF_COLLEGE_DESC	Pref College Description	College, faculty or school name.	VARCHAR2(255)		STVCOLL	STVCOLL_DESC
PREF_DONOR_CATEGORY	Preferred Donor Category	Primary or preferred donor category associated with this constituent.	VARCHAR2(63)		APRCATG	APRCATG_DONR_CODE
PREF_DONOR_CATEGORY_DESC	Preferred Donor Category Description	Primary or preferred donor category description.	VARCHAR2(255)		ATVDONR	ATVDONR_DESC
PREF_FIRST_NAME	Pref First Name	If a person prefers to go by a name that is different from his/her name given at the time of their admissions application submission, the university allows the person to do this by setting a preferred name.	VARCHAR2(255)		APBCONS	APBCONS_PREF_FIRST_NAME
PREF_LAST_NAME	Pref Last Name	If a person prefers to go by a name that is different from his/her name given at the time of their admissions application submission, the university allows the person to do this by setting a preferred name.	VARCHAR2(255)		APBCONS	APBCONS_PREF_LAST_NAME
PREF_MIDDLE_INITIAL	Pref Middle Initial	If a person prefers to go by a name that is different from his/her name given at the time of their admissions application submission, the university allows the person to do this by setting a preferred name.	VARCHAR2(63)		APBCONS	APBCONS_PREF_MI
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
PROSPECT_IND	Prospect Indicator	Indicates whether this person has a prospect record.	VARCHAR2(1)		FUNCTION	F_PROSPECT_IND
SOCIETY_NAME	Society Name	Gift society name.	VARCHAR2(255)		APBCONS	APBCONS_SOCIETY_NAME
SPECIAL_ACTIVITY_COUNT	Special Activity Count	Count of special activities.	NUMBER		FUNCTION	MAKFUNC.F_COUNT_SPECIAL_ACTIVITY
SPECIAL_PURPOSE_GROUP_COUNT	Special Purpose Group Count	Special purpose group count.	NUMBER		FUNCTION	MAKFUNC.F_COUNT_SPECIAL_PURP
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
SPOUSE_NAME	Spouse Name	Full name of the constituent's spouse LFM.	VARCHAR2(100)		FUNCTION	MAKFUNC.F_GET_SPOUSE_NAME

Ver: 9.0