ASSET_LOCATIONS Table - Data Element Index   Tables and Data Elements   Assets Home   Data Warehouse Home

ASSET_LOCATIONS Table

Explanation
The ASSET_LOCATIONS table contains location information associated with individual assets. ASSET_LOCATIONS is replaced in its entirety during nightly updates.

Common Uses
Displaying the location currently associated with a building, fixed, movable or land asset, as of the most recent update to the Data Warehouse.

ASSET_ID
LOCATION_ID
UNITS_ASSIGNED

ASSET_ID
ASSET_NUMBER
EXTRACT_DATE
LOCATION_BUILDING
LOCATION_ID
UNITS_ASSIGNED

ASSETS
ASSET_LOCATION_HISTORY
BUILDINGS
FLOORS
ROOMS

Cautions

• Keep in mind that this is the latest information about an asset's location- the ASSET_LOCATIONS table does not keep history about locations. The ASSET_LOCATIONS_HISTORY table is available to view day-to-day changes in locations for asset records. Historical monthly snapshots of asset information are available in the ASSET_LOCATIONS_SNAP table.
• For more detailed information about the physical space (LOCATION_BUILDING, LOCATION_FLOOR, LOCATION_ROOM) associated with the asset, refer to the DWADMIN.BUILDINGS, DWADMIN.FLOORS and DWADMIN.ROOMS tables.
• The ASSET_LOCATIONS table is stored in the DWGL schema in the Data Warehouse.

ASSET LOCATIONS Table - Data Element Index   Tables and Data Elements   Assets Home   Data Warehouse Home