FPSAPP.SCH_P_CURR_TOOL_TYPES

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)

SCHED_GROUP

This is the grouping of tools and processes which the FPS Scheduler schedules together. Since this is a parent of tool via tool->process_group and a parent of process via process->process_group, by definition each tool and each process can only be in one sched group. We need all related tools and processes to be in the same sched group for efficient scheduling. One example is sinks and furnaces because of queue times and batching. Another example is for smaller facilities like Assembly or Test where we might schedule the entire facility together. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

TOOL_TYPE

the tool type from the first lot that scheduled (* inherited from FPSAPP.SCH_W_SCHED_DURABLE_INSPECT)

DEFAULT_PROCESS_CHG_SEC

Used for Scheduler. Default process change seconds. (* inherited from FPSINPUT.EQP_TYPES)

DEFAULT_PROCESS_CHG_COST

Used for Scheduler. Default process change cost. (* inherited from FPSINPUT.EQP_TYPES)

DEFAULT_SETUP_CHG_SEC

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

DEFAULT_SETUP_CHG_COST

Default setup change cost. See comments on USE_SETUP_CHG_AUTO_FOR_SCH for details on when this is used. (* inherited from FPSINPUT.EQP_TYPES)

DEFAULT_RECIPE_CHG_SEC

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

DEFAULT_RECIPE_CHG_COST

Default recipe change cost. See comments on USE_SETUP_CHG_AUTO_FOR_SCH for details on when this is used. (* inherited from FPSINPUT.EQP_TYPES)

DEFAULT_DURABLE_CHG_SEC

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

DEFAULT_DURABLE_CHG_COST

Default durable change cost. See comments on USE_SETUP_CHG_AUTO_FOR_SCH for details on when this is used. (* inherited from FPSINPUT.EQP_TYPES)

MAX_TRANSIT_SEC_TO_DISP

MAX_BATCH_DISP_INT_SEC

DEFAULT_FIRST_UNIT_SEC

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

DEFAULT_UNIT_INT_SEC

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

DEFAULT_BATCH_INT_SEC

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

DEFAULT_WAFERS_PER_DISC

DEFAULT_LOAD_SEC

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

DEFAULT_UNLOAD_SEC

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

DEFAULT_BACKLOAD_SEC

Use for the Scheduler to determine the time the next batch/lot can start without missing the cascade (* inherited from FPSAPP.SCH_W_H_S_TOOL_TYPES)

DEFAULT_MIN_DISP_SEC

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

DEFAULT_MAX_THP_PCT

BATCH_MATCH_QTY_THRESHOLD

HOURS_TO_LOAD_WSH

IS_CASCADING_IMPOSSIBLE

There are some chamber tools where we know cascading is not possible but running in parallel can confuse the THP logic so this flag addresses that. (* inherited from FPSINPUT.EQP_TYPES)

DISPATCH_CAPACITY

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

DISPATCH_NUM_STEPS_AWAY

