The ASSET_CHANGE_HISTORY table contains a record of all changes to select asset data elements: Asset Responsible ORG, Asset Responsible Center, Research Amount, Acquisition Cost, and Accumulated Depreciation. ASSET_CHANGE_HISTORY records can be created nightly, dependent upon any changes in the column values compared to those in ASSETS the previous day.
Displaying all historical changes to select elements for an asset.
||Indexed Data Elements
- ASSET_CHANGE_HISTORY contains day-to-day changes only for Asset Responsible ORG, Asset Responsible Center, Research Amount, Acquisition Cost, and Accumulated Depreciation. To track changes in other elements, refer to ASSETS_SNAP, which captures asset records as of the end of each BEN Assets period. For most current information available about an asset, refer to the ASSETS table.
- There may be multiple rows for a given asset, as this table stores a snapshot of the asset record as it appeared at the time of the extract to the Warehouse. Note that the table stores only the latest value of asset attributes -- 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 record in the day. To sort all rows in chronological order, be sure to use a date format that includes time specification.
- The ASSET_CHANGE_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