The filteritem table in the onpload database
The filteritem table defines the conditions to be applied to load data to filter out records. Each filter item is attached to a particular field of a record in a data file. Use the filter options to modify this table.
| Column | Type | Description |
|---|---|---|
| formid | INTEGER | Filter identifier (foreign key to the filters table) |
| seq | INTEGER | Specifies the order in which the filter items (the match expression) are applied |
| fname | CHAR(128) | The name of the field that this filter affects |
| option | CHAR(7) | Specifies the disposition of a record (discard or keep) when the match criterion is true |
| match | CHAR(60) | Match expression that is applied to data field |