NJAMS_T_MONITOR_MAIN holds meta-data about each process instance, such as its start and end time.

The following is the description of each of the columns. Note that this table structure is subject to change.

LOGID: internal ID to uniquely identify the process instance

CORRELATIONLOGID: ID to correlate discrete process instances

PARENTLOGID: ID to correlate the caller-stack of discrete process instances

EXTERNALLOGID: an external reference ID (customer’s typically store IDs from external systems, such as SAP, here for faster lookups)

JOBID: the original BW Job ID

MACHINENAME: the BW host this process instance was executed on

BUSINESSSERVICE: the configured business service, as visible in the Business View

BUSINESSOBJECT: the configured business object, as visible in the Business View

BUSINESSSTART: a custom timestamp to set the start time of the business process, if it does not start in BW

BUSINESSEND: a custom timestamp to set the end time of the business process, if it does not end in BW

JOBSTART: the timestamp of when BW started this process instance

JOBEND: the timestamp of when BW terminated this process instance

CUSTOMID: not used

STATUS: the process’ result: 0 = running, 1 = success, 2 = warning, 3 = error

LASTEVENTSTATUS: the last recorded event severity for this process instance: 0 = running, 1 = success, 2 = warning, 3 = error

DURATION_MS: in milliseconds, the lifetime of the job instance

DOMAIN_OBJECT_ID: foreign key to uniquely identify this process definition within the BWPM instance; lookup data is stored in NJAMS_T_DOMAIN_OBJECTS

STATTIME: the minute timestamp of when this process instance was started