data-dictionary
data-dictionary
Breadcrumbs

FPSBASE.DBC_PROCEDURES

Data Dictionary

>

FPSBASE Tables

> FPSBASE.DBC_PROCEDURES

Table FPSBASE.DBC_PROCEDURES"

Database Checker table to store procedures which changed between this instance and the referenced linked instance.

  • Schema: FPSBASE

  • Tablespace: FPSDATA


Column

Type

Nullable

Comment

OWNER

VARCHAR2(30)

OBJECT_NAME

VARCHAR2(30)

This could be an object name (we will disable loading of that object in the scheduled jobs), a load job (we will disable loading of all objects in that scheduled job), an FPSAPP prefix (we will disable loading of all objects with that prefix), a constraint (we can explain why it is permanently disabled), or a trigger (technically an object so we can get away with omitting this from the column name and also to explain why it is permanently disabled). (* from FPSADMIN.CFG_DISABLED)

PROCEDURE_NAME

VARCHAR2(30)

COMMENTS

VARCHAR2(200)

A comment field allowing a user to document the source or reason of the values populated in the table (* from FPSAPP.GP_C_RSEC_PROCESS_ROUTE)