...
Primary key: INSTANCE
Unique index: CORRELATION_ID
Non-unique index: ORIG_CORRELATION_ID
ORCH_REQUEST_PARAMS
The PACE_MASTERDBO.ORCH_REQUEST_PARAMS contains a list of parameters for each orchestration request. Once again, the fact that it is a data driven architecture makes the list of parameters impossible to be predefined. So, most important and common parameters are captured in theĀ ORCHtheĀ ORCH_REQUEST_DEF table and all other parameter parameters are be stored in a one-to-many relationship child table as key-value pairs.
...