Skip to content

MPE_LINEAGE_TABS

The MPE_LINEAGE_TABS table stores table-level lineage - the table-to-table relationships derived from jobs registered in SAS DI Studio. See the lineage guide for more details.

Columns

  • TX_FROM num: SCD2 open datetime
  • 🔑 TX_TO num: SCD2 close datetime
  • 🔑 JOBID char(17): Identifier of the job in which the relationship was found
  • JOBNAME char(128): Name of the job
  • 🔑 SRCTABLEID char(17): Identifier of the source table
  • SRCTABLETYPE char(16): Type of the source table
  • SRCTABLENAME char(64): Name of the source table
  • SRCLIBREF char(8): Libref of the source table
  • 🔑 TGTTABLEID char(17): Identifier of the target table
  • TGTTABLETYPE char(16): Type of the target table
  • TGTTABLENAME char(64): Name of the target table
  • TGTLIBREF char(8): Libref of the target table