Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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	Book Amount	Amount of the transaction associated with this particular account distribution.	NUMBER(17,2)		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(8)		FNBUNTH	FNBUNTH_DONOR_PIDM
FUND		Unique fiscal entity code.	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		Identification accounting code use to identify the program classification structure or a subset or that structure as defined by the national council of higher education management systems.	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: