# Rptprojectsopentasksresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptprojectsopentasksresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountManager` | `string` | Account Manager | ☐ | | | `Activity` | `string` | Activity | ☐ | | | `ActivityType` | `string` | Activity Type | ☐ | | | `Actuals` | `int64` | Actuals | ☑ | | | `Baseline` | `int64` | Baseline | ☑ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `FeeCustomer` | `decimal` | Fee Customer | ☑ | | | `FeeMargin` | `decimal` | Fee Margin | ☑ | | | `FeeResource` | `decimal` | Fee Resource | ☑ | | | `Id` | `int32` | ID | ☑ | | | `LastActualDate` | `datetimeoffset` | Last Actual Date | ☐ | | | `OpenWeeks` | `int32` | Open Weeks | ☑ | | | `ProjectCode` | `string` | Project Code | ☐ | | | `ProjectId` | `int32` | Project ID | ☑ | | | `ProjectManager` | `string` | Project Manager | ☐ | | | `ProjectName` | `string` | Project Name | ☐ | | | `ResourceDepartment` | `string` | Resource Department | ☐ | | | `ResourceId` | `int32` | Resource ID | ☑ | | | `ResourceName` | `string` | Resource Name | ☐ | | | `StartDate` | `datetimeoffset` | Start Date | ☐ | | | `TaskId` | `int32` | Task ID | ☑ | | | `TaskLevel` | `string` | Task Level | ☐ | | | `TaskName` | `string` | Task Name | ☐ | | | `TaskStatus` | `string` | Task Status | ☐ | | | `TimeStatus` | `string` | Time Status | ☐ | | | `TimeToCompletion` | `int64` | Time to Completion | ☑ | | | `TimeToCompletionDays` | `decimal` | Time to Completion Days | ☑ | |