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

ASSETS Table

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

Common Uses
Displaying detailed information about a building, fixed, movable or land asset, as of the most recent update to the Data Warehouse.

ASSET_ID

ASSET_ID
ASSET_NUMBER
ASSET_RESPONSIBLE_CTR
ASSET_RESPONSIBLE_ORG
ASSET_TYPE
CUSTODIAN_NAME
CUSTODIAN_PENN_ID
DATE_PLACED_IN_SERVICE
EXTRACT_DATE
FISCAL_MONTH_PLACED_IN_SERVICE
FY_PLACED_IN_SERVICE
LEASE_ID
LEGACY_ASSET_NUMBER
PARENT_ASSET_ID
RETIRED_FLAG
TAGGABLE_STATUS
TAGGING_CONTACT_NAME
TAGGING_CONTACT_PENN_ID

ASSET_ADJUSTMENTS
ASSET_CATEGORIES
ASSET_CHANGE_HISTORY
ASSET_INVOICES
ASSET_LOCATIONS
ASSET_LOCATIONS_HISTORY
ASSET_RETIREMENTS
LEASES

Cautions

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

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