Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.NMV_W_RESERVE_LOT_EXTL_LOG
Table FPSADMIN.NMV_W_RESERVE_LOT_EXTL_LOG"
Logging table for external system calls
-
Schema: FPSADMIN
-
Tablespace: FPSDATAHIST
-
Primary key: INSERTED_TIME, LOT, STEP, ROUTE, FACILITY
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
INSERTED_TIME |
TIMESTAMP(6) |
N |
Timestamp field set by trigger storing SYSTIMESTAMP when record was inserted in the table. (* from FPSINPUT.WIP_EVENT_HIST) |
|
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) |
|
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) |
|
ROUTE |
VARCHAR2(256) |
N |
Route that has threading requirements (* from FPSINPUT.RTG_STEP_THREADING) |
|
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) |
|
CALL_FROM |
VARCHAR2(30) |
||
|
CALL_TYPE |
VARCHAR2(16) |
||
|
ERROR_MESSAGE |
VARCHAR2(2000) |
||
|
EXTL_ADDL_INFO |
VARCHAR2(256) |
This will have any additional lot info needed by the external system (* from FPSBASE.WIP_STEP_FUTURE_SCHED) |
|
|
EXTL_DEST_LOCATION |
VARCHAR2(32) |
This column will have the destination location for the lot (* from FPSBASE.WIP_STEP_FUTURE_SCHED) |
|
|
EXTL_DISP_INST |
DATE |
Time by when the external system recommends that the job must be dispatched. (* from FPSBASE.WIP_STEP_FUTURE_SCHED) |
|
|
EXTL_DO_NOT_MOVE |
CHAR(1) |
This column will decided whether NextMove will highlight to move or override it (* from FPSBASE.WIP_STEP_FUTURE_SCHED) |
|
|
EXTL_END |
DATE |
Time by when the external system recommends that the job will end processing. (* from FPSBASE.WIP_STEP_FUTURE_SCHED) |
|
|
EXTL_IS_RESERVED |
CHAR(1) |
Flag indicated whether the external system has reserved the lot to the tool. If not we still move to the destination. (* from FPSBASE.WIP_STEP_FUTURE_SCHED) |
|
|
EXTL_RECIPE |
VARCHAR2(100) |
||
|
EXTL_REQ_EXACT_DEST |
CHAR(1) |
This column will decided whether NextMove use alternates and station assignments or ignore them. (* from FPSBASE.WIP_STEP_FUTURE_SCHED) |
|
|
EXTL_RESERVE_CH_TO_USE |
VARCHAR2(24) |
||
|
EXTL_RESERVE_INST |
DATE |
||
|
EXTL_RESERVE_JOB_ID |
VARCHAR2(64) |
||
|
EXTL_RESERVE_QTY_IN_JOB |
NUMBER(7) |
||
|
EXTL_RESERVE_TOOL |
VARCHAR2(16) |
||
|
EXTL_RESERVE_USERNAME |
VARCHAR2(64) |
||
|
EXTL_SETUP |
VARCHAR2(100) |
||
|
EXTL_SHOW_EXACT_DEST |
CHAR(1) |
This column will decided whether NextMove will show the destination Bay or the exact destination. (* from FPSBASE.WIP_STEP_FUTURE_SCHED) |
|
|
EXTL_START |
DATE |
Time by when the external system recommends that the job will begin processing. (* from FPSBASE.WIP_STEP_FUTURE_SCHED) |
|
|
EXTL_TIME_TO_NEXT_MOVE |
DATE |
Time provided by an external system to override the carrier time to move for racks. (* from FPSBASE.WIP_STEP_FUTURE_SCHED) |
|
|
EXTL_TRANSPORT_MODE |
VARCHAR2(16) |
Name of the site transport mode which represents how material is moved from one location to another. (* from FPSINPUT.MHS_EXTERNAL_TRANSPORT_MODES) |
|
|
EXTL_UNRESERVE_INST |
DATE |
||
|
EXTL_VEHICLE_SUB_ROUTE |
VARCHAR2(36) |
||
|
I_ADDL_INFO |
VARCHAR2(1000) |
||
|
I_CH_TO_USE |
VARCHAR2(1000) |
||
|
I_DEST_LOCATION |
VARCHAR2(1000) |
||
|
I_DO_NOT_MOVE |
CHAR(1) |
||
|
I_EXTL_DISP_INST |
DATE |
||
|
I_EXTL_END |
DATE |
||
|
I_EXTL_JOB_ID |
VARCHAR2(1000) |
||
|
I_EXTL_RECIPE |
VARCHAR2(1000) |
||
|
I_EXTL_SETUP |
VARCHAR2(1000) |
||
|
I_EXTL_START |
DATE |
||
|
I_EXTL_TIME_TO_NEXT_MOVE |
DATE |
||
|
I_IGNORE_NULLS |
CHAR(1) |
||
|
I_IS_RESERVE |
CHAR(1) |
||
|
I_QTY_IN_JOB |
NUMBER(9) |
||
|
I_REQ_EXACT_DEST |
CHAR(1) |
||
|
I_SHOW_EXACT_DEST |
CHAR(1) |
||
|
I_TOOL |
VARCHAR2(1000) |
||
|
I_TRANSPORT_MODE |
VARCHAR2(1000) |
||
|
I_USERNAME |
VARCHAR2(1000) |