Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER			AOBORGN	AOBORGN_PIDM	NO	NO
DONOR_IND	Donor Indicator	Indicates whether the organization constituent or constituent has been a donor.	VARCHAR2(1)			FUNCTION	F_DONOR_IND	NO	NO
ID	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
PROSPECT_IND	Prospect Indicator	Indicates whether this entity has a prospect record.	VARCHAR2(1)			FUNCTION	F_PROSPECT_IND	NO	NO
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(63)			FUNCTION	F_FORMAT_NAME	NO	NO
FEDERAL_IDENTIFICATION	Federal ID	Organization's federal government assigned identification number.	VARCHAR2(63)			AOBORGN	AOBORGN_EIN	NO	NO
BUSINESS	Business	Organization's general category of business.	VARCHAR2(255)			AOBORGN	AOBORGN_BUSINESS	NO	NO
STANDARD_INDUSTRY_CODE	Standard Industry Code	Organization's standard industry code (sic).	VARCHAR2(63)			AOBORGN	AOBORGN_SICC_CODE	NO	NO
STANDARD_INDUSTRY_CODE_DESC	Standard Industry Code Description	Standard industry code (sic) description.	VARCHAR2(255)			ATVSICC	ATVSICC_DESC	NO	NO
MATCHING_GIFT_PERCENT	Matching Gift Percent	Organization's matching gift percentage.	NUMBER			AOBORGN	AOBORGN_MATCH_PCT	NO	NO
MAX_YEAR_DONATE_AMOUNT	Maximum Year Donate Amount	Maximum amount the organization donates to an institution per year.	NUMBER			AOBORGN	AOBORGN_MATCH_ORG_MAX	NO	NO
MAX_PERSON_MATCH_AMOUNT	Maximum Person Match Amount	The annual total an organization will match per employee. This field is for information only. 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 will give.	NUMBER			AOBORGN	AOBORGN_MATCH_PERSON_MAX	NO	NO
PREF_ADDRESS_TYPE	Pref Address Type	Address to use for the organizational contact.	VARCHAR2(63)			AOBORGN	AOBORGN_PREF_ATYP_CODE	NO	NO
PREF_ADDRESS_TYPE_DESC	Pref Address Type Description	Address type description.	VARCHAR2(255)			STVATYP	STVATYP_DESC	NO	NO
JOB_CATEGORY	Job Category	Job category associated with the organizational contact's title.	VARCHAR2(63)			AOBORGN	AOBORGN_JOBC_CODE	NO	NO
JOB_CATEGORY_DESC	Job Category Description	Job category code description.	VARCHAR2(255)			ATVJOBC	ATVJOBC_DESC	NO	NO
MATCHING_GIFT_UID	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	NO	NO
MATCH_MINIMUM	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	NO	NO
MATCH_MAXIMUM	Match Maximum	Maximum matching gift amount allowed.	NUMBER			AOBORGN	AOBORGN_MATCH_MAXIMUM	NO	NO
MAX_MATCH_ORG_EMPL_YEAR	Maximum Match Organization Empl Year	Maximum corporate matching gift payout per employee per year.	NUMBER			AOBORGN	AOBORGN_MATCH_ORG_EMPL_YR	NO	NO
MULTIPLE_RATIOS_IND	Multiple Ratios Indicator	Specifies whether multiple ratios exist for this organization constituent.	VARCHAR2(1)			FUNCTION	F_MULTIPLE_RATIOS	NO	NO
PRIMARY_DONOR_CATEGORY	Primary Donor Category	Primary donor code.	VARCHAR2(63)			APRCATG	APRCATG_DONR_CODE	NO	NO
PRIMARY_DONOR_CATEGORY_DESC	Primary Donor Category Description	Preferred donor description.	VARCHAR2(255)			ATVDONR	ATVDONR_DESC	NO	NO
DONOR_CATEGORY_COUNT	Donor Category Count	Count of donor categories associated with this constituent that is an organization entity.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_DONOR_CATEGORY	NO	NO
ADDRESS_COUNT	Address Count	Count of current active addresses for this person or entity.	NUMBER			FUNCTION	MSKFUNC.F_COUNT_ADDRESSES	NO	NO
PHONE_COUNT	Phone Count	Count of phone records.	NUMBER			FUNCTION	MSKFUNC.F_COUNT_TELEPHONES	NO	NO
FUND_COUNT	Fund Count	Count of number of institution funding activities that the organization constituent has expressed interest.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_FUNDING_INT	NO	NO
CONTACT_COUNT	Contact Count	Count the number of contacts made by the institution to this constituent organization.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_ORGN_CONTACT	NO	NO
LIFE_TOTAL_GIVING	Life Total Giving	Lifetime total giving.	NUMBER			FUNCTION	F_LIFE_TOTAL_GIVING	NO	NO
MOST_RECENT_GIFT_NUMBER	Most Recent Gift Number	Most recent gift number.	VARCHAR2(63)			AGBGIFT	AGBGIFT_GIFT_NO	NO	NO
MOST_RECENT_GIFT_DATE	Most Recent Gift Date	Most recent gift date.	DATE			FUNCTION	F_MOST_RECENT_GIFT_AMOUNT	NO	NO
MOST_RECENT_GIFT_AMT	Most Recent Gift Amount	Most recent gift amount.	NUMBER			FUNCTION	F_MOST_RECENT_GIFT_AMOUNT	NO	NO
LIFE_TOTAL_PLEDGE_AMT	Life Total Pledge Amount	Lifetime total pledged amount.	NUMBER			FUNCTION	F_LIFE_TOTAL_PLEDGED_AMOUNT	NO	NO
MOST_RECENT_PLEDGE_NUMBER	Most Recent Pledge Number	Most recent pledge number.	VARCHAR2(63)			AGBPLDG	AGBPLDG_PLEDGE_NO	NO	NO
MOST_RECENT_PLEDGE_DATE	Most Recent Pledge Date	Most recent pledge date.	DATE			FUNCTION	F_MOST_RECENT_PLEDGE_AMOUNT	NO	NO
MOST_RECENT_PLEDGE_AMT	Most Recent Pledge Amount	Most recent pledge amount.	NUMBER			FUNCTION	F_MOST_RECENT_PLEDGE_AMOUNT	NO	NO
LIFE_TOTAL_PLEDGE_PAY	Life Total Pledge Pay	Lifetime total pledge payments.	NUMBER			FUNCTION	F_LIFE_TOTAL_PLEDGE_PAYMENT	NO	NO
LIFE_GIFT_SOCIETY_TYPE	Life Gift Society Type	Lifetime gift society type.	VARCHAR2(63)			FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY	NO	NO
LIFE_GIFT_SOCIETY_TYPE_DESC	Life Gift Society Type Description	Lifetime gift society type description.G14244.	VARCHAR2(255)			ATVDCST	ATVDCST_DESC	NO	NO
LIFE_GIFT_SOCIETY	Life Gift Society	Lifetime gift society.	VARCHAR2(63)			FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY	NO	NO
LIFE_GIFT_SOCIETY_DESC	Life Gift Society Description	Lifetime gift society description.	VARCHAR2(255)			ATVDCNP	ATVDCNP_DESC	NO	NO
LIFE_TOTAL_COMMITMENT	Life Total Commitment	Lifetime total commitments.	NUMBER			FUNCTION	F_LIFE_TOTAL_COMMITMENT	NO	NO
MULTI_SOURCE	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	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
PREF_ADDRESS_NUMBER	Preferred Address Number	Sequence used to identify different addresses within the same address type.	NUMBER			AOBORGN	AOBORGN_PREF_ATYP_SEQNO	NO	NO

Ver: 9.2