Skip to content

MPE_DATADICTIONARY

The MPE_DATADICTIONARY table stores user-maintained documentation for libraries, tables, columns and directories. This content is surfaced in the Data Dictionary view of Data Controller.

Columns

  • TX_FROM num: SCD2 open datetime
  • 🔑 DD_TYPE char(16): The type of item being documented (e.g. LIBRARY, TABLE, COLUMN, DIRECTORY)
  • 🔑 DD_SOURCE char(1024): The item being documented (e.g. libref, libref.table, libref.table.column or a directory path)
  • DD_SHORTDESC char(256): Short description
  • DD_LONGDESC char(32767): Long description (Markdown supported)
  • DD_OWNER char(128): Owner of the item
  • DD_RESPONSIBLE char(128): Responsible party for the item
  • DD_SENSITIVITY char(64): Sensitivity classification (e.g. Low)
  • 🔑 TX_TO num: SCD2 close datetime