Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AGGREGATE_BOOK_AMOUNT	Aggregation of all the transaction amounts up to and including this unitization period end date associated with this particular chart of accounts and fund.	NUMBER	FUNCTION	MFKFUNC.F_GET_BOOK_AMOUNT	NO	NO
AGGREGATE_UNITS_PURCHASED	Aggregation of all the number of units that the gift purchased in the pool up to and including this unitzation period end date based on the unit value for the period of the gift date for this specific chart of accounts and fund.	NUMBER	FUNCTION	MFKFUNC.F_GET_UNITS_PURCHASED	NO	NO
BOOK_AMOUNT	Summarized amount of the transactions associated with this particular chart of accounts and fund.	NUMBER	FUNCTION	MFKFUNC.F_SUM_BOOK_AMOUNT	NO	NO
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FNVENDW	FNVENDW_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CHART_OF_ACCOUNTS_STATUS	Status of the chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND	NO	NO
ENDOWMENT_FUND_LD	Detailed endowment title of the fund.	VARCHAR2(255)	FNVENDW	FNVENDW_LONG_FUND_TITLE	NO	NO
ENDOWMENT_POOL	User assigned code for a unitized pool of funds.	VARCHAR2(63)	FNRUCTR	FNRUCTR_POOL_CODE	NO	NO
ENDOWMENT_POOL_DESC	Endowment pool description.	VARCHAR2(255)	FNVPOOL	FNVPOOL_POOL_TITLE	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	FNBUNTH	FNBUNTH_FUND_CODE	NO	NO
FUND_DESC	Description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
FUND_STATUS	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND	NO	NO
MARKET_PURCHASE_UNIT_PRICE	Market price per unit at which the units of this pool is to be purchased.	NUMBER	FNRUCTR	FNRUCTR_PUR_PRICE_VAL_UNIT	NO	NO
MARKET_VALUATION_DATE	Date this market unit price is valid.	DATE	FNRUCTR	FNRUCTR_VALUATION_DATE	NO	NO
MARKET_VALUE	Number of units that the gift purchased in the pool based on the unit value for the period of the gift date.	NUMBER	CALCULATION	MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE	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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
UNITIZATION_PERIOD_END_DATE	End date of the unitization period for which the gift purchased units.	DATE	FNBUNTH	FNBUNTH_UNTZ_END_DATE	NO	NO
UNITS_PURCHASED	Summarized number of units that the gift purchased in the pool based on the unit value for the period of the gift date for this specific chart of accounts and fund.	NUMBER	FUNCTION	MFKFUNC.F_SUM_UNITS_PURCHASED	NO	NO

Ver: 9.2