RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE 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 ORIGINATION_TAG_NUMBER
GRANT_ID
PERSON_UID

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

FFBMAST

FFBMAST_ACQD_DATE

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 Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ASSET_DESC Fixed asset description. VARCHAR2(255)

FFBMAST

FFBMAST_ASSET_DESC

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

FFBMAST

FFBMAST_GIFT_IND

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

FFBMAST

FFBMAST_SYSTEM_STATUS_CODE

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

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

FFBMAST

FFBMAST_ASTY_CODE

ASSET_TYPE_DESC Asset type description. VARCHAR2(255)

FTVASTY

FTVASTY_TITLE

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

FFBMAST

FFBMAST_BARCODE_NUM

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

FFBMAST

FFBMAST_BOOK_AMT

CAPITALIZATION_DATE Date the asset was declared for capitalization value. DATE

FFBMAST

FFBMAST_CAP_DATE

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 code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

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

FFBMAST

FFBMAST_COMM_CODE

COMMODITY_DESC Commodity description or title. VARCHAR2(255)

FTVCOMM

FTVCOMM_DESC

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

FFBMAST

FFBMAST_ACON_CODE

CONDITION_DESC Condition description for the asset. VARCHAR2(255)

FFVACON

FFVACON_DESC

DISPOSAL_DATE Date on which this asset was disposed. DATE

FFBMAST

FFBMAST_DISP_DATE

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

FFBMAST

FFBMAST_EXT_REF_NUM

FULL_NAME_FMIL Combination of the person's first, middle initial, and last name into one value. VARCHAR2(94)

FUNCTION

MSKFUNC.F_FORMAT_NAME

FULL_NAME_LFMI Combination of the person's last, first, and middle initial into one value. VARCHAR2(94)

FUNCTION

MSKFUNC.F_FORMAT_NAME

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 or description. VARCHAR2(256)

FRBGRNT

FRBGRNT_LONG_TITLE

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

FRBGRNT

FRBGRNT_TITLE

ID System generated, unique, internal identification number assigned to this custodian or equipment manager. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

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 document number on which this fixed asset was paid. VARCHAR2(63)

FFBMAST

FFBMAST_INVH_CODE

INVOICE_DATE Date of the invoice. DATE

FFBMAST

FFBMAST_INVH_DATE

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

FFBMAST

FFBMAST_INVC_ITEM

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

FFBMAST

FFBMAST_IN_SERV_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 Date on which this asset was last inventoried. DATE

FFBMAST

FFBMAST_LAST_INVENTORY_DATE

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

FFBMAST

FFBMAST_LOCN_CODE_RESP

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

FUNCTION

F_GET_FINANCE_DESC

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

FFBMAST

FFBMAST_MAKE

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

FFBMAST

FFBMAST_MANUFACTURER

MARKET_VALUE_AMOUNT Market value amount for this fixed asset. NUMBER

FFBMAST

FFBMAST_MARKET_AMT

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

FFBMAST

FFBMAST_ACQM_CODE

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

FFVACQM

FFVACQM_DESC

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 Disposal method description. VARCHAR2(255)

FFVDISP

FFVDISP_DESC

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

FFBMAST

FFBMAST_MODEL

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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 usable life expected for the asset. NUMBER

FTVASTY

FTVASTY_STD_LIFE

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

FFBMAST

FFBMAST_ORGN_CODE_RESP

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

FUNCTION

F_GET_FINANCE_DESC

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 Calculated as the original cost of the asset excluding attachment costs. NUMBER

FUNCTION

FOKODSF.F_COST_AMT

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 System generated tag number assigned when the asset is acquired. VARCHAR2(9)

FFBMAST

FFBMAST_OTAG_CODE

ORIGINATION_TAG_NUMBER_DATE Date the system tag number is assigned. DATE

FFBMAST

FFBMAST_OTAG_DATE

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 System tag number for the primary fixed asset when multiple assets are linked together. VARCHAR2(63)

FFBMAST

FFBMAST_OTAG_CODE_PRIMARY

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 Date the permanent tag number is assigned to the fixed asset. DATE

FFBMAST

FFBMAST_PTAG_DATE

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

FFBMAST

FFBMAST_CUSTODIAN_PIDM

FFBMAST_EQUIP_MGR_PIDM

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 number on which this fixed asset was ordered. VARCHAR2(63)

FFBMAST

FFBMAST_POHD_CODE

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

FFBMAST

FFBMAST_PODT_ITEM

RECEIVED_DATE Date the purchase order item was received. DATE

FFBMAST

FFBMAST_RCHD_DATE

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

FFBMAST

FFBMAST_RCHD_CODE

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

FFBMAST

FFBMAST_REPL_AMT

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

FFBMAST

FFBMAST_SERIAL_NUM_VIN

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 Date that the source document was created. DATE

FFBMAST

FFBMAST_DTAG_ACTIVITY_DATE

SOURCE_DOCUMENT_SEQ_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 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 Document type sequence number for the source document used for the fixed asset. NUMBER

FFBMAST

FFBMAST_OTHER_SRC_DTYP_NUM

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 Deciphers asset subordinate type as a component or attachment relating to the primary tag. VARCHAR2(255)

CALCULATION

DECODE(FFBMAST_SUBORDINATE_TYPE)

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

FFBMAST

FFBMAST_TTST_CODE

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

FFVTTST

FFVTTST_DESC

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 Sum of original cost of the asset and attachment costs. NUMBER

FUNCTION

FOKODSF.F_TOTAL_COST_AMT

TRANSFER_DATE Date on which the asset was last transferred. DATE

FFBMAST

FFBMAST_TRANSFER_DATE

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

FFBMAST

FFBMAST_USER_STATUS_CODE

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

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

SPRIDEN

SPRIDEN_ID

VENDOR_NAME Extracted name of the vendor that supplied the asset. VARCHAR2(94)

FUNCTION

MSKFUNC.F_FORMAT_NAME

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

FFBMAST

FFBMAST_VEND_PIDM

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

FFBMAST

FFBMAST_WORK_IN_PROG_IND



Ver: 3.1