The BAM database contains the following tables.
| Row Name | Value | Null Value |
|---|---|---|
| ouIn | DECIMAL(10) | NOT NULL |
| parentIn | DECIMAL(10) | NOT NULL |
| name | STRING(255) | NOT NULL |
Primary Key: ouIN
| Row Name | Value | NULL Value |
|---|---|---|
| roleIn | DECIMAL(10) | NOT NULL |
| roleID | DECIMAL(10) | NOT NULL |
Primary Key: roleIn
| Row Name | Value | NULL Value |
|---|---|---|
| participantIN | DECIMAL(10) | NOT NULL |
| participantID | STRING(255) | NOT NULL |
| ouIn | DECIMAL(10) | NOT NULL |
| displayName | STRING(255) |
Primary Key: participantIn
Foreign Key: ouin, referenceTable="OUs"
| Row Name | Value | NULL Value |
|---|---|---|
| ouIn | DECIMAL(10) | NOT NULL |
| processIn | DECIMAL(10) | NOT NULL |
| processId | STRING(255) | NOT NULL |
| label | STRING(255) | NOT NULL |
Primary Key: processIn .
Foreign Key: ouIn, referencedTable="OUs" .
| Row Name | Value | NULL Value |
|---|---|---|
| activityIn | DECIMAL(10) | NOT NULL |
| activityId | STRING(255) | NOT NULL |
| processIN | DECIMAL(10) | NOT NULL |
| label | STRING(255) |
Primary Key: activityIn .
Foreign Key: processIn, referencedTable="BAM_Processes" .
This table contains a record of the number of instances, the average time since the instance was created and the average time waiting for the activityIn to be processed. This information is stored for an activity, role, participant, and if applicable, the activity in a subprocess containing the child instances created by the activityIn.
| Row Name | Value | NULL Value | Description |
|---|---|---|---|
| snapshot | TIMESTAMP | NOT NULL | |
| activityIn | DECIMAL(10) | NOT NULL | |
| roleIn | DECIMAL(10) | NOT NULL | |
| participantIn | DECIMAL(10) | NOT NULL | |
| origActivityIn | DECIMAL(10) | NOT NULL | Contains the activityIn (Activity Identification Number) of the subflow or process creation activity that triggers this subprocess. This value is different from only for those activities that are part of a subprocess. |
| waitActivityIn | DECIMAL(10) | NOT NULL | Within a subflow Process Data Mart and Business Activity Monitoring BAM this activity is the subflow or process creation activity that create the instances taken into account in the current record. |
| quantity | DECIMAL(10) | NOT NULL | Specifies the number of instances in the activity waiting to be processed. |
| avgTimeTask | DECIMAL(10) | NOT NULL | Specifies the average time, in seconds, that an instances waits to be processed within the activity. |
| avgTimeProcess | DECIMAL(10) | NOT NULL | Specifies the average time, in seconds, that an instance was created. |
This table contains a record for each instance that is processed in the activityIn , roleIn , and participantIn .
| Row Name | Value | NULL Value | |
|---|---|---|---|
| activityIn | DECIMAL(10) | NOT NULL | |
| roleIn | DECIMAL(10) | NOT NULL | |
| participantIn | DECIMAL(10) | NOT NULL | |
| completionDate | DECIMAL(10) | NOT NULL | Specifies the date when the instance was processed in the activity and flew to the next activity. To maintain the coherence between the data, the completionDate is stored in GMT-0, as there might be different servers running with different hours. |
| taskTime | DECIMAL(10) | NOT NULL | Specifies the total processing time, in seconds, for the instance in the activity. |
| Row Name | Value | NULL Value | Description |
|---|---|---|---|
| processIn | DECIMAL(10) | NOT NULL | |
| completionDate | TIMESTAMP | NOT NULL | Date when the instance reached the End activity of the process. To maintain the coherence between the data, the completionDate is stored as GMT-0 since there might be different servers running with different hours. |
| taskTime | DECIMAL(10) | NOT NULL | Stores the time, in seconds, required to process the instance. |
Foreign Key: processIn, referencedTable="Processes".
This table stores a view of the BAM_WorkLoad table, including the time the BAM updater was last executed.
| Row Name | Value | NULL Value |
|---|---|---|
| lastshapshot | TIMESTAMP | NOT NULL |