Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.CAL_WORK_DAYS
Table FPSADMIN.CAL_WORK_DAYS"
All known work days including past, present, and future.
-
Schema: FPSADMIN
-
Tablespace: FPSDATA
-
Primary key: START_WORK_DAY
-
Foreign keys: CAL_WORK_DAYS_FK_WEEK: START_WEEK REFERENCES FPSINPUT.CAL_WORK_WEEKS (START_WEEK)
-
Referenced by: FPSINPUT.CAL_SHIFTS (START_WORK_DAY)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
START_WORK_DAY |
DATE |
N |
Work days must be 24 hours in length and the start of the work day must be the start of one of the shifts. Contrast this to plan day which is independent of shift. |
|
CALENDAR_DAY |
DATE |
N |
When we choose this day on a website calendar we will associate with work_days of this day. Typically this is the day of the start_day but not always. For example, start_day might be 17:00 and represent the following calendar_day. |
|
DAY_OF_WEEK |
VARCHAR2(3) |
N |
This should be Mon, Tue, etc. |
|
END_WORK_DAY |
DATE |
N |
It is critical that this field equal the start_work_day of the next work day. |
|
START_WEEK |
DATE |
N |
Work weeks must be 7 days in duration and the start of the work week must be the start of one of the work days. (* from FPSINPUT.CAL_WORK_WEEKS) |