Mapping the Asset Registry to the Inventory Tables
Assets / Assets
Assets / Enterprise Assets
Mapping the Asset Registry to the Inventory Tables
The Asset Registry is a data source that combines four tables: Equipment (eq), Tagged Furniture (ta), Buildings (bl), and Properties (property). The Asset Registry is a key feature of the Assets and Enterprise Assets applications, as it provides comprehensive information on theses four asset types from one location.
The Asset Registry appears in the Asset Registration, Asset Lifecycle, Asset Disposal, and Asset Reconciliation Consoles.
The following shows the mapping of the data shown in the Asset Registry, to the asset tables that the data comes from.
Mapping for properties
|
Properties table: field heading and field name |
DataSource field heading and field name |
|---|---|
|
Property Code (property.pr_id) |
Asset (asset_id) |
|
Property Status (property.status) |
Asset Status (asset_status) |
| Not mapped for properties |
Asset Standard (asset_std) |
| Not mapped for properties |
Date Purchased (date_purchased) |
|
Purchase Price (property.cost_purchase) |
Purchase Price (cost_purchase) |
|
Property Name (property.name) |
Title / Description (description) |
| Not mapped for properties |
project_id |
|
ctry.geo_region_id where property.ctry_id = ctry.ctry_id (Maps to the Geo-Region ID for the country entered for the property) |
Geo-Region ID (geo_region_id) |
|
Country Code (property.ctry_id ) |
Country (ctry_id) |
|
State Code (property.state_id) |
State (state_id) |
|
City Code (property.city_id) |
City (city_id) |
| Not mapped for properties |
site_id |
|
bl_id |
|
|
fl_id |
|
|
rm_id |
|
|
bu_id |
|
|
dv_id |
|
|
dp_id |
|
|
Value - Book (property.value_book) |
Depreciated Value (cost_dep_value) |
|
Value - Market (property.value_market) |
Market Value (cost_val_market) |
|
Disposal Type (property.disposal_type) |
Disposal Type (disposal_type) |
|
Date Disposed (property.date_disposal) |
Date of Disposal (date_disposal) |
|
Disposal Comments (property.comment_disposal) |
Disposal Comment (comment_disposal) |
|
Pending Action (property.pending_action) |
Pending Action (pending_action) |
|
Value - Market (property.value_market) |
Cost to Replace (cost_replace) |
| Criticality (property.criticality) | Criticality (criticality) |
| Property Condition (property.condition) | Asset Condition (condition) |
Mapping for buildings
The following shows the mapping of the data in the Buildings table to the data source. A If a field is mapped to a table other than the Buildings table, this is noted.
| Buildings table field heading and field name | DataSource field heading and field name |
|---|---|
| Building Code (bl.bl_id) | Asset (asset_id) |
| Not mapped as the bl table does not have an Asset Status field. | Asset Status (asset_status) |
| Not mapped as the bl table does not have an Asset Standard field. | Asset Standard (asset_std) |
| Not mapped as the bl table does not have a date_purchased field | Date Purchased (date_purchased) |
|
Purchase Price (ot. cost_purchase) (Maps to the ot.cost_purchase where the bl.bl_id = ot.bl_id.) |
Purchase Price (cost_purchase) |
| Building Name (bl.name) | Title / Description (description) |
| Not mapped for buildings as the bl table does not have the project_id field. | project_id |
| Geo-Region ID (ctry.geo_region_id) where bl.ctry_id = ctry.ctry_id | Geo-Region ID (geo_region_id) |
|
Country Code (bl.ctry_id ) |
Country (ctry_id ) |
| State Code (bl.state_id) | State (state_id) |
| City Code (bl.city_id) |
City (city_id) |
| Site Code (bl.site_id ) |
Site (site_id) |
| Building Code (bl.bl_id) |
Building (bl_id) |
| Not mapped as the bl table does not have these fields | Floor (fl_id) |
|
Room (rm_id) |
|
|
Business Unit (bu_id) |
|
|
Division Code (dv_id) |
|
|
Department Code (dp_id) |
|
| Value - Book (bl.value_book) |
Depreciated Value (cost_dep_value) |
| Value Market (bl.value_market) | Market Value (cost_val_market) |
| Disposal Type (bl.disposal_type) |
Disposal Type (disposal_type) |
| Date Disposed (bl.date_disposal) |
Date Disposed (date_disposal) |
| Disposal Comments (bl.comment_disposal) | Disposal Comments (comment_disposal) |
| Pending Action (bl.pending_action) |
Pending Action (pending_action) |
| Value - Market (bl.value_market) |
Cost to Replace (cost_replace) |
| Criticality (bl.criticality) | Criticality (criticality) |
| Building Condition (bl.condition) | Asset Condition (condition) |
Mapping for equipment
The following shows the mapping of the data in the Equipment table to the datasource.
|
Equipment table field heading and field name |
DataSource field heading and field name |
|---|---|
|
Equipment Code (eq.eq_id) |
Asset (asset_id) |
|
Equip Status (eq.status) |
Asset Status (asset_status) |
|
Equipment Standard (eq.eq_std) |
Asset Standard (asset_std) |
|
Purchase Date (eq.date_purchased) |
Date Purchased (date_purchased) |
|
Purchase Price (eq.cost_purchase) |
Purchase Price (cost_purchase) |
| Description (eq.description) |
Title / Description (description) |
|
project.project_id where eq.eq_id = project.eq_id AND project.status NOT Closed; Completed or Cancelled; (Maps to the project_id for the project that the equipment is associated with) If there is more than one project dataSource, then the .project_id = MULTIPLE |
Project ID (project_id) |
|
ctry.geo_region_id where eq.bl_id = bl.bl_id and bl.ctry_id = ctry.ctry_id (Maps to the Geo-Region ID for the country entered for the building the equipment is associated with) |
Geo-Region ID (geo_region_id) |
|
bl.ctry_id where eq.bl_id = bl.bl_id (Maps to the country_id for the building the equipment is associated with) |
Country (ctry_id) |
|
bl.state_id where eq.bl_id = bl.bl_id (Maps to the state_id for the building the equipment is associated with) |
State (state_id) |
|
bl.city_id where eq.bl_id = bl.bl_id Maps to the city_id for the building the equipment is associated with) |
City (city_id) |
|
Site Code (eq.site_id) |
Site (site_id) |
|
Building Code (eq.bl_id) |
Building (bl_id) |
|
Floor Code (eq.fl_id) |
Floor (fl_id) |
|
Room Code (eq.rm_id) |
Room (rm_id) |
|
dv.bu_id where eq.dv_id = dv.dv_id (Maps to the Business Unit - bu_id - for the division the equipment is associated with) |
Business Unit (bu_id) |
|
Division Code (eq.dv_id) |
Division (dv_id) |
|
Department Code (eq.dp_id) |
Department (dp_id) |
|
Depreciated Value (eq.cost_dep_value) |
Depreciated Value (cost_dep_value) |
|
Current Value (eq_dep.value_current where eq_dep.eq_id = eq.eq_id) (Maps to the Current Value for the equipment in the Equipment Depreciation table) |
Market Value (cost_val_market) |
|
Disposal Type (eq.disposal_type) |
Disposal Type (disposal_type) |
|
Date Disposed (eq.date_disposal) |
Date of Disposal (date_disposal) |
|
Disposal Comments (eq.comment_disposal) |
Disposal Comment (comment_disposal) |
|
Pending Action (eq.pending_action) |
Pending Action (pending_action) |
|
Cost to Replace (eq.cost_replace) |
Cost to Replace (cost_replace) |
| Criticality (eq.criticality) |
Criticality (criticality) |
| Equipment Condition (eq.condition) | Asset Condition (condition) |
Mapping for tagged furniture
The following shows the mapping of the data in the Tagged Furniture table to the datasource.
| Tagged Furniture table field heading and field name | DataSource field heading and field name |
|---|---|
|
Furniture Code (ta.ta_id) |
Asset (asset_id) |
|
Furn. Status (ta.status) |
Asset Status (asset_status) |
|
Furniture Standard (ta.fn_std) |
Asset Standard (asset_std) |
|
Sale Date (ta.date_sale) |
Date Purchased (date_purchased) |
|
Purchase Price (ta.value_original) |
Purchase Price (cost_purchase) |
|
Furniture Use (ta.use1) |
Title / Description (description) |
| Not mapped for Tagged Furniture |
Project ID (project_id) |
|
ctry.geo_region_id where ta.bl_id = bl.bl_id and bl.ctry_id = ctry.ctry_id (Maps to the Geo Region ID for the country entered for the building the tagged furniture is located in) |
Geo-Region ID (geo_region_id) |
|
bl.ctry_id where ta.bl_id = bl.bl_id (Maps to the Country Code for the building entered for the furniture) |
Country (ctry_id) |
|
bl.state_id where ta.bl_id = bl.bl_id (Maps to the State Code for the building entered for the furniture) |
State (state_id) |
|
bl.city_id where ta.bl_id = bl.bl_id (Maps to the City Code for the building entered for the furniture) |
City (city_id) |
|
bl.site_id where ta.bl_id = bl.bl_id (Maps to the Site Code for the building entered for the furniture) |
Site (site_id) |
|
Building Code (ta.bl_id) |
Building (bl_id) |
|
Floor Code (ta.fl_id) |
Floor (fl_id) |
|
Room Code (ta.rm_id) |
Room (rm_id) |
|
dv.bu_id where ta.dv_id = dv.dv_id (Maps to the Business Unit for the division entered for the furniture) |
Business Unit (bu_id) |
|
Division Code (ta.dv_id) |
Division (dv_id) |
|
Department Code (ta.dp_id) |
Department (dp_id) |
|
Salvage Value (ta.value_salvage) |
Depreciated Value (cost_dep_value) |
|
Replacement Value (ta.value_replace) |
Market Value (cost_val_market) |
|
Disposal Type (ta.disposal_type) |
Disposal Type (disposal_type) |
|
Date Disposed (ta.date_disposal) |
Date of Disposal (date_disposal) |
|
Disposal Comments (ta.comment_disposal) |
Disposal Comment (comment_disposal) |
|
Pending Action (ta.pending_action) |
Pending Action (pending_action) |
|
Replacement Value (ta.value_replace) |
Cost to Replace (cost_replace) |
| Criticality (ta.criticality) | Criticality (criticality) |
| Furniture Condition (ta.condition) | Asset Condition (condition) |