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

ASSET_LOCATIONS_HISTORY Table

Explanation
The ASSET_LOCATIONS_HISTORY table contains a record of all asset location changes. ASSETS_LOCATIONS_HISTORY records can be created nightly, dependent upon any changes in the column values compared to those in ASSET_LOCATIONS the previous day.

Common Uses
Displaying all historical location changes for an asset.

ASSET_ID
LAST_UPDATE_DATE
LOCATION_ID
UNITS_ASSIGNED

ASSET_ID
ASSET_NUMBER
LOCATION_BUILDING
LAST_UPDATE_DATE
LOCATION_ID
UNITS_ASSIGNED

ASSETS
ASSET_LOCATIONS
BUILDINGS
FLOORS
ROOMS
    

Cautions

• ASSET_LOCATIONS_HISTORY contains day-to-day changes for asset locations only. To track changes in other elements, refer to ASSETS_SNAP, which captures asset records as of the end of each BEN Assets period. In addition, the ASSET_LOCATIONS_SNAP table captures asset location information as of the end of each BEN Assets period. For most current information available about asset locations, refer to the ASSET_LOCATIONS table.
• There may be multiple rows for a given asset, as this table stores a snapshot of the asset location record as it appeared at the time of the extract to the Warehouse. Note that the table stores only the latest value of asset locations in a day -- it does not represent changes over the course of one day. Therefore, the LAST_UPDATED_BY column displays only the last user to update the asset location record in the day. To sort all rows in chronological order, be sure to use a date format that includes time specification.
• The ASSET_LOCATIONS_HISTORY table is stored in the DWGL schema in the Data Warehouse.

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