# Rptresourcesactivetasksresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptresourcesactivetasksresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActualCostBudget` | `decimal` | Actual Cost Budget | ☐ | | | `ActualMargin` | `decimal` | Actual Margin | ☐ | | | `ActualMarginPct` | `decimal` | Actual Margin % | ☐ | | | `ActualSalesBudget` | `decimal` | Actual Sales Budget | ☐ | | | `ActualsDays` | `decimal` | Actuals Days | ☐ | | | `ActualsHours` | `int64` | Actuals Hours | ☐ | | | `Age` | `int32` | Age | ☐ | | | `AssignedDays` | `decimal` | Assigned Days | ☑ | | | `AssignedHours` | `int64` | Assigned Hours | ☑ | | | `AvgDaysWeek` | `decimal` | Average Days Week | ☐ | | | `AvgHoursWeek` | `int64` | Average Hours Week | ☐ | | | `BaselineDays` | `decimal` | Baseline Days | ☑ | | | `BaselineHours` | `int64` | Baseline Hours | ☑ | | | `BirthDate` | `datetimeoffset` | Birth Date | ☐ | | | `CostPriceDay` | `decimal` | Cost Price Day | ☐ | | | `CostPriceHour` | `decimal` | Cost Price Hour | ☐ | | | `CustomerId` | `int32` | Customer ID | ☐ | | | `CustomerName` | `string` | Customer Name | ☐ | | | `DefaultSkill` | `string` | Default Skill | ☐ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `EndDateResource` | `datetimeoffset` | End Date Resource | ☐ | | | `EngagementClause` | `boolean` | Engagement Clause | ☐ | | | `FirstName` | `string` | First Name | ☐ | | | `Id` | `int32` | ID | ☑ | | | `LastName` | `string` | Last Name | ☐ | | | `MarginDay` | `decimal` | Margin Day | ☐ | | | `MarginHour` | `decimal` | Margin Hour | ☐ | | | `MarginPctDay` | `decimal` | Margin % Day | ☐ | | | `MSPFeePct` | `decimal` | MSP Fee % | ☐ | | | `NTOMarginPct` | `decimal` | NTO Margin % | ☐ | | | `NTOMarginPerDay` | `decimal` | NTO Margin Per Day | ☐ | | | `OpenDays` | `decimal` | Open Days | ☐ | | | `OpenMargin` | `decimal` | Open Margin | ☐ | | | `OpenRevenue` | `decimal` | Open Revenue | ☐ | | | `OpenWeeks` | `decimal` | Open Weeks | ☐ | | | `PredictedActualsDays` | `decimal` | Predicted Actuals Days | ☐ | | | `PredictedActualsHours` | `int64` | Predicted Actuals Hours | ☐ | | | `ProjectDepartment` | `string` | Project Department | ☐ | | | `ProjectId` | `int32` | Project ID | ☑ | | | `ProjectName` | `string` | Project Name | ☐ | | | `ProjectSalesManager` | `string` | Project Sales Manager | ☐ | | | `ProjectStatus` | `string` | Project Status | ☐ | | | `RegimePct` | `decimal` | Regime Percentage | ☐ | | | `ResourceExternalCode` | `string` | Resource External Code | ☐ | | | `ResourceId` | `int32` | Resource ID | ☑ | | | `ResourceName` | `string` | Resource Name | ☐ | | | `ResourceType` | `string` | Resource Type | ☐ | | | `SalesPriceDay` | `decimal` | Sales Price Day | ☐ | | | `SalesPriceHour` | `decimal` | Sales Price Hour | ☐ | | | `SalesPricePerDayVsRegimePct` | `decimal` | Sales Price Per Day Vs Regime % | ☐ | | | `StartDate` | `datetimeoffset` | Start Date | ☐ | | | `StartDateResource` | `datetimeoffset` | Start Date Resource | ☐ | | | `TaskId` | `int32` | Task ID | ☑ | | | `TaskName` | `string` | Task Name | ☐ | | | `VolumeDiscountPct` | `decimal` | Volume Discount % | ☐ | | | `WorkDays` | `int32` | Work Days | ☐ | |