Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.DASH_C_MNT_TIME_DROPDOWN
Table FPSINPUT.DASH_C_MNT_TIME_DROPDOWN"
Options for time dropdown.
-
Schema: FPSINPUT
-
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) |