ProblemWorklogs
ServiceDeskPlus problem work tracking and time logging for effort measurement
Columns
| Name | Type | References | |
| Id [KEY] | Long | ||
| CurrencyId | Long | ||
| ProblemId | Long |
Problems.Id | |
| CreatedBySiteId | Long | ||
| OwnerSiteId | Long | ||
| CreatedById | Long | ||
| OwnerId | Long | ||
| Description | String | ||
| StartTime | Datetime | ||
| EndTime | Datetime | ||
| RecordedTime | Datetime | ||
| CreatedByDepartment | String | ||
| CreatedByEmail | String | ||
| CreatedByFirstName | String | ||
| CreatedByLastName | String | ||
| CreatedByMobile | String | ||
| CreatedByName | String | ||
| CreatedByPhone | String | ||
| IsCreatedBySiteDeleted | Boolean | ||
| CreatedBySiteName | String | ||
| CreatedBySmsEmail | String | ||
| CurrencyCode | String | ||
| IsCurrencyDeleted | Boolean | ||
| CurrencyExchangeRate | Decimal | ||
| CurrencyName | String | ||
| CurrencySymbol | String | ||
| EndTimeDisplay | String | ||
| ExchangeRate | Decimal | ||
| DoesIncludeNonoperationalHours | Boolean | ||
| IsCreatedBySiteDefault | Boolean | ||
| IsCreatedByTechnician | Boolean | ||
| IsCreatedByVipUser | Boolean | ||
| IsOwnerSiteDefault | Boolean | ||
| IsOwnerTechnician | Boolean | ||
| IsOwnerVipUser | Boolean | ||
| OtherCharge | Decimal | ||
| OtherChargeCurrency | String | ||
| OtherChargeDisplay | String | ||
| OtherChargeSecondaryCurrency | String | ||
| OtherChargeSecondaryDisplay | String | ||
| OtherChargeSecondaryValue | Decimal | ||
| OwnerDepartment | String | ||
| OwnerEmail | String | ||
| OwnerFirstName | String | ||
| OwnerLastName | String | ||
| OwnerMobile | String | ||
| OwnerName | String | ||
| OwnerPhone | String | ||
| IsOwnerSiteDeleted | Boolean | ||
| OwnerSiteName | String | ||
| OwnerSmsEmail | String | ||
| RecordedTimeDisplay | String | ||
| StartTimeDisplay | String | ||
| TechCharge | Decimal | ||
| TechChargeCurrency | String | ||
| TechChargeDisplay | String | ||
| TechChargeSecondaryCurrency | String | ||
| TechChargeSecondaryDisplay | String | ||
| TechChargeSecondaryValue | Decimal | ||
| TimeSpentHours | Integer | ||
| TimeSpentMinutes | Integer | ||
| TimeSpentValue | Long | ||
| TotalCharge | Decimal | ||
| WorklogType | String | ||
| TotalChargeCurrency | String | ||
| TotalChargeDisplay | String | ||
| TotalChargeSecondaryCurrency | String | ||
| TotalChargeSecondaryDisplay | String | ||
| TotalChargeSecondaryValue | Decimal |