ProjectResources
Retrieve and modify project resources.
Table Specific Information
To query this table, the ProjectId must be specified either in the query's WHERE clause criteria or via the ProjectId connection property.
SELECT * FROM ProjectResources WHERE ProjectId = '99a38309-dc1d-eb11-bf8a-00155d9c6312'
Columns
Name | Type | ReadOnly | References | Required | Description |
Id [KEY] | String | True | False | ||
ActualCost | Double | True | False | ||
ActualCostWorkPerformed | String | True | False | ||
ActualCostWorkPerformedMilliseconds | Int | True | False | ||
ActualCostWorkPerformedTimeSpan | Time | True | False | ||
ActualOvertimeCost | Double | True | False | ||
ActualOvertimeWork | String | True | False | ||
ActualOvertimeWorkMilliseconds | Int | True | False | ||
ActualOvertimeWorkTimeSpan | Time | True | False | ||
ActualWork | String | True | False | ||
ActualWorkMilliseconds | Int | True | False | ||
ActualWorkTimeSpan | Time | True | False | ||
AvailableFrom | Datetime | True | False | ||
AvailableTo | Datetime | True | False | ||
BaselineCost | Double | True | False | ||
BaselineWork | String | True | False | ||
BaselineWorkMilliseconds | Int | True | False | ||
BaselineWorkTimeSpan | Time | True | False | ||
BudetCostWorkPerformed | Double | True | False | ||
BudgetedCost | Double | True | False | ||
BudgetedCostWorkScheduled | Double | True | False | ||
BudgetedWork | String | True | False | ||
BudgetedWorkMilliseconds | Int | True | False | ||
BudgetedWorkTimeSpan | Time | True | False | ||
Cost | Double | True | False | ||
CostVariance | Double | True | False | ||
CostVarianceAtCompletion | Double | True | False | ||
Created | Datetime | True | False | ||
CurrentCostVariance | Double | True | False | ||
Finish | Datetime | True | False | ||
IsBudgeted | Bool | True | False | ||
IsGenericResource | Bool | True | False | ||
IsOverAllocated | Bool | True | False | ||
Modified | Datetime | True | False | ||
Notes | String | True | False | ||
OvertimeCost | Double | True | False | ||
OvertimeWork | String | True | False | ||
OvertimeWorkMilliseconds | Int | True | False | ||
OvertimeWorkTimeSpan | Time | True | False | ||
PeakWork | String | True | False | ||
PeakWorkMilliseconds | Int | True | False | ||
PeakWorkTimeSpan | Time | True | False | ||
PercentWorkComplete | Int | True | False | ||
RegularWork | String | True | False | ||
RegularWorkMilliseconds | Int | True | False | ||
RegularWorkTimeSpan | Time | True | False | ||
RemainingCost | Double | True | False | ||
RemainingOvertimeCost | Double | True | False | ||
RemainingOvertimeWork | String | True | False | ||
RemainingOvertimeWorkMilliseconds | Int | True | False | ||
RemainingOvertimeWorkTimeSpan | Time | True | False | ||
RemainingWork | String | True | False | ||
RemainingWorkMilliseconds | Int | True | False | ||
RemainingWorkTimeSpan | Time | True | False | ||
ScheduleCostVariance | Double | True | False | ||
Start | Datetime | True | False | ||
Work | String | True | False | ||
WorkMilliseconds | Int | True | False | ||
WorkTimeSpan | Time | True | False | ||
WorkVariance | String | True | False | ||
WorkVarianceMilliseconds | Int | True | False | ||
WorkVarianceTimeSpan | Time | True | False | ||
LinkedCustomFields | String | False | False | ||
LinkedEnterpriseResource | String | False | False | ||
CanLevel | Bool | False | False | ||
Code | String | False | False | ||
CostAccrual | Int | False | False | ||
CostCenter | String | False | False | ||
CostPerUse | Double | False | False | ||
DefaultBookingType | Int | False | False | ||
String | False | False | |||
Group | String | False | False | ||
Initials | String | False | False | ||
MaterialLabel | String | False | False | ||
MaximumCapacity | Double | False | False | ||
Name | String | False | False | ||
OvertimeRate | Double | False | False | ||
OvertimeRateUnits | Int | False | False | ||
Phonetics | String | False | False | ||
StandardRate | Double | False | False | ||
StandardRateUnits | Int | False | False | ||
LinkedAssignments | String | False | False | ||
LinkedDefaultAssignmentOwner | String | False | False | ||
ProjectId [KEY] | String | True | False |
Id of the parent. |