Skip to content

MPE_TABLES

The MPE_TABLES table defines the tables that are EDITABLE - along with attributes such as load type, number of approvals, and hook scripts.

A more detailed breakdown of the columns / features is available in the configuration section.

Columns

  • TX_FROM num: SCD2 open datetime
  • 🔑 TX_TO num: SCD2 close datetime
  • 🔑 LIBREF char(8): SAS Libref (8 chars)
  • 🔑 DSN char(64): The library member name
  • NUM_OF_APPROVALS_REQUIRED num: The number of approvals required (against staged data) before the base table is updated.
  • LOADTYPE char(12): The update method. See config
  • BUSKEY char(1000): The logical key. See config
  • VAR_TXFROM char(32): The SCD2 start column of the base table. See config
  • VAR_TXTO char(32): The SCD2 end column of the base table. See config
  • VAR_BUSFROM char(32): The bitemporal business start column of the base table. See config
  • VAR_BUSTO char(32): The bitemporal business end column of the base table. See config
  • VAR_PROCESSED char(32): A column to contain the batch load time. See config
  • CLOSE_VARS char(500): Close out unloaded records for a key section. See config
  • PRE_EDIT_HOOK char(200): Run SAS code before an EDIT. See config
  • POST_EDIT_HOOK char(200): Run SAS code after an EDIT. See config
  • PRE_APPROVE_HOOK char(200): Run SAS code before an APPROVE. See config
  • POST_APPROVE_HOOK char(200): Run SAS code after final approval (and dataload). See config
  • SIGNOFF_COLS char(200): For marking final approval. See config
  • SIGNOFF_HOOK char(200): Run SAS code after signoff. See config
  • NOTES char(1000): Additional notes. See config
  • RK_UNDERLYING char(1000): The key on which the retained key is generated. See config
  • AUDIT_LIBDS char(41): Configure alternative audit history tracking tables (or switch off audit history). See config