Data Dictionary
>
FPSAPP Tables
> FPSAPP.CFG_COLUMNS_TO_IGNORE
Table FPSAPP.CFG_COLUMNS_TO_IGNORE"
List of individual columns which should be ignored by the ETL in tables which are otherwise updated automatically. For tables updated by ADM_TABLE_xxx procedures, these columns will be ignored automatically. For tables updated by APF, the BLD_TABLE_QUERIES view will ignore these columns but we must copy/paste from this view into the APF report so this is not automatic.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: TABLE_NAME, COLUMN_NAME
-
Foreign keys: CFG_COLUMNS_TO_IGNORE_FK_CODE: IGNORE_CODE REFERENCES FPSADMIN.GEN_COLUMN_IGNORE_CODES (IGNORE_CODE)
|
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) |