FPSADMIN.SCH_G_CFG_SCHED_GROUPS

SCHED_GROUP

VARCHAR2(36)

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

BATCH_SIZE_WEIGHTS_AT_OPER

NUMBER(7,2)

the batch score weight applied to the percent of lots that are at the batching operation (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

BATCH_SIZE_WEIGHTS_COMING

NUMBER(7,2)

the batch weights for the lots will arrive after the process starting (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

BATCH_SIZE_WEIGHTS_CURRENT

NUMBER(7,2)

the batch weights for the current batched lots (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

BATCH_SIZE_WEIGHTS_FULL

NUMBER(7,2)

the batch score bonus points for scheduling a full batch - either max size or all lots in scheduler window (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

BATCH_SIZE_WEIGHTS_FUTURE

NUMBER(7,2)

the batch weights for the lots will arrive before process starting (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

DISPATCH_RULES

VARCHAR2(36)

used to define the order of dispatching: 0. timer lots, the timer lot at least needs to be nearby and in-danger 1. lot on tool; durable on tool 2. lot on tool; durable near tool (on tool or stocker) 3. lot near tool; durable on tool 4. lot near tool; durable near tool 5. lot on tool; 6. lot near tool; 7. sched-rank-1 lot, currently at the operation; 8. enable dispatch based on lot priority; for example, (1):(3):(2):(4) -> will dispatch 1 first and followed by 3 and then 2 and then 4; for example, (1):(2|3):(4) -> will dispatch 1 first and followed by (2 or 3) and then 4; (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

ENABLE_SCHED_ONLY_LOT_AT_OP

CHAR(1)

EXPIRED_QUEUE_TIMER_WEIGHT

NUMBER(7,2)

how much weight to give lots with expired timers for example: A weight of 0 -> expired timers will all get the same score of 20. for example: A weight of 1 -> expired timers will get an additional point for every hour they are late (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

FEEDBACK_EMAIL

VARCHAR2(512)

HOURS_TO_DISPLAY

NUMBER

WILL REMOVE SOON (* from FPSINPUT.RTG_SCHED_GROUPS)

HOURS_TO_SCHEDULE

NUMBER

This column is used to determine how many hours to look ahead and schedule the lots that might come into this area/SCHED-GROUP even it is still several steps away. (* from FPSINPUT.RTG_SCHED_GROUPS)

HOURS_TO_SCHEDULE_FIRST_STEP

NUMBER

to set the max hours to sched for the first step of each lot (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

HOURS_TO_SCHEDULE_MIN_BATCH

NUMBER(2)

HOURS_TO_SCHEDULE_TOOL_EVENT

NUMBER

to indicate how far in the future to include a tool_event. Any event that starts within current time + this value will be considered (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

LOGIN_RQD_FOR_PREVIOUS_RUNS

CHAR(1)

MIN_EST_SMP_PCT_TO_SCHED

NUMBER(7,2)

NUM_LOTS_TO_SCHEDULE_PER_LOOP

NUMBER

NUM_TOP_TOOL_ASGNS_TO_EVL

NUMBER(3)

to indicate the number of top tool assignments will be evaluated in the scheduler on the SCHED-GROUP. Default to 999, it means it will most likely to evaluate on every tool assignment (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

RQD_PCT_TO_UPDATE_WSFS

NUMBER(2)

When less than this percentage of lot steps are evaluated/placed before timeout, the scheduler will not update WIP_STEP_FUTURE_SCHED data for the run. Note that this is not the percent of scheduled lots - only the percent evaluated. If this parameter is set to 70 and in a run all lot/steps are evaluated by 31 percent cannot be scheduled (due to tool assignment or other), then the scheduler will still update WIP_STEP_FUTURE_SCHED. This flag is primarily to prevent SLOW scheduler runs from clearing WIP_STEP_FUTURE_SCHED. (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

RSV_WEIGHTS_ON_NEXT_RQD_STEP

NUMBER(7,2)

to assign the points to the next required step if the current step is reserved/dispatched (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

SCORING_TIME_BASE

VARCHAR2(16)

the scoring time base is used to allow scheduler to calculate the time related points based on HOUR or DAY (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

SHOULD_SCHEDULE_FUTURE_STARTS

CHAR(1)

When set to N, the scheduler will not include future WIP from WIP_STARTS in the scheduler. (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

SHOULD_UPDATE_WSFS

CHAR(1)

When this value is set to N, the scheduler will not write lot schedule results back to WIP_STEP_FUTURE_SCHED. Results will only be written to the snapshot tables (e.g. SCH_W_H_S_LOTS). This can be useful during an initial deployment of a new scheduler where you do not want the results from a scheduler to impact step enter times for other schedules (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

SHOW_CARRIER_ID

VARCHAR2(50)

to set the visibility of a carrier id within a lot block in the Gantt chart. SHOW: Show the carrier id. HIDE: Hide the carrier id. SHOW_IF_DIFFERENT: Only show the carrier if it is different from the lot id (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

STEPS_TO_SCHEDULE

NUMBER

This column is used to determine how many steps to look ahead and schedule the lots that might come into this area/SCHED-GROUP even it is still several hours away. Between HOURS_TO_SCHEDULE and STEPS_TO_SCHEDULE, the Scheduler will try to schedule all the lots either will arrive within X hours OR within Y steps away. (* from FPSINPUT.RTG_SCHED_GROUPS)

STEP_ENTER_LOGISTIC_MIDPOINT

NUMBER(3,1)

The midpoint of the S-curve function for step enter time. After this many hours, the raw sore will equal 5 for the function. (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

STEP_ENTER_LOGISTIC_SLOPE

NUMBER(3,1)

The steepness of the S-curve function for step enter time. Larger numbers mean steeper curves - i.e. closer to a step function change. (* from FPSAPP.SCH_C_GROUP_LOT_PRIORITIES)

TIMER_HURRY_IN_HOURS

NUMBER(5,1)

is used to determine when x hours left on the timer, the scheduler should start to prioritize the lot (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

TIMER_HURRY_IN_PCT

NUMBER(3)

is used to determine when x % left on the timer, the scheduler should start to prioritize the lot (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

TIMER_TIME_SCHED_PCT

NUMBER(3)

is used to determine how conservative the timer should be in schedulder (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

USE_MPCT_STATE

CHAR(1)

USE_NEXT_STEP_LOC_ON_LINK_STEP

CHAR(1)

to indicate if it needs to use the location from the next step as primary location for the current step, for the link step (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

USE_NEXT_STEP_LOC_ON_TIMER

CHAR(1)

to indicate if it needs to use the location from the next step as primary location for the current step, for the timer lot (* from FPSAPP.SCH_C_CFG_SCHED_GROUPS)

WEIGHT_FOR_FIRST_DISP_INST

NUMBER(4)

WEIGHT_FOR_KIT_TIME_POINTS

NUMBER(4)

WEIGHT_FOR_NUM_DURABLES_KITTED

NUMBER(4)

WEIGHT_FOR_POD_SELECTION

NUMBER(4)