data-dictionary
data-dictionary
Breadcrumbs

FPSAPP.WIP_HOLD_GROUPS

Data Dictionary

>

FPSAPP Tables

> FPSAPP.WIP_HOLD_GROUPS

Table FPSAPP.WIP_HOLD_GROUPS"

List of all possible hold groups. Having hold type and group allows for two categories of grouping.

  • Schema: FPSAPP

  • Tablespace: FPSDATA

  • Primary key: HOLD_GROUP

  • Foreign keys: WIP_HOLD_GROUPS_BG_COLOR_FK: OVR_BG_COLOR REFERENCES FPSADMIN.GEN_COLORS (COLOR)

  • Referenced by: FPSINPUT.WIP_HOLD_TYPES (HOLD_GROUP)


Column

Type

Nullable

Comment

HOLD_GROUP

VARCHAR2(36)

N

Grouping of hold_type for reporting purposes.

COUNT_AS_LONG_HOLD_FOR_CTM

CHAR(1)

When this flag is set to Y, time on hold in this hold_group is bucketed into the Long Hold process state to be grouped separately from the normal Hold time on CTA and FLCT.

DESCRIPTION

VARCHAR2(256)

Tool desciption. This value is only used to display in the Dashboard. (* from FPSINPUT.EQP_TOOLS)

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.