Skip to content

MPE_DATALOADS

The MPE_DATALOADS table records an audit entry for every load performed (via the frontend, or via the bitemporal dataloader macros).

Columns

  • 🔑 PROCESSED_DTTM num: Datetime the load completed
  • 🔑 LIBREF char(8): SAS Libref of the target table
  • 🔑 DSN char(32): Target table name
  • 🔑 ETLSOURCE char(100): Source of the load (e.g. the submitting user / service)
  • LOADTYPE char(20): The load type applied (UPDATE, REPLACE, TXTEMPORAL, BITEMPORAL, FORMAT_CAT)
  • CHANGED_RECORDS num: Number of records changed
  • NEW_RECORDS num: Number of records added
  • DELETED_RECORDS num: Number of records deleted
  • DURATION num: Duration of the load (seconds)
  • USER_NM char(50): The user who performed the load
  • MAC_VER char(5): The version of the Data Controller macros used