Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
ENTITY_IND	Entity Indicator	Indicates whether the entity is a person or an organization.	VARCHAR2(1)		CONSTANT CONSTANT	'O' 'P'
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER		AGRPMEM APRCHIS	AGRPMEM_MEMO_PIDM APRCHIS_PIDM
FISCAL_YEAR	Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)		ATVFISC	ATVFISC_CODE
FISCAL_YEAR_DESC	Fiscal Year Description	Fiscal year code description.	VARCHAR2(255)		ATVFISC	ATVFISC_DESC
GIFT_SOCIETY_COUNT	Gift Society Count	Count of gift societies.	NUMBER		FUNCTION	MAKFUNC.F_COUNT_GIFT_SOCIETY
HIGHEST_GIFT_AMOUNT	Highest Gift Amount	Highest gift amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT_DATE	Highest Gift Amount Date	Date of the highest gift amount for the year.	DATE		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_PLEDGE_AMOUNT	Highest Pledge Amount	Highest pledge amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR
ID	ID	Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
TOTAL_ANT_MATCH_GIFT_ONE_PAY	Total Anticipated Matching Gifts for Onetime Payments	Total anticipated matching gifts for one-time payments or outright gifts received for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY
TOTAL_ANT_MATCH_GIFT_PAY	Total Anticipated Matching Gifts for Pledge Payments	Total anticipated matching gifts for pledge payments received for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY
TOTAL_GIVING	Total Giving	Total giving for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR
TOTAL_NON_MATCH_GIFT_MEMO	Total Non-Matching Gift Memo Credit	Total non-matching gift memo or soft credit received for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO
TOTAL_NUMBER_OF_GIFTS	Total Number Of Gifts	Number of gifts for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR
TOTAL_NUMBER_OF_PLEDGES	Total Number Of Pledges	Total number of pledges for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR
TOTAL_PLEDGE_AMOUNT	Total Pledge Amount	Total pledged amount for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR
TOTAL_PLEDGE_PAYMENTS	Total Pledge Payments	Total pledge payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR
TOTAL_REAL_MATCH_GIFT_ONE_PAY	Total Realized Matching Gifts for One-time Payments	Total realized matching gifts for one-time payments or outright gifts received for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY
TOTAL_REAL_MATCH_GIFT_PAY	Total Realized Matching Gifts for Pledge Payments	Total realized matching gifts for pledge payments received for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

Ver: 9.0