Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSBASE.RTG_QUEUE_TIMERS_PLUS
This view adds the queue timer start and end step sequence numbers, in addition to other useful route/step columns, as a plus view. The end step sequence number will be the step's sequence number on the end route if different from the start route, in which case it cannot be used in relation to the start step sequence number. If you need a query that includes all steps on the timer with one row for each step then use RTG_QUEUE_TIMERS_ALL_STEPS although that view only works for timers that start and end on the same route.
|
Column |
Comment |
|---|---|
|
TIMER_ID |
Unique number representing the queue timer to index with other tables. Automatically populated with RTG_QUEUE_TIMERS_ID_SEQ sequence. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
FACILITY |
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. (* inherited from FPSINPUT.GEN_FACILITIES) |
|
ROUTE |
Route that has threading requirements (* inherited from FPSINPUT.RTG_STEP_THREADING) |
|
START_STEP |
Start step that will impact the future thread step rank in RTG_TOOL_ASSIGNMENT_LOT (* inherited from FPSINPUT.RTG_STEP_THREADING) |
|
END_STEP |
The step upon move out where the WIP balance limit is no longer applied (* inherited from FPSINPUT.RTG_STEP_BALANCE) |
|
END_ROUTE_IF_DIFF |
Most normal queue timers start and end on the same route and for these we leave this column blank. However some timers start on a rework route and ending on the main route so this column allows us to support this. We would populate the route column with the rework route (the start step would be on this rework route) and this end_route_if_diff column with the main route (the end step would be on this main route). (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
END_STEP_ROUTE |
|
|
WARN_SEC |
Seconds from the start event until warning limit for queue time restriction. Lots that remain in the timer sequence longer than this warning limit should be prioritized to prevent them from expiring. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
EXPIRED_SEC |
Seconds from the start event until queue time restriction is expired. After expiration, the lot must rework or scrap or otherwise be evaluated. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
EXPIRED_PULL_SEC |
|
|
MIN_WAIT_SEC |
All lots must wait at least this many seconds at the step before processing. This column is the opposite of the others and can only be populated if the others are null. Also start_step and end_step must be the same since this can only apply at a single step. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
FEED_IF_LESS_THAN_SEC |
If WIP in the queue sequence as measured by total seconds of EET is below this number then we should prioritize lots entering the sequence. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
TIMER_START_EVENT |
The WIP event type which starts the queue timer at the start step. The default and preferred choice is END since most timers should start when the lot ends processing at the start step but other choices are DISPATCH, BEGIN, and COMP. These four choices are a subset of list in WIP_EVENT_TYPES. This column would be more accurately named TIMER_START_EVENT_TYPE but this is in use everywhere and changing ETL makes upgrades significantly more difficult so we are leaving this slightly confusing column name. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
TIMER_END_EVENT |
The WIP event type which ends the queue timer at the end step. Prior to Scheduler version 1.18.1, the only choice is BEGIN so all timers will end when the lot starts processing at the end step. For 1.18.1+, DISPATCH, BEGIN, END, and COMP are all available options. Please note that scheduling timers that end on COMP and END events is much more difficult, as many factors can introduce significant variability to the processing time of a lot. DISPATCH and BEGIN are the preferred event types to use here. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
RWK_IF_EXPIRED |
Indicates whether rework is required after queue timer expires. If allowed, we need to specify the route and step that we expect the lot to move into for rework. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
RWK_ROUTE |
If the queue timer is from a rework route to the main route then this is the name of the rework route and the route column is the name of the main route. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
RWK_START_STEP |
If the queue timer moves to a rework route and step from the main route then this is the start step on the rework route. The timer handling is treated the same once it enters rework, with the rework step starting the timer like the normal start step. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
OVR_IS_QUEUE_STOPPED |
This is Y if we know from the customer logic that lots cannot start the first step in the queue because their logic has determined that there is too much WIP already in the queue sequence. In the future, we will also use our own logic for this so we stop lots if this is Y or if our logic says to stop. In both cases, we can allow specific lots to go through using ovr_is_queue_allowed in WIP_LOTS_STATIC. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
WAIT_SEC_TO_SCHED |
The lot may be scheduled but must not be allowed to dispatch or start until this number of seconds has elapsed. (* inherited from FPSINPUT.WIP_LOTS_STATIC) |
|
WAIT_SEC_UPDATED_INST |
Time which may be used to adjust wait_sec_to_sched, usually based on how long a timer was been stopped. (* inherited from FPSINPUT.WIP_LOTS_STATIC) |
|
NON_TIMER_WIP_PCT |
When calculating the time required to process WIP through a queue timer segment, we normally consider both WIP on queue timers, as well as non-queue-time-limited WIP in the same area, equally in terms of their impact on the available capacity of the tools required to run the segment. If this is set to <100%, then we under-weight the impact of the non-queue-time-limited WIP accordingly. We strongly recommend keeping it at 100%, because setting it to a low value can cause scheduler to prioritize excessive queue timer WIP, and delay running non-queue-time-limited WIP. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
WIP_TIMER_PCT_SCALE |
|
|
HIDE_TIMER_IN_DASH |
This configuration will remove WIP for this timer_id from the Dashboard Queue Timer report. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
EXCLUDE_HOLD_LOTS_IN_TIMER |
This configuration will exclude any HOLD lots from queue timer consideration if set to Y. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
TIMER_DISPLAY |
This column can be displyed on the Dashboard for the lot popup and lot search pages and is a shorter display field than the queue timer. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
DESCRIPTION |
Tool desciption. This value is only used to display in the Dashboard. (* inherited from FPSINPUT.EQP_TOOLS) |
|
SCH_IGNORE_TIMER |
When set to Y, this timer will not be loaded into the scheduler for consideration. (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
SCH_IGNORE_ON_EXPIRY |
THE FLAG WHICH INDICATES TO STOP SCHEDULING UPON EXPIRATION OF THE TIMER (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
SCH_WEIGHT_PER_HOUR_ON_EXPIRY |
THE VALUE WHICH INDICATES THE POINTS PER HOUR ADDED TO THE TIMER SCORE UPON EXPIRATION OF THE TIMER (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
SCH_RESET_SCORE_ON_EXPIRY |
THE FLAG WHICH INDICATES QUEUE TIMER SCORE SHOULD BE SET TO ZERO UPON EXPIRATION OF THE TIMER (* inherited from FPSINPUT.RTG_QUEUE_TIMERS) |
|
START_STEP_SEQ_NUM |
|
|
START_STEP_SMP_PCT |
|
|
START_STEP_SCHED_GROUP |
|
|
START_STEP_PROCESS_MODULE |
|
|
START_STEP_PROCESS_GROUP |
|
|
START_STEP_PROCESS |
|
|
START_STEP_TCT_SEC |
|
|
START_STEP_TCT_SEC_TO_EOL |
|
|
START_STEP_COMMIT_STEP_SEC |
|
|
START_STEP_COMMIT_SEC_TO_EOL |
|
|
START_STEP_SEC_NOHLD_RT_WSF |
|
|
START_STEP_SEC_NH_R_WSF_TO_EOL |
|
|
START_STEP_PROC_SEC_C_F_WAVG |
|
|
END_STEP_SEQ_NUM |
|
|
END_STEP_SMP_PCT |
|
|
END_STEP_SCHED_GROUP |
|
|
END_STEP_PROCESS_MODULE |
|
|
END_STEP_PROCESS_GROUP |
|
|
END_STEP_PROCESS |
|
|
END_STEP_TCT_SEC |
|
|
END_STEP_TCT_SEC_TO_EOL |
|
|
END_STEP_COMMIT_STEP_SEC |
|
|
END_STEP_COMMIT_SEC_TO_EOL |
|
|
END_STEP_SEC_NOHLD_RT_WSF |
|
|
END_STEP_SEC_NH_R_WSF_TO_EOL |
|
|
END_STEP_PROC_SEC_C_F_WAVG |