Tagged Furniture Table: Field Reference

This topic documents all of the fields of the Tagged Furniture table. A few of these fields are used by the Archibus Client / Server applications and are not used in the Web Central applications. When the field is not currently used, this is noted in the Purpose column.

The table is sorted alphabetically by Field Heading.

Field Heading Field Name Purpose Archibus Type

Building Code

bl_id

Stores the location of the furniture asset. Validated by the Buildings (bl) table.

None

Cost Depreciation Closing Month date_dep_closing_month

When the depreciation calculation is run, the system completes this field to represent the report log closing date. It lets you know when the Depreciated Value was updated on tagged furniture. The user sets the Closing Month date (dep_reports.last_date) with the Define Depreciation Logs task.

For information on depreciation calculations, see Depreciation Calculations .

Calculated
Criticality criticality A numeric field to document the importance of the furniture to your enterprise's mission. The value is entered as a whole number from 1 to 9 using whatever definition of these numbers you find useful. None

Current Building Code

curr_bl_id

Used to support Radio Frequency ID functionality

Calculated
Current Floor Code curr_fl_id Used to support Radio Frequency ID functionality Calculated
Current Room Code curr_rm_id Used to support Radio Frequency ID functionality Calculated
Current Site Code curr_site_id Used to support Radio Frequency ID functionality Calculated
Date Disposal date_disposal This is the date you disposed of the furniture item. This date is entered using the Asset Disposal Console. None
Delivery Date date_delivery This field stores the date the furniture was actually delivered.

The application uses the Delivery Date when calculating depreciation.

None
Department Code dp_id The department using the furniture. This field is validated by the Departments (dp) table.
Depreciated Value cost_dep_value

The value of the asset after depreciation is calculated. The application completes this value when calculating depreciation (via the Asset Lifecycle console's Recalculate Depreciation task, or the Assets domain's Depreciation applications). See Depreciation Calculations .

When depreciation costs are calculated, a new record is inserted into the Tagged Furniture Depreciation table ( ta_dep.value_current ).

This value is shown on the asset registry custom datasource.

Note : If you import data into this field, or manually enter this value, as long as the Property Type (ta.property_type ) field is empty, this value will not be overwritten with the calculated depreciation value.

Currency
Disposal Comments comment_disposal Use this field to store any comments about the disposal. These comments are entered using the Asset Disposal Console. None
Disposal Type disposal_type Use this field to record the way in which the furniture was disposed of: Sell, Discard; Donate; Stolen; Lost; N/A (used when the equipment is not disposed of). These values are stored in an enumerated list. None
Division Code dv_is The organizational division using the furniture. Validated by the Divisions (dv) table. None
Drawing Layer layer_name If you represent the furniture item in a drawing, the system completes this field with the layer name for the furniture asset symbol. Layr
Drawing Name dwgname If you represent furniture with an asset symbol in a drawing, the system automatically completes this field with the asset symbol’s drawing name. Dwgname
Employee Name em_id For furniture used by particular employees, enter the name of the employee using the furniture. For furniture that is not assigned to a particular employee, leave this field blank. This field is validated by the Employees (em) table. None
Entity Handle / Unique ID ehandle If you represent the furniture item in a drawing, the system completes this field with information about the furniture asset symbol. When querying the drawing, the Archibus Smart Client Extension for AutoCAD uses the values in the Entity Handle field to quickly find the asset symbol. Ehandle
Floor Code Floor Code Stores the floor location of the furniture. Validated by the Floors (fl) table. None
Furn. Status status

This enumerated list field provides several values for documenting a furniture item's current status--is it in service, in storage, being repaired, salvaged, in use, disposed; donated; or stolen? This field is shown in the asset registry .

See Status Definitions for Assets for a description of all statuses.

The status field is used to help identify assets that need to be evaluated for disposal, refurbishment, repurposing, or storing.

