The REPORTING_EXECUTIONS table of the reporting database should provide the order history id information

Current Situation

• The REPORTING_EXECUTIONS table contains information about the executed order steps.
  • REPORTING_EXECUTIONS.HISTORY_ID represents the task history id information (corresponds to SCHEDULER_HISTORY.ID) and can be accessed directly by the JOC to receive the execution data of a given task.
  • The order history id information (corresponds to SCHEDULER_ORDER_HISTORY.HISTORY_ID) is not available and can be retrieved only by joining the REPORTING_TRIGGERS table (REPORTING_TRIGGERS.HISTORY_ID).

Desired Behaviour

• The REPORTING_EXECUTIONS table should contain the order history id information to improve query performance.
  • Introducing a new column REPORTING_EXECUTIONS.TRIGGER_HISTORY_ID (corresponds to REPORTING_TRIGGERS.HISTORY_ID)
  • Queries should be optimized with this field.