FPSADMIN.DASH_P_WIP_PRIORITIES

PRIORITY

This is the priority value as it is stored in the MES for each lot. It might be a number or a letter or word depending on the MES and the facility. (* inherited from FPSINPUT.WIP_PRIORITIES)

PRIORITY_DISPLAY

The name of the priority displayed on all dashboards and reports. Typically priority is short like P1, P2 so we allow a longer more descriptive name here that should be more familiar to the users. (* inherited from FPSINPUT.WIP_PRIORITIES)

PRIORITY_SORT

Unique sort of priority. Sort ascending gives the order from highest to lowest priority. Therefore the smallest number in priority_sort is the highest priority. (* inherited from FPSINPUT.WIP_PRIORITIES)

DESCRIPTION

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

IS_PLAN_PRIORITY

Flag indicates whether this priority is a plan_priority which is the permanent priority for the lot. If this is N that indicates this is a temporary priority such as queue time warning or SPC jeopardy. (* inherited from FPSINPUT.WIP_PRIORITIES)

IS_HIGHLIGHTED_PRTY

This flag indicates if this priority should be highlighted on the dashboard. When we sort all priorities by priority_sort all Y should be first followed by all N. (* inherited from FPSINPUT.WIP_PRIORITIES)

PRTY_CTM_GROUP

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. (* inherited from FPSINPUT.WIP_PRIORITIES)

CTM_FACTOR

Factor to multiply cycle time for this lot 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 lot group whose factor is 1.0 then we would estimate it to be 9 hours for this lot group. (* inherited from FPSINPUT.WIP_LOT_GROUPS)

IS_COUNT_PRIORITY_PCT

This flag determines which priorities to include in our overall percentage of priority lots in the Dashboard spotlight. This is similar to is_highlighted_prty but it is possible that we might want to highlight a priority but not include it in the percentage. (* inherited from FPSINPUT.WIP_PRIORITIES)

BG_COLOR

Background color assigned. BG_COLOR is in English like red or blue or light green and we look up the HTML color like #FF0000 in the GEN_COLORS table. BG_COLOR must be set manually but the FPSADMIN view BLD_POPULATE_COLORS will generate queries to randomly set bg_color for all values in a table. (* inherited from FPSINPUT.GEN_CUSTOMERS)

HTML_BG_COLOR

HTML_TEXT_COLOR

PRTY_TRANSPORT_MODE

Priority level transport mode. If no other mode is specified, this will be the value used to direct wip with a specific priority. (* inherited from FPSINPUT.WIP_PRIORITIES)