Skip to content

MPE_SIGNOFFS

The MPE_SIGNOFFS table is designed to record signoffs - the final approval step associated with SIGNOFF access (see MPE_SECURITY and SIGNOFF_COLS).

Note

This table is created as part of the Data Controller data model but is not currently populated by any Data Controller service. It is reserved for custom signoff implementations.

Columns

  • 🔑 TECH_FROM_DTTM num: SCD2 open datetime
  • 🔑 SIGNOFF_TABLE char(50): The table being signed off
  • 🔑 SIGNOFF_SECTION_RK num: The retained key of the section being signed off
  • SIGNOFF_VERSION_RK num: The retained key of the version being signed off
  • SIGNOFF_NAME char(100): The name of the user performing the signoff
  • TECH_TO_DTTM num: SCD2 close datetime