FPSBASE.MSO_DEFAULT_CONDITION_SETTINGS

Data Dictionary

FPSBASE Tables

> FPSBASE.MSO_DEFAULT_CONDITION_SETTINGS

Table FPSBASE.MSO_DEFAULT_CONDITION_SETTINGS"

This is an unusual FPSBASE table in that all sites will have the same 100 rows with percent values from 1 to 100. Furthermore all sites will have the same values for the three base columns. This makes it similar to an FPSADMIN table where the data is the same for all sites. But the values of the three default columns are set manually and can be different at each site. The default values are what is actually used in the MSO decision calculation but the common base values exist to help calculate the default values.

Schema: FPSBASE
Tablespace: FPSDATA
Primary key: RULE_CONDITION, RULE_TYPE

Column	Type	Nullable	Comment
RULE_CONDITION	NUMBER(8)	N
RULE_TYPE	VARCHAR2(32)	N
MAX_CON_SKIP_TAG_LOT_BASE	NUMBER(5)	N	Max consecutive skips to hit sample percent. Calculated from 1/n value. Should not be changed or updated. This value is not actually used in the percent rule algorithm.
MAX_CON_SKIP_TAG_LOT_DEFAULT	NUMBER(5)	N	Default value to be used in percent rule calculation. Initial load defaults to base MAX_CON_SKIP_TAG_LOT_BASE value + 20%. This value is used in the percent rule algorithm unless there is a rule override value.
MIN_CON_SKIP_ALLOW_TAG_BASE	NUMBER(5)	N	Min consecutive skips to hit sample percent. Calculated from 1/n value. Should not be changed or updated. This value is not actually used in the percent rule algorithm.
MIN_CON_SKIP_ALLOW_TAG_DEFAULT	NUMBER(5)	N	Default value to be used in percent rule calculation. Initial load defaults to MIN_CON_SKIP_ALLOW_TAG_BASE value - 20%. This value is used in the percent rule algorithm unless there is a rule override value.
NUM_LOTS_HIST_CUTOFF_BASE	NUMBER(5)	N	Base value for number of lots to use for history when calculating percentage. This value should not be changed or updated. This value is not actually used in the percent rule algorithm.