FPSINPUT.DASH_P_CATEGORY_TABLES

WEB_VERSION

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)

CATEGORY

TABLE_ID

DISPLAY

This is the short description to show on the scheduler web ui (* inherited from FPSAPP.SCH_C_TMP_SCHED_GROUPS)

TABLE_NUM_ROW_DEFAULT

This is the maximum number of columns to show when the page is initially generated prior to clicking on the "More" link.  When counting rows, this includes the zero columns which are later hidden ordered by the sort order.  For example, we have 16 records with non-zero values plus 8 more records which have zeroes across the board.  Also the default_sort_column_id is set to ITEM to sort alphabetically so the non-zero and zero records are mixed when ordered. If we set this value to 20 then we will take the top 20 records alphabetically so the last four are out. Then of those 20 we take only the non-zero records so we will show as few as 12 records in the end. This initially might be confusing because we see 12 of the 16 non-zero records when this value is set to 20 but this is actually correct. To see all non-zero records initially, make sure to set this value to a number which is greater than the total number of records. (* inherited from FPSAPP.DASH_C_CATEGORY_TABLES)

TABLE_NUM_ROW_MAX

SHOULD_DISPLAY

SHOULD_EXPORT

ALLOW_ROLLUP

DEFAULT_SORT_COLUMN_ID

The column used to sort the records in the table when the page is initially generated. This must be a column where should_display is set to Y. Sort direction is Ascending or Descending based on the value of default_sort_direction for this column in DASH_C_COLUMNS. (* inherited from FPSAPP.DASH_C_CATEGORY_TABLES)