FPSINPUT.GP_P_PRIORITY_LINE_BALANCE

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)

ROUTE

VARCHAR2(256)

N

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

STEP

VARCHAR2(256)

N

A single processing step within a route representing a single tool visit. Step is often a very complex string and should rarely be displayed. Instead we should use process_display. (* from FPSINPUT.RTG_ROUTE_STEPS)

COMMON_STEP

VARCHAR2(50)

N

A display-friendly field that groups similar steps together for purposes of viewing the entire line. Typically the only duplicates within a single route will be optional ordered steps in the same segment. But we will often have steps across routes that share the same common step even though exact step definition is not identical. (* from FPSINPUT.RTG_COMMON_STEPS)

CURR_WIP_QTY_COMSTEP

NUMBER

CURR_WIP_QTY_COMSTEP_RT_FAM

NUMBER

CURR_WIP_QTY_COMSTEP_RT_GRP

NUMBER

CURR_WIP_QTY_FINAL

NUMBER

CURR_WIP_QTY_OPERATION

NUMBER

CURR_WIP_QTY_OPER_RT_FAM

NUMBER

CURR_WIP_QTY_OPER_RT_GRP

NUMBER

CURR_WIP_QTY_PHOTO_LAYER

NUMBER

CURR_WIP_QTY_PHOTO_RT_FAM

NUMBER

CURR_WIP_QTY_PHOTO_RT_GRP

NUMBER

CURR_WIP_QTY_PROCESS

NUMBER

CURR_WIP_QTY_PROCESS_RT_FAM

NUMBER

CURR_WIP_QTY_PROCESS_RT_GRP

NUMBER

CURR_WIP_QTY_PROCFAM

NUMBER

CURR_WIP_QTY_PROCFAM_RT_FAM

NUMBER

CURR_WIP_QTY_PROCFAM_RT_GRP

NUMBER

CURR_WIP_QTY_ROUTE_SEG

NUMBER

CURR_WIP_QTY_ROUTE_SEG_RT_FAM

NUMBER

CURR_WIP_QTY_ROUTE_SEG_RT_GRP

NUMBER

CURR_WIP_QTY_RT_STEP

NUMBER

GP_SUBFAMILY

VARCHAR2(58)

GP_subfamily is used for Goal Planner and is an extension of process_family which can additionally include lot_group and an additional suffix. We populate GP_subfamily automatically based on process_family, process_subfamily, gp_subfamily_suffix, and add_lotgrp_to_gp_subfamily using the function GET_GP_SUBFAMILY. We build this starting with nvl(process_subfamily, process_family) followed by gp_subfamily_suffix if populated then followed by lot_group if add_lotgrp_to_gp_subfamily is set to Y. It is possible to have one or two or three parts. You might have values for process_family/process_subfamily/gp_subfamily_suffix/add_lotgrp of Furn/blank/blank/Y and that would give you gp_subfamilies of Furn/Prod and Furn/Dev. Or Furn/HighTemp/blank/Y would give you HighTemp/Prod and HighTemp/Dev. Or Sink/blank/FeedsOxFurn/N would give you Sink/FeedsOxFurn. And so on. (* from FPSBASE.WIP_END_SHIFT_HIST)

LAST_LOOKAHEAD_COMMON_STEP

VARCHAR2(50)

LAST_LOOKAHEAD_PROCESS

VARCHAR2(50)

LAST_LOOKAHEAD_SEQ_NUM

NUMBER(7,2)

LAST_LOOKAHEAD_STEP

VARCHAR2(256)

LB_NORMALIZATION_GROUPING

VARCHAR2(32)

This determines the grouping used to calculate the normalized line balance score. If set to facility then normalization is done across the facility. If set to route section or any other value then the normalization is done within the group which means there may be multiple max or min scores that represent different effective WIP deltas across the facility. (* from FPSAPP.GP_C_FACILITY)

LB_NORMALIZATION_METHOD

VARCHAR2(24)

This determines the method used for normalization, which is either linear or logistic S-curve. Logistic creates greater seperation of scores that are closer to 0. (* from FPSAPP.GP_C_FACILITY)

LINE_BALANCE_GROUPING

VARCHAR2(48)

N

LINE_BALANCE_SCORE_COMSTEP

NUMBER

LINE_BALANCE_SCORE_COMSTEP_RF

NUMBER

LINE_BALANCE_SCORE_COMSTEP_RG

NUMBER

LINE_BALANCE_SCORE_FINAL

NUMBER

LINE_BALANCE_SCORE_LINEAR

NUMBER

LINE_BALANCE_SCORE_LOGISTIC

NUMBER

LINE_BALANCE_SCORE_OPERATION

NUMBER

LINE_BALANCE_SCORE_OPER_RF

NUMBER

LINE_BALANCE_SCORE_OPER_RG

NUMBER

LINE_BALANCE_SCORE_PHOTO

NUMBER

LINE_BALANCE_SCORE_PHOTO_RF

NUMBER

LINE_BALANCE_SCORE_PHOTO_RG

NUMBER

LINE_BALANCE_SCORE_PROCESS

NUMBER

LINE_BALANCE_SCORE_PROCESS_RF

NUMBER

LINE_BALANCE_SCORE_PROCESS_RG

NUMBER

LINE_BALANCE_SCORE_PROCFAM

NUMBER

LINE_BALANCE_SCORE_PROCFAM_RF

NUMBER

LINE_BALANCE_SCORE_PROCFAM_RG

NUMBER

LINE_BALANCE_SCORE_ROUTE_SEG

NUMBER

LINE_BALANCE_SCORE_RSEG_RF

NUMBER

LINE_BALANCE_SCORE_RSEG_RG

NUMBER

LINE_BALANCE_SCORE_RT_STEP

NUMBER

LINE_BAL_QTY_DELTA_COMSTEP

NUMBER

LINE_BAL_QTY_DELTA_COMSTEP_RF

NUMBER

LINE_BAL_QTY_DELTA_COMSTEP_RG

NUMBER

LINE_BAL_QTY_DELTA_FINAL

NUMBER

LINE_BAL_QTY_DELTA_PROCESS

NUMBER

LINE_BAL_QTY_DELTA_PROCESS_RF

NUMBER

LINE_BAL_QTY_DELTA_PROCESS_RG

NUMBER

LINE_BAL_QTY_DELTA_PROCFAM

NUMBER

LINE_BAL_QTY_DELTA_PROCFAM_RF

NUMBER

LINE_BAL_QTY_DELTA_PROCFAM_RG

NUMBER

LINE_BAL_QTY_DELTA_RT_STEP

NUMBER

MAX_LINE_BAL_QTY_DELTA_COMSTEP

NUMBER

MAX_LINE_BAL_QTY_DELTA_COMS_RF

NUMBER

MAX_LINE_BAL_QTY_DELTA_COMS_RG

NUMBER

MAX_LINE_BAL_QTY_DELTA_OPER

NUMBER

MAX_LINE_BAL_QTY_DELTA_OPER_RF

NUMBER

MAX_LINE_BAL_QTY_DELTA_OPER_RG

NUMBER

MAX_LINE_BAL_QTY_DELTA_PFAM_RF

NUMBER

MAX_LINE_BAL_QTY_DELTA_PFAM_RG

NUMBER

MAX_LINE_BAL_QTY_DELTA_PL

NUMBER

MAX_LINE_BAL_QTY_DELTA_PL_RF

NUMBER

MAX_LINE_BAL_QTY_DELTA_PL_RG

NUMBER

MAX_LINE_BAL_QTY_DELTA_PROCESS

NUMBER

MAX_LINE_BAL_QTY_DELTA_PROCFAM

NUMBER

MAX_LINE_BAL_QTY_DELTA_PROC_RF

NUMBER

MAX_LINE_BAL_QTY_DELTA_PROC_RG

NUMBER

MAX_LINE_BAL_QTY_DELTA_RSEG

NUMBER

MAX_LINE_BAL_QTY_DELTA_RSEG_RF

NUMBER

MAX_LINE_BAL_QTY_DELTA_RSEG_RG

NUMBER

MAX_LINE_BAL_QTY_DELTA_RT_STEP

NUMBER

MAX_TARGET_WIP_QTY_COMSTEP

NUMBER

MAX_TARGET_WIP_QTY_COMSTEP_RF

NUMBER

MAX_TARGET_WIP_QTY_COMSTEP_RG

NUMBER

MAX_TARGET_WIP_QTY_PROCESS

NUMBER

MAX_TARGET_WIP_QTY_PROCESS_RF

NUMBER

MAX_TARGET_WIP_QTY_PROCESS_RG

NUMBER

MAX_TARGET_WIP_QTY_PROCFAM

NUMBER

MAX_TARGET_WIP_QTY_PROCFAM_RF

NUMBER

MAX_TARGET_WIP_QTY_PROCFAM_RG

NUMBER

MAX_TARGET_WIP_QTY_RT_STEP

NUMBER

OPERATION

VARCHAR2(50)

N

Operation is usually the primary level of routing in the MES and the level where the facility typically reports moves. FPS only allows one tool per step so our step is a lower level of routing than operation although both may be the same if the MES only allows one tool per operation. Note that because operation can include multiple steps and therefore multiple process families that we cannot have any association to equipment by operation. (* from FPSINPUT.RTG_OPERATIONS)

PHOTO_LAYER

VARCHAR2(12)

The photo layer the step belongs to. (* from FPSINPUT.RTG_ROUTE_STEPS)

PROCESS

VARCHAR2(50)

N

