Projects
Projects and project tasks managed in HaloServiceDesk, representing planned work with time budgets, task hierarchies, and milestone tracking.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| AgentId | Integer |
Agents.Id | |
| ClientId | Integer |
Clients.Id | |
| ParentId | Integer |
Projects.Id | |
| MainProjectId | Integer |
Projects.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 | ||
| 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 | ||
| AppointmentType | Integer | ||
| EndUserStatus | Integer | ||
| StartTimeSlot | Integer | ||
| TargetTimeSlot | Integer | ||
| ImpactLevel | Integer | ||
| Impact | Integer | ||
| Urgency | Integer | ||
| RiskLevel | Integer | ||
| Source | Integer | ||
| MergedIntoId | Integer | ||
| TableType | Integer | ||
| MaximumRestrictedPriority | Integer | ||
| ChildCount | Integer | ||
| AttachmentCount | Integer | ||
| UsefulCount | Integer | ||
| NotUsefulCount | Integer | ||
| ReassignCount | Integer | ||
| Quantity | Integer | ||
| ClosureAgentId | Integer |
Agents.Id | |
| Summary | String | ||
| Details | String | ||
| ClientName | String | ||
| SiteName | String | ||
| UserName | String | ||
| UserEmail | String | ||
| Team | String | ||
| Priority | String | ||
| Category1 | String | ||
| Category1Display | String | ||
| Category2 | String | ||
| Category2Display | String | ||
| Category3 | String | ||
| Category3Display | String | ||
| Category4 | String | ||
| Category4Display | String | ||
| ReportedBy | String | ||
| EmailToList | String | ||
| SLAName | String | ||
| Use | String | ||
| Guid | String | ||
| IdSummary | String | ||
| TicketTags | String | ||
| ServiceStatusNote | String | ||
| OppCompanyName | String | ||
| PurchaseOrderNumber | String | ||
| StartTime | String | ||
| TargetTime | String | ||
| SiteTimezone | String | ||
| SectionTimezone | String | ||
| SlaResponseState | String | ||
| SlaState | String | ||
| WorkflowName | String | ||
| UserDef1 | String | ||
| UserDef2 | String | ||
| UserDef3 | String | ||
| UserDef4 | String | ||
| UserDef5 | String | ||
| ProjectTimeBudget | Decimal | ||
| ProjectTimeActual | Decimal | ||
| ProjectMoneyActual | Decimal | ||
| Estimate | Decimal | ||
| EstimateDays | Decimal | ||
| Cost | Decimal | ||
| OppValueAdjusted | Decimal | ||
| SlaHoldTime | Decimal | ||
| SlaTimeElapsed | Decimal | ||
| TimeTaken | Decimal | ||
| TicketAge | Decimal | ||
| OpenSearchScore | Decimal | ||
| DateOccurred | Datetime | ||
| DateCreated | Datetime | ||
| DateAssigned | Datetime | ||
| LastActionDate | Datetime | ||
| LastUpdate | Datetime | ||
| LastIncomingEmail | Datetime | ||
| RespondByDate | Datetime | ||
| ResponseDate | Datetime | ||
| FixByDate | Datetime | ||
| DateClosed | Datetime | ||
| DateFullyClosed | Datetime | ||
| DeadlineDate | Datetime | ||
| IsProjectInternalTask | Boolean | ||
| IsFlagged | Boolean | ||
| IsRead | Boolean | ||
| IsOnHold | Boolean | ||
| IsInactive | Boolean | ||
| IsSiteInactive | Boolean | ||
| IsAreaInactive | Boolean | ||
| IsVip | Boolean | ||
| IsImportantContact | Boolean | ||
| IsExcludedFromSla | Boolean | ||
| IsReleaseImportant | Boolean | ||
| IsReviewed | Boolean | ||
| IsEverClosed | Boolean | ||
| IsServiceStatusUpdateEnabled | Boolean | ||
| IsInvoiceSeparatelyOverridden | Boolean | ||
| CustomFields | String |