Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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		Unique fiscal entity code.	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	Income Spend Amount	Amount of spendable income distributed.	NUMBER(17,2)		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	Real Gain Loss Amount	Amount of realized income distributed.	NUMBER(17,2)		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	Spend Variable Amount	Amount of spending policy variance income distributed.	NUMBER(17,2)		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(3)		FNBDSTH	FNBDSTH_SUBMISSION_NUMBER
UNIT_SPEND_RATE		Spendable income amount per unit.	NUMBER		FNBDSTH	FNBDSTH_SPND_RATE
UNREAL_GAIN_LOSS_AMOUNT	Unrealized Gain Loss Amount	Amount of unrealized income distributed.	NUMBER(17,2)		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: