data-dictionary
data-dictionary
Breadcrumbs

FPSADMIN.WIP_PRTY_CTM_GROUPS

Data Dictionary

>

FPSADMIN Tables

> FPSADMIN.WIP_PRTY_CTM_GROUPS

Table FPSADMIN.WIP_PRTY_CTM_GROUPS"

The possible set of priority cycle time groups that can be assigned to different prty_ctm_groups. Separate table needed for normalization of prty_ctm_factor.

  • Schema: FPSADMIN

  • Tablespace: FPSDATA

  • Primary key: PRTY_CTM_GROUP


Column

Type

Nullable

Comment

PRTY_CTM_GROUP

VARCHAR2(7)

N

This is one of the primary keys of our CTM tables. We use this group rather than the priority because we often have several different priorities which are close and are expected to have the same cycle time. (* from FPSINPUT.WIP_PRIORITIES)

MAX_HOLD_SEC_FOR_WSF

NUMBER(8)

Prevent huge cycle times at steps where a minority of lots have been on hold for an exceedingly long time

MAX_STEP_SEC_NOHOLD_FOR_WSF

NUMBER(8)

Prevent huge cycle times at steps where a minority of lots have been waiting for an exceedingly long time

PRTY_CTM_FACTOR

NUMBER(3,2)

N

Factor to multiply cycle time for this priority group compared to other groups if not known. For example, if this factor is 1.5 and we know the CTM is 6 hours for another priority group whose factor is 1.0 then we would estimate it to be 9 hours for this group.

UPDATED_INST

DATE

Time when the record was updated according to the source data. Note this is not the time when the record was actually updated in this table - it will almost always be earlier. (* from FPSINPUT.GEN_FACILITIES)