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

ASSET_CHANGE_HISTORY Table

Explanation
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.

Common Uses
Displaying all historical changes to select elements for an asset.

ASSET_ID
LAST_UPDATE_DATE

ASSET_ID
ASSET_NUMBER
ASSET_RESPONSIBLE_CTR
ASSET_RESPONSIBLE_ORG
LAST_UPDATE_DATE

ASSETS

Cautions

• 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.

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