Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDRESS_COUNT	Count of current active addresses for this person or entity.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADDRESSES	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
BUSINESS	Organization's general category of business.	VARCHAR2(255)	AOBORGN	AOBORGN_BUSINESS	NO	NO
CONTACT_COUNT	Count the number of contacts made by the institution to this constituent organization.	NUMBER	FUNCTION	MAKFUNC.F_COUNT_ORGN_CONTACT	NO	NO
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
DONOR_IND	Indicates whether the organization constituent or constituent has been a donor.	VARCHAR2(1)	FUNCTION	F_DONOR_IND	NO	NO
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AOBORGN	AOBORGN_PIDM	NO	NO
FEDERAL_IDENTIFICATION	Organization's federal government assigned identification number.	VARCHAR2(63)	AOBORGN	AOBORGN_EIN	NO	NO
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
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
JOB_CATEGORY	Job category associated with the organizational contact's title.	VARCHAR2(63)	AOBORGN	AOBORGN_JOBC_CODE	NO	NO
JOB_CATEGORY_DESC	Job category code description.	VARCHAR2(255)	ATVJOBC	ATVJOBC_DESC	NO	NO
LIFE_GIFT_SOCIETY	Lifetime gift society.	VARCHAR2(63)	FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY	NO	NO
LIFE_GIFT_SOCIETY_DESC	Lifetime gift society description.	VARCHAR2(255)	ATVDCNP	ATVDCNP_DESC	NO	NO
LIFE_GIFT_SOCIETY_TYPE	Lifetime gift society type.	VARCHAR2(63)	FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY	NO	NO
LIFE_GIFT_SOCIETY_TYPE_DESC	Lifetime gift society type description.G14244.	VARCHAR2(255)	ATVDCST	ATVDCST_DESC	NO	NO
LIFE_TOTAL_COMMITMENT	Lifetime total commitments.	NUMBER	FUNCTION	F_LIFE_TOTAL_COMMITMENT	NO	NO
LIFE_TOTAL_GIVING	Lifetime total giving.	NUMBER	FUNCTION	F_LIFE_TOTAL_GIVING	NO	NO
LIFE_TOTAL_PLEDGE_AMT	Lifetime total pledged amount.	NUMBER	FUNCTION	F_LIFE_TOTAL_PLEDGED_AMOUNT	NO	NO
LIFE_TOTAL_PLEDGE_PAY	Lifetime total pledge payments.	NUMBER	FUNCTION	F_LIFE_TOTAL_PLEDGE_PAYMENT	NO	NO
MATCHING_GIFT_PERCENT	Organization's matching gift percentage.	NUMBER	AOBORGN	AOBORGN_MATCH_PCT	NO	NO
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_MAXIMUM	Maximum matching gift amount allowed.	NUMBER	AOBORGN	AOBORGN_MATCH_MAXIMUM	NO	NO
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
MAX_MATCH_ORG_EMPL_YEAR	Maximum corporate matching gift payout per employee per year.	NUMBER	AOBORGN	AOBORGN_MATCH_ORG_EMPL_YR	NO	NO
MAX_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
MAX_YEAR_DONATE_AMOUNT	Maximum amount the organization donates to an institution per year.	NUMBER	AOBORGN	AOBORGN_MATCH_ORG_MAX	NO	NO
MOST_RECENT_GIFT_AMT	Most recent gift amount.	NUMBER	FUNCTION	F_MOST_RECENT_GIFT_AMOUNT	NO	NO
MOST_RECENT_GIFT_DATE	Most recent gift date.	DATE	FUNCTION	F_MOST_RECENT_GIFT_AMOUNT	NO	NO
MOST_RECENT_GIFT_NUMBER	Most recent gift number.	VARCHAR2(63)	AGBGIFT	AGBGIFT_GIFT_NO	NO	NO
MOST_RECENT_PLEDGE_AMT	Most recent pledge amount.	NUMBER	FUNCTION	F_MOST_RECENT_PLEDGE_AMOUNT	NO	NO
MOST_RECENT_PLEDGE_DATE	Most recent pledge date.	DATE	FUNCTION	F_MOST_RECENT_PLEDGE_AMOUNT	NO	NO
MOST_RECENT_PLEDGE_NUMBER	Most recent pledge number.	VARCHAR2(63)	AGBPLDG	AGBPLDG_PLEDGE_NO	NO	NO
MULTIPLE_RATIOS_IND	Specifies whether multiple ratios exist for this organization constituent.	VARCHAR2(1)	FUNCTION	F_MULTIPLE_RATIOS	NO	NO
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	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(63)	FUNCTION	F_FORMAT_NAME	NO	NO
PHONE_COUNT	Count of phone records.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TELEPHONES	NO	NO
PREF_ADDRESS_NUMBER	Sequence used to identify different addresses within the same address type.	NUMBER	AOBORGN	AOBORGN_PREF_ATYP_SEQNO	NO	NO
PREF_ADDRESS_TYPE	Address to use for the organizational contact.	VARCHAR2(63)	AOBORGN	AOBORGN_PREF_ATYP_CODE	NO	NO
PREF_ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC	NO	NO
PRIMARY_DONOR_CATEGORY	Primary donor code.	VARCHAR2(63)	APRCATG	APRCATG_DONR_CODE	NO	NO
PRIMARY_DONOR_CATEGORY_DESC	Preferred donor description.	VARCHAR2(255)	ATVDONR	ATVDONR_DESC	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROSPECT_IND	Indicates whether this entity has a prospect record.	VARCHAR2(1)	FUNCTION	F_PROSPECT_IND	NO	NO
STANDARD_INDUSTRY_CODE	Organization's standard industry code (sic).	VARCHAR2(63)	AOBORGN	AOBORGN_SICC_CODE	NO	NO
STANDARD_INDUSTRY_CODE_DESC	Standard industry code (sic) description.	VARCHAR2(255)	ATVSICC	ATVSICC_DESC	NO	NO

Ver: 9.2