None
Furniture Code ta_id The unique identifier for the furniture item. Bar code
Furniture Condition condition Use this field to record the condition of the equipment as New; Excellent; Good; Fair; Poor; or Bad. These values are stored in an enumerated list. The condition of an asset is a key factor in optimization analysis. None
Furniture Standard fn_std The type of furniture. Validated by the Furniture Standards table. Std
Furniture Use use1 Stores the description of how the furniture is used. None
GIS Object ID geo_objectid When using advanced map features , if you are maintaining asset geometry outside the Archibus environment (rather than with the Smart Client Extensions), you import this field from ArcGIS Map Services, so that it can be imported into Archibus. None
Last Survey Update From survey_id When the supervisor closes out a survey, the program uses this field to document the survey from which the system updated the Tagged Furniture (ta) table. Validated by the Disposition Surveys table. None
Latitude lat Used to support Radio Frequency ID Functionality Calculated
Lease Code ta_lease_id This field identifies the lease associated with the furniture. The field is validated by the leases in the ta_lease table. You can develop the validating lease data using the Asset Portal's View and Edit Leases task available from the Equipment process. None
Longitude longitude Used to support Radio Frequency ID Functionality None
Pending Action pending_action

This field stores the description of where the furniture item is in the disposal process. These values come from the enumerated list: N/A (not being considered for disposal); Mark for Disposal; Mark for Donation; Mark for Evaluation; Mark for Refurbish; Mark for Repurpose

This field can be entered using the Asset Disposal Console, or from the Add Furniture form.

None
PO Line Number po_line_id

This validated field is currently not used. To use it, you would need to use the New View command to create views to access the PO and PO_LINE tables to develop the validating data, You would also need to create new views to add the purchase order line item data for specific furniture. See also the entry for Purchase Order Code in this table

None
Policy Code policy_id

Select the insurance policy for this furniture. This field is validated against the Insurance Policies (policy) table. You develop the validating background data using the Asset Portal's Define and Edit Insurance Policies task available from the Equipment process.

None
Property Type property_type

The property type describes how the property is treated when calculating depreciation. You define property types as background data, giving the property type a depreciation method and percentage (for items that appreciate), or months (for items that depreciate.) Complete this field if you intend to track depreciation with any of the applications of the Assets domain.

None
Purchase Order Code po_id

Enter the purchase order for this furniture asset. This validated field is currently not used. To use it, you would need to use the New View command to create views to access the PO and PO_LINE tables to develop the validating data. You would also need to create new views to add the purchase order data for specific furniture. See also the entry for PO Line Number in this table.

None
Purchase Price value_original This field stores the purchase price for the furniture. You can enter this value using the Add / Edit Furniture form or the Edit Tagged Furniture and Property Types task of the Asset Portal's Depreciation Process. The system uses this value to calculate depreciation. You can review this value from any of the consoles that use the asset registry . None
Replacement Value value_replace The cost of replacing the furniture item. You enter this value using the Add / Edit Furniture form, or the Edit and Add Tagged Furniture by Property Types task. You can review this value from any of the consoles that use the asset registry . None
Return Date date_return The date the furniture was returned to the manufacturer / supplier. The return date could be associated with a lease or a defect. None
RF Reader or Tag ID rf_id Used to support Radio Frequency ID Functionality None
Room Code room_id The location of the furniture. Validated against the Rooms table. None
Sale Date date_sale Date the furniture item was purchased. You can review this value from any of the consoles that use the asset registry . None
Salvage Value value_salvage

This field stores the salvage value for the furniture. You manually enter this value using the Edit Tagged Furniture and Property Types task, or when adding or editing a furniture records.

None
Serial Number serial_number If the furniture has a serial number, record it in this field. None
Warranty Code warranty_id Select the warranty for the furniture asset. The field is validated by the Warranties (warranty) table. You can develop the validating warranty data using the Asset Portal's View and Edit Warranties task available from the Equipment process. None