Reporting View Target: FIXED_ASSET

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: FIXED_ASSET_ATTRIBUTES

Description Contains asset item user defined values used to meet external and or internal reporting requirements.
Key & Frequency One row per fixed asset item per attribute table per attribute value.
Recommended Search Columns ORIGINATION_TAG_NUMBER

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

ASSET_DESC Asset Description Fixed asset description. VARCHAR2(255)
FFBMAST

FFBMAST_ASSET_DESC

ATTRIBUTE_DATA Attribute Data Additional user defined data values. VARCHAR2(255)
FFVSDAT

FFVSDAT_DATA

ATTRIBUTE_DESC Attribute Description Fixed asset attribute value description. VARCHAR2(255)
FFVSDAT

FFVSDAT_TITLE

ATTRIBUTE_SHORT_DESC Attribute Short Description Short description for the fixed asset attribute value. VARCHAR2(255)
FFVSDAT

FFVSDAT_SHORT_TITLE

ATTRIBUTE_TABLE Attribute Table User-defined table used for ad-hoc reporting purposes. VARCHAR2(63)
FFRFUSN

FFRFUSN_SDAT_CODE_ATTR

ATTRIBUTE_TABLE_VALUE Attribute Table Value User defined attribute value used for ad-hoc reporting purposes. VARCHAR2(63)
FFRFUSN

FFRFUSN_SDAT_CODE_OPT_1

CHART_OF_ACCOUNTS Chart Of Accounts Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FFBMAST

FFBMAST_COAS_CODE_RESP

CHART_OF_ACCOUNTS_DESC Chart Of Accounts Description Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

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

ORIGINATION_TAG_NUMBER Origination Tag Number System generated tag number assigned when the asset is acquired. VARCHAR2(63)
FFRFUSN

FFRFUSN_OTAG_CODE

PERMANENT_TAG_NUMBER Permanent Tag Number Unique user defined or system generated one-up number for this asset. VARCHAR2(63)
FFBMAST

FFBMAST_PTAG_CODE

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

Ver: 9.0

Description	Contains asset item user defined values used to meet external and or internal reporting requirements.
Key & Frequency	One row per fixed asset item per attribute table per attribute value.
Recommended Search Columns	ORIGINATION_TAG_NUMBER

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ASSET_DESC	Asset Description	Fixed asset description.	VARCHAR2(255)	FFBMAST	FFBMAST_ASSET_DESC
ATTRIBUTE_DATA	Attribute Data	Additional user defined data values.	VARCHAR2(255)	FFVSDAT	FFVSDAT_DATA
ATTRIBUTE_DESC	Attribute Description	Fixed asset attribute value description.	VARCHAR2(255)	FFVSDAT	FFVSDAT_TITLE
ATTRIBUTE_SHORT_DESC	Attribute Short Description	Short description for the fixed asset attribute value.	VARCHAR2(255)	FFVSDAT	FFVSDAT_SHORT_TITLE
ATTRIBUTE_TABLE	Attribute Table	User-defined table used for ad-hoc reporting purposes.	VARCHAR2(63)	FFRFUSN	FFRFUSN_SDAT_CODE_ATTR
ATTRIBUTE_TABLE_VALUE	Attribute Table Value	User defined attribute value used for ad-hoc reporting purposes.	VARCHAR2(63)	FFRFUSN	FFRFUSN_SDAT_CODE_OPT_1
CHART_OF_ACCOUNTS	Chart Of Accounts	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FFBMAST	FFBMAST_COAS_CODE_RESP
CHART_OF_ACCOUNTS_DESC	Chart Of Accounts Description	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
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
ORIGINATION_TAG_NUMBER	Origination Tag Number	System generated tag number assigned when the asset is acquired.	VARCHAR2(63)	FFRFUSN	FFRFUSN_OTAG_CODE
PERMANENT_TAG_NUMBER	Permanent Tag Number	Unique user defined or system generated one-up number for this asset.	VARCHAR2(63)	FFBMAST	FFBMAST_PTAG_CODE
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA