Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADDRESS_NAME	Address Name	Name to be used with the preferred address type.	VARCHAR2(120)		APBCONS	APBCONS_ADDR_NAME
BUSINESS		This field specifies the organizations general category of business.	VARCHAR2(30)		NA	NA
COMBINED_MAILING_NAME	Combined Mailing Name	Combined mailing name for the constituent.	VARCHAR2(120)		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)		STVATYP	STVATYP_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)		CONSTANT	'P'
ENTITY_UID		System generated number that is internally generated to uniquely identify the person.	NUMBER(8)		APBCONS	APBCONS_PIDM
FEDERAL_IDENTIFICATION		This field specifies the organizations federal identification number.	VARCHAR2(9)		NA	NA
GRADUATION_NAME	Graduation Name	Constituent's name at the time of college graduation.	VARCHAR2(120)		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)		ATVFISC	ATVFISC_DESC
HIGHEST_GIFT_NUMBER		Gift number of the highest gift ever received from the constituent.	VARCHAR2(7)		AGBGIFT	AGBGIFT_GIFT_NO
HOMETOWN	Hometown	Constituent's hometown.	VARCHAR2(50)		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)		STVNATN	STVNATN_NATION
HOMETOWN_STATE		State of the constituent's hometown.	VARCHAR2(3)		APBCONS	APBCONS_STAT_CODE_HOME
HOMETOWN_STATE_DESC		State/province name.	VARCHAR2(30)		STVSTAT	STVSTAT_DESC
INCOME_LEVEL		Constituent's income level.	VARCHAR2(2)		APBCONS	APBCONS_INCM_CODE
INCOME_LEVEL_DESC		Income level code description.	VARCHAR2(30)		ATVINCM	ATVINCM_DESC
JOB_CATEGORY		This field specifies the job category associated with the organizational contacts title.	VARCHAR2(3)		NA	NA
JOB_CATEGORY_DESC		This field specifies the description of the job category code.	VARCHAR2(30)		NA	NA
LIFE_GIFT_SOCIETY		Lifetime gift society.	VARCHAR2(4)		FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY
LIFE_GIFT_SOCIETY_DESC		Lifetime gift society description.	VARCHAR2(60)		ATVDCNP	ATVDCNP_DESC
LIFE_GIFT_SOCIETY_TYPE		Lifetime gift society type.	VARCHAR2(2)		FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY
LIFE_GIFT_SOCIETY_TYPE_DESC		Lifetime gift society type description.	VARCHAR2(30)		ATVDCST	ATVDCST_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)		NA	NA
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)		NA	NA
MATCH_MAXIMUM		The maximum matching gift amount allowed.	NUMBER(11, 2)		NA	NA
MATCH_MINIMUM		Minimum amount organization will match.	NUMBER(11, 2)		NA	NA
MAX_MATCH_ORG_EMPL_YEAR		Maximum corporate matching gift payout per employee per year.	NUMBER(11, 2)		NA	NA
MAX_PERSON_MATCH_AMOUNT		Amount an employee can be matched per year.	NUMBER(11, 2)		NA	NA
MAX_YEAR_DONATE_AMOUNT		Amount the organization will donate to an institution per year.	NUMBER(11, 2)		NA	NA
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)		NA	NA
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	Occupational Title Description	Occupation code description.	VARCHAR2(60)		ATVDOTT	ATVDOTT_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)		APBCONS	APBCONS_ATYP_CODE_PREF
PREF_ADDRESS_TYPE_DESC		This field identifies the address type associated with the type code.	VARCHAR2(30)		STVATYP	STVATYP_DESC
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)		STVATYP	STVATYP_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)		STVCOLL	STVCOLL_DESC
PREF_FIRST_NAME	Preferred First Name	Preferred first name of the constituent.	VARCHAR2(60)		APBCONS	APBCONS_PREF_FIRST_NAME
PREF_LAST_NAME	Preferred Last Name	Preferred last name of the constituent.	VARCHAR2(60)		APBCONS	APBCONS_PREF_LAST_NAME
PREF_MIDDLE_INITIAL	Preferred Middle Initial	Preferred middle initial of the constituent.	VARCHAR2(60)		APBCONS	APBCONS_PREF_MI
PRIMARY_DONOR_CATEGORY		This is the preferred donor code	VARCHAR2(4)		ATVDONR	ATVDONR_CODE
PRIMARY_DONOR_CATEGORY_DESC		This is the description of preferred donor code	VARCHAR2(30)		ATVDONR	ATVDONR_DESC
PROSPECT_IND		Indicates whether the person has a prospect record.	VARCHAR2(1)		FUNCTION	F_PROSPECT_IND
SOCIETY_NAME	Society Name	Gift society name.	VARCHAR2(120)		APBCONS	APBCONS_SOCIETY_NAME
STANDARD_INDUSTRY		This field specifies the organizations standard industry code.	VARCHAR2(4)		NA	NA
STANDARD_INDUSTRY_DESC		This field specifies the description of the SIC.	VARCHAR2(30)		NA	NA
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: