Input tables of AppOne

Input tables of AppOne in standalone Process Mining and their relationship to the output tables produced by the Basic Connector.

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 [.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 [.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 [.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 [.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.