Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADDRESS_NAME		This field specifies the name to be used with the preferred address type.	VARCHAR2(35)		NA	NA
BUSINESS		Organization's general category of business.	VARCHAR2(30)		AOBORGN	AOBORGN_BUSINESS
COMBINED_MAILING_NAME		This field specifies the combined mailing name for the constituent.	VARCHAR2(50)		NA	NA
COMB_MAILING_ADDR_TYPE		This field specifies the address type to be used for the combined mailing.	VARCHAR2(21)		NA	NA
COMB_MAILING_ADDR_TYPE_DESC		This field identifies the address type associated with the type code.	VARCHAR2(30)		NA	NA
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	'O'
ENTITY_UID		System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		AOBORGN	AOBORGN_PIDM
FEDERAL_IDENTIFICATION		Organization's federal government assigned identification number.	VARCHAR2(9)		AOBORGN	AOBORGN_EIN
GRADUATION_NAME		This field specifies the constituents name at the time of college graduation.	VARCHAR2(60)		NA	NA
HIGHEST_GIFT_AMOUNT		This is the highest gift ever received from the constituent.	NUMBER(11, 2)		NA	NA
HIGHEST_GIFT_DATE		This is the date of the highest gift ever received from the constituent.	DATE		NA	NA
HIGHEST_GIFT_FISCAL_YEAR		This is the fiscal year associated with the highest gift ever received from the constituent.	NUMBER(4)		NA	NA
HIGHEST_GIFT_FISCAL_YEAR_DESC		This is the description of the highest fiscal year.	VARCHAR2(30)		NA	NA
HIGHEST_GIFT_NUMBER		This is the gift number of the highest gift ever received from the constituent.	VARCHAR2(7)		NA	NA
HOMETOWN		This field specifies the constituents hometown.	VARCHAR2(20)		NA	NA
HOMETOWN_NATION		This field specifies the country of the constituents hometown.	VARCHAR2(5)		NA	NA
HOMETOWN_NATION_DESC		This field specifies the nation/country associated with the nation code.	VARCHAR2(30)		NA	NA
HOMETOWN_STATE		This field specifies the state of the constituents hometown.	VARCHAR2(3)		NA	NA
HOMETOWN_STATE_DESC		This field specifies the state associated with the state code.	VARCHAR2(30)		NA	NA
INCOME_LEVEL		This field specifies the constituents income level.	VARCHAR2(2)		NA	NA
INCOME_LEVEL_DESC		This field specifies the description of the income level code.	VARCHAR2(30)		NA	NA
JOB_CATEGORY		Job category associated with the organizational contact's title.	VARCHAR2(3)		AORCONT	AORCONT_JOBC_CODE
JOB_CATEGORY_DESC	Job Category Description	Job category code description.	VARCHAR2(60)		ATVJOBC	ATVJOBC_DESC
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		This is the lost alumnus indicator	VARCHAR2(1)		NA	NA
MAIDEN_LAST_NAME		This field specifies the constituents maiden name.	VARCHAR2(25)		NA	NA
MATCHING_GIFT_PERCENT		Organization's matching gift percentage.	NUMBER(3)		AOBORGN	AOBORGN_MATCH_PCT
MATCHING_GIFT_UID		Internal identification number for the matching gift company associated with the organization. The identification number may be the same identification number or the parent identification number.	NUMBER(8)		AOBORGN	AOBORGN_MG_PIDM
MATCH_MAXIMUM		Maximum matching gift amount allowed.	NUMBER(11, 2)		AOBORGN	AOBORGN_MATCH_MAXIMUM
MATCH_MINIMUM		Smallest amount a company matches. If a gift goes toward multiple designations, then the designation amount is compared to this amount in the Matching Gift Allocations Process.	NUMBER(11, 2)		AOBORGN	AOBORGN_MATCH_MINIMUM
MAX_MATCH_ORG_EMPL_YEAR		Maximum corporate matching gift payout per employee per year.	NUMBER(11, 2)		AOBORGN	AOBORGN_MATCH_ORG_EMPL_YR
MAX_PERSON_MATCH_AMOUNT		Annual total an organization matches per employee. This is different than the annual total company payout per employee in that it identifies how much of donors' gifts will be matched, and not the matching gift amount that the company gives. This field is for information only.	NUMBER(11, 2)		AOBORGN	AOBORGN_MATCH_PERSON_MAX
MAX_YEAR_DONATE_AMOUNT		Maximum amount the organization will donate to an institution per year.	NUMBER(11, 2)		AOBORGN	AOBORGN_MATCH_ORG_MAX
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		Specifies whether multiple ratios exist for this organization constituent.	VARCHAR2(1)		FUNCTION	F_MULTIPLE_RATIOS
NICKNAME		This field specifies the nickname used by the constituent.	VARCHAR2(40)		NA	NA
OCCUPATIONAL_TITLE		This field specifies the constituents occupational title.	VARCHAR2(4)		NA	NA
OCCUPATIONAL_TITLE_DESC		This field specifies the description of the occupation code.	VARCHAR2(30)		NA	NA
PARENTS_NAME		This field specifies the name of the constituents parents.	VARCHAR2(50)		NA	NA
PREF_ADDRESS_TYPE		Address to use for the organizational contact.	VARCHAR2(2)		AORCONT	AORCONT_ATYP_CODE
PREF_ADDRESS_TYPE_DESC		Address type description.	VARCHAR2(30)		STVATYP	STVATYP_DESC
PREF_ADDR_TYPE_GEOR		This field specifies the address type of the address to be used as the preferred geographic region address.	VARCHAR2(2)		NA	NA
PREF_ADDR_TYPE_GEOR_DESC		This field identifies the address type associated with the type code.	VARCHAR2(30)		NA	NA
PREF_CLASS		This field specifies the 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(4)		NA	NA
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		This field specifies the college within the institution with which the constituent prefers to be associated.	VARCHAR2(2)		NA	NA
PREF_COLLEGE_DESC		This field specifies the college or school associated with the college code.	VARCHAR2(30)		NA	NA
PREF_FIRST_NAME		This field specifies the preferred first name of the constituent.	VARCHAR2(15)		NA	NA
PREF_LAST_NAME		This field specifies the preferred last name of the constituent.	VARCHAR2(25)		NA	NA
PREF_MIDDLE_INITIAL	Preferred Middle Initial	This field specifies the preferred middle initial of the constituent.	VARCHAR2(1)		NA	NA
PRIMARY_DONOR_CATEGORY		Primary donor code.	VARCHAR2(4)		APRCATG	APRCATG_DONR_CODE
PRIMARY_DONOR_CATEGORY_DESC		Preferred donor description.	VARCHAR2(30)		ATVDONR	ATVDONR_DESC
PROSPECT_IND		Indicates whether this entity has a prospect record.	VARCHAR2(1)		FUNCTION	F_PROSPECT_IND
SOCIETY_NAME		Gift Society name. This name will default to gift societies when they memberships are created. The name may be modified on the society form.	VARCHAR2(60)		NA	NA
STANDARD_INDUSTRY		This field specifies the organizations standard industry code.	VARCHAR2(4)		AOBORGN	AOBORGN_SICC_CODE
STANDARD_INDUSTRY_DESC	Standard Industry Description	This field specifies the description of the SIC.	VARCHAR2(60)		ATVSICC	ATVSICC_DESC
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: