data-dictionary

FPSINPUT.DBF_COL_COMMENTS

Data Dictionary

>

FPSINPUT Tables

> FPSINPUT.DBF_COL_COMMENTS

Table FPSINPUT.DBF_COL_COMMENTS"

See comments in DBF_REF_COL_COMMENTS view.

  • Schema: FPSINPUT

  • Tablespace: FPSDATA

  • Primary key: OWNER, TABLE_NAME, COLUMN_NAME


Column

Type

Nullable

Comment

OWNER

VARCHAR2(30)

N

TABLE_NAME

VARCHAR2(128)

N

COLUMN_NAME

VARCHAR2(128)

N

Name of the column in DWH. Note: The column may exist in more than one table and/or schema. (* from FPSINPUT.GEN_EXPLANATIONS)

COMMENTS

VARCHAR2(4000)

A comment field allowing a user to document the source or reason of the values populated in the table (* from FPSAPP.GP_C_RSEC_PROCESS_ROUTE)

USE_FOR_COLUMN_NAME

CHAR(1)