Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSAPP.CTR_P_PRD_CTM_SERIES_ALL_FAC
This view is used for the queries only and does not have a facility column. For the dropdowns, we use CTR_P_PRD_CTM_SERIES which includes facility from RTG_PRDS.
|
Column |
Comment |
|---|---|
|
PRD |
Prd determines the route which is used to process the lot in the facility and what tools, recipes, durables, etc. can be used at each step. Prd also determines the next facility for the lot when it finishes its route. For detailed information on prd vs. planprd see table comments in RTG_PLANPRDS. (* inherited from FPSINPUT.RTG_PRDS) |
|
CTM_SERIES |
This is a grouping across facilities for our Finished Lot Cycle Time application indicating prds which make up the same or similar final product to be shipped. Prds are allowed to be in multiple series - for example when a generic prd A is assembled together with various specific prds B1, B2, B3. (* inherited from FPSINPUT.RTG_PRD_CTM_SERIES) |
|
CTM_SERIES_SEQ_IN_FAC |