data-dictionary

FPSADMIN.RTG_REF_PRD_FACILITY_REVERSE

Data Dictionary

>

FPSADMIN Views

> FPSADMIN.WIP_WAFER_HIST_LOOP

View FPSBASE.RTG_REF_PRD_FACILITY_REVERSE

This view uses connect by to build the past facility/prd path from a given facility/prd. Similar logic is used in the RTG_PRD_FACILITY_FLUSH for the future path. See note in SUM_FROM_STRING function about its usage here.

Column

Comment

SOURCE_PRD

First prd in the process flow when a lot visits multiple facilities in sequence. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT)

SOURCE_FACILITY

First facility in the process flow when a lot visits multiple facilities in sequence. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT)

IS_SHIP_PRD