View tablestructure

id

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

instanceId

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

<placeholder>Name

Contains the object's name.

<placeholder>Description

Contains the object's description.

<placeholder>Start

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.

<placeholder>End

Returns the time when the process left this object.

creationTime

Is the entry's creation time.

creationUserId

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

is<Placeholder>

Contains a true/false value.

isArchiv

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 (ScriptNode, Tasknode, Mailnode, …).

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

index10

value10

isArchiv

Statement whether the process instance is already archived or not.

identityId

Contains the primary key that points to the current corresponding user.

roleId

Contains the primary key that points to the current corresponding role.

id

The unique identification number used throughout the entire database.

name

Name of the swimlane.

clientId

A number corresponding to the client at hand.

instanceId

Contains the primary key which points to the corresponding instance.

actorId

Contains the primary key that points to the current corresponding user.

pooledActorId

Contains the primary key that points to the corresponding group.

id

The unique identification number used throughout the entire database.

configurationName

The name of the configuration.

clientId

A number corresponding to the impacted client.

creationTime

Contains the creation time of the configuration.

costCenter

User's costcenter from the user profile.

department

User's department from the user profile.

personnelNumber

User's personnel number from the user profile.

phoneNumber

User's telephone number from the user profile.

tableRowCount

Field “display table rows” from the user profile.

timezoneOffset

User's timezone.

lastModificationTime

Contains the time, when the profile was last edited.

lastModificationUserId

Contains the primary key of the user that last edited the profile.

defaultRepresentativeId

Contains the primary key of the user that is lodged as the representative in the user profile.

departmentChiefId

Contains the primary key of the user that is lodged as the department chief in the user profile

supervisorId

Contains the primary key of the user that is lodged as the supervisor in the user profile.

companyId

Field “Company ID” from the user profile.

companyName

Field “Company Name” from the user profile.

country

Field “Country” from the user profile.

isNotifyByMail

Field “Email-Notification preferred” from the user profile or from the client profile.

isNotifyAsignee

Field “Notify assignee if his task is done by somebody else” from the user profile.

isIgnoringLDAPAuth

Field “ignore LDAP authentication” from the user profile.

id

The unique identification number used throughout the entire database.

taskName

Name of the task.

taskDescription

Contains a description of the task.

clientId

A number referencing a specific client.

creationTime

The exact point in time when the task was initiated.

creationUserId

A number referencing the impacted user.

instanceId

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

taskStart

The exact point in time when this task was started.

taskEnd

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

actorId

Contains the primary key that points to the current corresponding user.

pooledActorId

Contains the primary key that points to the current corresponding group.

activityId

Contains the primary key that points to the superordinate activity.

parentFolderId

Contains the corresponding folder's primary key.

swimlaneId

Contains the primary key that points to the swimlane, in which the task lies.

remainingTime

Contains the remaining time for processing the activity.

elapsedTime

Contains the elapsed time for processing the activity.

isOpen

Indicates whether the task is finished or not (Attention! Signal-Methods often do not finish tasks!).

isAdhoc

Indicates whether this task was created as an AdHoc task or not.

isArchiv

Statement whether the process instance is already archived or not.

id

The unique identification number used throughout the entire database.

tokenName

The name of the token.

clientId

A number referencing a specific client.

instanceId

Contains the primary key which points to the corresponding instance.

activityId

Contains the primary key which points to the corresponding activity.

parentTokenId

Contains the primary key which points to a sub-token. If the Root Token is on a closing AND gateway, a sub-token is found for each entry / exit.

id

The unique identification number used throughout the entire database.

variableName

Name of the instance variable.

clientId

A number referencing a specific client.

instanceId

Contains a number which points to the corresponding instance.

stringvalue

Contains the process variable's content.

label

Contains the process variables corresponding label.