Data Dictionary
>
FPSBASE Tables
> FPSBASE.CFG_FILES
Table FPSBASE.CFG_FILES"
Configurable info on files to update using ADM_LOAD.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Foreign keys: CFG_FILES_FK_METHOD: METHOD REFERENCES FPSADMIN.GEN_LOAD_METHODS (METHOD)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
FILE_NAME |
VARCHAR2(50) |
CFG_FILES table is currently not used. |
|
|
CHANGE_EMAIL_LIST |
VARCHAR2(512) |
CFG_FILES table is currently not used. |
|
|
COPY_AS_TXT |
CHAR(1) |
CFG_FILES table is currently not used. |
|
|
COPY_TO_ARCHIVE |
CHAR(1) |
CFG_FILES table is currently not used. |
|
|
DURATION_SEC |
NUMBER(9) |
Duration in seconds of the period to be used to run the APF report. Used only for CLR, CLRA, and QE. (* from FPSADMIN.CFG_TABLES) |
|
|
END_REP_START_SHIFT |
CHAR(1) |
This column is obsolete and will be dropped from the table in the next DWH version. (* from FPSADMIN.CFG_TABLES) |
|
|
ERR_IF_NO_ROWS |
CHAR(1) |
If set to Y then the job will error if no rows are inserted. This cannot be used with DBPM because the match logic frequently updates no rows. (* from FPSADMIN.CFG_TABLES) |
|
|
METHOD |
VARCHAR2(6) |
N |
Method used to load data in table or execute procedure (* from FPSADMIN.GEN_LOAD_METHODS) |
|
OTHERS_TO_LOAD_IF_CHG |
VARCHAR2(128) |
This allows us to load a table only if another table changed. This is rarely used but can save time. (* from FPSADMIN.CFG_TABLES) |
|
|
OVR_PERMISSION |
NUMBER(3) |
CFG_FILES table is currently not used. |
|
|
OVR_STATION_VAR |
VARCHAR2(12) |
This allows us to pass a value for $Station to an APF report or rule. This is rarely used. (* from FPSADMIN.CFG_TABLES) |
|
|
PCT_FEWER_ROWS_ERR |
NUMBER(2) |
CFG_FILES table is currently not used. |
|
|
PCT_FEWER_ROWS_WARN |
NUMBER(2) |
CFG_FILES table is currently not used. |
|
|
PCT_MORE_ROWS_ERR |
NUMBER(4) |
CFG_FILES table is currently not used. |
|
|
PCT_MORE_ROWS_WARN |
NUMBER(3) |
CFG_FILES table is currently not used. |
|
|
SKIP_DIFF_CHK |
CHAR(1) |
CFG_FILES table is currently not used. |