Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ATTRIBUTE_TYPE	Set code that the attribute types are associated with.	VARCHAR2(63)	FTRPRGA	FTRPRGA_ATTT_CODE	NO	NO
ATTRIBUTE_TYPE_DESC	Attribute type description associated with the set.	VARCHAR2(255)	FTVATTT	FTVATTT_DESC	NO	NO
ATTRIBUTE_TYPE_STATUS	Attribute type status associated with the set.	VARCHAR2(63)	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(255)	CALCULATION	DECODE(FTVATTT_STATUS_IND)	NO	NO
ATTRIBUTE_VALUE	Code representing one of the values of the attribute type.	VARCHAR2(63)	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(255)	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(63)	FTRPRGA	FTRPRGA_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE	NO	NO
CHART_OF_ACCOUNTS_STATUS	Status of the chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	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(63)	FTRPRGA	FTRPRGA_PROG_CODE	NO	NO
PROGRAM_DESC	Program code description or title.	VARCHAR2(255)	FTVPROG	FTVPROG_TITLE	NO	NO
PROGRAM_STATUS	Status of the program.	VARCHAR2(63)	FTVPROG	FTVPROG_STATUS_IND	NO	NO
SET_CODE	Code defining a set with which the attribute types are associated.	VARCHAR2(63)	CALCULATION	NVL(FTRPRGA_ATTS_CODE,'NONE')	NO	NO
SET_CODE_DESC	Set code description.	VARCHAR2(255)	FTVATTS	FTVATTS_DESC	NO	NO

Ver: 9.2