FPSAPP.MSO_TABLES

Data Dictionary

>

FPSAPP Tables

> FPSAPP.MSO_TABLES

Table FPSAPP.MSO_TABLES"

Configuration table that contains the list of MSO tables used by the admin utility package (ADM_MSO_UTILITIES) used to copy rules, copy data and replaying and validating data.

Schema: FPSAPP
Tablespace: FPSDATA

Column	Type	Nullable	Comment
OWNER	VARCHAR2(30)
TABLE_NAME	VARCHAR2(30)
IS_CONFIG_HIST_TABLE	CHAR(1)		Indicates if the table is history table of all the MSO configurations
IS_CONFIG_TABLE	CHAR(1)		Indicates if the table is a MSO configuration table that defines rules, tag conditions, waivers, settings, etc. Typically these are tables modified by the UI. These tables may have triggers associated to them that track changes.
IS_COPY_ALLOWED	CHAR(1)		Indicates if the table is part of the COPY_CONFIGURATION_TABLES procedure in ADM_MSO_UTILITIES package.
IS_DATA_HIST_TABLE	CHAR(1)		Indicates if the table contains history of MSO sampling results (i.e. tagging decisions, process history, etc.). This also is used if copying data from one database to another.
IS_DATA_TABLE	CHAR(1)		Indicates if the table contains current MSO data (i.e. current counters, tagged lots, etc.). This also is used if copying data from one database to another.
IS_ETL_TABLE	CHAR(1)		Indicates if the table or certain columns in the table is affect MSO. This is primarly used for verifying differences between databases in ETL tables.
IS_TEST_PACKAGE_RENAME	CHAR(1)
IS_TRUNCATE_ALLOWED	CHAR(1)		Indicates if the history table can be truncated in the ADM_MSO_UTILITIES package
TABLE_RENAME_PRIMARY_NAME	VARCHAR2(30)		Indicates the table rename value for the ADM_MSO_UTILITIES package when replaying history. This is necessary for history tables that need to be renamed in order to replay data and not modify the existing history tables.