Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date that information for this record on the table was entered or last updated.	DATE		FTVFSPD	FTVFSPD_ACTIVITY_DATE
CHART_OF_ACCOUNTS	Chart Of Accounts	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)		FTVFSPD	FTVFSPD_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart Of Accounts Description	Chart of accounts code title or description.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Institution value of the organization-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(6)		NA	NA
FISCAL_PERIOD	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	00 13 14
FISCAL_YEAR	Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(4)		FUNCTION	FOFYCNV(FTVFSPD_FSYR_CODE)
MIF_DESC	MIF Description	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
MIF_VALUE	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
PERIOD_END_DATE	Period End Date	Day, month and year (DD-MM-YY) identifying the end of the accounting period.	DATE		FTVFSPD	FTVFSPD_PRD_END_DATE
PERIOD_START_DATE	Period Start Date	Day, month and year (DD-MM-YY) identifying the start of the accounting period.	DATE		FTVFSPD	FTVFSPD_PRD_START_DATE
PERIOD_STATUS	Period Status	Current status of the accounting period used to control the ability to accept posting activity.	VARCHAR2(1)		FTVFSPD	FTVFSPD_PRD_STATUS_IND
PERIOD_STATUS_DESC	Period Status Description	Fiscal period status description.	VARCHAR2(35)		CALCULATION	DECODE(FTVFSPD_PRD_STATUS_IND)
USER_ID	User ID	Unique identification code of the user.	VARCHAR2(30)		FTVFSPD	FTVFSPD_USER_ID
YEAR_ACCRUAL_STATUS	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
YEAR_ACCRUAL_STATUS_DESC	Year Accrual Status Description	Year end accrual status description.	VARCHAR2(35)
YEAR_END_DATE	Year End Date	Exact day, month, and year (DD-MON-YY) that marks the end of the fiscal year.	DATE		FTVFSYR	FTVFSYR_END_DATE
YEAR_START_DATE	Year Start Date	Exact day, month, and year (DD-MON-YY) that marks the beginning of the fiscal year.	DATE		FTVFSYR	FTVFSYR_START_DATE
ZONE_VALUE	Zone Value	Institution value of the process-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(6)		NA	NA

Ver: