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