Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

Banner Operational Data Store
Composite View Target: AF_FUND_ATTRIBUTES_ODS

Description Source composite view contains all the attributes (sets, types, values) associated with a fund code.

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)

FTRFNDA

FTRFNDA_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)

FTRFNDA

FTRFNDA_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)

FTRFNDA

FTRFNDA_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
FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(6)

FTRFNDA

FTRFNDA_FUND_CODE

NO

NO
FUND_DESC Fund code description or title. VARCHAR2(35)

FTVFUND

FTVFUND_TITLE

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
SET_CODE Code defining a set with which the attribute types are associated. VARCHAR2(8)

CALCULATION

NVL(FTRFNDA_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: