- Working With Dashboards and Charts
- Working With Process Graphs
- Showing or Hiding the Menu
- Context Information
- Root Cause Analysis
- Sending Automation Ideas to UiPath Automation Hub
- Filters
- Simulating Automation Potential
- Tags
- Due Dates
- Compare
- Export
- Triggering an automation from a process app
- Starting a Task Mining project from Process Mining
- Connector & App Framework 0.8.1 Overview
- Release Process
- Input Tables of TemplateOne 1.0.0
Input Tables of TemplateOne 1.0.0
Introduction
If you want to create a custom SQL connector for TemplateOne 1.0.0 you must make sure that the output data of your connector meets the required input format for TemplateOne 1.0.0.
This page contains an overview of the attributes for each of the input tables of TemplateOne. For each attribute, the name and a data type are displayed. Apart from that, it is indicated whether the attribute is mandatory.
Mandatory and Optional Attributes
Your input data file can have different attributes or different attribute names. However, there are some attributes mandatory for using TemplateOne, which means that the data must be available in your input data file for a correct working of TemplateOne. The mandatory attributes are:
- Activity
- Case ID
- Event end
It is possible that this data is available otherwise in your input file. For example, Event_end can be calculated by combining a date
attribute and a time
attribute containing event end data.
Optional attributes can be used to get more detailed views in TemplateOne.
In the Event log tables in TemplateOne, the attributes are grouped by mandatory and optional attributes.
Tables
Below is an overview of the tables of the TemplateOne data model.
Table |
Mandatory Y/N |
---|---|
Cases_base |
Y |
Event_log_base |
Y |
Tags |
N |
Due_dates |
N |
Cases_base
Below is an overview of the attributes of the Cases-Base
table.
Name |
Data type |
Mandatory Y/N |
Description |
---|---|---|---|
|
Text |
Y |
The unique identifier of the case. |
|
Text |
N |
A user-friendly name to identify the case. |
|
Text |
N |
The categorization of the cases. |
|
Text |
N |
The status of the case in the process. For example, ‘open’, ‘closed’, ‘pending’, ‘approved’, etc. |
|
Double |
N |
A monetary value related to the case. |
Event_log_base
Below is an overview of the attributes of the Event_log_base
table.
Name |
Data type |
Mandatory Y/N |
Description |
---|---|---|---|
|
Text |
Y |
The unique identifier of the case the event belongs to. |
|
Text |
Y |
The name of the event. This describes the step in the process. |
|
Date + time |
Y |
The timestamp associated with the end of executing the event. |
|
Integer |
Y |
A unique identifier of the event. |
|
Date + time |
N |
The timestamp associated with the start of executing the event. |
|
Integer |
N |
If activities take place on the same time (in parallel), you can define their order here. |
|
Text |
N |
The team that executed the event. |
|
Text |
N |
The user who executed the event. |
|
Boolean |
N |
Indicates whether the event is manually executed or automated. |
|
Text |
N |
Information related to the event. |
|
Double |
N |
The costs for executing the event. |
|
Integer |
N |
The amount of time actually spent working for the event given in milliseconds. |
*
If you want to use the Efficiency - Automation dashboard the attributes Event cost
and Event processing time
are mandatory.
Event cost
and Event processing time
are mandatory.
Tags
Tags
table must contain a unique entry for each combination of Case ID
and Tag
.
Below is an overview of the attributes of the Tags
table.
Name |
Type |
Mandatory Y/N |
Description |
---|---|---|---|
|
Text |
N* |
A unique identifier of the case. |
|
Integer |
N* |
A unique identifier of the tag. |
|
Text |
N* |
A user-friendly name to identify the tag. |
*
If you want to use tags in TemplateOne, which can be analyzed using the Compliance - Tags dashboard, the attributes for the Tags
table must be loaded in TemplateOne. In this case, the attributes are mandatory.
Due_dates
Due dates
table must contain a unique entry for each combination of Event_ID
and Due_date
.
Below is an overview of the attributes of the Due_dates
table.
Name |
Type |
Mandatory Y/N |
Description |
---|---|---|---|
|
Text |
N* |
The name of the due date. |
|
Date + Time |
N* |
The timestamp associated with the execution of an event. |
|
Date + Time |
N* |
The timestamp associated with the expected execution of an event. |
|
Integer |
N* |
A unique identifier of the event. |
|
Integer |
N |
The number of days late for the case. |
*
If you want to use due dates in TemplateOne, which can be analyzed using the Compliance - Due dates dashboard, the attributes for the Due dates
table must be loaded in TemplateOne. In this case, the attributes are mandatory.
See also Steps to roll-out TemplateOne.
Attribute Type
Below is an overview of the different attribute types and their default format settings.
Attribute type |
Specification |
---|---|
Boolean |
N/A |
Date |
Format: YYYY-M-D |
DateTime |
Date format: YYYY-M-D Time format: h:mm:ss[[.zzz]] |
Double |
Decimal separator: . (dot) Thousand separator: none |
Integer |
Thousand separator: none |
Text |
N/A |