ODBC Driver for Microsoft Project

Build 25.0.9539

DraftAssignments

Retrieve and modify draft assignments.

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 DraftAssignments WHERE ProjectId = '99a38309-dc1d-eb11-bf8a-00155d9c6312'

Insert

The following is an example of inserting into the DraftAssignments table: 

INSERT INTO DraftAssignments (ProjectID, TaskId, ResourceID, Notes, Start, Finish) VALUES ('50ff2a89-98ac-ef11-bbda-00155df00e07', '1e95ac9d-6a2f-f011-819a-00155df0dd09', 'a6b7bfdc-df19-f011-92a0-00155df00d03', 'Test Notes', '2025-05-28', '2025-05-31');

Columns

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

ActualCostWorkPerformed Double False False

ActualOvertimeCost Double False False

BaselineCost Double False False

BaselineCostPerUse Double False False

BaselineFinish Datetime False False

BaselineStart Datetime False False

BaselineWork String False False

BaselineWorkMilliseconds Int False False

BaselineWorkTimeSpan Time False False

BudgetedCostWorkPerformed Double False False

BudgetedCostWorkScheduled Double False False

CostVariance Double False False

CostVarianceAtCompletion Double False False

Created Datetime False False

CurrentCostVariance Double False False

Finish Datetime False False

FinishVariance String False False

FinishVarianceMilliseconds Int False False

FinishVarianceTimeSpan Time False False

IsConfirmed Bool False False

IsOverAllocated Bool False False

IsPublished Bool False False

IsResponsePending Bool False False

IsUpdateNeeded Bool False False

LevelingDelay String False False

LevelingDelayMilliseconds Int False False

LevelingDelayTimeSpan Time False False

Modified Datetime False False

Notes String False False

OvertimeCost Double False False

RemainingCost Double False False

RemainingOvertimeCost Double False False

Resume Datetime False False

ScheduleCostVariance Double False False

Start Datetime False False

StartVariance String False False

StartVarianceMilliseconds Int False False

StartVarianceTimeSpan Time False False

Stop Datetime False False

WorkContourType Int False False

WorkVariance String False False

WorkVarianceMilliseconds Int False False

WorkVarianceTimeSpan Time False False

LinkedCustomFields String False False

ActualCost Double False False

ActualFinish Datetime False False

ActualOvertimeWork String False False

ActualOvertimeWorkMilliseconds Int False False

ActualOvertimeWorkTimeSpan Time False False

ActualStart Datetime False False

ActualWork String False False

ActualWorkMilliseconds Int False False

ActualWorkTimeSpan Time False False

BudgetedCost Double False False

BudgetedWork String False False

BudgetedWorkMilliseconds Int False False

BudgetedWorkTimeSpan Time False False

Cost Double False False

CostRateTable Int False False

DefaultBookingType Int False False

Delay String False False

DelayMilliseconds Int False False

DelayTimeSpan Time False False

IsLockedByManager Bool False False

IsWorkResource Bool False False

OvertimeWork String False False

OvertimeWorkMilliseconds Int False False

OvertimeWorkTimeSpan Time False False

PercentWorkComplete Int False False

RegularWork String False False

RegularWorkMilliseconds Int False False

RegularWorkTimeSpan Time 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

ResourceCapacity Double False False

ResourceId String False False

TaskId String False False

Work String False False

WorkMilliseconds Int False False

WorkTimeSpan Time False False

Owner_Id Int True False

Parent_Id String True False

Resource_Id String True False

Task_Id String True False

LinkedOwner String False False

LinkedParent String False False

LinkedResource String False False

LinkedTask 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 function. This is the default and is recommended. Set to 'ODATA' to use standard ODATA insert functionality. This input is only applicable during inserts. The value set in this input overrides the value set in the InsertMode connection property (see the documentation page for the InsertMode connection property for more information).

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539