Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSAPP.DASH_P_STATE_DIAGRAM
This view for the maintenance spotlights to get the availability and utilization percentages
|
Column |
Comment |
|---|---|
|
EQP_STATE |
Client equipment state taken directly from their MES or from their existing tool state model. For EQP_MNT_FUTURE, this is the state that we estimate the entity will be in during the maintenance which is often set to a generic PM state if we do not have detailed information. (* inherited from FPSINPUT.EQP_L6_DETAILED_STATES) |
|
EQP_STATE_DISPLAY |
Display name for the equipment state which will be displayed on all Dashboards and reports. (* inherited from FPSINPUT.EQP_L6_DETAILED_STATES) |
|
OVERALL_SORT_ORDER |
|
|
EQP_STATE_LONG_DESC |
|
|
EQP_STATE_TECHNICAL_DETAILS |
|
|
IS_ENHANCED_STATE |
|
|
IS_ACTIVE |
Flag to enable or disable the tag condition. (* inherited from FPSBASE.MSO_TAG_CONDITIONS) |
|
EQP_STATE_OWNER |
Person or department who owns each state. This is for reference and reporting only and can be left blank (* inherited from FPSINPUT.EQP_L6_DETAILED_STATES) |
|
LOT_GROUP_TO_SCHED_LIST |
By default we will schedule all lots when a tool is in a state where mfg_state is MFG (PRD and SBY but not ENG). For NONMFG states use this column to schedule lots of certain lot_groups, most likely test wafers. (* inherited from FPSINPUT.EQP_L6_DETAILED_STATES) |
|
TRANSITION_STATE |
We name this transition_state because ideally this state would be determine what states are allowed to follow but really this is just a grouping which is the parent of eqp_state and child of etp_group (* inherited from FPSINPUT.EQP_L5_TRANSITION_STATES) |
|
TRANSITION_STATE_DISPLAY |
|
|
TRANSITION_STATE_LONG_DESC |
|
|
TRANSITION_STATE_SORT_ORDER |
|
|
IS_NST_HIDDEN_ON_HIST |
If yes then do not include time in this NST state in the history. Most NST states should be Y unless there is a specific reason why the client wants it to be part of the total. An example calculation here is if a tool is PRD for 1 day, SBY for 1 day, SDT for 1 day, UDT for 1 day, and NST for 3 days then the totals for the week are 25% each for PRD, SBY, UDT, SBY because the NST is ignored. (* inherited from FPSINPUT.EQP_L5_TRANSITION_STATES) |
|
MNT_GROUP |
Grouping field for upcoming maintenance on Dashboard and Mnt Viewer. This can be any value and should be formatted for display. (* inherited from FPSINPUT.EQP_L5_TRANSITION_STATES) |
|
MFG_GROUP |
|
|
EST_CH_SORT |
|
|
IS_ALLOWED_MNT_FUT_ANY |
|
|
IS_ALLOWED_MNT_FUT_ONLY_ACTUAL |
|
|
OPPORTUNITY_STATE |
FPS Enhanced Tool Performance group assigned to each transition_state and to each etp_family. This assignment determines the default grouping on all Tool Performance charts and determines the color on all views including Dashboard and Gantt charts. (* inherited from FPSINPUT.EQP_L5_TRANSITION_STATES) |
|
OPPORTUNITY_STATE_DISPLAY |
|
|
OPPORTUNITY_STATE_LONG_DESC |
|
|
OPPORTUNITY_STATE_SORT_ORDER |
|
|
OPPORTUNITY_STATE_BG_COLOR |
|
|
OPPORTUNITY_STATE_TEXT_COLOR |
|
|
E10_STATE |
|
|
E10_STATE_DISPLAY |
|
|
E10_STATE_LONG_DESC |
|
|
E10_STATE_SORT_ORDER |
|
|
E10_STATE_BG_COLOR |
|
|
E10_STATE_TEXT_COLOR |
|
|
UTILIZATION |
|
|
AVAILABILITY |
|
|
AVAILABILITY_DISPLAY |
|
|
AVAILABILITY_LONG_DESC |
|
|
AVAILABILITY_SORT_ORDER |
|
|
AVAILABILITY_BG_COLOR |
|
|
AVAILABILITY_TEXT_COLOR |
|
|
OPERATIONAL_STATE |
|
|
OPERATIONAL_STATE_DISPLAY |
|
|
OPERATIONAL_STATE_LONG_DESC |
|
|
OPERATIONAL_STATE_SORT_ORDER |
|
|
OPERATIONAL_STATE_BG_COLOR |
|
|
OPERATIONAL_STATE_TEXT_COLOR |
|
|
L6_STATE_BG_COLOR |
|
|
IS_NST_HIDDEN_IF_OTHERS |