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