Tagged Furniture Table: Field Reference
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
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 (
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
|
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 |