Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date that information for this record on the table was entered or last updated.	DATE	FTVFSPD	FTVFSPD_ACTIVITY_DATE	NO	NO
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FTVFSPD	FTVFSPD_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code title or description.	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
DOMAIN_VALUE	Institution value of the organization-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(6)	NA	NA	NO	NO
FISCAL_PERIOD	Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.	VARCHAR2(2)	CONSTANT CONSTANT CONSTANT FTVFSPD	00 13 14 FTVFSPD_FSPD_CODE	NO NO NO NO	NO
FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(4)	FUNCTION	FOFYCNV(FTVFSPD_FSYR_CODE)	NO	NO
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA	NO	NO
PERIOD_END_DATE	Day, month and year (DD-MM-YY) identifying the end of the accounting period.	DATE	FTVFSPD	FTVFSPD_PRD_END_DATE	NO	NO
PERIOD_START_DATE	Day, month and year (DD-MM-YY) identifying the start of the accounting period.	DATE	FTVFSPD	FTVFSPD_PRD_START_DATE	NO	NO
PERIOD_STATUS	Current status of the accounting period used to control the ability to accept posting activity.	VARCHAR2(1)	FTVFSPD	FTVFSPD_PRD_STATUS_IND	NO	NO
PERIOD_STATUS_DESC	Fiscal period status description.	VARCHAR2(35)	CALCULATION	DECODE(FTVFSPD_PRD_STATUS_IND)	NO	NO
USER_ID	Unique identification code of the user.	VARCHAR2(30)	FTVFSPD	FTVFSPD_USER_ID	NO	NO
YEAR_ACCRUAL_STATUS	Current status for year end accruals used to control posting activity in the 14th period.	VARCHAR2(1)	FTVFSYR	FTVFSYR_EOY_ACCR_STATUS_IND	NO	NO
YEAR_ACCRUAL_STATUS_DESC	Year end accrual status description.	VARCHAR2(35)				NO
YEAR_END_DATE	Exact day, month, and year (DD-MON-YY) that marks the end of the fiscal year.	DATE	FTVFSYR	FTVFSYR_END_DATE	NO	NO
YEAR_START_DATE	Exact day, month, and year (DD-MON-YY) that marks the beginning of the fiscal year.	DATE	FTVFSYR	FTVFSYR_START_DATE	NO	NO
ZONE_VALUE	Institution value of the process-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(6)	NA	NA	NO	NO

Ver: