data-dictionary
data-dictionary
Breadcrumbs

FPSAPP.CAL_PLAN_QUARTERS

Data Dictionary

>

FPSAPP Tables

> FPSAPP.CAL_PLAN_QUARTERS

Table FPSAPP.CAL_PLAN_QUARTERS"

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

  • Schema: FPSAPP

  • Tablespace: FPSDATA

  • Foreign keys: CAL_PLAN_QUARTER_FK_YEAR: START_PLAN_YEAR REFERENCES FPSINPUT.CAL_PLAN_YEARS (START_PLAN_YEAR)

  • Referenced by: FPSINPUT.CAL_PLAN_MONTHS (START_PLAN_QUARTER)


Column

Type

Nullable

Comment

START_PLAN_QUARTER

DATE

This is the plan quarter not the calendar quarter. Start of the plan quarter must be the start of a plan month and each plan month must be within a single plan quarter.

END_PLAN_QUARTER

DATE

N

It is critical that this field equal the start_plan_quarter of the next plan quarter.

PLAN_QUARTER

VARCHAR2(6)

N

Name of plan 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_plan_quarter rather than plan_quarter in case we want to change the naming convention for the plan_quarter.

PLAN_QUARTER_DISPLAY

VARCHAR2(13)

N

Particularly at sites which use a fiscal year starting in July we might want to show a longer quarter in certain places that includes the fiscal quarter and calendar quarter for clarity.