Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY		Code used to identify accounting data by activity.	VARCHAR2(6)		FTRACVA	FTRACVA_ACTV_CODE
ACTIVITY_DESC		Activity code title or description.	VARCHAR2(35)		FTVACTV	FTVACTV_TITLE
ATTRIBUTE_TYPE		Set code that the attribute types are associated with.	VARCHAR2(8)		FTRACVA	FTRACVA_ATTT_CODE
ATTRIBUTE_TYPE_DESC		Attribute type description associated with the set.	VARCHAR2(50)		FTVATTT	FTVATTT_DESC
ATTRIBUTE_TYPE_STATUS		Attribute type status associated with the set.	VARCHAR2(1)		FTVATTT	FTVATTT_STATUS_IND
ATTRIBUTE_TYPE_STATUS_DESC		Deciphers a description of the activity status of the attribute type. Values can be Active or Inactive.	VARCHAR2(8)		CALCULATION	DECODE(FTVATTT_STATUS_IND)
ATTRIBUTE_VALUE		Code representing one of the values of the attribute type.	VARCHAR2(8)		FTRACVA	FTRACVA_ATTV_CODE
ATTRIBUTE_VALUE_BEGIN_DATE		Date from which this attribute value is valid.	DATE		FTRATTV	FTRATTV_BEGIN_DATE
ATTRIBUTE_VALUE_DESC		Attribute type value description.	VARCHAR2(50)		FTRATTV	FTRATTV_DESC
ATTRIBUTE_VALUE_END_DATE		Date after which this attribute value is not longer valid.	DATE		FTRATTV	FTRATTV_END_DATE
CHART_OF_ACCOUNTS		Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)		FTRACVA	FTRACVA_COAS_CODE
CHART_OF_ACCOUNTS_DESC		Chart of accounts code description or title.	VARCHAR2(35)		FTVCOAS	FTVCOAS_TITLE
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
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
SET_CODE		Code defining a set with which the attribute types are associated.	VARCHAR2(8)		CALCULATION	NVL(FTRACVA_ATTS_CODE,'NONE')
SET_CODE_DESC		Set code description.	VARCHAR2(50)		FTVATTS	FTVATTS_DESC
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: