Process Mining
2021.10
false
Banner background image
Process Mining
Last updated 2 avr. 2024

Input tables of AppOne

Introduction

This pages gives an overview of the input tables of AppOne.

Note: The output tables of the Basic Connector are the same as the input tables of AppOne.

Cases_base

Name

Data type

Mandatory Y/N

Description

Case ID

Text

Y

A unique internal identifier of the case.

Amount

Double

N

A numeric value (Liters, Euro’s, Weight, etc.).

Amount group

Text

N

Group to which the amounts belong (High, Med, Low).

Case

Text

N

While Case ID is the case number, Case can designate a more user-friendly name of a case.

Case department

Text

N

The department of a case.

Case owner

Text

N

The owner of a case (User name, ID, department).

Case type

Text

N

Categorization of a case (Simple case, Complex Case, Case department).

Customer

Text

N

Descriptive field about a case customer (Customer, Brand, Relationship nr, company).

Customer type

Text

N

Group of customers.

Supplier

Text

N

Descriptive field about a supplier (Company, Brand, Relation).

Supplier type

Text

N

Group of suppliers.

Variant type

Text

N

Group of variants.

Case URL

Text

N

URL where more info about each case can be found.

Generic items

Name

Data type

Mandatory Y/N

Generic_case_1

Text

N

Generic_case_2

Text

N

Generic_case_3

Text

N

Generic_case_4

Text

N

Generic_case_5

Text

N

Generic_case_6

Text

N

Generic_case_6

Text

N

Generic_case_7

Text

N

Generic_case_8

Text

N

Generic_case_9

Text

N

Generic_case_10

Text

N

Events_base

Name

Data type

Mandatory Y/N

Description

Activity

Text

Y

The events in a case (Open, Close, Screen X, Document created, etc.)

Case ID

Text

Y

Reference to the unique Case ID in Cases_base.

Event end

Datetime

Y

Format: YYYY-M-D h:mm[:ss[[.zzz]]] the end time of an activity / timestamp of an activity.

Activity order

Integer

N

If activities take place on the same time (in parallel), you can define their order here.

Activity type

Text

N

Grouping of activities (Finance steps, Payments, etc.).

Activity type order

Integer

N

Order of activity type in the legend.

Country

Text

N

Country where the event(activity) took place.

Event cost

Double

N

Cost involved in the execution of the event. For example, employee wages.

Event processing time

Duration

N

Time that is actually worked on the event without taking into account any waiting time.

Event detail

Text

N

Information related to the event.

Event ID

Text

N

Unique identifier of the event.

Event start

Datetime

N

Format: YYYY-M-D h:mm[:ss[[.zzz]]]. If an activity has a start and end time defined you can map the start time of the activity here.

Event URL

Text

N

URL where more info about each event can be found.

Is automated

Boolean

N

Define if the event is automated or not.

Is close activity

Boolean

N

Define if this is an (expected) end/close activity to define the end of a process.

Is open activity

Boolean

N

Define if this is an (expected) start/open activity to define the start of a process.

Team

Text

N

Team which executed the activity.

User

Text

N

User which executed the activity.

Generic items

Name

Data type

Mandatory Y/N

Generic_event_1

Text

N

Generic_event_2

Text

N

Generic_event_3

Text

N

Generic_event_4

Text

N

Generic_event_5

Text

N

Generic_event_6

Text

N

Generic_event_6

Text

N

Generic_event_7

Text

N

Generic_event_8

Text

N

Generic_event_9

Text

N

Generic_event_10

Text

N

Tags_base

Name

Data type

Mandatory Y/N

Description

Case ID

Text

Y

Reference to the unique Case ID in Cases_base.

Comment

Text

N

Description of the tag.

Tag

Text

N

Name of the tag.

Tag score

Text

N

A tag score.

Tag type

Text

N

Tag type (Rework, Inefficiency, Violation, etc).

Due_dates_base

Name

Data type

Mandatory Y/N

Description

Actual date

Datetime

Y

Format: YYYY-M-D h:mm[:ss[[.zzz]]] the end time of the activity / timestamp of the activity, related to the Due date.

Due date

Text

Y

Name of the Due date.

Event ID

Text

Y

Reference to the unique Event ID in Events_base.

Expected date

Datetime

Y

Format: YYYY-M-D h:mm[:ss[[.zzz]]] the date on which the activity should have been finished.

Due date amount

Currency

N

Amount related to the Due date, often this will be a penalty or a discount.

Time bin

Text

N

Description of the bin depending if the activity took place on time or not, e.g. “More than two weeks late”, “One week ahead”.

Reference_models_base

Name

Data type

Mandatory Y/N

Description

Activity

Text

Y

The events of a case.

Reference model

Text

Y

Name of the Reference model.

Trace ID

Text

Y

Numeric value to indicate the order of the activities.

Global_settings

Name

Data type

Mandatory Y/N

Description

Default period

Text

N

Default period for the period filter. If not set, the default will be All.

Dashboard item is expanded by default

Text

N

The History and/or Distribution charts are collapsed by default.

Welcome screen

Text

N

HTML text to be used for the welcome dashboard.

  • Introduction
  • Cases_base
  • Generic items
  • Events_base
  • Generic items
  • Tags_base
  • Due_dates_base
  • Reference_models_base
  • Global_settings

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.