Data Dictionary
>
FPSAPP Tables
> FPSAPP.WIP_LOTS_COLS_W_DD_PRTN
Table FPSAPP.WIP_LOTS_COLS_W_DD_PRTN"
See comments in WIP_REF_LOTS_COLS_W_DD_PRTN view.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: LOT
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
LOT |
VARCHAR2(32) |
N |
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) |
|
CRITICAL_RATIO |
NUMBER(5,3) |
The critical ratio (days until due / days of CT left) for the lot (* from FPSAPP.SCH_W_H_S_LOTS) |
|
|
CURR_STEP_EARLIEST_COMP_INST |
DATE |
||
|
CURR_STEP_EST_COMP_INST |
DATE |
||
|
CURR_STEP_EST_COMP_REASON |
VARCHAR2(347) |
||
|
DAYS_BEHIND |
NUMBER(5,2) |
||
|
EST_BEG_INST_TOOL_FOR_TTS |
DATE |
||
|
EST_COMP_INST_BANK |
DATE |
||
|
EST_COMP_INST_CUM_MOVE |
DATE |
||
|
EST_COMP_INST_HOLD |
DATE |
||
|
EST_COMP_INST_IF_BEG_NOW |
DATE |
||
|
EST_COMP_INST_SCHED |
DATE |
||
|
EST_COMP_INST_SLOW |
DATE |
||
|
EST_COMP_INST_STAGING |
DATE |
||
|
EST_COMP_INST_TOOL |
DATE |
||
|
EST_DISP_INST_TOOL_FOR_TTS |
DATE |
||
|
EST_END_INST_TOOL |
DATE |
||
|
EST_END_INST_TOOL_FOR_TTS |
DATE |
||
|
EST_END_TOOL_REASON |
VARCHAR2(201) |
||
|
EST_NEXT_BEG_INST_TOOL |
DATE |
||
|
EST_NEXT_BEG_TOOL_REASON |
VARCHAR2(203) |
||
|
EST_RELEASE_INST |
DATE |
||
|
EXP_OUT_BY_ROUTE_DAYS_BEHIND |
NUMBER(6,2) |
||
|
EXP_OUT_BY_ROUTE_INST |
DATE |
||
|
EXP_OUT_BY_ROUTE_START_WEEK |
DATE |
||
|
EXP_OUT_BY_ROUTE_WEEK |
VARCHAR2(7) |
||
|
FIRST_WFR_BEG_INST |
DATE |
Time when the first wafer of the job started processing. (* from FPSBASE.WIP_STEP_HIST) |
|
|
FIRST_WFR_END_INST |
DATE |
Time when the first wafer of the job finished processing. (* from FPSBASE.WIP_STEP_HIST) |
|
|
IS_NMV_NOW |
CHAR(1) |
||
|
IS_QUEUE_TIMER_EXPIRED |
CHAR(1) |
||
|
LAST_END_PROC_INST_FOR_TTS |
DATE |
||
|
LAST_WFR_BEG_INST |
DATE |
Time when the last wafer of the job started processing. (* from FPSBASE.WIP_STEP_HIST) |
|
|
LAST_WFR_END_INST |
DATE |
Time when the last wafer of the job finished processing. (* from FPSBASE.WIP_STEP_HIST) |
|
|
NEXT_BEG_INST_TOOL_FOR_TTS |
DATE |
||
|
NMV_SORT_INST |
DATE |
||
|
NUM_WFRS_BEG |
NUMBER(3) |
||
|
NUM_WFRS_ENDED |
NUMBER(3) |
||
|
OUT_INST_EXPECTED |
DATE |
||
|
OVR_PROCESS_STATE_DETAILS |
VARCHAR2(600) |
This column will override the process state details for the Dashboard if populated. It is important to note that this column is technically independent from the process_state which is calculated based on events from WIP_EVENT_HIST. For example, immediately after a lot is dispatched, this column might still have a message about WAIT when the process state just changed to DISP. To reduce the duration of these discrepancies, you should refresh WIP_LOTS_VERIFY in the RealTime job or at least every 1-2 minutes if you populate this column. (* from FPSINPUT.WIP_LOTS_VERIFY) |
|
|
OVR_STEP_COMP_INST |
DATE |
Specify a time when the lot will complete the step. We will use this mainly for banks and staging steps with a release plan. For steps that require processing on a tool, please use ovr_est_end_inst instead. (* from FPSINPUT.WIP_LOTS_VERIFY) |
|
|
PULL_POINT_DETAILS_W_FILLIN |
VARCHAR2(256) |
||
|
PULL_POINT_INST_W_FILLIN |
DATE |
||
|
PULL_POINT_PACE_DETAILS |
VARCHAR2(256) |
||
|
PULL_POINT_PACE_INST |
DATE |
||
|
QUEUE_TIMER_DESCRIPTION |
VARCHAR2(256) |
||
|
QUEUE_TIMER_DISPLAY |
VARCHAR2(48) |
||
|
QUEUE_TIMER_REMAIN_SEC |
NUMBER(22) |
||
|
RN_BY_TOOL_FOR_TTS |
NUMBER(2) |
||
|
SCHEDULE_STATUS |
VARCHAR2(14) |
||
|
SCHEDULE_STATUS_COLOR |
VARCHAR2(6) |
||
|
SHOULD_HIGHLIGHT_AGE_FOR_HOLD |
CHAR(1) |
||
|
STEP_HOLD_SEC |
NUMBER(9) |
||
|
STEP_HOLD_SEC_CURR_DAY |
NUMBER(8) |
||
|
STEP_HOLD_SEC_CURR_SHIFT |
NUMBER(8) |
Time on hold at the current step during the current shift (* from FPSBASE.WIP_STEP_HIST) |
|
|
STEP_SEC_CURR_DAY |
NUMBER(8) |
||
|
STEP_SEC_CURR_SHIFT |
NUMBER(8) |
||
|
TIME_TO_NEXT_MOVE |
DATE |
||
|
WAIT_SEC_TO_SCHED |
NUMBER(7) |
The lot may be scheduled but must not be allowed to dispatch or start until this number of seconds has elapsed. (* from FPSINPUT.WIP_LOTS_STATIC) |