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

Banner Operational Data Store
Reporting View Target: FIXED_ASSET_ITEM

Description Contains general information about the fixed asset item including acquisition details and current values such as capitalization date, capitalization amount, last adjustment date, asset type, asset description, normal useful life, various amounts, disposal method, disposal date, purchase order, invoice, vendor name, transfer date, chart of accounts, responsible organization code, responsible location, responsible person name, and grant.
Key & Frequency One row per fixed asset origination tag number.
Recommended Search Columns PERSON_UID
ORIGINATION_TAG_NUMBER
GRANT_ID

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACQUISITION_DATE Acquisition Date Date the asset was purchased within or outside of purchasing. DATE

FFBMAST

FFBMAST_ACQD_DATE

ADDITIONAL_SERIAL_NUMBER Additional Serial Number Additional part serial number or vehicle identification number (VIN) for the fixed asset. VARCHAR2(63)

FFBMAST

FFBMAST_PART_NUM_VEHICLE_TAG

ADMINISTRATIVE_GROUP Administrative Group Administrative-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

ASSET_GIFT_IND Asset Gift Indicator Indicates whether this asset was acquired as a gift. VARCHAR2(63)

FFBMAST

FFBMAST_GIFT_IND

ASSET_STATUS Asset Status Indicates the current system maintained status for the fixed asset. VARCHAR2(63)

FFBMAST

FFBMAST_SYSTEM_STATUS_CODE

ASSET_STATUS_DESC Asset Status Description Retrieved description for asset system status. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

ASSET_TYPE Asset Type Describes an asset category for depreciation purposes. VARCHAR2(63)

FFBMAST

FFBMAST_ASTY_CODE

ASSET_TYPE_DESC Asset Type Description Asset type description. VARCHAR2(255)

FTVASTY

FTVASTY_TITLE

BARCODE_NUMBER Barcode Number Barcode number for the fixed asset. VARCHAR2(63)

FFBMAST

FFBMAST_BARCODE_NUM

BOOK_VALUE_AMOUNT Book Value Amount User entered book value amount for this fixed asset. NUMBER

FFBMAST

FFBMAST_BOOK_AMT

CAPITALIZATION_DATE Capitalization Date Date the asset was declared for capitalization value. DATE

FFBMAST

FFBMAST_CAP_DATE

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

COMMODITY Commodity User-defined code associated with this commodity. VARCHAR2(63)

FFBMAST

FFBMAST_COMM_CODE

COMMODITY_DESC Commodity Description Commodity description or title. VARCHAR2(255)

FTVCOMM

FTVCOMM_DESC

CONDITION Condition Code used to define the asset condition. VARCHAR2(63)

FFBMAST

FFBMAST_ACON_CODE

CONDITION_DESC Condition Description Condition description for the asset. VARCHAR2(255)

FFVACON

FFVACON_DESC

DISPOSAL_DATE Disposal Date Date on which this asset was disposed. DATE

FFBMAST

FFBMAST_DISP_DATE

EXTERNAL_REFERENCE_NUMBER External Reference Number Externally assigned reference number for the fixed asset when available. VARCHAR2(63)

FFBMAST

FFBMAST_EXT_REF_NUM

FULL_NAME_FMIL Full Name First, Middle Initial, Last Combination of the person's first, middle initial, and last name into one value. VARCHAR2(255)

FUNCTION

MSKFUNC.F_FORMAT_NAME

FULL_NAME_LFMI Full Name Last, First, Middle Initial Combination of the person's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

MSKFUNC.F_FORMAT_NAME

GRANT_ID Grant ID Unique user defined or system generated one-up number for this grant. VARCHAR2(63)

FFBMAST

FFBMAST_GRNT_CODE

GRANT_LONG_TITLE Grant Long Title Grant long title or description. VARCHAR2(256)

FRBGRNT

FRBGRNT_LONG_TITLE

GRANT_TITLE Grant Title Shortened name or title for the grant. VARCHAR2(255)

FRBGRNT

FRBGRNT_TITLE

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

INSURANCE_AMOUNT Insurance Amount User defined amount that is reported to the insurance company in the event of total loss. NUMBER

FFBMAST

FFBMAST_INS_AMT

INVOICE Invoice Invoice document number on which this fixed asset was paid. VARCHAR2(63)

FFBMAST

FFBMAST_INVH_CODE

INVOICE_DATE Invoice Date Date of the invoice. DATE

FFBMAST

FFBMAST_INVH_DATE

INVOICE_ITEM Invoice Item Invoice item number on which this fixed asset was ordered. NUMBER

FFBMAST

FFBMAST_INVC_ITEM

