Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_ACTIVITY_ATTRIBUTES_ODS

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

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY Code used to identify accounting data by activity. VARCHAR2(6)

FTRACVA

FTRACVA_ACTV_CODE

ACTIVITY_DESC Activity code title or description. VARCHAR2(35)

FTVACTV

FTVACTV_TITLE

ATTRIBUTE_TYPE Set code that the attribute types are associated with. VARCHAR2(8)

FTRACVA

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

FTRACVA

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

FTRACVA

FTRACVA_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(FTRACVA_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: 8.0