The ASSETS table contains basic and summary information about individual assets, such as: asset number, description, responsible ORG, location, custodian, tagging contact, category, acquisition cost, etc. ASSETS is replaced in its entirety during nightly updates.
Displaying detailed information about 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 - the ASSETS table does not keep history about assets. The ASSET_CHANGE_HISTORY table is available to view day-to-day changes in select fields for asset records. Historical monthly snapshots of asset information are available in the ASSETS_SNAP table.
- The ASSETS table contains records for retired assets; to determine whether an asset has been retired, check the RETIRED_FLAG.
- The ASSETS 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