IN_SERVICE_DATE IN Service Date Date on which this asset was placed in service. DATE

FFBMAST

FFBMAST_IN_SERV_DATE

LAST_ADJUSTMENT_DATE Last Adjustment Date Date the fixed asset value was last adjusted for any reason (capitalization, depreciation or any other adjustment). DATE

FFBMAST

FFBMAST_ADJ_DATE

LAST_INVENTORY_DATE Last Inventory Date Date on which this asset was last inventoried. DATE

FFBMAST

FFBMAST_LAST_INVENTORY_DATE

LOCATION Location Identification code of the physical location for the asset. VARCHAR2(63)

FFBMAST

FFBMAST_LOCN_CODE_RESP

LOCATION_DESC Location Description Extracted description or title of the associated location. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

LOCATION_STATUS Location Status Status of the Location. VARCHAR2(63)

FTVLOCN

FTVLOCN_STATUS_IND

MAKE Make Make for the fixed asset usually associated with a car. VARCHAR2(63)

FFBMAST

FFBMAST_MAKE

MANUFACTURER Manufacturer Name of the manufacturer for the fixed asset. VARCHAR2(63)

FFBMAST

FFBMAST_MANUFACTURER

MARKET_VALUE_AMOUNT Market Value Amount Market value amount for this fixed asset. NUMBER

FFBMAST

FFBMAST_MARKET_AMT

METHOD_OF_ACQUISITION Method Of Acquisition Code used to indicate the method used to acquire the asset. VARCHAR2(63)

FFBMAST

FFBMAST_ACQM_CODE

METHOD_OF_ACQUISITION_DESC Method Of Acquisition Description Description of the method used to acquire the asset. VARCHAR2(255)

FFVACQM

FFVACQM_DESC

METHOD_OF_DISPOSAL Method Of Disposal Code used to define method of disposal associated with this fixed asset. VARCHAR2(63)

FFBMAST

FFBMAST_DISP_CODE

METHOD_OF_DISPOSAL_DESC Method Of Disposal Description Disposal method description. VARCHAR2(255)

FFVDISP

FFVDISP_DESC

MODEL Model Model number for the fixed asset. VARCHAR2(63)

FFBMAST

FFBMAST_MODEL

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

NET_BOOK_VALUE_AMOUNT Net Book Value Amount Net book value calculated as original cost plus or minus any adjustments minus accumulated depreciation for the asset not including attachment costs. NUMBER

FUNCTION

FOKODSF.F_NET_BOOK_AMT

NORMAL_USEFUL_LIFE Normal Useful Life Normal usable life expected for the asset. NUMBER

FTVASTY

FTVASTY_STD_LIFE

ORGANIZATION_CODE Organization Code Identification accounting code used for the responsible department. VARCHAR2(63)

FFBMAST

FFBMAST_ORGN_CODE_RESP

ORGANIZATION_DESC Organization Description Extracted description or title associated with the organization code. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

ORGANIZATION_STATUS Organization Status Status of the organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

ORIGINAL_CAPITALIZED_AMOUNT Original Capitalized Amount Calculated as original cost plus or minus any adjustments minus accumulated depreciation for the asset including attachment costs. NUMBER

FUNCTION

FOKODSF.F_CAPITALIZED_AMT

ORIGINAL_COST_AMOUNT Original Cost Amount Calculated as the original cost of the asset excluding attachment costs. NUMBER

FUNCTION

FOKODSF.F_COST_AMT

ORIGINATION_TAG_CANCEL_DATE Origination Tag Cancel Date Date the new system tag number is assigned and the old tag number retired. DATE

FFBMAST

FFBMAST_OTAG_CANCEL_DATE

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

FFBMAST

FFBMAST_OTAG_CODE

ORIGINATION_TAG_NUMBER_DATE Origination Tag Number Date Date the system tag number is assigned. DATE

FFBMAST

FFBMAST_OTAG_DATE

ORIGINATION_TAG_NUMBER_OLD Origination Tag Number Old Old tag number when a new system tag number is assigned. VARCHAR2(63)

FFBMAST

FFBMAST_OTAG_CODE_OLD

ORIGINATION_TAG_NUMBER_PRIMARY Origination Tag Number Primary System tag number for the primary fixed asset when multiple assets are linked together. VARCHAR2(63)

FFBMAST

FFBMAST_OTAG_CODE_PRIMARY

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

FFBMAST

FFBMAST_PTAG_CODE

PERMANENT_TAG_NUMBER_DATE Permanent Tag Number Date Date the permanent tag number is assigned to the fixed asset. DATE

FFBMAST

FFBMAST_PTAG_DATE

PERSON_UID Person UID System generated unique internal identification number assigned to the equipment manager for this asset. NUMBER

FFBMAST

FFBMAST

FFBMAST_CUSTODIAN_PIDM

FFBMAST_EQUIP_MGR_PIDM

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

NA

NA

PURCHASE_ORDER Purchase Order Purchase order number on which this fixed asset was ordered. VARCHAR2(63)

FFBMAST

FFBMAST_POHD_CODE

PURCHASE_ORDER_ITEM Purchase Order Item Purchase order item number on which this fixed asset was ordered. NUMBER

FFBMAST

FFBMAST_PODT_ITEM

RECEIVED_DATE Received Date Date the purchase order item was received. DATE

FFBMAST

FFBMAST_RCHD_DATE

RECEIVER Receiver Unique number for the receiving document associated with this asset created in receiving. VARCHAR2(63)

FFBMAST

FFBMAST_RCHD_CODE

REPLACEMENT_VALUE_AMOUNT Replacement Value Amount User-defined replacement value amount for this fixed asset. NUMBER

FFBMAST

FFBMAST_REPL_AMT

SERIAL_NUMBER Serial Number Serial number or vehicle identification number (VIN) for the fixed asset. VARCHAR2(63)

FFBMAST

FFBMAST_SERIAL_NUM_VIN

SOURCE_DOCUMENT Source Document Document number for the source document outside of fixed assets used to track the asset when the origination tag number was created. VARCHAR2(63)

FFBMAST

FFBMAST_OTHER_SRC_DOC_CODE

SOURCE_DOCUMENT_DATE Source Document Date Date that the source document was created. DATE

FFBMAST

FFBMAST_DTAG_ACTIVITY_DATE

SOURCE_DOCUMENT_SEQ_NUMBER Source Document Sequence Number Document system assigned sequence number to the accounting line for the source document used for the fixed asset. NUMBER

FFBMAST

FFBMAST_OTHER_SRC_SEQ_NUM

SOURCE_DOCUMENT_SUB_NUMBER Source Document Sub Number Document submission number for the source document used for fixed assets. Like an auto submission for a journal voucher. NUMBER

FFBMAST

FFBMAST_OTHER_SRC_SUB_NUM

SOURCE_DOCUMENT_TYPE Source Document Type Document type sequence number for the source document used for the fixed asset. NUMBER

FFBMAST

FFBMAST_OTHER_SRC_DTYP_NUM

SUBORDINATE_TYPE Subordinate Type When the fixed asset is not the primary, indicates how the subordinate fixed asset is linked. It can either be linked to depreciate with the primary as an asset or linked and depreciated separately as a component. VARCHAR2(63)

FFBMAST

FFBMAST_SUBORDINATE_TYPE

SUBORDINATE_TYPE_DESC Subordinate Type Description Deciphers asset subordinate type as a component or attachment relating to the primary tag. VARCHAR2(255)

CALCULATION

DECODE(FFBMAST_SUBORDINATE_TYPE)

TITLED_TO Titled To Represents the title-to designation at the institution. VARCHAR2(63)

FFBMAST

FFBMAST_TTST_CODE

TITLED_TO_DESC Titled To Description Name from the titled-to designation. VARCHAR2(255)

FFVTTST

FFVTTST_DESC

TOTAL_NET_BOOK_VALUE_AMOUNT Total Net Book Value Amount Total net book value calculated as original cost plus or minus any adjustments minus accumulated depreciation for the asset including attachment costs. NUMBER

FUNCTION

FOKODSF.F_TOTAL_BOOK_AMT

TOTAL_ORIGINAL_COST_AMOUNT Total Original Cost Amount Sum of original cost of the asset and attachment costs. NUMBER

FUNCTION

FOKODSF.F_TOTAL_COST_AMT

TRANSFER_DATE Transfer Date Date on which the asset was last transferred. DATE

FFBMAST

FFBMAST_TRANSFER_DATE

USER_STATUS User Status Indicates the current user assigned status for the fixed asset. VARCHAR2(63)

FFBMAST

FFBMAST_USER_STATUS_CODE

USER_STATUS_DESC User Status Description Retrieves description for asset user status. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

VENDOR_ID Vendor ID User-defined or system generated one-up number of the vendor. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

VENDOR_NAME Vendor Name Extracted name of the vendor that supplied the asset. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

VENDOR_UID Vendor UID System generated unique internal identification number used to access the vendor. NUMBER

FFBMAST

FFBMAST_VEND_PIDM

WORK_IN_PROGRESS_IND Work IN Progress Indicator For assets such as buildings, defines if work is in progress. VARCHAR2(63)

FFBMAST

FFBMAST_WORK_IN_PROG_IND



Ver: 9.2