FPSINPUT.SCH_W_H_S_QUEUE_STEPS

CREATE_INST

DATE

EARLIER_START

DATE

FACILITY

VARCHAR2(6)

N

Facility is included in almost every join in the DWH so this represents a definitive split. A route must have all steps on tools in the same facility. A tool must process all lots in the same facility. If your site has multiple buildings where lots run on routes using tools in multiple buildings then everything should be one facility. For example, multiple Fab buildings. But if your site has independent facilities like Fab and Test and Assembly where lot may progress from one to the next but on different routes then these should be different facilities. Since this column is in virtually every table it is critical that the value here is exactly matches what is in the MES if the MES has facility. Use facility_display for the display friendly name displayed in applications. See site_name comment for client/site/facility example. (* from FPSINPUT.GEN_FACILITIES)

LATE_START

DATE

LOT

VARCHAR2(32)

A lot is a group of units that process together. Usually lot_id or lot_number in MES. All units in a lot are in the same carrier but there may be multiple lots in a carrier. (* from FPSINPUT.WIP_LOTS_STATIC)

NUM_STEPS_AWAY_END

NUMBER(4)

NUM_STEPS_AWAY_START

NUMBER(4)

PROCESS_END

VARCHAR2(50)

the process for the timer end step (* from FPSAPP.SCH_W_H_S_QUEUE_TIMERS)

PROCESS_GROUP_END

VARCHAR2(36)

the process group for the timer end step (* from FPSAPP.SCH_W_H_S_QUEUE_TIMERS)

PROCESS_GROUP_START

VARCHAR2(36)

the process group for the timer start step (* from FPSAPP.SCH_W_H_S_QUEUE_TIMERS)

PROCESS_START

VARCHAR2(50)

the process for the timer start step (* from FPSAPP.SCH_W_H_S_QUEUE_TIMERS)

QUEUE_EXPIRED_SEC

NUMBER

QUEUE_TCT_SEC

NUMBER

The total process time (TCT_SEC) between the step and the end step, but not include the step that is est_smp_pct < 50

QUEUE_WAIT_SEC

NUMBER

ROUTE

VARCHAR2(256)

N

Route that has threading requirements (* from FPSINPUT.RTG_STEP_THREADING)

RUN_ID

VARCHAR2(50)

N

the run id from the last successful scheduler (* from FPSAPP.SCH_W_SCHED_GROUP_STATUS)

SCHED_END_END

DATE

SCHED_END_START

DATE

SCHED_GROUP_END

VARCHAR2(36)

SCHED_GROUP_START

VARCHAR2(36)

SCHED_START_END

DATE

SCHED_START_START

DATE

SEQ_NUM_END

NUMBER(7,2)

SEQ_NUM_START

NUMBER(7,2)

SHOULD_USE

CHAR(1)

This flag determines if the scheduler should use this data or not

STEP_END

VARCHAR2(256)

STEP_START

VARCHAR2(256)

TIMER_ID

NUMBER

Unique number representing the queue timer to index with other tables. Automatically populated with RTG_QUEUE_TIMERS_ID_SEQ sequence. (* from FPSINPUT.RTG_QUEUE_TIMERS)