data-dictionary
data-dictionary
Breadcrumbs

FPSADMIN.DASH_C_COLUMNS

Data Dictionary

>

FPSADMIN Tables

> FPSADMIN.DASH_C_COLUMNS

Table FPSADMIN.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: FPSADMIN

  • 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.