Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSAPP.DASH_P_CUSTOM_REPORTS
This P view shows the contents of the C table plus any global FPS reports which are not already listed in the C table. This means that Reports tab on the Dashboard will always include all global FPS reports regardless of whether they are in DASH_C_CUSTOM_REPORTS or not. If DASH_C_CUSTOM_REPORTS is completely blank then Reports tab will show just these reports in the default format. Please note that the ~ in the URL means the current application. So if you are viewing the Reports page at http://fpsweb.yourco.com/DashboardUAT/Reports then the link for the Lot List will go to http://fpsweb.yourco.com/DashboardUAT/Operations/Lots.
|
Column |
Comment |
|---|---|
|
FACILITY |
Facility is included in almost every join in the DWH so this represents a definitive split. A route must have all steps on tools in the same facility. A tool must process all lots in the same facility. If your site has multiple buildings where lots run on routes using tools in multiple buildings then everything should be one facility. For example, multiple Fab buildings. But if your site has independent facilities like Fab and Test and Assembly where lot may progress from one to the next but on different routes then these should be different facilities. Since this column is in virtually every table it is critical that the value here is exactly matches what is in the MES if the MES has facility. Use facility_display for the display friendly name displayed in applications. See site_name comment for client/site/facility example. (* inherited from FPSINPUT.GEN_FACILITIES) |
|
LINK_TEXT |
The text of the report link (* inherited from FPSAPP.DASH_C_CUSTOM_REPORTS) |
|
HOVER_TEXT |
The hover text of the report link (* inherited from FPSAPP.DASH_C_CUSTOM_REPORTS) |
|
SECTION |
The section the report link belongs under, such as Operations or Maintenance (* inherited from FPSAPP.DASH_C_CUSTOM_REPORTS) |
|
SECTION_SEQ |
The order of the sections for display purposes (* inherited from FPSAPP.DASH_C_CUSTOM_REPORTS) |
|
URL |
The URL of the report link (* inherited from FPSAPP.DASH_C_CUSTOM_REPORTS) |
|
URL_SEQ |