Data Dictionary
>
FPSAPP Tables
> FPSAPP.MNT_TECH_SCHED_ASSIGNMENTS
Table FPSAPP.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: FPSAPP
-
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) |