Process defines what occurs at a step. Different steps can share the same process if they are identical. Process should normally determine allowed tools and recipe although it can be overridden by step, route, prd, lot, and experiment for exceptions. Each process is dynamically assigned to one or more eqp_type-process_family combinations with use_pct. One process_family is determined to be primary. If grouping is done correctly, a process should only be one eqp_group with no crossover. (* from FPSINPUT.RTG_PROCESSES)

PROCESS_CLASS

VARCHAR2(12)

Top-level grouping of process groups with same general purpose (i.e. Process or Metrology or Nonwafer). Allowed values are defined by FPS and are listed in FPSADMIN.RTG_PROCESS_CLASSES. This field can also be defined in EQP_TOOLS using the ovr_process_class field if we do not know it for the process group. (* from FPSINPUT.RTG_PROCESS_GROUPS)

PROCESS_FAMILY

VARCHAR2(50)

See https://help.inficonims.com/display/DW/Guide+to+Process+Families. (* from FPSINPUT.RTG_PROCESS_FAMILIES)

PROCESS_GROUP

VARCHAR2(36)

Process group is the critical field where tools and processes come together for the purposes of Scheduler. Process group is in both EQP_TOOLS for the tools and in RTG_PROCESSES for processes. Ideally all tools that run the same set of processes with no crossover including back-up and emergency tools would be in the same process group but it is important to note that this is not technically required for Scheduler as long as all process groups are in the same sched group. (* from FPSINPUT.RTG_PROCESS_GROUPS)

PROCESS_MODULE

VARCHAR2(12)

N

WIP_MODULE is used to credit moves and set goals. See comments on the module column in GEN_MODULES for info on this column and how it relates to eqp_module and mnt_module. (* from FPSBASE.RTG_ROUTE_STEPS_PLUS)

PROC_SEC

NUMBER

ROUTE_FAMILY

VARCHAR2(36)

Route_family indicates that all routes within the family have similar or even identical steps and have the same segments. At facilities where various prds share the same route it is likely that the route will be the route_family. This is sometimes referred to as the main process flow. It is used on Segment Summary and Line Viewer to group similar routes. (* from FPSINPUT.RTG_ROUTE_FAMILIES)

ROUTE_GROUP

VARCHAR2(36)

Route_group is the parent of route_family. Route_group is used on the Dashboard and other applications as a large grouping for filtering. At many sites this is referred to as technology. (* from FPSINPUT.RTG_ROUTE_GROUPS)

ROUTE_SECTION

VARCHAR2(32)

A large grouping of route steps used for line balance and should be set to contain at least a week of steps based on cycle time. Line balance uses this grouping instead of segment so that it can be configured independently from segment which is used in the Dashboard for display purposes, but they can also be set the same if desired. The section should be large in order to minimize the impact of short-term WIP distribution changes on step WIP targets because line balance calculates step WIP targets based on the WIP currently in each section. (* from FPSINPUT.RTG_ROUTE_STEPS)

ROUTE_SEGMENT

VARCHAR2(36)

Route_segment allows for clear hierarchical segment organization for Segment Summary and Line Viewer on Dashboard. This is often referred to as stage and typically will come from the MES (as opposed to facility_segment which we will typically have to define for our purposes). We recommend that all routes in the same route family have the same route segments in the same order so that the Line Viewer by route family will be consistent but if this is not the case then we approximate the order as best we can. (* from FPSINPUT.RTG_ROUTE_STEPS)

SAMPLE_RATIO

NUMBER

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)

SEQ_NUM

NUMBER(7,2)

N

Sequence number of step in route (* from FPSINPUT.RTG_ROUTE_STEPS)

TARGET_WIP_QTY_COMSTEP

NUMBER

TARGET_WIP_QTY_COMSTEP_RF

NUMBER

TARGET_WIP_QTY_COMSTEP_RG

NUMBER

TARGET_WIP_QTY_FINAL

NUMBER

TARGET_WIP_QTY_OPERATION

NUMBER

TARGET_WIP_QTY_OPERATION_RF

NUMBER

TARGET_WIP_QTY_OPERATION_RG

NUMBER

TARGET_WIP_QTY_PHOTO_LAYER

NUMBER

TARGET_WIP_QTY_PHOTO_LAYER_RF

NUMBER

TARGET_WIP_QTY_PHOTO_LAYER_RG

NUMBER

TARGET_WIP_QTY_PROCESS

NUMBER

TARGET_WIP_QTY_PROCESS_RF

NUMBER

TARGET_WIP_QTY_PROCESS_RG

NUMBER

TARGET_WIP_QTY_PROCFAM

NUMBER

TARGET_WIP_QTY_PROCFAM_RF

NUMBER

TARGET_WIP_QTY_PROCFAM_RG

NUMBER

TARGET_WIP_QTY_ROUTE_SEG

NUMBER

TARGET_WIP_QTY_ROUTE_SEG_RF

NUMBER

TARGET_WIP_QTY_ROUTE_SEG_RG

NUMBER

TARGET_WIP_QTY_RT_STEP

NUMBER