Skip to content

MPE_LINEAGE_COLS

The MPE_LINEAGE_COLS table stores column-level lineage - the column mappings derived from jobs registered in SAS DI Studio. See the lineage guide for more details.

Columns

  • 🔑 COL_ID char(32): Unique identifier of the lineage record
  • 🔑 DIRECTION char(1): Lineage direction (e.g. F for forward, R for reverse)
  • JOBNAME char(256): Name of the job in which the mapping was found
  • SOURCETABLENAME char(256): Name of the source table
  • SOURCECOLNAME char(256): Name of the source column
  • 🔑 SOURCECOLURI char(256): URI of the source column
  • 🔑 MAP_TYPE char(256): The type of mapping
  • 🔑 MAP_TRANSFORM char(256): The transformation applied in the mapping
  • TARGETTABLENAME char(256): Name of the target table
  • TARGETCOLNAME char(256): Name of the target column
  • 🔑 TARGETCOLURI char(256): URI of the target column
  • DERIVED_RULE char(500): The derivation rule applied
  • LEVEL num: The depth of the mapping within the lineage tree
  • MODIFIED_DTTM num: Datetime the record was last modified
  • MODIFIED_BY char(64): The user who last modified the record