FPSBASE.ETP_STATE_DIAGRAM

ETP_STATE

VARCHAR2(48)

N

If entity is down then use eqp_state directly. If entity is up then determine etp_state from proc_state and sby_state. (* from FPSBASE.ETP_STATUS)

AVAILABILITY

VARCHAR2(4)

N

AVAILABILITY_BG_COLOR

VARCHAR2(24)

N

AVAILABILITY_DISPLAY

VARCHAR2(48)

N

AVAILABILITY_LONG_DESC

VARCHAR2(1000)

AVAILABILITY_SORT_ORDER

NUMBER(3)

N

E10_STATE

VARCHAR2(3)

N

E10_STATE_BG_COLOR

VARCHAR2(24)

N

E10_STATE_DISPLAY

VARCHAR2(48)

N

E10_STATE_LONG_DESC

VARCHAR2(1000)

E10_STATE_SORT_ORDER

NUMBER(3)

N

EST_CH_SORT

NUMBER(2)

ETP_STATE_BG_COLOR

VARCHAR2(24)

ETP_STATE_DISPLAY

VARCHAR2(48)

N

ETP_STATE_LONG_DESC

VARCHAR2(1000)

ETP_STATE_OWNER

VARCHAR2(48)

ETP_STATE_SHORT_DISPLAY

VARCHAR2(12)

N

ETP_STATE_SOURCE_TABLE

VARCHAR2(30)

ETP_STATE_TECHNICAL_DETAILS

VARCHAR2(1000)

IGNORE_PROC_LONGER

CHAR(1)

N

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

INCLUDE_IN_DASH_DOWN

CHAR(1)

This column will hide tools from the Down tools section of the Equipment Dashboard if set to N for this opportunity state (* from FPSADMIN.ETP_L4_OPPORTUNITY_STATES)

IS_ACTIVE

CHAR(1)

Flag to enable or disable the tag condition. (* from FPSBASE.MSO_TAG_CONDITIONS)

IS_ALARM

CHAR(1)

N

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

IS_ALLOWED_MNT_FUT_ANY

CHAR(1)

N

IS_ALLOWED_MNT_FUT_ONLY_ACTUAL

CHAR(1)

N

IS_CSCNOWIP

CHAR(1)

N

IS_CSCWWIP

CHAR(1)

N

IS_ELIGIBLE_NON_SBY

CHAR(1)

N

IS_ENHANCED_STATE

CHAR(1)

N

IS_EQP_RELATED

CHAR(1)

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

IS_HIST_ONLY

CHAR(1)

IS_NST_HIDDEN_ON_HIST

CHAR(1)

N

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

IS_PM

CHAR(1)

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

IS_QUAL

CHAR(1)

N

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

IS_SBYNOWIP

CHAR(1)

N

IS_SBYPOST

CHAR(1)

N

IS_SBYSETUP

CHAR(1)

N

IS_SBYWWIP

CHAR(1)

N

IS_SCHED_QUAL

CHAR(1)

N

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

IS_SDT_SETUP

CHAR(1)

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

LOT_GROUP_TO_SCHED_LIST

VARCHAR2(64)

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

MFG_GROUP

VARCHAR2(6)

N

MNT_GROUP

VARCHAR2(36)

Grouping field for upcoming maintenance on Dashboard and Mnt Viewer. This can be any value and should be formatted for display. (* from FPSINPUT.EQP_L5_TRANSITION_STATES)

OBJECT_NAME_WHERE_SET

VARCHAR2(30)

OPERATIONAL_STATE

VARCHAR2(9)

N

OPERATIONAL_STATE_BG_COLOR

VARCHAR2(24)

N

OPERATIONAL_STATE_DISPLAY

VARCHAR2(48)

N

OPERATIONAL_STATE_LONG_DESC

VARCHAR2(1000)

OPERATIONAL_STATE_SORT_ORDER

NUMBER(2)

N

OPPORTUNITY_STATE

VARCHAR2(12)

N

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

OPPORTUNITY_STATE_BG_COLOR

VARCHAR2(24)

N

OPPORTUNITY_STATE_DISPLAY

VARCHAR2(48)

N

OPPORTUNITY_STATE_LONG_DESC

VARCHAR2(1000)

OPPORTUNITY_STATE_SORT_ORDER

NUMBER(3)

N

OVERALL_SORT_ORDER

NUMBER(3)

N

RELEVANT_COLUMN_NAME

VARCHAR2(30)

SBY_PRECEDENCE

NUMBER(3)

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. (* from FPSADMIN.ETP_L6_ADDL_SBY_STATES)

TRANSITION_STATE

VARCHAR2(48)

N

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

TRANSITION_STATE_DISPLAY

VARCHAR2(48)

N

TRANSITION_STATE_LONG_DESC

VARCHAR2(1000)

TRANSITION_STATE_SORT_ORDER

NUMBER(3)

N