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

SGHE Banner Operational Data Store
Composite View Target: AF_FIXED_ASSET_ITEM

Description Source composite view contains detailed information on fixed assets items.

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

ACTUAL_USEFUL_LIFE_YEARS Estimated actual life of the asset used for depreciation. NUMBER(4)

FFBMAST

FFBMAST_EST_LIFE_YEARS

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

FFBMAST

FFBMAST_PART_NUM_VEHICLE_TAG

ASSET_DESC Fixed asset description. VARCHAR2(60)

FFBMAST

FFBMAST_ASSET_DESC

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

FFBMAST

FFBMAST_GIFT_IND

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

FFBMAST

FFBMAST_SYSTEM_STATUS_CODE

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

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

FFBMAST

FFBMAST_ASTY_CODE

ASSET_TYPE_DESC Asset type description. VARCHAR2(35)

FTVASTY

FTVASTY_TITLE

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

FFBMAST

FFBMAST_BARCODE_NUM

BOOK_VALUE_AMOUNT User entered book value amount for this fixed asset. NUMBER(17,2)

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(1)

FFBMAST

FFBMAST_COAS_CODE_RESP

CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

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

FFBMAST

FFBMAST_COMM_CODE

COMMODITY_DESC Commodity description or title. VARCHAR2(50)

FTVCOMM

FTVCOMM_DESC

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

FFBMAST

FFBMAST_ACON_CODE

CONDITION_DESC Condition description for the asset. VARCHAR2(35)

FFVACON

FFVACON_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DEPRECIATION_FREQUENCY Defined frequency (monthly, annually, semi-annually, quarterly) for the calculation of depreciation for this asset. VARCHAR2(1)

FFBMAST

FFBMAST_DEPR_FREQ

DEPRECIATION_METHOD Method of depreciation to be used for this fixed asset. Might include values like First Half All/Second Year None, Full Year, Take Half and Proportional. VARCHAR2(2)

FFBMAST

FFBMAST_DEPR_CODE

DEPRECIATION_METHOD_DESC Instructions as to how to handle the depreciation for an asset. VARCHAR2(35)

FTVDEPR

FTVDEPR_TITLE

DEPRECIATION_START_DATE Date on which the asset starts to depreciate. DATE

FFBMAST

FFBMAST_DEPR_START_DATE

DISPOSAL_DATE Date on which this asset was disposed. DATE

FFBMAST

FFBMAST_DISP_DATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

FFBMAST

FFBMAST_EXT_REF_NUM

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

FFBMAST

FFBMAST_GRNT_CODE

GRANT_LONG_TITLE Grant description or title. VARCHAR2(256)

FRBGRNT

FRBGRNT_LONG_TITLE

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

FRBGRNT

FRBGRNT_TITLE

INSURANCE_AMOUNT User defined amount that is reported to the insurance company in the event of total loss. NUMBER(17,2)

FFBMAST

FFBMAST_INS_AMT

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

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(4)

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_DEPRECIATION_DATE Date on which the depreciation calculation was last performed. DATE

FFBMAST

FFBMAST_LAST_DEPR_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(6)

FFBMAST

FFBMAST_LOCN_CODE_RESP

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

FUNCTION

F_GET_FINANCE_DESC

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

FFBMAST

FFBMAST_MAKE

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

FFBMAST

FFBMAST_MANUFACTURER

MARKET_VALUE_AMOUNT Market value amount for this fixed asset. NUMBER(17,2)

FFBMAST

FFBMAST_MARKET_AMT

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

FFBMAST

FFBMAST_ACQM_CODE

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

FFVACQM

FFVACQM_DESC

METHOD_OF_DISPOSAL Code used to define method of disposal associated with this fixed asset. VARCHAR2(2)

FFBMAST

FFBMAST_DISP_CODE

METHOD_OF_DISPOSAL_DESC Disposal method description. VARCHAR2(35)

FFVDISP

FFVDISP_DESC

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

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

FFBMAST

FFBMAST_MODEL

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(4)

FTVASTY

FTVASTY_STD_LIFE

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

FFBMAST

FFBMAST_ORGN_CODE_RESP

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

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(9)

FFBMAST

FFBMAST_OTAG_CODE_OLD

ORIGINATION_TAG_NUMBER_PRIMARY System tag number for the primary fixed asset when multiple assets are linked together. VARCHAR2(9)

FFBMAST

FFBMAST_OTAG_CODE_PRIMARY

PERMANENT_TAG_NUMBER Unique user defined or system generated one-up number for this asset. VARCHAR2(9)

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_MANAGER_UID System internally generated identification number to uniquely identify the equipment manager responsible for this fixed asset. NUMBER(8)

FFBMAST

FFBMAST_EQUIP_MGR_PIDM

PERSON_UID System generated unique internal identification number assigned to custodian assigned to this asset. NUMBER(8)

FFBMAST

FFBMAST_CUSTODIAN_PIDM

PRIOR_LAST_DEPRECIATION_DATE Next to last date on which the depreciation calculation was last performed. DATE

FFBMAST

FFBMAST_OLD_LAST_DEPR_DATE

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

FFBMAST

FFBMAST_POHD_CODE

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

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 the asset created in receiving. VARCHAR2(8)

FFBMAST

FFBMAST_RCHD_CODE

REMAINING_LIFE_MONTHS Calculated as months as the depreciation frequency being used is defined as monthly for the remaining life of the asset. This is null if the depreciation frequency is not monthly. NUMBER(4)

FUNCTION

FOKODSF.F_REMAINING_LIFE

REMAINING_LIFE_QUARTERS Calculated as quarters as the depreciation frequency being used is defined as quarterly for the remaining life of the asset. This is null if the depreciation frequency is not quarterly. NUMBER

FUNCTION

FOKODSF.F_REMAINING_LIFE

REMAINING_LIFE_SEMI_ANNUAL Calculated as number of half years as the depreciation frequency being used is defined as semi-annual for the remaining life of the asset. This is null if the depreciation frequency is not semi-annual. NUMBER

FUNCTION

FOKODSF.F_REMAINING_LIFE

REMAINING_LIFE_YEARS Calculated as years as the depreciation frequency being used is defined as annual for remaining life of the asset. This is null if the depreciation frequency is not annual. NUMBER

FUNCTION

FOKODSF.F_REMAINING_LIFE

REPLACEMENT_VALUE_AMOUNT User-defined replacement value amount for this fixed asset. NUMBER(17,2)

FFBMAST

FFBMAST_REPL_AMT

SALVAGE_AMOUNT Amount below which this fixed asset cannot be depreciated. NUMBER(17,2)

FFBMAST

FFBMAST_SALVAGE_AMT

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

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(8)

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(4)

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(2)

FFBMAST

FFBMAST_OTHER_SRC_SUB_NUM

SOURCE_DOCUMENT_TYPE Document type sequence number for the source document used for the fixed asset. NUMBER(2)

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(1)

FFBMAST

FFBMAST_SUBORDINATE_TYPE

SUBORDINATE_TYPE_DESC Subordinate type will indicated whether this is a component of or attached to when this is not the origination tag number that is primary. VARCHAR2(30)

CALCULATION

DECODE(FFBMAST_SUBORDINATE_TYPE)

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

FFBMAST

FFBMAST_TTST_CODE

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

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 of the fixed asset. VARCHAR2(1)

FFBMAST

FFBMAST_USER_STATUS_CODE

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

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

FFBMAST

FFBMAST_VEND_PIDM

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

FFBMAST

FFBMAST_WORK_IN_PROG_IND

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