Data Dictionary
>
FPSBASE Tables
> FPSBASE.CAL_PLAN_YEARS
Table FPSBASE.CAL_PLAN_YEARS"
All known plan years including past, present, and future.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Referenced by: FPSINPUT.CAL_PLAN_QUARTERS (START_PLAN_YEAR)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
START_PLAN_YEAR |
DATE |
This is the plan year not the calendar year. Start of the plan year must be the start of a plan quarter and each plan quarter must be within a single plan year. |
|
|
END_PLAN_YEAR |
DATE |
N |
It is critical that this field equal the start_plan_year of the next plan year. |
|
PLAN_YEAR |
VARCHAR2(6) |
N |
Name of plan year must be unique and can be in any format as long as it is display friendly since this is what we show everywhere. We prefer that other tables should reference start_plan_year rather than plan_year in case we want to change the naming convention for the plan_year. |