View tablestructure

Contains the primary key and is a unique key in the table.

Contains the primary key of the processinstance that corresponds to this object/entry.

Contains the object's name.

Contains the object's description.

Returns the time when the process became active on this object. A task can e.g. be crated earlier and be started at a later point in time.

Returns the time when the process left this object.

Is the entry's creation time.

Contains the primary key (see id) of the user, which created the entry.

Contains a true/false value.

Indicates, whether the object is already archived or not.

id

The unique identification number used throughout the entire database.

activityName

Name of the activity.

activityDescription

Contains a description of the activity.

clientId

A number referencing a specific client.

creationTime

The exact point in time when the activity was initiated.

creationUserId

A number referencing the impacted user.

instanceId

A number which references an impacted instance in which the activity is active.

activityStart

The exact point in time when this activity was started.

activityEnd

The exact point in time when the activity was finally terminated.

loopCount

If the process runs through the activity repeatedly (loops), the runs are saved counted.

duration

Contains the activity's maximum and modeled process time.

escalationTime

Contains the calculated time of the activity's next escalation.

estimatedEnd

Contains the activity's expected end date.

milestoneDate

Contains the time, when the next milestone should be reached.

elapsedTime

Contains the elapsed time for processing the activity.

remainingTime

Contains the time that is left for finishing the activity.

timeBuffer

Contains the calculated buffer for this activity.

calculatedEST

Calculated the earliest start time

calculatedEFT

Calculated earliest finish time

calculatedLST

Calculated latest start time

calculatedLFT

Calculated latest finish time

valueEST

Pure time display of earliest start time (contains Business Calendar)

valueEFT

Pure time display of earliest finish time (contains Business Calendar)

valueLST

Pure time display of latest start time (contains Business Calendar)

valueLFT

Pure time display of latest finish time (contains Business Calendar)

activityType

Returns type of activity:

BESCN - Boundary Escalation Shape Non Interrupting
BESCI - Boundary Escalation Shape Interrupting
BEXI - Boundary Exception Shape
BMSGI - Boundary Message Shape
BS - Boundary Shape
C - Process State Node
D - Decision Node
E - End State
F - Fork Node
H - Halt State
J - Join Node
K - Task Node
L - Milestone Node
M - Mail Node
N - Execute Node Job
R - Start State Node
S - State Node
X - Message Start Event

isMilestone

Indicates, whether the activity is a milestone or not.

inTime

Indicates, whether the activity is still on schedule or not.

isArchive

Indicates, whether the activity is archived or not.

id

The unique identification number used throughout the entire database.

costcenterName

Name of the costcenter.

costcenterDescription

Contains a description of the costcenter.

clientId

A number referencing a specific client.

creationTime

The exact point in time when the costcenter was initiated.

creationUserId

A number referencing the user who created the costcenter.

hourly

Contains the costcenter's hourly pay.

currency

Contains the costcenter's currency.

id

The unique identification number used throughout the entire database.

defintionName

The name of the process definition.

definitionDescription

Contains a description of the definition.

clientId

A number referencing a specific client.

creationTime

Point in time at which the process definition was deployed.

creationUserId

The unique ID of the user who deployed the task instance.

version

Process definitions present version.

escalationStatus

A statement about the process' escalation status.

owner

Process owner (or group).

starter

User or group, who is allowed to start the definition.

deployer

User or group, who as workflow-designer is allowed to deploy the definition.

isArchiv

Indicates, whether the definition is already archived or not.

id

The unique identification number used throughout the entire database.

effortName

The name assigned to the effort.

effortDescription

Contains a description of the effort.

clientId

The number corresponding to the impacted client.

creationTime

The point in time at which this effort was made.

creationUserId

The unique ID of the user who is responsible for causing the effort.

instanceId

The number corresponding to the impacted instance.

effortType

Type of effort (time or money).

effortValue

Value of effort without unit.

timeValue

Contains the time effort.

financeValue

Contains the financial effort and the costcenter's consideration in the moment of capture.

costcenterName

Contains the costcenter, on which the effort was booked.

currency

Contains the currency, with which the effort was booked, in the moment of capture.

hourlyRate

Contains the costcenter's hourly pay in the moment of capture.

parentFolderId

Contains the corresponding folder's primary key.

id

The unique identification number used throughout the entire database.

identityName

Contains the name of the identity.

clientId

A number corresponding to the client at hand.

creationTime

The point in time when this identity/user was created.

creationUserId

The number corresponding to the user who created this user/group/client.

displayName

Contains the full name and username (e.g. John Doe / john.doe).

lastLogin

Contains the time, when the user last logged in.

loginCount

Contains the user's number of logins.

identityType

User's type of identity, can have following values: 'USER', 'GROUP', 'MEMBERSHIP' or 'CLIENT'.

email

User's or group's email-address.

firstname

User's first name.

lastname

User's last name.

parentUserId

Contains a primary key, that points to the group, which belongs to this membership.

userId

Contains a primary key, that points to the user, which belongs to this membership (only affects identityType 'MEMBERSHIP').

userProfileId

Contains the primary key that contains the user profile.

isBlocked

Indicates whether this user/group/client is blocked or not.

isArchiv

Indicates whether this user/group/client is archived or not.

id

The unique identification number used throughout the entire database.

instanceName

The name of the process instance.

instanceDescription

Contains a description of the instance.

clientId

A number affiliated with a client of the process instance.

creationTime

The point in time at which the process instance was started.

creationUserId

A number corresponding to the user who started this process instance.

creationGroupId

Contains the primary key of the group that started the process.

rootTokenId

Contains the primary key of the current token, that points to the current activity.

parentProcessTokenId

Contains the primary key that points to the corresponding main process.

instanceKey

Contains the created value of the YearIDGenerator, if it was used.

definitionId

Contains a number that points to a processdefinition, which underlies this instance.

definitionName

The underlying processdefinition's name.

instanceStart

This is the exact point in time when the process instance was started.

instanceEnd

This is the exact point in time when the process instance was terminated.

archivationUserId

Contains the primary key that points to the user, which archived this instance.

archivationTime

Point in time, where the processinstance was archived.

nextEscalationTime

Contains the calculated time of the process's next escalation.

index1

All indexnames and values which were labeled as indexvalues in the process.

value1

index2

value2

index3

value3

index4

value4

index5

value5

index6

value6

index7

value7

index8

value8

index9

value9