Data Dictionary
>
FPSAPP Tables
> FPSAPP.CAL_WORK_YEARS
Table FPSAPP.CAL_WORK_YEARS"
All known work years including past, present, and future.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Referenced by: FPSINPUT.CAL_WORK_QUARTERS (START_WORK_YEAR)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
START_WORK_YEAR |
DATE |
This is the work year not the calendar year. Start of the work year must be the start of a work quarter and each work quarter must be within a single work year. |
|
|
END_WORK_YEAR |
DATE |
N |
It is critical that this field equal the start_work_year of the next work year. |
|
WORK_YEAR |
VARCHAR2(6) |
N |
Name of work 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_work_year rather than work_year in case we want to change the naming convention for the work_year. |