Skip to content

MPE_LOADS

The MPE_LOADS table tracks the status of CSV file loads processed by the target loader (mpe_targetloader macro), including failures and their reasons.

Columns

  • 🔑 CSV_DIR char(255): The staged folder reference (mperef) containing the CSV files being loaded
  • USER_NM char(50): The user who submitted the load
  • STATUS char(15): The status of the load (e.g. IN PROGRESS, SUCCESS, FAILED)
  • DURATION num: Duration of the load (seconds)
  • PROCESSED_DTTM num: Datetime the load was processed
  • REASON_TXT char(2048): The reason for failure (where applicable)
  • APPROVALS char(64): Approval information for the load