Tickets

Support tickets raised in HaloServiceDesk, representing incidents, requests, and service interactions.

Columns

Name	Type	References
Id [KEY]	Integer
Summary	String
Details	String
DetailsHtml	String
ChangeInformationHtml	String
Use	String
Guid	String
IdSummary	String
TicketTags	String
ServiceStatusNote	String
Team	String
Priority	String
ClientName	String
SiteName	String
UserName	String
UserEmail	String
SLAName	String
WorkflowName	String
ReportedBy	String
TakenBy	String
SupplierName	String
EmailToList	String
StartTime	String
TargetTime	String
SiteTimezone	String
SectionTimezone	String
TimezoneName	String
SlaResponseState	String
SlaState	String
PurchaseOrderNumber	String
OppCompanyName	String
OppContactName	String
OppEmailAddress	String
OppTel	String
OppAddress1	String
OppAddress2	String
OppAddress3	String
OppAddress4	String
OppPostcode	String
OppCountry	String
OppRegion	String
OppType	String
OppTimezoneName	String
ProductName	String
PhoneNumber	String
PhoneNumberFrom	String
AddressFrom	String
MessageSent	String
BackoutPlan	String
CommunicationPlan	String
TestPlan	String
RiskDescription	String
ImpactDescription	String
ApprovalProcessStepName	String
ApprovalProcessGroupName	String
PagerDutyId	String
PagerDutyIncidentIdString	String
MailEntryId	String
CustomerRelationships	String
UserDef1	String
UserDef2	String
UserDef3	String
UserDef4	String
UserDef5	String
Category1	String
Category1Display	String
Category2	String
Category2Display	String
Category3	String
Category3Display	String
Category4	String
Category4Display	String
AgentId	Integer	Agents.Id
ClientId	Integer	Clients.Id
ParentId	Integer	Tickets.Id
PriorityId	Integer
SLAId	Integer
SiteId	Integer	Sites.Id
StatusId	Integer	Status.Id
TeamId	Integer	Teams.Id
TicketTypeId	Integer	TicketType.Id
UserId	Integer	Users.Id
OrganisationId	Integer
DepartmentId	Integer
TeamDepartmentId	Integer
MatchedKbId	Integer	KBArticles.Id
ProductId	Integer
ReleaseId	Integer
Release2Id	Integer
Release3Id	Integer
WorkflowId	Integer
WorkflowStep	Integer
WorkflowSeq	Integer
PipelineStageId	Integer
ItilRequestTypeId	Integer
ReleaseNoteGroupId	Integer
SupplierStatus	Integer
SupplierContractId	Integer
AppointmentType	Integer
EndUserStatus	Integer
StartTimeSlot	Integer
TargetTimeSlot	Integer
ImpactLevel	Integer
Impact	Integer
Urgency	Integer
Source	Integer
RiskLevel	Integer
ParentStatus	Integer
MergedIntoId	Integer
MainProjectId	Integer	Tickets.Id
TableType	Integer
MaximumRestrictedPriority	Integer
ChildCount	Integer
AttachmentCount	Integer
UsefulCount	Integer
NotUsefulCount	Integer
ReassignCount	Integer
Quantity	Integer
ClosureAgentId	Integer	Agents.Id
CreatedFromId	Integer
TopLevelId	Integer
SiteSlaId	Integer
ChangeSeq	Integer
MailboxId	Integer
ChargeRate	Integer
LastStatusChangeInformed	Integer
LastStatusChangeInformedManager	Integer
AuditStatus	Integer
AuditUnum	Integer
SendPrintRequest	Integer
PagerDutyStatus	Integer
ComponentId	Integer
VersionId	Integer
Currency	Integer
ProjectConsignmentHeaderId	Integer
ProjectConsignmentDetailId	Integer
ServiceFailurestId	Integer
HdId	Integer
MatchedRuleId	Integer
TimeTaken	Decimal
SlaTimeElapsed	Decimal
SlaHoldTime	Decimal
Estimate	Decimal
EstimateDays	Decimal
Cost	Decimal
OppValueAdjusted	Decimal
ProjectTimeBudget	Decimal
ProjectTimeActual	Decimal
ProjectMoneyActual	Decimal
TicketAge	Decimal
OpenSearchScore	Decimal
DeadlineNotificationHours	Decimal
DateOccurred	Datetime
DateCreated	Datetime
LastUpdate	Datetime
DateAssigned	Datetime
LastActionDate	Datetime
LastIncomingEmail	Datetime
RespondByDate	Datetime
ResponseDate	Datetime
FixByDate	Datetime
DateClosed	Datetime
DateFullyClosed	Datetime
DeadlineDate	Datetime
WorkflowStepStarted	Datetime
AuditDate	Datetime
IsFlagged	Boolean
IsInactive	Boolean
IsOnHold	Boolean
IsRead	Boolean
IsVip	Boolean
IsImportantContact	Boolean
IsSiteInactive	Boolean
IsAreaInactive	Boolean
IsExcludedFromSla	Boolean
IsReleaseImportant	Boolean
IsProjectInternalTask	Boolean
IsReviewed	Boolean
IsEverClosed	Boolean
IsServiceStatusUpdateEnabled	Boolean
IsInvoiceSeparatelyOverridden	Boolean
IsSupplierBreachResponseSent	Boolean
IsSupplierBreachFixBySent	Boolean
IsVisibleToUsers	Boolean
IsAgreedCleared	Boolean
IsSurveySent	Boolean
IsSurveyNeeded	Boolean
IsThirdPartySystemNotified	Boolean
IsKnownError	Boolean
IsDevelopment	Boolean
IsActionBillableByDefault	Boolean
IsInboundUpdatesForwarded	Boolean
IsLoggedOutsideWorkingHours	Boolean
IsAccountManagerSurveyInformed	Boolean
IsOppExcludedFromMailingList	Boolean
IsDeleted	Boolean
IsKbMatchIgnored	Boolean
IsShownOnRoadmap	Boolean
PriorityObject	String
UserObject	String
TicketTypeObject	String
DeliveryAddress	String
BillingAddress	String
CustomFields	String