used to determine how many steps away for the coming lots to become eligible to dispatch (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

DISPATCH_SEC

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

SHOW_GANTT_CHART_CAST_PORT

SHOW_GANTT_CHART_CHAMBER

ENABLE_CAST_PORT_TO_SCHED

ENABLE_POD_PORT_TO_SCHED

IS_DISP_INST_AFT_SETUP

MIN_SEC_TO_FILL_SCHED

SHOULD_UNRESERVE_DIFF_SETUP

PRE_SCHED_ORDER_NUM_JOBS

PRE_SCHED_ORDER_STEPS_AWAY

Defines how many steps away will be assigned this prev-sched-order score (* inherited from FPSINPUT.EQP_TYPES)

PRE_SCHED_ORDER_HOURS

Defines how many hours the lot scheduled will be assigned this prev-sched-order score (* inherited from FPSINPUT.EQP_TYPES)

PRE_SCHED_ORDER_ON_DOWN_TOOL

Defines if it should assign the prev-sched-order score to the lots scheduled on the down tools. by default, it will be N, meaning it will not give any pre-sched-order score to the lots scheduled on the down tools (* inherited from FPSINPUT.EQP_TYPES)

PATTERN_INVALID_COST

PATTERN_INVALID_SEC

PREFER_START_IN_HOURS

BATCH_BUFFER_IN_MINS

MAX_WAIT_SEC_FOR_TIMER

The Scheduler will not consider a tool eligible for scheduling timer lots if the WAIT_SEC_TO_SCHED is greater than this value in seconds. (* inherited from FPSAPP.SCH_W_H_S_TOOL_TYPES)

TIMER_EXPIRE_PREFER_TOOL_HRS

When selecting the best tool at a timer end step, the scheduler will prefer a tool that beats the timer expiration by at least this many hours over tools that have later start times. This takes precedence over the tool scores. (* inherited from FPSAPP.SCH_W_H_S_TOOL_TYPES)

RESCHED_MIN_CAP_SCORE_PCT

how much better on the tool score to determine if it should break the current reservation to reschedule to another tool. (* inherited from FPSAPP.SCH_W_H_S_TOOL_TYPES)

RESCHED_MIN_CAP_SEC

How much better on sched-start-time on the lot to determine if it should break the current reservation to reschedule to another tool (* inherited from FPSINPUT.RTG_SCHED_GROUPS)

RESERVE_SEC

RESERVE_STEPS

RESERVE_STEPS_LOT

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

RESERVE_SEC_LOT

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

RESERVE_STEPS_PRTY_LOT

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

RESERVE_SEC_PRTY_LOT

This column is part of the Area Scheduler configuration. Please see Area Scheduler documentation for details. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

RESERVE_SEC_BUFFER

Defines the buffer on un-reserving lots by time. Lots with start times outside the reservation window plus this buffer will be unreserved by the queue manager (* inherited from FPSAPP.SCH_W_H_S_TOOL_TYPES)

RESERVE_LOT_BUFFER

ENABLE_BATCH_SAME_NUM_STEP

PROC_TIME_LOOK_AHEAD_PCT

For batching logic in the Scheduler, the percentage of the processing time that we will wait for future lots to arrive to make a full batch. For example, high priorities might have 0 for this column meaning we will never wait for future lots. Standard priority default is 100 meaning if the batch processing time is 2 hours that we would wait for up to 2 hours for future lots to arrive. Low priority might be 200 meaning we will wait up to 4 hours. Of course Scheduler might choose to process an incomplete batch sooner based on other logic but this is upper bound. (* inherited from FPSINPUT.WIP_PRIORITIES)

MAX_SEC_TO_KEEP_POD

used to determine how long will keep the pod on the tool before to switch another pod. by default, it should be 0 which means it allows to switch the pod without any restriction. (* inherited from FPSINPUT.RTG_PROCESS_GROUPS)

POD_SWITCH_WINDOW

To indicate how far to look ahead and behind when determining the severity of a pod switch. by default, it should be 0 which means it will not check for processJobs within some time window (* inherited from FPSAPP.SCH_W_H_S_TOOL_TYPES)

SCHED_WEIGHTS_IN_RSV_WINDOW

RESERVE_ONLY_AFTER_SCHED

ALLOW_RESRV_ON_PREV_DISPATCH

to allow to reserve the lot to the tool when the previous step is dispatched (* inherited from FPSINPUT.EQP_TYPES)

TOOL_IDLE_SCORE_SEC

To get a score for the Tool Idle Time rule, the lot must be scheduled to begin processing within this time window from the start of the scheduler run (* inherited from FPSAPP.SCH_W_H_S_TOOL_TYPES)

TOOL_IDLE_SCORE_JOBS

To get a score for the Tool Idle Time rule, the lot must be one of the first jobs (ordered by start time) scheduled to the tool. (* inherited from FPSAPP.SCH_W_H_S_TOOL_TYPES)

BREAK_CASCADE_PROC_CHANGE

SCH_CHG_CAL_METHOD_COST

This is used for the scheduler, to determine how to calculate the cost for process/setup/recipe when there are multiple changes. The default value will be SUM, this means, if there are more than 2 setups that require changes, it will add up total cost (* inherited from FPSINPUT.EQP_TYPES)

SCH_CHG_CAL_METHOD_SEC

This is used for the scheduler, to determine how to calculate the time for process/setup/recipe when there are multiple changes. The default value will be MAX, this means, if there are more than 2 setups that require changes, it will take longer time for the entier changes (* inherited from FPSINPUT.EQP_TYPES)

SCH_ADD_SEC_SCHED_END

This is used for the scheduler, to add seconds to the sched_end time if lot is still in PROC (* inherited from FPSINPUT.EQP_TYPES)