data-dictionary
data-dictionary
Breadcrumbs

FPSAPP.DBC_PROCEDURES

Data Dictionary

>

FPSAPP Tables

> FPSAPP.DBC_PROCEDURES

Table FPSAPP.DBC_PROCEDURES"

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

  • Schema: FPSAPP

  • 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)