data-dictionary
data-dictionary
Breadcrumbs

FPSINPUT.CAL_WORK_QUARTERS

Data Dictionary

>

FPSINPUT Tables

> FPSINPUT.CAL_WORK_QUARTERS

Table FPSINPUT.CAL_WORK_QUARTERS"

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

  • Schema: FPSINPUT

  • Tablespace: FPSDATA

  • Foreign keys: CAL_WORK_QUARTERS_FK_YEAR: START_WORK_YEAR REFERENCES FPSINPUT.CAL_WORK_YEARS (START_WORK_YEAR)

  • Referenced by: FPSINPUT.CAL_WORK_MONTHS (START_WORK_QUARTER)


Column

Type

Nullable

Comment

START_WORK_QUARTER

DATE

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.

END_WORK_QUARTER

DATE

N

It is critical that this field equal the start_work_quarter of the next work quarter.

START_WORK_YEAR

DATE

N

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. (* from FPSINPUT.CAL_WORK_YEARS)

WORK_QUARTER

VARCHAR2(6)

N

Name of work quarter 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_quarter rather than work_quarter in case we want to change the naming convention for the work_quarter.