Layton ServiceDesk - FAQ - Database Column Definitions
(New page) |
(Completed section) |
||
| (3 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
__FORCETOC__ | __FORCETOC__ | ||
=Overview= | =Overview= | ||
| − | This article documents | + | This article documents information on the function of various columns. It is not complete. |
| − | =request= | + | =request Table= |
==Response== | ==Response== | ||
| − | '' | + | A ''response'' is defined as one of these actions, performed by the Analyst: |
| − | * | + | *Added a new '''[[Layton ServiceDesk - Viewing and Editing Requests#Adding a Comment|Comment]]''' |
| − | * | + | *Applied a '''[[Layton ServiceDesk - Solution Base|Solution]]''' |
| − | *Changed | + | *Changed Request Status. |
===sys_respond=== | ===sys_respond=== | ||
| Line 24: | Line 24: | ||
===sys_respond_assigned=== | ===sys_respond_assigned=== | ||
| + | If the date and time contained in '''[[#sys_respond|sys_respond]]''' expires, and auto-assignment is performed based on the escalation Analyst in the '''[[Layton ServiceDesk - Settings - Libraries - Priority#Response Time|Response Time settings in Priority]]''', the value of this column will change from ''NULL'' to ''1'', indicating that assignment has been done. | ||
Latest revision as of 05:53, 7 July 2017
Contents |
[edit] Overview
This article documents information on the function of various columns. It is not complete.
[edit] request Table
[edit] Response
A response is defined as one of these actions, performed by the Analyst:
[edit] sys_respond
Based on the Response Time settings in Priority, this is the date and time by which the Analyst has to respond. If not responded to by this time, it will escalate.
[edit] sys_respond_emailed
If email notifications are configured for the above 3 triggers, an integer value corresponding to one of these events will be written to this column to indicate which notification was sent. If the notification for the event is disabled, the value 0 will be written.
[edit] sys_responded
The date and time that the first response was recorded. Subsequent responses are not recorded here.
[edit] sys_respondedby
The full name of the user, not username, who generated the first response event. Subsequent responses are not recorded here.
[edit] sys_respond_assigned
If the date and time contained in sys_respond expires, and auto-assignment is performed based on the escalation Analyst in the Response Time settings in Priority, the value of this column will change from NULL to 1, indicating that assignment has been done.
