Data Dictionary
>
FPSBASE Tables
> FPSBASE.CAL_PLAN_WEEKS
Table FPSBASE.CAL_PLAN_WEEKS"
All known plan weeks including past, present, and future.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Referenced by: FPSAPP.PERF_P_H_COMP_WIP_WEEK (START_PLAN_WEEK) FPSBASE.CTM_SUMMARY_WEEK_HIST (START_PLAN_WEEK) FPSBASE.ECT_SUMMARY_WEEK_HIST (START_PLAN_WEEK) FPSBASE.EQP_ENTITY_E10_PW_HIST (START_PLAN_WEEK) FPSBASE.EQP_TOOL_E10_PW_HIST (START_PLAN_WEEK) FPSBASE.ETP_ENTITY_E10_PW_HIST (START_PLAN_WEEK) FPSBASE.ETP_TOOL_E10_PW_HIST (START_PLAN_WEEK)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
START_PLAN_WEEK |
DATE |
Plan weeks must be 7 days in duration and the start of the plan week must be the start of one of the plan days. |
|
|
CORRESPONDING_START_WORK_WEEK |
DATE |
N |
This is the start of the work week which most closely corresponds with this plan week. We prefer that plan and work calendars are identical so this would be equal to start_plan_week but if they are off we need to be able to match them as close as possible using this field. |
|
END_PLAN_WEEK |
DATE |
N |
It is critical that this field equal the start_plan_week of the next plan week. |
|
PLAN_WEEK |
VARCHAR2(7) |
N |
Name of plan week must be unique and can be in any format as long as it is display friendly since this is what we show everywhere. |