===== Conditions for an evaluation ===== Evaluations are defined by SQL statements. Therefore only the following predefined [[:software:dashboard:dashboard_views|database views]] can be used. ---- ===== Explanation of the table contents ===== {{ :dashboard_views.png?332x500}} * **id **always contains the so called primary key and is a unique number in the table * **instanceId ** contains the primary key of the process instance that belongs to the object/entry * **Name** contains the object's name * **Description** contains the object's description * **Start** represents the time when the process got active on this object. A task can be e.g. be created earlier but started later. * **End** represents the time when the process left the object. * **creationTime **is the creation time of the entry * **creationUserId **contains the primary key (see id) of the user that created this entry * **is** beinhaltet immer ein Wahr/Falsch Wert always contains a false/true value * **isArchiv** states if the process was already archived or not ---- view_activity * **id** * **activityName** * **activityDescription** * **clientId** * **creationTime** * **creationUserId** * **instanceId** * **activityStart** * **activityEnd** * **loopCount**: If the prozess runs through the activity more than one time (Loops) the the runs are saved here * **duration**: contains the maximum and modelling processing time of the activity * **escalationTime**: calculated time of the next escalation of the activity * **estimatedEnd**: contains the expected end date of the activity * **mileStoneDate**: time when the milestone should be reached * **elapsedTime**: contains the elapsed time for processing the activity * **timeBuffer**: calculated buffer for the activity * **calculatedEST**: [[en:support:cpm|calculated earliest start]] * **calculatedEFT**: [[en:support:cpm|calculated earliest end]] * **calculatedLST**: [[en:support:cpm|calculated latest start]] * **calculatedLFT**: [[en:support:cpm|calculated latest end]] * **valueEST**: pure time display of [[en:support:cpm|earliest start]] (contains [[:software:tim:calendar_profile|Business Calender]]) * **valueEFT**: pure time display of [[en:support:cpm|earliest end]] (contains [[:software:tim:calendar_profile|Business Calender]]) * **valueLST**: pure time display of [[en:support:cpm|latest start]] (contains [[:software:tim:calendar_profile|Business Calender]]) * **valueLFT**: pure time display of [[en:support:cpm|latest end]] (contains [[:software:tim:calendar_profile|Business Calender]]) * **activityType**: gives back the kind of activity (ScriptNode, Tasknode, Mailnode,…) * **isMilestone**: states if the activity is a milestone or not * **inTime**: states if the activity is still in schedule/timetable === view_definition === * **id**: * **definitionName**: * **definitionDescription** * **clientId**: * **creationTime**: * **creationUserId**: * **version**: version in which the process definition exists * **escalationStatus**: information on the escalation status of the process * **owner**: process owner * **starter**: user or group who is allowed to start the definition * **deployer**: user or group who is allowed to deploy the definition * **isArchiv**: states if the definition is archived or not === view_effort === * **id**: * **effortName**: * **effortDescription** * **clientId**: * **creationTime**: * **creationUserId**: * **instanceId**: * **effortType**: kind of effort (time or money) * **effortValue**: value of the effort without unit * **timeValue: **contains the time effort * **financeValue **contains the financial effort and takes into account the cost center at the moment of capture * **costcenterName**: contains the cost center on which the effort was booked * **currency: **contains the curreny with which the effort was booked in the moment of capture * **hourlyRate **contains the hourly rate of the cost center at the moment of capture * **parentFolderId**: contains the primary key of the corresponding folder === view_identity === * **id**: * **identityName**: * **clientId**: * **creationTime**: * **creationUserId**: * **displayName**: contains the full name and username (e.g. **Max Mustermann (M.Muster)**) * **lastLogin**: contains the tim at which the user last logged in * **identityType**: type of identity/user can have the following values 'USER','GROUP','MEMBERSHIP','ROLE' or 'CLIENT' * **email**: e-mail adress of the user or group * **firstname**: user's first name * **lastname**: user's last name * **parentUserId**: contains the primary key which points to the group that belongs to this membership * **userID** : contains the primary key which points to the user that belongs to this membership (only affects identityType 'MEMBERSHIP') * **userProfileId**: Enthält den Primärschlüssel, der das Benutzerprofils beinhaltet contains the primary key which points to the userprofile * **isBlocked**: states if this user/group/client is blocked or not * **isArchiv**: states if this user/group/client is archived or not === view_instance === * **id**: * **instanceName**: * **instanceDescription**: * **clientId**: * **creationTime**: * **creationUserId**: * **creationGroupId **contains the primary key of the group that started the process * **rootTokenId**: contains the primary key of the current token which points to the current activity * **parentProcessToken**: contains the primary key which points to the corresponding main process * **instanceKey**: contains the generated value of the [[en:software:tim:actionhandler:yearidgenerator|YearIDGenerator]], if it is used * **definitionId**: contains the number that points to the processdefinition, which underlies this instance * **definitionName**: the name of the underlying processdefinition * **instanceStart**: * **instanceEnd**: * **archivationUserId** : contains the primary key which points to the user, who archived this instance * **archivationTime: **time at which the processinstance was archived * **nextEscalationTime**: contains the calculated time of the next escalationof the process * **index1-10 und value1-10**: all index names and values which are declared as indexvalues in the process * **isInTime**: states if the process is still on schedule or if milestones/processing time are not possible anymore * **isArchiv**: states if the process instance is archived or not === view_swimlane === * **id**: * **swimlaneName**: * **clientId**: * **instanceId**: contains the primary key that points to the corresponding instance * **actorId**: contains the primary key that points to the currently corresponding user * **pooledActorId**: contains the primary key which points to the corresponding group === view_task === * **id**: * **taskName**: * **taskDescription**: * **clientId**: * **creationTime**: * **creationUserId**: * **instanceId**: * **taskStart**: * **taskEnd**: * **actorId**: contains the primary key that points to the currently corresponding user * **pooledActorId**: contains the primary key that points to the currently corresponding group * **activityId**: contains the primary key that points to the superordinate activity * **parentFolderId**: contains the primary key that points to the corresponding folder * **swimlaneId**: contains the primary key that points to the swimlane in which the task lies * **remainingTime**: contains the remaining processing time of this task * **elapsedTime**: contains the elapsed processing time * **isOpen**: states if the task is finished already (Attention! signalling methods don't always finish tasks) * **isAdhoc**: states if this task was created as an [[en:software:tim:ad_hoc_tasks|AdHoc-task]] or not * **isArchiv**: === view_token === * **id**: * **tokenName**: * **clientId**: * **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 the sub-token. If the roottoken is on a closing AND gateway, a sub-token per input/output is found === view_variable === * **id**: * **variableName**: * **clientId**: * **instanceId**: contains a number which points to the corresponding instance * **stringValue**: contains the content of the process variable * **label**: contains the corresponding label for the process variable === view_role === * **identityId**: contains the primary key which points to the currently corresponding user * **roleId**: contains the primary key which points to the corresponding role === view_costcenter === * **id**: * **costcenterName**: * **costcenterDescription**: * **clientId**: * **creationTime**: * **creationUserId**: * **hourly**: contains the hourly rate of the cost center * **currency**: contains the currency that is lodged in the cost center === view_systemconfiguration === * **id**: * **configurationName**: * **clientId**: * **creationTime**: * **costCenter** : cost center of the user from the [[en:software:tim:userprofil_profile|userprofile]] * **department**: department of the user from the [[en:software:tim:userprofil_profile|userprofile]] * **personnelNumber** : personnel number of the user from the [[en:software:tim:userprofil_profile|userprofile]] * **phoneNumber** : telephone number of the user from the [[en:software:tim:userprofil_profile|userprofile]] * **tableRowCount** : Field "Display table rows" from the [[en:software:tim:userprofil_profile|userprofile]] * **timezoneOffset** : timezone of the user * **lastModificationTime**: contains the last time the profile was edited * **lastModificationUserId**: contains the primary key of the user that did the last changes * **defaultRepresentativeId** : contains the primary key that point to the user that is lodged as representative in the [[en:software:tim:userprofil_profile|userprofile]] * **departmentChiefId**: contains the primary key that points to the user that is lodged as the department chief in the [[en:software:tim:userprofil_profile|userprofile]] * **supervisorId** : contains the primary key that points to the user that is lodged as the supervisor in the [[en:software:tim:userprofil_profile|userprofile]] * **companyId** : Field "Company ID in the [[en:software:tim:userprofil_profile|userprofile]] * **companyName**: Field "Company Name" in the [[en:software:tim:userprofil_profile|userprofile]] * **country**: Field "Country" in the [[en:software:tim:userprofil_profile|userprofile]] * **isNotifingByMail**: Field "Email-Notification preferred" in the [[en:software:tim:userprofil_profile|userprofile]] or in the [[en:software:tim:client_profile|clientprofil]] * **isNotifingAsignee**: Field "Notify asignee if his task is done by somebody else" in the [[en:software:tim:userprofil_profile|userprofile]] * **isIgnoringLDAPAuth**: Field "ignore LDAP authentication" in the [[en:software:tim:userprofil_profile|userprofile]] === view_folder === * **id**: * **folderName**: * **clientId**: * **creationTime**: * **creationUserId**: * **parentFolderId**: contains the primary key which points to itself and represents a subfolder in the documents * **isArchiv**: