Data Dictionary
>
FPSAPP Tables
> FPSAPP.RTG_ALL_PRD_SPLIT_30DAY
Table FPSAPP.RTG_ALL_PRD_SPLIT_30DAY"
See comments in RTG_REF_ALL_PRD_SPLIT_30DAY view.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: SOURCE_FACILITY, SOURCE_PRD, SOURCE_BANK, DEST_FACILITY, DEST_PRD, DEST_BANK
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
SOURCE_FACILITY |
VARCHAR2(6) |
N |
First facility in the process flow when a lot visits multiple facilities in sequence. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
SOURCE_PRD |
VARCHAR2(64) |
N |
First prd in the process flow when a lot visits multiple facilities in sequence. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
SOURCE_BANK |
VARCHAR2(36) |
N |
|
|
DEST_FACILITY |
VARCHAR2(6) |
N |
Facility where the lot will go after it completes its route in the current facility. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
DEST_PRD |
VARCHAR2(64) |
N |
Prd which will the lot will assume after it completes its route in the current facility. This could be the same as the current prd. (* from FPSINPUT.RTG_PRD_FACILITY_NEXT) |
|
DEST_BANK |
VARCHAR2(36) |
N |