Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.CAL_WORK_WEEKS
Table FPSINPUT.CAL_WORK_WEEKS"
All known work weeks including past, present, and future.
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: START_WEEK
-
Foreign keys: CAL_WORK_WEEKS_FK_MONTH: START_WORK_MONTH REFERENCES FPSINPUT.CAL_WORK_MONTHS (START_WORK_MONTH)
-
Referenced by: FPSAPP.CTA_P_BASE_WK (START_WEEK) FPSAPP.ECTA_P_BASE_WK (START_WEEK) FPSBASE.CTM_WEEK_HIST (START_WEEK) FPSBASE.ECT_MOVES_WEEK_HIST (START_WEEK) FPSBASE.ECT_STATE_WEEK_HIST (START_WEEK) FPSBASE.EQP_ENTITY_E10_WEEK_HIST (START_WEEK) FPSBASE.EQP_ENTITY_WEEK_HIST (START_WEEK) FPSBASE.EQP_SETUP_CHG_TOOL_WEEK_HIST (START_WEEK) FPSBASE.EQP_SETUP_CHG_WEEK_HIST (START_WEEK) FPSBASE.EQP_TOOL_E10_WEEK_HIST (START_WEEK) FPSBASE.EQP_TOOL_WEEK_HIST (START_WEEK) FPSBASE.ETP_ENTITY_E10_WEEK_HIST (START_WEEK) FPSBASE.ETP_ENTITY_WEEK_HIST (START_WEEK) FPSBASE.ETP_TOOL_E10_WEEK_HIST (START_WEEK) FPSBASE.ETP_TOOL_WEEK_HIST (START_WEEK) FPSBASE.THP_EQPTYPE_WEEK_HIST (START_WEEK) FPSBASE.THP_TOOL_WEEK_HIST (START_WEEK) FPSINPUT.CAL_WORK_DAYS (START_WEEK)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
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. |
|
END_WEEK |
DATE |
N |
It is critical that this field equal the start_week of the next work work. |
|
START_WORK_MONTH |
DATE |
N |
This is the work month not the calendar month. Start of the work month must be the start of a work week and each work week must be within a single work month. (* from FPSINPUT.CAL_WORK_MONTHS) |
|
WORK_WEEK |
VARCHAR2(7) |
N |
Name of work week must be unique and can be in any format as long as it is display friendly since this is what we show everywhere. |