JDBC Driver for Microsoft Project

Build 25.0.9434

PublishedAssignments

Retrieve published assignments.

Columns

Name Type References Description
Id [KEY] String
ActualCostWorkPerformed Double
ActualOvertimeCost Double
BaselineCost Double
BaselineCostPerUse Double
BaselineFinish Datetime
BaselineStart Datetime
BaselineWork String
BaselineWorkMilliseconds Int
BaselineWorkTimeSpan Time
BudgetedCostWorkPerformed Double
BudgetedCostWorkScheduled Double
CostVariance Double
CostVarianceAtCompletion Double
Created Datetime
CurrentCostVariance Double
Finish Datetime
FinishVariance String
FinishVarianceMilliseconds Int
FinishVarianceTimeSpan Time
IsConfirmed Bool
IsOverAllocated Bool
IsPublished Bool
IsResponsePending Bool
IsUpdateNeeded Bool
LevelingDelay String
LevelingDelayMilliseconds Int
LevelingDelayTimeSpan Time
Modified Datetime
Notes String
OvertimeCost Double
RemainingCost Double
RemainingOvertimeCost Double
Resume Datetime
ScheduleCostVariance Double
Start Datetime
StartVariance String
StartVarianceMilliseconds Int
StartVarianceTimeSpan Time
Stop Datetime
WorkContourType Int
WorkVariance String
WorkVarianceMilliseconds Int
WorkVarianceTimeSpan Time
LinkedCustomFields String
ActualCost Double
ActualFinish Datetime
ActualOvertimeWork String
ActualOvertimeWorkMilliseconds Int
ActualOvertimeWorkTimeSpan Time
ActualStart Datetime
ActualWork String
ActualWorkMilliseconds Int
ActualWorkTimeSpan Time
BudgetedCost Double
BudgetedWork String
BudgetedWorkMilliseconds Int
BudgetedWorkTimeSpan Time
Cost Double
CostRateTable Int
DefaultBookingType Int
Delay String
DelayMilliseconds Int
DelayTimeSpan Time
IsLockedByManager Bool
IsWorkResource Bool
OvertimeWork String
OvertimeWorkMilliseconds Int
OvertimeWorkTimeSpan Time
PercentWorkComplete Int
RegularWork String
RegularWorkMilliseconds Int
RegularWorkTimeSpan Time
RemainingOvertimeWork String
RemainingOvertimeWorkMilliseconds Int
RemainingOvertimeWorkTimeSpan Time
RemainingWork String
RemainingWorkMilliseconds Int
RemainingWorkTimeSpan Time
ResourceCapacity Double
Work String
WorkMilliseconds Int
WorkTimeSpan Time
Owner_Id Int
Parent_Id String
Resource_Id String
Task_Id String
LinkedOwner String
LinkedParent String
LinkedResource String
LinkedTask String
ProjectId [KEY] String Id of the parent. This column only supports equality (=) and IN filters.

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