Data Dictionary
>
FPSAPP Tables
> FPSAPP.CAL_WORK_MONTHS
Table FPSAPP.CAL_WORK_MONTHS"
All known work months including past, present, and future.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Foreign keys: CAL_WORK_MONTHS_FK_QUARTER: START_WORK_QUARTER REFERENCES FPSINPUT.CAL_WORK_QUARTERS (START_WORK_QUARTER)
-
Referenced by: FPSINPUT.CAL_WORK_WEEKS (START_WORK_MONTH)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
START_WORK_MONTH |
DATE |
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. |
|
|
END_WORK_MONTH |
DATE |
N |
It is critical that this field equal the start_work_month of the next work month. |
|
START_WORK_QUARTER |
DATE |
N |
This is the work quarter not the calendar quarter. Start of the work quarter must be the start of a work month and each work month must be within a single work quarter. (* from FPSINPUT.CAL_WORK_QUARTERS) |
|
WORK_MONTH |
VARCHAR2(9) |
N |
Name of work month 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_month rather than work_month in case we want to change the naming convention for the work_month. |