Schema for the Asset Registry Data Source
Assets / Assets
Assets / Enterprise Assets
Schema for the Asset Registry Data Source
The Asset Registry is a data source that combines four tables: Equipment (eq), Tagged Furniture (ta), Buildings (bl), and Properties (property). It is a key feature of the Assets and Enterprise Assets applications, as it provides comprehensive information for all asset types in one place.
The Asset Registry appears in the Asset Registration, Asset Lifecycle, Asset Disposal, and Asset Reconciliation Consoles.
The following describes the schema for the Asset Registry data source. This topic serves as a reference. For example, you can use it you are customizing the application.
|
Field Name |
ML Heading |
Data Type |
Size |
Default |
PK |
Validating Table |
Allow Null? |
Enum List |
Notes |
|---|---|---|---|---|---|---|---|---|---|
|
asset_id |
Asset |
Char |
16 |
|
2 |
|
N |
|
This will be the source_table.id value |
|
asset_type |
Asset Type |
Char |
16 |
Equipment |
1 |
|
N |
bl;Building;eq;Equipment; ta;Furniture; property;Property |
Stored value is the asset table name. |
|
pending_action |
Pending Action |
Char |
24 |
N/A |
0 |
|
N |
Enum List:N/A;N/A; Evaluate for Disposal; Evaluate for Disposal; Mark for Disposal; Mark for Disposal; Mark for Donation; Mark for Donation; Mark for Refurbish; Mark for Refurbish; Mark for Repurpose; Mark for Repurpose |
Active and Inactive will be in the inventory table status field Used in Disposal Console |
|
disposal_type |
Disposal Type |
Char |
8 |
N/A |
0 |
|
N |
Sold;Sold;Discarded;Discarded;Donated;Donated;Stolen;Stolen;Lost;Lost;N/A;N/A Used in Asset Disposal Console |
Used in Disposal Console |
|
date_disposal |
Date of Disposal |
Date |
|
|
|
|
Y |
Used in Asset Disposal Console |
Used in Disposal Console |
|
comment_disposal |
Disposal Comment |
VarChar |
256 |
|
0 |
|
Y |
Used in Asset Disposal Console |
Used in Disposal Console |
The value for the following fields in the Asset Registry data source comes from the asset table (eq, ta, property or bl) for the asset type.
See Mapping the Asset Registry to the Inventory Tables for the mapping used for each asset type.
|
Field Name |
ML Heading |
Data Type |
Size |
Default |
PK |
Validating Table |
Allow Null? |
Enum List |
Notes |
|---|---|---|---|---|---|---|---|---|---|
|
asset_status |
Asset Status |
Char |
16 |
|
0 |
|
|
|
|
|
asset_std |
Asset Standard |
Char |
24 |
|
0 |
|
N |
|
|
|
asset_tag |
Asset Tag |
Char |
16 |
|
0 |
|
Y |
|
Bar Code field |
|
description |
Title/ Description |
VarChar |
256 |
|
0 |
|
Y |
|
|
|
date_purchased |
Date Purchased |
Date |
8 |
|
0 |
|
Y |
|
|
|
cost_purchase |
Purchase Price |
Numeric |
12,2 |
0.00 |
0 |
|
N |
|
|
|
project_id |
Project ID |
Char |
32 |
|
0 |
project |
Y |
|
|
|
geo_region_id |
Geo-Region ID |
Char |
8 |
|
0 |
geo_region |
Y |
|
|
|
ctry_id |
Country |
Char |
16 |
|
0 |
ctry |
Y |
|
|
|
state_id |
State |
Char |
4 |
|
0 |
state |
Y |
|
|
|
city_id |
City |
Char |
16 |
|
0 |
city |
Y |
|
|
|
site_id |
Site |
Char |
16 |
|
0 |
site |
Y |
|
|
|
bl_id |
Building |
Char |
8 |
|
0 |
bl |
Y |
|
|
|
fl_id |
Floor |
Char |
4 |
|
0 |
fl |
Y |
|
|
|
rm_id |
Room |
Char |
8 |
|
0 |
rm |
Y |
|
|
|
bu_id |
Business Unit |
Char |
16 |
|
0 |
bu |
Y |
|
|
|
dv_id |
Division |
Char |
16 |
|
0 |
dv |
Y |
|
|
|
dp_id |
Department |
Char |
16 |
|
0 |
dp |
Y |
|
|
|
cost_dep_value |
Depreciated Value |
Numeric |
12,2 |
0.00 |
0 |
|
N |
|
|
|
cost_val_market |
Market Value |
Numeric |
12,2 |
0.00 |
0 |
|
N |
|
|
|
cost_replace |
Cost to Replace |
Numeric |
12,2 |
0.00 |
0 |
|
N |
|
|
| condition | Asset Condition | Char | 12 | new | 0 | Y | |||
| criticality | Criticality | Smallint | 1 | 0 | 0 | N |