Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSBASE.ETP_REF_STATE_DIAGRAM
This view summarizes all levels of ETP state information into one refreshed table. It combines enhanced states for PRD/SBY from ETP_L6_STATES with nonmfg states from EQP_L6_DETAILED STATES. We almost always use ETP_STATE_DIAGRAM rather than the individual ETP_Lx_xxx tables. If this refresh fails due to a violation of ETP_STATUS_FK_ETP_STATE then some states changed from NONMFG to MFG and you need to execute this script to fix this: alter trigger fpsbase.etp_status_after disable; update fpsbase.etp_status set etp_state = 'SBY-NONE' where etp_state in (select ETP_STATE from FPSBASE.ETP_STATE_DIAGRAM minus select ETP_STATE from FPSBASE.ETP_REF_STATE_DIAGRAM); alter trigger fpsbase.etp_status_after enable; If this refresh fails due to a constraint violation of either ETP_ST_DIAG_PRECEDENCE_TRANS or ETP_ST_DIAG_U_SBY_PRECEDENCE or ETP_ST_DIAG_U_OVERALL_SORT, this is because we have a duplicate value for sort_within_transition. This column comes from rank_sort if the etp_state is from a rank or from sby_precedence if it is an additional standby state. We cannot enforce a unique constraint across multiple tables so we enforce it in this table. The solution is to modify the values according so that this query has no duplicates: select 'AUTO' as s, rank, rank_display, rank_sort, sby_transition_state, use_in_sched, proc_state_if_wait from rtg_auto_ranks union all select 'PERM', rank, rank_display, rank_sort, sby_transition_state, use_in_sched, proc_state_if_wait from rtg_perm_ranks union all select 'SBY', sby_or_csc_state_suffix, sby_or_csc_display_suffix, sby_precedence, sby_transition_state, null, null from etp_l6_addl_sby_states a order by rank_sort;
|
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_SOURCE_TABLE |
|
|
ETP_STATE_DISPLAY |
|
|
ETP_STATE_SHORT_DISPLAY |
|
|
ETP_STATE_BG_COLOR |
|
|
IS_ENHANCED_STATE |
|
|
IS_ACTIVE |
Flag to enable or disable the tag condition. (* inherited from FPSBASE.MSO_TAG_CONDITIONS) |
|
IS_HIST_ONLY |
|
|
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) |
|
OBJECT_NAME_WHERE_SET |
|
|
RELEVANT_COLUMN_NAME |
|
|
SBY_PRECEDENCE |
This column fits these ranks in with RANK_SORT for the other standby states to give the overall standby precedence. This value has be unique including not matching any in RTG_RANKS. (* inherited from FPSADMIN.ETP_L6_ADDL_SBY_STATES) |
|
OVERALL_SORT_ORDER |
|
|
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 |
|
|
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) |
|
IS_SDT_SETUP |
Boolean column indicating if the eqp_state is Scheduled Down due to setup conversion. We will note this in ETP_MNT_EPISODE_HIST to differentiate from regular PMs. (* inherited from FPSINPUT.EQP_L5_TRANSITION_STATES) |
|
IS_EQP_RELATED |
This should be set to Y for UDT or SDT states where the equipment is solely responsible for the entity being down and is actively being diagnosed or repaired. (Does not include Wait-times or alarms, can include Quals). Should only be Set to Y for Downtime (UDT or SDT) states (* inherited from FPSINPUT.EQP_L5_TRANSITION_STATES) |
|
IS_PM |
This should be set to Y if the state should count as a Preventative Maintenance, PM, event. This should only be Y on Scheduled (SDT) States. This is used in the Mean time to (perform) PM, MTTPM metric. (Does not include Wait-times. Can include Qualifications or Verification tests) (* 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) |
|
IS_SCHED_QUAL |
This should be set to Y if the state should count as a scheduled qual event. (This is typically a qual run by the equipment operator rather than by the maintenance group.) (* inherited from FPSINPUT.EQP_L5_TRANSITION_STATES) |
|
IS_ALARM |
This should be set to Y if the state should count as an alarm event. (This is typically a downtime event automatically triggered by the equipment.) (* inherited from FPSINPUT.EQP_L5_TRANSITION_STATES) |
|
IS_QUAL |
This should be set to Y if the state should count as a qual event and time spent in this state should count as qual time. The EQP_L5_QUAL_CHECK constraint ensures that this must be set to Y when mnt_group is QUAL. The is_qual column is critical for NMV_P_TOOL_QUAL_SUMMARY and this constraint is not perfect but it prevents the most obvious wrong case. (* inherited from FPSINPUT.EQP_L5_TRANSITION_STATES) |
|
IGNORE_PROC_LONGER |
This flag tells ETP that we should never set state to Missed Cascade when processing a lot of this lot group because the throughput estimates are unreliable. This must always be N for production lot groups. (* inherited from FPSINPUT.WIP_LOT_GROUPS) |
|
IS_ELIGIBLE_NON_SBY |
|
|
IS_SBYSETUP |
|
|
IS_SBYPOST |
|
|
IS_SBYWWIP |
|
|
IS_SBYNOWIP |
|
|
IS_CSCWWIP |
|
|
IS_CSCNOWIP |
|
|
TRANSITION_STATE_SORT_ORDER |
|
|
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 |
|
|
EST_CH_SORT |
|
|
IS_ALLOWED_MNT_FUT_ANY |
|
|
IS_ALLOWED_MNT_FUT_ONLY_ACTUAL |
|
|
OPPORTUNITY_STATE_BG_COLOR |
|
|
INCLUDE_IN_DASH_DOWN |
This column will hide tools from the Down tools section of the Equipment Dashboard if set to N for this opportunity state (* inherited from FPSADMIN.ETP_L4_OPPORTUNITY_STATES) |
|
OPPORTUNITY_STATE_SORT_ORDER |
|
|
E10_STATE |
|
|
E10_STATE_DISPLAY |
|
|
MFG_GROUP |
|
|
UTILIZATION |
|
|
E10_STATE_BG_COLOR |
|
|
E10_STATE_SORT_ORDER |
|
|
AVAILABILITY |
|
|
AVAILABILITY_DISPLAY |
|
|
AVAILABILITY_BG_COLOR |
|
|
AVAILABILITY_SORT_ORDER |
|
|
OPERATIONAL_STATE |
|
|
OPERATIONAL_STATE_DISPLAY |
|
|
OPERATIONAL_STATE_BG_COLOR |
|
|
OPERATIONAL_STATE_SORT_ORDER |
|
|
ETP_STATE_LONG_DESC |
|
|
TRANSITION_STATE_LONG_DESC |
|
|
OPPORTUNITY_STATE_LONG_DESC |
|
|
E10_STATE_LONG_DESC |
|
|
AVAILABILITY_LONG_DESC |
|
|
OPERATIONAL_STATE_LONG_DESC |
|
|
ETP_STATE_TECHNICAL_DETAILS |