Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT	Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(6)	FNBUNTH	FNBUNTH_ACCT_CODE
ACCOUNT_DESC	Account code description or title.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
BOOK_AMOUNT	Amount of the transaction associated with this particular account distribution.	NUMBER	FNBUNTH	FNBUNTH_TRANS_AMT
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FNBUNTH	FNBUNTH_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	FNBUNTH	FNBUNTH_DONOR_PIDM
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	FNBUNTH	FNBUNTH_FUND_CODE
FUND_DESC	Description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
GIFT_DATE	Date of the gift for IRS valuation purposes. Used to obtain purchase price per unit in the unitization process in endowment management.	DATE	FNBUNTH	FNBUNTH_GIFT_DATE
GIFT_NUMBER	Gift number that is assigned when the gift is entered.	VARCHAR2(8)	FNBUNTH	FNBUNTH_GIFT_NUM
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
ORGANIZATION_CODE	Identification accounting code used for the department on the gift transaction.	VARCHAR2(6)	FNBUNTH	FNBUNTH_ORGN_CODE
ORGANIZATION_DESC	Extracted description or title associated with the organization code.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
POSTING_DATE	Date used to post the gift to the ledgers.	DATE	FNBUNTH	FNBUNTH_TRANS_DATE
PROGRAM	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(6)	FNBUNTH	FNBUNTH_PROG_CODE
PROGRAM_DESC	Extracted description or title of the associated program.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
UNITIZATION_PERIOD_END_DATE	End date of the unitization period for which the gift purchased units.	DATE	FNBUNTH	FNBUNTH_UNTZ_END_DATE
UNITS_PURCHASED	Number of units that the gift purchased in the pool based on the unit value for the period of the gift date.	NUMBER	FNBUNTH	FNBUNTH_NUM_UNITS
UNIT_MARKET_VALUE	Price per unit at which the units of this gift was purchased.	NUMBER	FNBUNTH	FNBUNTH_UNIT_MKT_VALUE
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: