data-dictionary
data-dictionary
Breadcrumbs

FPSINPUT.CAL_WORK_MONTHS

Data Dictionary

>

FPSINPUT Tables

> FPSINPUT.CAL_WORK_MONTHS

Table FPSINPUT.CAL_WORK_MONTHS"

All known work months including past, present, and future.

  • Schema: FPSINPUT

  • 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.