Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.RTG_PRD_CTM_SERIES
Table FPSADMIN.RTG_PRD_CTM_SERIES"
This table stores the list of CTM series for each prd which is used for selection criteria in the Finished Lot Cycle Time application. In theory this could be determined from RTG_PRD_FACILITY_NEXT but there are often exceptions and options in that table which make it difficult. We found it was easier to configure this manually using this table.
-
Schema: FPSADMIN
-
Tablespace: FPSDATA
-
Primary key: PRD, CTM_SERIES
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
PRD |
VARCHAR2(64) |
N |
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. (* from FPSINPUT.RTG_PRDS) |
|
CTM_SERIES |
VARCHAR2(64) |
N |
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. |