Skip to content

MPE_SELECTBOX

The MPE_SELECTBOX table configures the values that appear in dropdowns when editing control tables (eg LOADTYPE in MPE_TABLES or ACCESS_LEVEL in MPE_SECURITY).

A more detailed breakdown is available in the configuration section.

Columns

  • VER_FROM_DTTM num: SCD2 open datetime
  • 🔑 SELECTBOX_RK num: Surrogate key for the selectbox value
  • SELECT_LIB char(17): Libref of the table to which the dropdown applies
  • SELECT_DS char(32): Name of the table to which the dropdown applies
  • BASE_COLUMN char(36): The column against which the dropdown is applied
  • SELECTBOX_VALUE char(500): The dropdown value
  • SELECTBOX_ORDER num: Optional ordering of the dropdown values (1 comes before 2)
  • SELECTBOX_TYPE char(32): Column type (blank for default, else sas or js to indicate relevant system functions)
  • VER_TO_DTTM num: SCD2 close datetime