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

Ver: 9.0