Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSAPP.DASH_P_ETP_STATE_DIAGRAM
This view provides the state information for the dashboard based on Enhanced Tool Performance (ETP)
|
Column |
Comment |
|---|---|
|
ETP_STATE |
If entity is down then use eqp_state directly. If entity is up then determine etp_state from proc_state and sby_state. (* inherited from FPSBASE.ETP_STATUS) |
|
ETP_STATE_DISPLAY |
|
|
OVERALL_SORT_ORDER |
|
|
ETP_STATE_LONG_DESC |
|
|
ETP_STATE_TECHNICAL_DETAILS |
|
|
IS_ENHANCED_STATE |
|
|
IS_ACTIVE |
Flag to enable or disable the tag condition. (* inherited from FPSBASE.MSO_TAG_CONDITIONS) |
|
ETP_STATE_OWNER |
|
|
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 |
|
|
ETP_STATE_BG_COLOR |
|
|
IS_NST_HIDDEN_IF_OTHERS |