Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ATTRIBUTE_TYPE	Set code that the attribute types are associated with.	VARCHAR2(8)	FTRPRGA	FTRPRGA_ATTT_CODE	NO	NO
ATTRIBUTE_TYPE_DESC	Attribute type description associated with the set.	VARCHAR2(50)	FTVATTT	FTVATTT_DESC	NO	NO
ATTRIBUTE_TYPE_STATUS	Attribute type status associated with the set.	VARCHAR2(1)	FTVATTT	FTVATTT_STATUS_IND	NO	NO
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)	NO	NO
ATTRIBUTE_VALUE	Code representing one of the values of the attribute type.	VARCHAR2(8)	FTRPRGA	FTRPRGA_ATTV_CODE	NO	NO
ATTRIBUTE_VALUE_BEGIN_DATE	Date from which this attribute value is valid.	DATE	FTRATTV	FTRATTV_BEGIN_DATE	NO	NO
ATTRIBUTE_VALUE_DESC	Attribute type value description.	VARCHAR2(50)	FTRATTV	FTRATTV_DESC	NO	NO
ATTRIBUTE_VALUE_END_DATE	Date after which this attribute value is not longer valid.	DATE	FTRATTV	FTRATTV_END_DATE	NO	NO
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FTRPRGA	FTRPRGA_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FTVCOAS	FTVCOAS_TITLE	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PROGRAM	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(6)	FTRPRGA	FTRPRGA_PROG_CODE	NO	NO
PROGRAM_DESC	Extracted description or title of the associated program.	VARCHAR2(35)	FTVPROG	FTVPROG_TITLE	NO	NO
SET_CODE	Code defining a set with which the attribute types are associated.	VARCHAR2(8)	CALCULATION	NVL(FTRPRGA_ATTS_CODE,'NONE')	NO	NO
SET_CODE_DESC	Set code description.	VARCHAR2(50)	FTVATTS	FTVATTS_DESC	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: