Penn Computing

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

ASSET_LOCATIONS Table - Data Element Index

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



Data element Definition
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.
EXTRACT_DATE

Indexed - yes
Format - date
May be null? no
The date the record was extracted from BEN Assets, the Oracle Fixed Assets system, and loaded into the Data Warehouse.
LOCATION_BUILDING

Indexed - yes
Format - varchar2(30)
May be null? yes
The building associated with the location. Building codes originate in the FacilityCenter system.

 

LOCATION_COMBINATION

Indexed - no
Format - varchar2(50)
May be null? yes
The building-floor-room code combination of the location.
LOCATION_ENABLED

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the location may be used in BEN Assets transactions.
LOCATION_FLOOR

Indexed - no
Format - varchar2(30)
May be null? yes
The floor associated with the location. Floor codes originate in the FacilityCenter system. If there is no floor associated with the location, a value of 'N/A' will appear in this field.

 

LOCATION_ID

Indexed - yes
Format - number(15)
May be null? no
The unique system identifier for the location of the asset unit(s).
LOCATION_ROOM

Indexed - no
Format - varchar2(30)
May be null? yes
The room associated with the location. Room codes originate in the FacilityCenter system. If there is no room associated with the location, a value of 'N/A' will appear in this field.

 

UNITS_ASSIGNED

Indexed - no
Format - number
May be null? yes
The number of units currently associated with the asset for the location.

ASSET_LOCATIONS 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