data-dictionary
data-dictionary
Breadcrumbs

FPSBASE.GEN_EXPLANATIONS

Data Dictionary

>

FPSBASE Tables

> FPSBASE.GEN_EXPLANATIONS

Table FPSBASE.GEN_EXPLANATIONS"

This table is where we make client-specific explanations about the translation of their data into our FPSINPUT tables.

  • Schema: FPSBASE

  • Tablespace: FPSDATA


Column

Type

Nullable

Comment

COLUMN_NAME

VARCHAR2(30)

Name of the column in DWH. Note: The column may exist in more than one table and/or schema.

EXPLANATION

VARCHAR2(4000)

Explanation of how data is translated for specific column. For example, this might include the table name and column name from the MES used to populate the column in the FPSINPUT table.

FORMULA

VARCHAR2(1000)

Mathematical formula for how the data is derived.

SRC_APPLICATION

VARCHAR2(30)

Application from which the source data is acquired. Usually this is the MES.

SRC_COLUMN

VARCHAR2(30)

Column(s) from which the column is acquired. This may be more than one column in some cases.