Target Column	Business Definition	Database Data Type	Source Name	Source Column
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FNBDSTH	FNBDSTH_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
DOCUMENT_NUMBER	Unique transaction id assigned from posting.	VARCHAR2(8)	FNBDSTH	FNBDSTH_DOC_NUM
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
ENDOWMENT_POOL	User assigned code for a unitized pool of funds.	VARCHAR2(2)	FNBDSTH	FNBDSTH_POOL_CODE
ENDOWMENT_POOL_DESC	Endowment pool description.	VARCHAR2(30)	FNVPOOL	FNVPOOL_POOL_TITLE
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	FNBDSTH	FNBDSTH_FUND_CODE
FUND_DESC	Description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_SPEND_AMOUNT	Amount of spendable income distributed.	NUMBER	FNBDSTH	FNBDSTH_SPND_INC_AMT
INCOME_SPEND_END_DATE	Period end date for which distribution of spendable income was run.	DATE	FNBDSTH	FNBDSTH_SPND_INC_END_DATE
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
REAL_GAIN_LOSS_AMOUNT	Amount of realized income distributed.	NUMBER	FNBDSTH	FNBDSTH_RLZD_GL_AMT
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
REAL_GAIN_LOSS_RATE	Amount of realized income distributed.	NUMBER	FNBDSTH	FNBDSTH_RLZD_GL_RATE
SPEND_VARIABLE_AMOUNT	Amount of spending policy variance income distributed.	NUMBER	FNBDSTH	FNBDSTH_SPND_VAR_AMT
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
SPEND_VARIABLE_RATE	Amount of unrealized income distributed.	NUMBER	FNBDSTH	FNBDSTH_SPND_VAR_RATE
SUBMISSION_NUMBER	Submission number used for documents that utilized resubmission features.	NUMBER	FNBDSTH	FNBDSTH_SUBMISSION_NUMBER
UNIT_SPEND_RATE	Spendable income amount per unit.	NUMBER	FNBDSTH	FNBDSTH_SPND_RATE
UNREAL_GAIN_LOSS_AMOUNT	Amount of unrealized income distributed.	NUMBER	FNBDSTH	FNBDSTH_URLZD_GL_AMT
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
UNREAL_GAIN_LOSS_RATE	Amount of unrealized income distributed.	NUMBER	FNBDSTH	FNBDSTH_URLZD_GL_RATE
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: