# Rptprojectsactualhourstaskresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptprojectsactualhourstaskresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Activity` | `string` | Activity | ☐ | | | `ActivityType` | `string` | Activity Type | ☐ | | | `Actuals` | `decimal` | Actuals | ☐ | | | `ActualSalesBudget` | `decimal` | Actual Sales Budget | ☐ | | | `Baseline` | `decimal` | Baseline | ☐ | | | `CurrentSalesBudget` | `decimal` | Current Sales Budget | ☐ | | | `Customer` | `string` | Customer | ☐ | | | `Description` | `string` | Description | ☐ | | | `Difference` | `decimal` | Difference | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsLeaf` | `boolean` | Is Leaf | ☑ | | | `ParentId` | `int32` | Parentid | ☐ | | | `Planned` | `decimal` | Planned | ☐ | | | `PlannedBaselineDifference` | `decimal` | Planned Baseline Difference | ☐ | | | `ProjectCode` | `string` | Project Code | ☐ | | | `ProjectDepartment` | `string` | Project Department | ☐ | | | `ProjectGroup` | `string` | Project Group | ☐ | | | `ProjectId` | `int32` | Project ID | ☑ | | | `ProjectManager` | `string` | Project Manager | ☐ | | | `ProjectName` | `string` | Project Name | ☐ | | | `ResourceInitials` | `string` | Resource Initials | ☐ | | | `Status` | `string` | Status | ☐ | | | `TaskDepartment` | `string` | Task Department | ☐ | | | `TaskId` | `int32` | Task ID | ☑ | | | `TaskName` | `string` | Task Name | ☐ | | | `TaskStatus` | `string` | Task Status | ☐ | | | `TimeToCompletion` | `decimal` | Time to Completion | ☐ | | | `TimeToCompletionDays` | `decimal` | Time to Completion Days | ☐ | |