FPSBASE.ETP_L5_TRANSITION_STATES

TRANSITION_STATE

VARCHAR2(48)

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)

IS_ALARM

CHAR(1)

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_CSCNOWIP

CHAR(1)

IS_CSCWWIP

CHAR(1)

IS_ELIGIBLE_NON_SBY

CHAR(1)

IS_QUAL

CHAR(1)

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)

IS_SBYPOST

CHAR(1)

IS_SBYSETUP

CHAR(1)

IS_SBYWWIP

CHAR(1)

IS_SCHED_QUAL

CHAR(1)

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)

LONG_DESCRIPTION

VARCHAR2(1000)

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_FOR_E10

VARCHAR2(12)

N

SORT_WITHIN_OPP

NUMBER(3)

N

Unique sort order within the ETP_group. This is not particularly critical but the idea is that 1 is worse (i.e. closer to NST) and the highest number is best (i.e. closer to PRD). (* from FPSINPUT.EQP_L5_TRANSITION_STATES)

SORT_WITHIN_OPP_FOR_E10

NUMBER(2)

N