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

SGHE Banner Operational Data Store
Composite View Target: AF_LOCATION_ATTRIBUTES_ODS

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

Target Column Business Definition Database Data Type Source Name Source Column
ATTRIBUTE_TYPE Set code that the attribute types are associated with. VARCHAR2(8)

FTRLCNA

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

FTRLCNA

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

FTRLCNA

FTRLCNA_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

LOCATION Identification accounting code of the physical location the grant has been assigned to. VARCHAR2(6)

FTRLCNA

FTRLCNA_LOCN_CODE

LOCATION_DESC Location code description or title. VARCHAR2(35)

FTVLOCN

FTVLOCN_TITLE

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(FTRLCNA_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.1