ChangeTaskWorklogs
ServiceDeskPlus change task time tracking and work logging for implementation tracking
Columns
| Name | Type | References | |
| Id [KEY] | Long | ||
| ChangeId | Long |
Changes.Id | |
| TaskId | Long |
ChangeTasks.Id | |
| CurrencyId | Long | ||
| CreatedByDepartmentId | Long | ||
| OwnerDepartmentId | Long | ||
| CreatedBySiteId | Long | ||
| OwnerSiteId | Long | ||
| CreatedById | Long | ||
| OwnerId | Long | ||
| Description | String | ||
| StartTime | Datetime | ||
| EndTime | Datetime | ||
| RecordedTime | Datetime | ||
| CreatedByCostPerHour | Decimal | ||
| CreatedByDepartmentName | String | ||
| CreatedByEmail | String | ||
| CreatedByEmployeeId | Long | ||
| CreatedByFirstName | String | ||
| CreatedByJobTitle | String | ||
| CreatedByLastName | String | ||
| CreatedByMobile | String | ||
| CreatedByName | String | ||
| CreatedByPhone | String | ||
| CreatedByPhotoURL | String | ||
| CreatedBySiteName | String | ||
| CreatedBySmsMailId | String | ||
| CreatedByUserScope | String | ||
| CurrencyCode | String | ||
| CurrencyExchangeRate | Decimal | ||
| CurrencyName | String | ||
| CurrencySymbol | String | ||
| EndTimeDisplay | String | ||
| ExchangeRate | Decimal | ||
| OtherChargeDisplay | String | ||
| OtherChargeSecondaryCurrencySymbol | String | ||
| OtherChargeSecondaryDisplay | String | ||
| OtherChargeCurrencySymbol | String | ||
| OwnerCostPerHour | Decimal | ||
| OwnerDepartmentName | String | ||
| OwnerEmail | String | ||
| OwnerEmployeeId | Long | ||
| OwnerFirstName | String | ||
| OwnerJobTitle | String | ||
| OwnerLastName | String | ||
| OwnerMobile | String | ||
| OwnerName | String | ||
| OwnerPhone | String | ||
| OwnerPhotoURL | String | ||
| OwnerSiteName | String | ||
| OwnerSmsMailId | String | ||
| OwnerUserScope | String | ||
| RecordedTimeDisplay | String | ||
| StartTimeDisplay | String | ||
| TechChargeDisplay | String | ||
| TechChargeSecondaryCurrencySymbol | String | ||
| TechChargeSecondaryDisplay | String | ||
| TechChargeCurrencySymbol | String | ||
| TotalChargeDisplay | String | ||
| TotalChargeSecondaryCurrencySymbol | String | ||
| TotalChargeSecondaryDisplay | String | ||
| TotalChargeCurrencySymbol | String | ||
| IsCreatedBySiteDeleted | Boolean | ||
| IsCreatedBySmsNotifyEnabled | Boolean | ||
| IsCurrencyDeleted | Boolean | ||
| DoesIncludeNonoperationalHours | Boolean | ||
| IsCreatedBySiteDefault | Boolean | ||
| IsCreatedByTechnician | Boolean | ||
| IsCreatedByVipUser | Boolean | ||
| IsOwnerSiteDefault | Boolean | ||
| IsOwnerTechnician | Boolean | ||
| IsOwnerVipUser | Boolean | ||
| IsOwnerSiteDeleted | Boolean | ||
| IsOwnerSmsNotifyEnabled | Boolean | ||
| OtherCharge | Decimal | ||
| OtherChargeSecondaryValue | Decimal | ||
| TechCharge | Decimal | ||
| TechChargeSecondaryValue | Decimal | ||
| TotalCharge | Decimal | ||
| TotalChargeSecondaryValue | Decimal | ||
| TimeSpentHours | Integer | ||
| TimeSpentMinutes | Integer | ||
| TimeSpent | Long | ||
| WorklogType | String |