data-dictionary

FPSADMIN.DASH_C_MNT_TIME_DROPDOWN

Data Dictionary

>

FPSADMIN Tables

> FPSADMIN.DASH_C_MNT_TIME_DROPDOWN

Table FPSADMIN.DASH_C_MNT_TIME_DROPDOWN"

Options for time dropdown.

  • Schema: FPSADMIN

  • Tablespace: FPSDATA


Column

Type

Nullable

Comment

TEXT

VARCHAR2(2000)

IS_DEFAULT

CHAR(1)

This is used to land the first sched group on the scheduler/web by default (* from FPSINPUT.RTG_SCHED_GROUPS)

IS_ENABLED

CHAR(1)

NUM_HOURS

NUMBER(5)

SORT_ORDER

NUMBER

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)

WINDOW_END_HOURS

NUMBER(5)