Actions
Ticket actions (notes, updates, and status changes) recorded against tickets in HaloServiceDesk.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| AgentId | Integer |
Agents.Id | |
| UserId | Integer |
Users.Id | |
| TicketId | Integer |
Tickets.Id | |
| ChargeHours | Decimal | ||
| ChargeAmount | Decimal | ||
| DateCreated | Datetime | ||
| NonChargeHours | Decimal | ||
| NonChargeAmount | Decimal | ||
| TravelChargeHours | Decimal | ||
| TravelAmount | Decimal | ||
| MileageAmount | Decimal | ||
| AttachmentCount | Integer | ||
| Colour | String | ||
| ActionDate | Datetime | ||
| IsBillable | Boolean | ||
| IsHiddenFromUser | Boolean | ||
| IsImportant | Boolean | ||
| IsPersonalUnread | Boolean | ||
| NewStatus | Integer | ||
| NewStatusName | String | ||
| Note | String | ||
| NoteHtml | String | ||
| EmailSubject | String | ||
| EmailBody | String | ||
| EmailBodyHtml | String | ||
| OldStatus | Integer | ||
| Outcome | String | ||
| OutcomeId | Integer | ||
| ChargeRate | Integer | ||
| Mileage | Integer | ||
| NonBillableTime | Integer | ||
| TimeTaken | Integer | ||
| TravelTime | Integer | ||
| Unread | Integer | ||
| WhoColour | String | ||
| WhoImgPath | String | ||
| WhoInitials | String | ||
| WhoLastOnline | Datetime | ||
| WhoName | String | ||
| WhoOnlineStatus | Integer | ||
| WhoAgentId | Integer |
Agents.Id | |
| WhoType | Integer | ||
| WhoWith | String | ||
| AssetId | Integer |
Assets.Id | |
| TimeTakenAdjusted | Integer | ||
| PrepayHours | Decimal | ||
| InvoiceNumber | String | ||
| ContractId | Integer | ||
| SlaResponseState | String | ||
| ResponseDate | Datetime | ||
| TargetResponseDate | Datetime | ||
| ArrivalDate | Datetime | ||
| CompletionDate | Datetime | ||
| AppointmentId | Integer | ||
| EmailFrom | String | ||
| EmailTo | String | ||
| EmailCC | String | ||
| EmailDirection | String | ||
| DateEmailed | Datetime | ||
| FromAddressOverride | String | ||
| NewTeam | String | ||
| NewAgent | Integer |
Agents.Id | |
| NewPriority | Integer | ||
| NewTicketType | Integer |
TicketType.Id | |
| NewSlaStatus | Integer | ||
| NewImpact | Integer | ||
| NewUrgency | Integer | ||
| NewFixByDate | Datetime | ||
| NewFollowupDate | Datetime | ||
| NewDeadlineDate | Datetime | ||
| NewCategory1 | String | ||
| NewCategory2 | String | ||
| NewCategory3 | String | ||
| NewCategory4 | String | ||
| NewMatchedKbId | Integer |
KBArticles.Id | |
| IsReviewed | Boolean | ||
| IsReadyForProcessing | Boolean | ||
| IsReplyDirect | Boolean | ||
| IsNewFirstTimeFix | Boolean |