Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSAPP.ECTA_P_PRTY_CTM_GROUPS
This view gets the list of ctm groups for the selections in the ECTA
|
Column |
Comment |
|---|---|
|
PRTY_CTM_GROUP |
This is one of the primary keys of our CTM tables. We use this group rather than the priority because we often have several different priorities which are close and are expected to have the same cycle time. (* inherited from FPSINPUT.WIP_PRIORITIES) |
|
SORT_ORDER |
This is used to sort within the grouping. SORT_ORDER always has a deferrable unique key to ensure uniqueness while allowing the user to make changes without erroring until the commit is attempted. Because of this you must be careful to not violate the unique key otherwise you will lose all of your edits. (* inherited from FPSINPUT.GEN_FACILITIES) |
|
PRIORITY |
This is the priority value as it is stored in the MES for each lot. It might be a number or a letter or word depending on the MES and the facility. (* inherited from FPSINPUT.WIP_PRIORITIES) |