FILTERID |
NOT NULL |
NUMBER |
Unique number used to identify the operation that used this filter |
SUBFILTERNUM |
NOT NULL |
NUMBER |
A unique id number that groups all filter items together. A corresponding filter header record can be found in the MVIEW_LOG table |
SUBFILTERTYPE |
|
VARCHAR2(12) |
Filter item number |
STR_VALUE |
|
VARCHAR2(1028) |
String attribute for items that require strings |
NUM_VALUE1 |
|
NUMBER |
Numeric low for items that require numbers |
NUM_VALUE2 |
|
NUMBER |
Numeric high for items that require numbers |
DATE_VALUE1 |
|
DATE |
Date low for items that require dates |
DATE_VALUE2 |
|
DATE |
Date high for items that require dates |