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.