Database tables

The database tables required to operate the exchange service are created with the SQL scripts create_tables_oracle.sql or create_tables_sqlserver.sql.

Table Field Description

systemguid

systemguid

Unique system web service GUID

tasklist

ovhdid

ID of incident that triggered the action

action

Action for the incident (state transitions of status diagram). Can be ProcessIncident, AddInfo, AcceptIncidentProcessing, RejectIncidentSolution, VerifyIncidentSolution, or CloseIncident.

startTimestamp

Creation timestamp of entry.

enqueueTimestamp

Timestamp for ordering of tasks. Initial value is startTimestamp.

earliestReadyTimestamp

Timestamp that specifies the earliest time when this entry can be processed. Empty means
immediately. Task becomes ready only after this time.

state

Task state. Can be 1=READY or 2=INPROCESS (task is processed already).

tries

Number of attempts to complete this task.

guid

GUID of the task to delete the correct entry in database.

sapid

Name of external help desk instance that incident is exchanged with.

runtimedata

incidentguid

GUID of exchanged incident

ovhdincidentid

ID of incident in helpdesk managed by web service

exthdincidentid

ID of incident in the external helpdesk

requesterguid

System GUID of requester helpdesk for that incident

providerguid

System GUID of provider helpdesk for that incident

metadata

Incident state in statement diagram and role the ServiceDesk has for this incident
(Requester or Provider). Stored in the same format used for the Hidden_Meta_Data
field in ServiceDesk (such as Requester:RequesterProcessing, Provider:SolutionProvided).

infologid

Reference to multiple entries in runtimedata_infolog.

attachmentid

Reference to multiple entries in runtimedata_attachments.

lastchange

Timestamp of last change of entry.

runtimedata_infolog

infologid

Key referenced from runtimedata.

infologblock

Number of infolog block sent already.

runtimedata_attachments

attachmentid

Key referenced from runtimedata.

filename

Filename of an attachment for incident.

attachmentguid

GUID for attachment (also known by external helpdesk) to delete attachment.