Data Dictionary
>
FPSBASE Tables
> FPSBASE.MNT_TECH_SCHEDULES
Table FPSBASE.MNT_TECH_SCHEDULES"
The possible schedules that a technician could work.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: SCHEDULE_ID
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
SCHEDULE_ID |
VARCHAR2(64) |
N |
A unique identifier for a schedule. Possibly a shift and a date. |
|
END_AVAIL |
DATE |
Time stamp when the schedule_id ended. |
|
|
SCHEDULE_DISPLAY |
NVARCHAR2(1024) |
A user friendly display for the schedule. |
|
|
SCHED_BURDEN_RATE |
NUMBER(12,2) |
Priority of the schedule, E.g. normal shifts = 1, Over-time work that costs more =2. Therefore, Overtime has twice the burden as normal time. |