JDBC Driver for Microsoft Project

Build 24.0.9062

Assignments

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

Columns

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

ActualCostWorkPerformed Double True False

ActualOvertimeCost Double True False

BaselineCost Double True False

BaselineCostPerUse Double True False

BaselineFinish Datetime True False

BaselineStart Datetime True False

BaselineWork String True False

BaselineWorkMilliseconds Int True False

BaselineWorkTimeSpan Time True False

BudgetedCostWorkPerformed Double True False

BudgetedCostWorkScheduled Double True False

CostVariance Double True False

CostVarianceAtCompletion Double True False

Created Datetime True False

CurrentCostVariance Double True False

Finish Datetime True False

FinishVariance String True False

FinishVarianceMilliseconds Int True False

FinishVarianceTimeSpan Time True False

IsConfirmed Bool True False

IsOverAllocated Bool True False

IsPublished Bool True False

IsResponsePending Bool True False

IsUpdateNeeded Bool True False

LevelingDelay String True False

LevelingDelayMilliseconds Int True False

LevelingDelayTimeSpan Time True False

Modified Datetime True False

Notes String True False

OvertimeCost Double True False

RemainingCost Double True False

RemainingOvertimeCost Double True False

Resume Datetime True False

ScheduleCostVariance Double True False

Start Datetime True False

StartVariance String True False

StartVarianceMilliseconds Int True False

StartVarianceTimeSpan Time True False

Stop Datetime True False

WorkContourType Int True False

WorkVariance String True False

WorkVarianceMilliseconds Int True False

WorkVarianceTimeSpan Time True 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

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062