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.
Displaying all historical location changes for an asset.
||Indexed Data Elements
- 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.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania