data-dictionary

FPSAPP.GEN_COLS_UPDATED_BY_TRIGGER

Data Dictionary

>

FPSAPP Tables

> FPSAPP.GEN_COLS_UPDATED_BY_TRIGGER

Table FPSAPP.GEN_COLS_UPDATED_BY_TRIGGER"

Lists columns in FPSINPUT tables which are updated by triggers. This is GEN rather than CFG because this is not configurable. Our APF load reports and ADM_AUTO_TABLE_REFRESH procedures will ignore these columns.

  • Schema: FPSAPP

  • Tablespace: FPSDATA

  • Primary key: TABLE_NAME, COLUMN_NAME


Column

Type

Nullable

Comment

TABLE_NAME

VARCHAR2(30)

N

COLUMN_NAME

VARCHAR2(30)

N

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