Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.ECT_STATE_DIAGRAM
Table FPSINPUT.ECT_STATE_DIAGRAM"
See comments in ECT_REF_STATE_DIAGRAM view.
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: ECT_STATE
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
ECT_STATE |
VARCHAR2(42) |
N |
ECT state is the lowest level state of our Enhanced Cycle Time hierarchy and the value which is stored in WIP_LOTS_REALTIME and ECT_HIST. We can lookup all information about the ECT state including process state in ECT_STATE_DIAGRAM. (* from FPSADMIN.WIP_ECT_STATES) |
|
DASH_PROC_STATE_IF_NOT_RESRV |
VARCHAR2(5) |
This is the process state assigned to this ECT state on the Dashboard if the lot is not reserved. This value should never be modified. (* from FPSADMIN.WIP_ECT_STATES) |
|
|
DASH_PROC_STATE_IF_RESRV |
VARCHAR2(5) |
This is the process state assigned to reserved lots on the Dashboard. Opinions on what to show here are widely variable so this is clearly the most commonly configurable of the five proc_state columns in this table. Scheduler will nearly always show RESRV while CTA+FLCT will always show WAIT1/WAIT2/WAIT3/DOWN/BLOCK/INHIB. The default is RESRV but it will be common to modify this to match dash_proc_state_if_not_resrv. (* from FPSADMIN.WIP_ECT_STATES) |
|
|
ECTA_ECTFL_PROC_STATE |
VARCHAR2(5) |
This is the process state assigned to this ECT state on the CTA and FLCT. Since the Reserved process state is not used in CTA and FLCT (we always count the time when the lot is reserved in the appropriate WAIT1/WAIT2/WAIT3/DOWN/BLOCK/INHIB process state) then this should rarely be modified and should nearly always be the same as dash_proc_state_if_not_resrv except when using older versions of CTA which do not understand the newer states INHIB and STUCK. (* from FPSADMIN.WIP_ECT_STATES) |
|
|
ECT_STATE_BG_COLOR |
VARCHAR2(24) |
N |
|
|
ECT_STATE_DETAILS |
VARCHAR2(1000) |
||
|
ECT_STATE_DISPLAY |
VARCHAR2(48) |
||
|
ECT_STATE_SORT_ORDER |
NUMBER(4) |
||
|
IS_OBSOLETE |
CHAR(1) |
||
|
IS_VIRTUAL |
CHAR(1) |
N |
|
|
PROC_STATE_DISPLAY_FOR_DIAG |
VARCHAR2(24) |
N |
|
|
PROC_STATE_EVENT_ONLY_FOR_DIAG |
VARCHAR2(5) |
||
|
SCH_PROC_STATE_IF_NOT_RESRV |
VARCHAR2(5) |
This is the process state assigned to this ECT state on the Scheduler if the lot is not reserved. Since the various WAIT states like WAIT1/WAIT2/WAIT3/DOWN/BLOCK/INHIB are already handled by the Scheduler logic, we typically assign WAIT as this value for all of these states. This value should never be modified. (* from FPSADMIN.WIP_ECT_STATES) |
|
|
SCH_PROC_STATE_IF_RESRV |
VARCHAR2(5) |
||
|
USE_IN_CTA |
CHAR(1) |
N |