data-dictionary

FPSBASE.DBC_DATA_QUERIES

Data Dictionary

>

FPSBASE Tables

> FPSBASE.DBC_DATA_QUERIES

Table FPSBASE.DBC_DATA_QUERIES"

Database Checker table to store comparison of data between this instance and the referenced linked instance.

  • Schema: FPSBASE

  • Tablespace: FPSDATA


Column

Type

Nullable

Comment

CREATED_INST

DATE

Time when the lot was created, either lot start or split. (* from FPSINPUT.WIP_LOTS_STATIC)

DBC_QUERY

VARCHAR2(4000)

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)

OWNER

VARCHAR2(30)