FPSBASE.EQP_APD_TOOL_E10_SHIFT_HIST

>

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSBASE.EQP_APD_TOOL_E10_SHIFT_HIST

This table is used for the E10 Equipment metrics and for Equipment Dashboard spotlights including the Tool pages. Includes: - the 6 basic E10 states (PRD, SBY, ENG, SDT, UDT, NST) [ Unit: seconds ] - combined states (MFG, EQP UP, EQP DOWN, OPER, TOTAL) [ Unit: seconds ] - UDT without waits/delays and SDT without waits/delays [ Unit: seconds ] - number of times UDT episode begins (e.g. for MTBF) - number of times SDT episode begins (e.g. for MTTS/MTTPM) - number of times continuous downtime begins (e.g. for MTOL) - _p subset of the group that specifically occurred during production - _e subset of the group that is Equipment related - mUxx metrics denote Unit metrics - mTxx metrics denote Time metrics - e10_x_entity denotes seconds logged to all entities for the tool. -- e10_x_entity is necessary for the Equipment Maintainability (8.4) metrics specifically. You might wonder if we really need both EQP and ETP versions considering that the only difference between EQP and ETP is the PRD and SBY time. The short answer is that we need both. The long answer for a specific example follows: Let's take a look at what metrics use the two columns e10_prd and e10_sby: - Mean time between failures during productive time (mtbf_p) - Mean Productive Time between Equipment-related Failures (e_mtbf_p) - Total Utilization (utu) - Operational Utilization (uou) Additionally there is a slight difference in some of the classifications of down episodes. The main differences is looking at the e10_state before the episode. The difference between PRD and SBY in the e10_state_before affects the the following episode classifications: - n_udt_p_episodes - n_e_udt_p_episodes - n_udt_p_episodes_entities - n_sdt_p_episodes, n_sdt_p_episodes_entities - n_cdt_episodes_entities And could change the values in the following metrics: - Mean time between failures during productive time (mtbf_p) - Mean failure duration during producive time. (mfd_p) - Mean Productive Time between Equipment-related Failures (e_mtbf_p) - Mean time off line (mtol) The quality of both the Eqp State Diagram and automated PRD/SBY logging at the site will determine how close the EQP metrics are to the ETP metrics. IMPORTANT NOTE: The major difference between all of the ExP_APD_y_E10_z_HIST views are: entity vs. tool, ETP vs. EQP, and shift-based vs. plan-based Entity vs. tool has important logical differences, but, ETP vs. EQP and shift-based vs. plan-based are nearly identical. When making changes, just edit one of the two then it is safe to find/replace EQP and ETP for the first three sections only with three exceptions. EQP_UNITS_plan_day_HIST and ETP_MNT_EPISODE_HIST are table names in both views plus column is_eqp_related_event is in both. Fortunately those will error if you find/replace so it is actually fine to find/replace everything in these first three sections and then fix errors on these two tables and one column. Everything below that starting with episode_sums is identical in both views and should be copied directly. All EQP/ETP must stay.