FPSADMIN.DASH_P_CATEGORY_TABLE_COLS

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

COLUMN_ID

COLUMN_HEADER_DISPLAY

SHOULD_TOTAL

SHOULD_DISPLAY

SHOULD_DISPLAY_EXP

SHOULD_EXPORT

SHOULD_AUTO_HIDE

If the flag is set to Y then the module will be hidden on the Dashboard even if it has active WIP or moves. (* inherited from FPSINPUT.GEN_MODULES)

COLUMN_WIDTH_PCT

COLUMN_HEADER_HOVERMSG

COLUMN_HEADER_ALIGN

COLUMN_DATA_ALIGN

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)

DEFAULT_SORT_DIRECTION

This controls the default sort order for each column. For most numeric values like WIP, Completes, Pace, Targets, Scrap, and so on, it makes sense for the default sort direction to be Descending. For example, if you click on the column header to sort by Completes that you expect to see records with the most Completes on top. Of course it is still possible to click a second time to sort Ascending if you really want to see the records with the fewest Completes on top but that would be the exception. (* inherited from FPSAPP.DASH_C_COLUMNS)

NUMBER_FORMAT

The most common formats are N0 (integer), N1 (one decimal place), and 0% (percentage with no decimal places). Complete information is at https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings. (* inherited from FPSAPP.DASH_C_COLUMNS)

COLUMN_ENTITY_MAX_NUM