The ASSET_LOCATIONS table contains location information associated with individual assets. ASSET_LOCATIONS is replaced in its entirety during nightly updates.
Displaying the location currently associated with a building, fixed, movable or land asset, as of the most recent update to the Data Warehouse.
||Indexed Data Elements
- 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.
Questions about this page? Email us at email@example.com
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania