Tables description
Glossary
The following terms are necessary to interpret some information in the tables :
- Case: A distinct and unique identifier of a specific process. Mandatory described in the mapping of a new project, its present on all events of a process
- Process key: an identifier of all similar Cases (topologically similar : all cases following the same sequence of Activities). Example: A, followed by B, followed by C.
- Graph key (a.k.a Variant): an identifier of all similar Process keys. (topologically similar, but including different loop repetitions inside the graph). Example: looping 3 times on the same path will lead to a different process key than looping 5 times, but all those processes will share the same graph key.
Table cases
This table is named with the identifier of the project followed by an hyphen and the data version number (Example: "b7bd7acb-6a13-44a9-bebb-26f8e7e96c48-1") and contains informations based on case data.
| Name | Type | Description |
|---|---|---|
| __time | Timestamp | start date of the first case event |
| enddate | Long | end date of the last case event |
| duration | Long | case duration in milliseconds |
| graphkey | UUID | variant id the case belongs to |
| processkey | UUID | process id the case belongs to |
| caseid | String | case unique identifier |
| active_duration | Long | case activity duration |
| concurrency | Double | case concurrency rate |
| rework | Long | case total rework |
| <metric-slug>_lpkr | Double | aggregated value of the metric at the case level |
| <dimension-slug>_lpkr | String | aggregated value of the dimension at the case level |
| all_<dimension-slug>_lpkr | String | array of all (non-deduplicated) values of the dimension at the case level, sorted in order of arrival in the case (start date, end date, name) |
Table _vertex
This table is named with the identifier of the project followed by an hyphen and the data version number, and suffixed by _vertex. (Example: "b7bd7acb-6a13-44a9-bebb-26f8e7e96c48-1_vertex")
This table contains task (vertex) level information.
| Name | Type | Description |
|---|---|---|
| ingestion_timestamp | Long | insertion timestamp |
| __time | Timestamp | task start date |
| enddate | Long | task end date |
| duration | Long | task duration in milliseconds |
| graphkey | UUID | variant id the task’s case belongs to |
| processkey | UUID | process id the task’s case belongs to |
| caseid | String | identifier of the task’s case |
| vertex_id | UUID | task non-unique identifier based on task name (two identical task names has same vertex_id) |
| task_id | UUID | task unique id |
| vertex_name | String | task name (null for Start and End vertices) |
| <metric-slug>_lpkr | Double | metric value for the event |
| <dimension-slug>_lpkr | String | dimension value for event |
| case_<metric-slug>_lpkr | Double | aggregated value of the metric for the case |
| case_<dimension-slug>_lpkr | Multi String | aggregated value of the dimension for the case |
| concurrent_vertices | Multi UUID | concurrent tasks non-unique ids |
| loop_path | Multi UUID | for a loop starting and finishing with vertex_id, non-unique ids of links composing the loop |
| occurrences_in_case | Long | number of times a the task appears in the case (based on task name) |
| rework | Long | number of repetitions of the task (without concurrency) in the case |
Table _simplifiedEdge
This table is named with the identifier of the project followed by an hyphen and the data version number, and suffixed by _simplifiedEdge. (Example: "b7bd7acb-6a13-44a9-bebb-26f8e7e96c48-1_simplifiedEdge")
This table contains information at the simplified edge level (simplified edges from an event A to an event B).
Simplified means that the graph description is a Direct Follower Graph (DFG), and do not include intermediary gateways (XOR, AND) of BPMN-like notation.
| Name | Type | Description |
|---|---|---|
| __time | Timestamp | edge start date (end of event A) |
| enddate | Long | edge end date (start of event B) |
| duration | Long | edge duration in milliseconds |
| graphkey | UUID | variant id the edge’s case belongs to |
| processkey | UUID | process id edge’s case belongs to |
| caseid | String | identifier of the edge’s case |
| edge_id | UUID | edge non-unique identifier based on edge name (two identical edges names have the same edge_id) |
| edge_name | String | edge name (A->B) |
| start_taskid | UUID | unique identifier of the starting task A |
| start_vertexid | UUID | non-unique identifier of the starting task A |
| start_vertexname | String | name of starting task A |
| end_taskid | UUID | unique identifier of the end task B |
| end_vertexid | UUID | non-unique identifier of the end task B |
| end_vertexname | String | name of end task B |
| <metric-slug>_lpkr_source | Double | task A metric value |
| <metric-slug>_lpkr_destination | Double | task B metric value |
| <dimension-slug>_lpkr_source | String | task A dimension value |
| <dimension-slug>_lpkr_destination | String | task B dimension value |
| case_<metric-slug>_lpkr | Double | aggregated value of the metric at the case level |
| case_<dimension-slug>_lpkr | Multi String | aggregated value of the dimension at the case level |
| concurrentEdges | Multi UUID | non-unique ids of concurrent links |
| occurrences_in_case | Long | number of times the link appears in the case (based on the link name) |
| rework | Long | number of repetitions of the link (without concurrency) in the case |