Data Dictionary
>
FPSBASE Tables
> FPSBASE.DASH_C_COLUMNS
Table FPSBASE.DASH_C_COLUMNS"
This table is used to set the property of each column_id which are the same across all tables, categories, facilities, and web versions at each site.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
COLUMN_ID |
VARCHAR2(100) |
||
|
COLUMN_DATA_ALIGN |
VARCHAR2(20) |
||
|
COLUMN_HEADER_ALIGN |
VARCHAR2(20) |
||
|
COLUMN_HEADER_DISPLAY |
VARCHAR2(100) |
||
|
COLUMN_HEADER_HOVERMSG |
VARCHAR2(500) |
||
|
DEFAULT_SORT_DIRECTION |
VARCHAR2(20) |
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. |
|
|
NUMBER_FORMAT |
VARCHAR2(20) |
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. |