data-dictionary
data-dictionary
Breadcrumbs

FPSINPUT.GEN_COLUMN_IGNORE_CODES

Data Dictionary

>

FPSINPUT Tables

> FPSINPUT.GEN_COLUMN_IGNORE_CODES

Table FPSINPUT.GEN_COLUMN_IGNORE_CODES"

Reference table listing all options for ignore code in CFG_COLUMNS_TO_IGNORE with full information.

  • Schema: FPSINPUT

  • Tablespace: FPSDATA

  • Primary key: IGNORE_CODE

  • Referenced by: FPSADMIN.CFG_COLUMNS_TO_IGNORE (IGNORE_CODE)


Column

Type

Nullable

Comment

IGNORE_CODE

VARCHAR2(1)

N

IGNORE_DETAILS

VARCHAR2(4000)

IGNORE_NAME

VARCHAR2(24)

IGNORE_NOTE

VARCHAR2(4000)

IS_ALLOWED_IF_COL_NOT_NULL

CHAR(1)

This column indicates exactly how the column is ignored by the ETL.

IS_INSERT_FROM_ETL

CHAR(1)

For APF, if Y then we include the column in our pre-built insert statement but not in our update statement. For REF views, if Y we include the column in the pre-build REF view but we only use it for insert and ignore for update. This allows the ETL to populate a default value on initial insert but then not update it since it will be updated manually.