Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACCOUNT		Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(6)		FTRACTA	FTRACTA_ACCT_CODE
ACCOUNT_DESC		Account code description or title.	VARCHAR2(35)		FTVACCT	FTVACCT_TITLE
ATTRIBUTE_TYPE		Set code that the attribute types are associated with.	VARCHAR2(8)		FTRACTA	FTRACTA_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)		FTRACTA	FTRACTA_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)		FTRACTA	FTRACTA_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(FTRACTA_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: