Target Column	Business Definition	Database Data Type	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	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	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	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)	AOBORGN	AOBORGN_JOBC_CODE
JOB_CATEGORY_DESC	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	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	AOBORGN	AOBORGN_MG_PIDM
MATCH_MAXIMUM	Maximum matching gift amount allowed.	NUMBER	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	AOBORGN	AOBORGN_MATCH_MINIMUM
MAX_MATCH_ORG_EMPL_YEAR	Maximum corporate matching gift payout per employee per year.	NUMBER	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	AOBORGN	AOBORGN_MATCH_PERSON_MAX
MAX_YEAR_DONATE_AMOUNT	Maximum amount the organization will donate to an institution per year.	NUMBER	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	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	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)
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	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	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: