data-dictionary
data-dictionary
Breadcrumbs

FPSBASE.CFG_PROCEDURES

Data Dictionary

>

FPSBASE Tables

> FPSBASE.CFG_PROCEDURES

Table FPSBASE.CFG_PROCEDURES"

List of procedures to run using ADM_LOAD.

  • Schema: FPSBASE

  • Tablespace: FPSDATA

  • Primary key: PROCEDURE_NAME


Column

Type

Nullable

Comment

PROCEDURE_NAME

VARCHAR2(30)

N

ERROR_PRIORITY

VARCHAR2(10)

This is just informative and used in FPSRPT objects but this could be used in SYSMNTR in the future. It is a string field so it can be a word or a number. (* from FPSADMIN.CFG_TABLES)

IS_EXTERNAL

CHAR(1)

Y means the job is called externally so we should not expect it to be in ADM_LOAD_CFG_SCHED.

IS_MANUAL

CHAR(1)

Y means the job is called manually so we should not expect it to be in ADM_LOAD_CFG_SCHED.

IS_NOT_USED

CHAR(1)

Y means the job is not used at this site so we should not expect it to be in ADM_LOAD_CFG_SCHED.

IS_WITHIN_APF

CHAR(1)

Y means the job is called within an APF rule or report so we should not expect it to be in ADM_LOAD_CFG_SCHED.

OWNER

VARCHAR2(30)

N

RPT_OWNER_NAME

VARCHAR2(64)

This field is used to indicate who owns this FPSRPT object. It is for informational purposes only and not used in the FPS DWH. (* from FPSADMIN.CFG_TABLES)