Plugin installed incorrectly. Rename plugin directory 'swiftmail.backup' to 'swiftmail'.
en:software:dashboard:dashboard_tablestructure
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:software:dashboard:dashboard_tablestructure [2019/04/10 10:38] Semen Bortnik [Explanation of table contents] |
en:software:dashboard:dashboard_tablestructure [2021/07/01 09:52] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== Conditions for an evaluation===== | + | ===== Conditions for an evaluation ===== |
| - | Evaluations are defined by SQL-Statements. Therefor only the following predefined [[en:software:dashboard:dashboard_views|dashboard views]] can be used. | + | Evaluations are defined by SQL-Statements. Therefor only the following predefined [[:en:software:dashboard:dashboard_views|dashboard views]] can be used. |
| ---- | ---- | ||
| Line 27: | Line 27: | ||
| * **is<Placeholder>**contains a true/false value. | * **is<Placeholder>**contains a true/false value. | ||
| * **isArchiv** indicates, whether the object is already archived or not. | * **isArchiv** indicates, whether the object is already archived or not. | ||
| - | ---- | + | —- |
| view_activity | view_activity | ||
| Line 33: | Line 33: | ||
| * **id**: The unique identification number used throughout the entire database | * **id**: The unique identification number used throughout the entire database | ||
| * **activityName**: Name of the activity | * **activityName**: Name of the activity | ||
| - | * **activityDescription** | + | * **activityDescription**: Contains a description of the activity |
| * **clientId**: A number referencing a specific client | * **clientId**: A number referencing a specific client | ||
| * **creationTime**: The exact point in time when the activity was initiated | * **creationTime**: The exact point in time when the activity was initiated | ||
| Line 39: | Line 39: | ||
| * **instanceId**: A number which references an impacted instance in which the activity is active | * **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 | * **activityStart**: The exact point in time when this activity was started | ||
| - | * **activityEnd**: The exact point in time when the activity was finally terminated | + | * **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 here. | * **loopCount**: If the process runs through the activity repeatedly (loops), the runs are saved here. | ||
| * **duration**: contains the activity's maximum and modelled process time. | * **duration**: contains the activity's maximum and modelled process time. | ||
| Line 60: | Line 60: | ||
| === view_definition === | === view_definition === | ||
| - | * **id**: | + | * **id**: The unique identification number used throughout the entire database |
| - | * **definitionName**: | + | * **definitionName**: The name of the process definition |
| - | * **definitionDescription** | + | * **definitionDescription**: Contains a description of the definition |
| - | * **clientId**: | + | * **clientId**: A number referencing a specific client |
| - | * **creationTime**: | + | * **creationTime**: Point in time at which the process definition was [[:en:software:dashboard:en:software:tim:deploy_processdefinition|deployed]] |
| - | * **creationUserId**: | + | * **creationUserId**: The unique ID of the user who [[:wiki.tim-solutions.de:doku.php?id=:en:software:dashboard:en:software:tim:deploy_processdefinition|deployed]] the task instance |
| * **version**: processdefinition's present version | * **version**: processdefinition's present version | ||
| * **escalationStatus**: statement about the process' escalation status | * **escalationStatus**: statement about the process' escalation status | ||
| Line 74: | Line 74: | ||
| === view_effort === | === view_effort === | ||
| - | * **id**: | + | * **id**: The unique identification number used throughout the entire database |
| - | * **effortName**: | + | * **effortName**: The name assigned to the effort |
| * **effortDescription** | * **effortDescription** | ||
| - | * **clientId**: | + | * **clientId**: The number corresponding to the impacted client |
| - | * **creationTime**: | + | * **creationTime**: The point in time at which this effort was made |
| - | * **creationUserId**: | + | * **creationUserId**: The unique ID of the user who is responsible for causing the effort |
| - | * **instanceId**: | + | * **instanceId**: The number corresponding to the impacted instance |
| * **effortType**: type of effort (time or money) | * **effortType**: type of effort (time or money) | ||
| * **effortValue**: value of effort without unit | * **effortValue**: value of effort without unit | ||
| Line 91: | Line 91: | ||
| === view_identity === | === view_identity === | ||
| - | * **id**: | + | * **id**: The unique identification number used throughout the entire database |
| - | * **identityName**: | + | * **identityName**: Contains the name if the identity |
| - | * **clientId**: | + | * **clientId**: A number corresponding to the client at hand |
| - | * **creationTime**: | + | * **creationTime**: The point in time when this identity/user was created |
| - | * **creationUserId**: | + | * **creationUserId**: The number corresponding to of the user who created this user/group/client |
| * **displayName**: contains the full name and username (e.g. **Max Mustermann (M.Muster)**). | * **displayName**: contains the full name and username (e.g. **Max Mustermann (M.Muster)**). | ||
| * **lastLogin**: contains the time, when the user last logged in. | * **lastLogin**: contains the time, when the user last logged in. | ||
| Line 110: | Line 110: | ||
| === view_instance === | === view_instance === | ||
| - | * **id**: | + | * **id**: The unique identification number used throughout the entire database |
| - | * **instanceName**: | + | * **instanceName**: The name of the process instance |
| - | * **instanceDescription**: | + | * **instanceDescription**: Contains a description of the instance |
| - | * **clientId**: | + | * **clientId**: A number affiliated with client of the process instance |
| - | * **creationTime**: | + | * **creationTime**: The point in time at which the process instance was started |
| - | * **creationUserId**: | + | * **creationUserId**: A number corresponding to the user who started this process instance |
| * **creationGroupId **:contains the primary key of the group that started the process | * **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. | * **rootTokenId**: contains the primary key of the current token, that points to the current activity. | ||
| Line 122: | Line 122: | ||
| * **definitionId**: contains a number that points to a processdefinition, which underlies this instance. | * **definitionId**: contains a number that points to a processdefinition, which underlies this instance. | ||
| * **definitionName**: the underlying processdefinition's name | * **definitionName**: the underlying processdefinition's name | ||
| - | * **instanceStart**: | + | * **instanceStart**: This is the exact point in time when the process instance was started |
| - | * **instanceEnd**: | + | * **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. | * **archivationUserId** : contains the primary key that points to the user, which archived this instance. | ||
| * **archivationTime: **point in time, where the processinstance was archived | * **archivationTime: **point in time, where the processinstance was archived | ||
| Line 131: | Line 131: | ||
| === view_swimlane === | === view_swimlane === | ||
| - | * **id**: | + | * **id**:The unique identification number used throughout the entire database |
| - | * **swimlaneName**: | + | * **swimlaneName**: name of the swimlane |
| - | * **clientId**: | + | * **clientId**: A number corresponding to the client at hand |
| * **instanceId**: contains the primary key which points to the corresponding instance. | * **instanceId**: contains the primary key which points to the corresponding instance. | ||
| * **actorId**: contains the primary key that points to the current corresponding user. | * **actorId**: contains the primary key that points to the current corresponding user. | ||
| Line 139: | Line 139: | ||
| === view_task === | === view_task === | ||
| - | * **id**: | + | * **id**: The unique identification number used throughout the entire database |
| - | * **taskName**: | + | * **taskName**:Name of the task |
| - | * **taskDescription**: | + | * **taskDescription**: Contains a description of the task |
| - | * **clientId**: | + | * **clientId**: A number referencing a specific client |
| - | * **creationTime**: | + | * **creationTime**: The exact point in time when the task was initiated |
| - | * **creationUserId**: | + | * **creationUserId**: A number referencing the impacted user |
| - | * **instanceId**: | + | * **instanceId**: A number which references an impacted instance in which the task is active |
| - | * **taskStart**: | + | * **taskStart**: The exact point in time when this task was started |
| - | * **taskEnd**: | + | * **taskEnd**: The exact point in time when the task was finally terminated |
| * **actorId**:contains the primary key that points to the current corresponding user. | * **actorId**:contains the primary key that points to the current corresponding user. | ||
| * **pooledActorId**: contains the primary key that points to the current corresponding group. | * **pooledActorId**: contains the primary key that points to the current corresponding group. | ||
| Line 160: | Line 160: | ||
| === view_token === | === view_token === | ||
| - | * **id**: | + | * **id**: The unique identification number used throughout the entire database |
| - | * **tokenName**: | + | * **tokenName**: The name of the token |
| - | * **clientId**: | + | * **clientId**: A number referencing a specific client |
| * **instanceId**: contains the primary key which points to the corresponding instance. | * **instanceId**: contains the primary key which points to the corresponding instance. | ||
| * **activityId**: contains the primary key which points to the corresponding activity. | * **activityId**: contains the primary key which points to the corresponding activity. | ||
| Line 168: | Line 168: | ||
| === view_variable === | === view_variable === | ||
| - | * **id**: | + | * **id**: The unique identification number used throughout the entire database |
| - | * **variableName**: | + | * **variableName**: Name of the instance variable |
| - | * **clientId**: | + | * **clientId**: A number referencing a specific client |
| * **instanceId**: contains a number which points to the corresponding instance | * **instanceId**: contains a number which points to the corresponding instance | ||
| * **stringValue**: contains the processvariable's content | * **stringValue**: contains the processvariable's content | ||
| Line 180: | Line 180: | ||
| === view_costcenter === | === view_costcenter === | ||
| - | * **id**: | + | * **id**: The unique identification number used throughout the entire database |
| - | * **costcenterName**: | + | * **costcenterName**: Name of the cost center |
| - | * **costcenterDescription**: | + | * **costcenterDescription**: Contains a description of the costcenter |
| - | * **clientId**: | + | * **clientId**: A number referencing a specific client |
| - | * **creationTime**: | + | * **creationTime**: The exact point in time when the cost center was initiated |
| - | * **creationUserId**: | + | * **creationUserId**: A number referencing the user who created the cost center |
| * **hourly**: contains the cost center's hourly pay | * **hourly**: contains the cost center's hourly pay | ||
| * **currency**: contains the cost center's currency | * **currency**: contains the cost center's currency | ||
| === view_systemconfiguration === | === view_systemconfiguration === | ||
| - | * **id**: | + | * **id**: The unique identification number used throughout the entire database |
| - | * **configurationName**: | + | * **configurationName**:The name of the configuration |
| - | * **clientId**: | + | * **clientId**: A number corresponding to the impacted client |
| - | * **creationTime**: | + | * **creationTime**: Contains the creation time of the configuration |
| * **costCenter** : user's cost center from the [[:en:software:tim:userprofil_profile|userprofil]] | * **costCenter** : user's cost center from the [[:en:software:tim:userprofil_profile|userprofil]] | ||
| * **department**: user's department from the[[:en:software:tim:userprofil_profile|userprofil]] | * **department**: user's department from the[[:en:software:tim:userprofil_profile|userprofil]] | ||
| Line 213: | Line 213: | ||
| === view_folder === | === view_folder === | ||
| - | * **id**: | + | * **id**: The unique identification number used throughout the entire database |
| - | * **folderName**: | + | * **folderName**: Name of the folder |
| - | * **clientId**: | + | * **clientId**: A number referencing a specific client |
| - | * **creationTime**: | + | * **creationTime**: Contains the creation time of the folder |
| - | * **creationUserId**: | + | * **creationUserId**: A number referencing the creater |
| * **parentFolderId**: contains a primary key that points to itself and presents a subfolder in the documents | * **parentFolderId**: contains a primary key that points to itself and presents a subfolder in the documents | ||
| - | * **isArchiv**: | + | * **isArchiv**: Shows wether the folder is archived |
en/software/dashboard/dashboard_tablestructure.1554885525.txt.gz · Last modified: 2021/07/01 09:55 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: 2013 T!M Solutions GmbH
