Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ATTRIBUTE_TYPE	Attribute Type	Set code that the attribute types are associated with.	VARCHAR2(63)	FTRPRGA	FTRPRGA_ATTT_CODE
ATTRIBUTE_TYPE_DESC	Attribute Type Description	Attribute type description associated with the set.	VARCHAR2(255)	FTVATTT	FTVATTT_DESC
ATTRIBUTE_TYPE_STATUS	Attribute Type Status	Attribute type status associated with the set.	VARCHAR2(63)	FTVATTT	FTVATTT_STATUS_IND
ATTRIBUTE_TYPE_STATUS_DESC	Attribute Type Status Description	Deciphers a description of the activity status of the attribute type. Values can be Active or Inactive.	VARCHAR2(255)	CALCULATION	DECODE(FTVATTT_STATUS_IND)
ATTRIBUTE_VALUE	Attribute Value	Code representing one of the values of the attribute type.	VARCHAR2(63)	FTRPRGA	FTRPRGA_ATTV_CODE
ATTRIBUTE_VALUE_BEGIN_DATE	Attribute Value Begin Date	Date from which this attribute value is valid.	DATE	FTRATTV	FTRATTV_BEGIN_DATE
ATTRIBUTE_VALUE_DESC	Attribute Value Description	Attribute type value description.	VARCHAR2(255)	FTRATTV	FTRATTV_DESC
ATTRIBUTE_VALUE_END_DATE	Attribute Value End Date	Date after which this attribute value is not longer valid.	DATE	FTRATTV	FTRATTV_END_DATE
CHART_OF_ACCOUNTS	Chart Of Accounts	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FTRPRGA	FTRPRGA_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart Of Accounts Description	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE
CHART_OF_ACCOUNTS_STATUS	Chart Of Accounts Status	Status of the chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM	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
PROGRAM_DESC	Program Description	Program code description or title.	VARCHAR2(255)	FTVPROG	FTVPROG_TITLE
PROGRAM_STATUS	Program Status	Status of the program.	VARCHAR2(63)	FTVPROG	FTVPROG_STATUS_IND
SET_CODE	Set Code	Code defining a set with which the attribute types are associated.	VARCHAR2(63)	CALCULATION	NVL(FTRPRGA_ATTS_CODE,'NONE')
SET_CODE_DESC	Set Code Description	Set code description.	VARCHAR2(255)	FTVATTS	FTVATTS_DESC

Ver: 9.2