Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.MHS_VEHICLES_TRACKING
Table FPSINPUT.MHS_VEHICLES_TRACKING"
List of all vehicles in the material handling system - including carts in a non-automated MHS. The location of a vehicle should be determined based on the location of the carrier(s) that it is transporting. For carts, this is typically the location of the last carrier that was picked up. Also tracks the user that is currently using the cart
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: VEHICLE
-
Foreign keys: MHS_VEHICLES_LIST_FK: VEHICLE REFERENCES FPSINPUT.MHS_VEHICLES (VEHICLE)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
VEHICLE |
VARCHAR2(24) |
N |
Field that uniquely identifies a vehicle. |
|
DELIVERIES_PER_MIN |
NUMBER(5,2) |
The interpolated delivery rate per minute. A delivery will count only after the dropoff |
|
|
DELIVERIES_THIS_SESSION |
NUMBER(5) |
Total deliveries for the user session |
|
|
IS_LAST_LOC_UNLOAD |
CHAR(1) |
Y means the last activity for the vehicle was a load. N means it was an unload. |
|
|
LAST_LOCATION |
VARCHAR2(32) |
Last location of vehicle is set by trigger based on the previous location of the carrier most recently loaded from/to the vehicle. |
|
|
LAST_LOCATION_INST |
DATE |
Time when the vehicle last loaded or unloaded a carrier. |
|
|
LAST_LOGIN_INST |
DATE |
Last cart login time |
|
|
LAST_LOGOUT_INST |
DATE |
Last cart logout time |
|
|
UPDATED_INST |
DATE |
Time when the record was updated according to the source data. Note this is not the time when the record was actually updated in this table - it will almost always be earlier. (* from FPSINPUT.GEN_FACILITIES) |