Penn Computing

University of Pennsylvania
Penn Computing << go backback
ASSET_CHANGE_HISTORY Table   Tables and Data Elements   Assets Home    Data Warehouse Home

ASSET_CHANGE_HISTORY Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
ACCUMULATED_DEPRECIATION

Indexed - no
Format - number
May be null? yes
The depreciation amount for the asset as of end of last month-end.

ACQUISITION_COST

Indexed - no
Format - number
May be null? no

The total acquisition cost of the asset, for items acquired through the accounts payable process.
ASSET_ID

Indexed - yes
Format - number(15)
May be null? no
The unique system identifier for an asset.
ASSET_NUMBER

Indexed - yes
Format - varchar2(15)
May be null? no
The unique identifier for an asset.
ASSET_RESPONSIBLE_CTR

Indexed - yes
Format - char(2)
May be null? yes
The center to which the organization responsible for managing the asset belongs.
ASSET_RESPONSIBLE_ORG

Indexed - yes
Format - char(4)
May be null? yes
The organization responsible for managing the asset. Note that the Asset_Responsible_Org is distinct and possibly different from the Responsible_Org associated with the fund used to purchase the asset.
LAST_UPDATED_BY_USER

Indexed - no
Format - varchar2(100)
May be null? yes
The BEN Financials login identification (ID) for the person or batch job that last updated the asset record.
LAST_UPDATE_DATE

Indexed - yes
Format - date
May be null? no
The date on which the asset was last updated in BEN Assets.
RESEARCH_AMOUNT

Indexed - no
Format - number
May be null? yes
For assets funded by sponsored programs, the total amount of the asset cost funded by grants. Contributions for all research funds are summed and stored in this amount.

ASSET_CHANGE_HISTORY Table   Tables and Data Elements   Assets Home    Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania