Skip to content

MPE_FILTERSOURCE

The MPE_FILTERSOURCE table stores the individual query lines of each filter created via the FILTER menu, keyed by the hash stored in MPE_FILTERANYTABLE. See the filter guide for more details.

Columns

  • 🔑 FILTER_HASH char(32): Hash of the filter clause, joining to MPE_FILTERANYTABLE
  • 🔑 FILTER_LINE num: Line number within the filter clause
  • GROUP_LOGIC char(3): AND / OR logic applied between groups
  • SUBGROUP_LOGIC char(3): AND / OR logic applied within the subgroup
  • SUBGROUP_ID num: Identifier of the subgroup to which this line belongs
  • VARIABLE_NM char(32): The variable being filtered
  • OPERATOR_NM char(12): The filter operator (e.g. =, >, IN)
  • RAW_VALUE char(4000): The filter value. A date, datetime or time is stored as a SAS literal (for example '20APR2042'd, '01JAN1960:00:00:42'dt, '00:00:42't), so the clause shown above the grid reads as a date rather than the internal day or second count.
  • PROCESSED_DTTM num: Datetime the filter line was created