data-dictionary
data-dictionary
Breadcrumbs

FPSAPP.CTM_FINISHED_PERIODS

Data Dictionary

>

FPSAPP Tables

> FPSAPP.CTM_FINISHED_PERIODS

Table FPSAPP.CTM_FINISHED_PERIODS"

See comments in CTM_REF_FINISHED_PERIODS view.

  • Schema: FPSAPP

  • Tablespace: FPSDATA

  • Primary key: FINISHED_PERIOD

  • Foreign keys: CTM_FIN_PERIODS_FK_P_TYPE: PERIOD_TYPE REFERENCES FPSADMIN.CTM_PERIOD_TYPES (PERIOD_TYPE)


Column

Type

Nullable

Comment

FINISHED_PERIOD

VARCHAR2(7)

N

END_PERIOD

DATE

PERIOD_TYPE

VARCHAR2(12)

PLAN_YEAR

VARCHAR2(6)

N

Name of plan 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_plan_year rather than plan_year in case we want to change the naming convention for the plan_year. (* from FPSINPUT.CAL_PLAN_YEARS)

SORT_ORDER

NUMBER(4)

This is used to sort within the grouping. SORT_ORDER always has a deferrable unique key to ensure uniqueness while allowing the user to make changes without erroring until the commit is attempted. Because of this you must be careful to not violate the unique key otherwise you will lose all of your edits. (* from FPSINPUT.GEN_FACILITIES)