Layton ServiceDesk - FAQ - Database Column Definitions
(New page) |
m (Changed name of section title to "request Table") |
||
Line 3: | Line 3: | ||
This article documents gives information on the function of various columns. It is not complete. | This article documents gives information on the function of various columns. It is not complete. | ||
− | =request= | + | =request Table= |
==Response== | ==Response== | ||
''Response'' means the Analyst did one of the following: | ''Response'' means the Analyst did one of the following: |
Revision as of 01:07, 7 July 2017
Contents |
Overview
This article documents gives information on the function of various columns. It is not complete.
request Table
Response
Response means the Analyst did one of the following:
- Created a comment
- Added a solution
- Changed the status.
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.
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.
sys_responded
The date and time that the first response was recorded. Subsequent responses are not recorded here.
sys_respondedby
The full name of the user, not username, who generated the first response event. Subsequent responses are not recorded here.