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

ASSET_ADJUSTMENTS Table

Explanation
The ASSET_ADJUSTMENTS table contains records of transactions related to assets. A history of additions, retirements, and other transactions that affect the asset financially are recorded here.

Common Uses
Reviewing financial transactions affecting an asset.

ASSET_ADJ_PK

ADJUSTMENT_COA_CNAC
ADJUSTMENT_COA_CREF
ADJUSTMENT_COA_FUND
ADJUSTMENT_COA_OBJECT
ADJUSTMENT_COA_ORG
ADJUSTMENT_COA_PROGRAM
ADJUSTMENT_RESPONSIBLE_ORG
ADJUSTMENT_TYPE
ASSET_ADJ_PK
ASSET_ID
ASSET_NUMBER
EXTRACT_DATE
PERIOD_ADJUSTED
PERIOD_CREATED
SOURCE_TYPE_CODE

ASSETS
CENTER_REF_CODES
CNAC_CODES
FUND_CODES
OBJECT_CODES
ORG_CODES
PROGRAM_CODES

Cautions

• The ASSET_ADJUSTMENTS table is stored in the DWGL schema in the Data Warehouse.

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