Skip to content

MPE_EMAILS

The MPE_EMAILS table maps emails to user ids. This is helpful in situations where the email address is not automatically available (eg in SAS metadata or the Viya identities service)

submits

The table is SCD2 controlled for ease of rollback and version management.

For more information, see the email config page.

Columns

  • 🔑 TX_FROM num: SCD2 open datetime
  • 🔑 USER_NAME char(50): The system name of the user
  • USER_DISPLAYNAME char(100): The name by which the user should be addressed
  • USER_EMAIL char(100): The email address of the user
  • TX_TO num: SCD2 close datetime