data-dictionary
data-dictionary
Breadcrumbs

FPSAPP.WIP_ECT_STATES

Data Dictionary

>

FPSAPP Tables

> FPSAPP.WIP_ECT_STATES

Table FPSAPP.WIP_ECT_STATES"

List of FPS universal ECT states used to build ECT_STATE_DIAGRAM. This table is rarely directed used since nearly all uses will point to ECT_STATE_DIAGRAM.

  • Schema: FPSAPP

  • 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.

DASH_PROC_STATE_IF_NOT_RESRV

VARCHAR2(5)

N

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.

DASH_PROC_STATE_IF_RESRV

VARCHAR2(5)

N

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.

ECTA_ECTFL_PROC_STATE

VARCHAR2(5)

N

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.

ECT_STATE_DETAILS

VARCHAR2(1000)

ECT_STATE_DISPLAY

VARCHAR2(48)

IS_OBSOLETE

CHAR(1)

OVR_BG_COLOR

VARCHAR2(24)

This column defines the color used in the reports for displaying WIP qtys by ECT state. Since hold groups are an ECT state this color will be the color used in the Dashboard reports for the associated hold group. (* from FPSINPUT.WIP_HOLD_GROUPS)

SCH_PROC_STATE_IF_NOT_RESRV

VARCHAR2(5)

N

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.