Composition of the Database
The Inventory database contains the following data information for each item of equipment.
-
Asset Data
- Tag number - the identifying number assigned to the asset.
- Item code - the code that indicates the inventory item type. Each item code has a corresponding one word description of the item type.
- Eqpt class - the code that indicates the equipment class.
- Replacement cost - the cost to replace the item with a new, like item.
- Vendor - the company or group from which the asset was purchased.
- Room Tag - the room tag identifies a building and room.
- Manuf - the manufacturer of the inventory item.
- Model - the model description of the item.
- Serial # - the manufacturer's serial number.
- Old tag number - the pre-bar-coded asset tag number, if any.
- Age - the age of the inventory item in years.
-
Condition - a condition code with a description:
5 Equipment presently in use
1 Equipment not in use
6 Equipment which has been declared surplus
7 Equipment excluded from the Facilities and Administrative Costs (F & A)
0 Unlocated equipment
- Untagged? - a declaration by the department that the asset cannot be tagged, once that the presence of the asset is confirmed, the PO will be tagged.
-
Ownership Data
- Dept - the code and description of the department to which the item is assigned.
- Resp per - the code and description of the person to which the item is assigned.
- Own #2 - the code and description of the secondary person to which the item is assigned.
- Agency - the code and description of the source from which the funds were made available.
-
Acquisition Data
- Method - the code and description of how this item was acquired.
- Approval Date - the date the purchase requisition for the asset was approved.
- PO # - the purchase order number with which this item was purchased.
- Requisition - the purchase requisition number with which this item was purchased.
- Voucher - the number of the voucher or check used to pay for the asset.
- Voucher Date - the date of the payment voucher.
- Date - the date the purchase of the asset was completed.
- Cost - the acquisition cost of the item.
-
Other Available Data
- Links - one asset may be associated with another. Linked assets are comprised of base and sub-asset link type.
- Accounts - the account and amounts for acquisition of an asset.
- Extended Description - the full description of an asset.
Last modified: May 31, 2007 11:00:58
