Data Dictionary
>
FPSBASE Tables
> FPSBASE.MNT_TECH_SCHED_ASSIGNMENTS
Table FPSBASE.MNT_TECH_SCHED_ASSIGNMENTS"
This table links together all schedules that a technicians works on including both their regular/default schedule defined in FPSINPUT.MNT_TECHNICIANS and any other ad-hoc or overtime schedules.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: MNT_TECH_USERNAME, SCHEDULE_ID
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
MNT_TECH_USERNAME |
VARCHAR2(64) |
N |
The unique identifier of a technician that also needs to exist in GEN_USERS. (* from FPSINPUT.MNT_TECHNICIANS) |