MCP Server for Microsoft Project

Build 25.0.9440

DraftProjectResources

Retrieve and modify draft 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 DraftProjectResources WHERE ProjectId = '99a38309-dc1d-eb11-bf8a-00155d9c6312'

Columns

Name Type ReadOnly References Required Description
Id [KEY] String False False

ActualCost Double False False

ActualCostWorkPerformed String False False

ActualCostWorkPerformedMilliseconds Int False False

ActualCostWorkPerformedTimeSpan Time False False

ActualOvertimeCost Double False False

ActualOvertimeWork String False False

ActualOvertimeWorkMilliseconds Int False False

ActualOvertimeWorkTimeSpan Time False False

ActualWork String False False

ActualWorkMilliseconds Int False False

ActualWorkTimeSpan Time False False

AvailableFrom Datetime False False

AvailableTo Datetime False False

BaselineCost Double False False

BaselineWork String False False

BaselineWorkMilliseconds Int False False

BaselineWorkTimeSpan Time False False

BudetCostWorkPerformed Double False False

BudgetedCost Double False False

BudgetedCostWorkScheduled Double False False

BudgetedWork String False False

BudgetedWorkMilliseconds Int False False

BudgetedWorkTimeSpan Time False False

Cost Double False False

CostVariance Double False False

CostVarianceAtCompletion Double False False

Created Datetime False False

CurrentCostVariance Double False False

Finish Datetime False False

IsBudgeted Bool False False

IsGenericResource Bool False False

IsOverAllocated Bool False False

Modified Datetime False False

Notes String False False

OvertimeCost Double False False

OvertimeWork String False False

OvertimeWorkMilliseconds Int False False

OvertimeWorkTimeSpan Time False False

PeakWork String False False

PeakWorkMilliseconds Int False False

PeakWorkTimeSpan Time False False

PercentWorkComplete Int False False

RegularWork String False False

RegularWorkMilliseconds Int False False

RegularWorkTimeSpan Time False False

RemainingCost Double False False

RemainingOvertimeCost Double False False

RemainingOvertimeWork String False False

RemainingOvertimeWorkMilliseconds Int False False

RemainingOvertimeWorkTimeSpan Time False False

RemainingWork String False False

RemainingWorkMilliseconds Int False False

RemainingWorkTimeSpan Time False False

ScheduleCostVariance Double False False

Start Datetime False False

Work String False False

WorkMilliseconds Int False False

WorkTimeSpan Time False False

WorkVariance String False False

WorkVarianceMilliseconds Int False False

WorkVarianceTimeSpan Time False False

EnterpriseResource_Id String 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

Email 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

DefaultAssignmentOwner_Id Int True False

LinkedAssignments String False False

LinkedDefaultAssignmentOwner String False False

ProjectId [KEY] String True False

Id of the parent. This column only supports equality (=) and IN filters.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
InsertMode String

Determines the Insert Mode. Set to 'ADD' to use standard MSProject Add functions. Set to 'ODATA' to use standard ODATA insert functionality. Only applicable during inserts.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440