Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FNBDSTH	FNBDSTH_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOCUMENT_NUMBER	Unique transaction id assigned from posting.	VARCHAR2(8)	FNBDSTH	FNBDSTH_DOC_NUM	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
ENDOWMENT_POOL	User assigned code for a unitized pool of funds.	VARCHAR2(2)	FNBDSTH	FNBDSTH_POOL_CODE	NO	NO
ENDOWMENT_POOL_DESC	Endowment pool description.	VARCHAR2(30)	FNVPOOL	FNVPOOL_POOL_TITLE	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	FNBDSTH	FNBDSTH_FUND_CODE	NO	NO
FUND_DESC	Description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
INCOME_SPEND_AMOUNT	Amount of spendable income distributed.	NUMBER	FNBDSTH	FNBDSTH_SPND_INC_AMT	NO	NO
INCOME_SPEND_END_DATE	Period end date for which distribution of spendable income was run.	DATE	FNBDSTH	FNBDSTH_SPND_INC_END_DATE	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
REAL_GAIN_LOSS_AMOUNT	Amount of realized income distributed.	NUMBER	FNBDSTH	FNBDSTH_RLZD_GL_AMT	NO	NO
REAL_GAIN_LOSS_END_DATE	Period end date for which distribution of gains and losses and spending policy variance was run.	DATE	FNBDSTH	FNBDSTH_RLZD_GL_END_DATE	NO	NO
REAL_GAIN_LOSS_RATE	Amount of realized income distributed.	NUMBER	FNBDSTH	FNBDSTH_RLZD_GL_RATE	NO	NO
SPEND_VARIABLE_AMOUNT	Amount of spending policy variance income distributed.	NUMBER	FNBDSTH	FNBDSTH_SPND_VAR_AMT	NO	NO
SPEND_VARIABLE_END_DATE	Period end date for which distribution of gains and losses and spending policy variance was run.	DATE	FNBDSTH	FNBDSTH_SPND_VAR_END_DATE	NO	NO
SPEND_VARIABLE_RATE	Amount of unrealized income distributed.	NUMBER	FNBDSTH	FNBDSTH_SPND_VAR_RATE	NO	NO
SUBMISSION_NUMBER	Submission number used for documents that utilized resubmission features.	NUMBER	FNBDSTH	FNBDSTH_SUBMISSION_NUMBER	NO	NO
UNIT_SPEND_RATE	Spendable income amount per unit.	NUMBER	FNBDSTH	FNBDSTH_SPND_RATE	NO	NO
UNREAL_GAIN_LOSS_AMOUNT	Amount of unrealized income distributed.	NUMBER	FNBDSTH	FNBDSTH_URLZD_GL_AMT	NO	NO
UNREAL_GAIN_LOSS_END_DATE	Period end date for which distribution of gains and losses and spending policy variance was run.	DATE	FNBDSTH	FNBDSTH_URLZD_GL_END_DATE	NO	NO
UNREAL_GAIN_LOSS_RATE	Amount of unrealized income distributed.	NUMBER	FNBDSTH	FNBDSTH_URLZD_GL_RATE	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: