JDBC Driver for Microsoft Project

Build 24.0.9060

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

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

LinkedAssignments String False False

LinkedDefaultAssignmentOwner String False False

ProjectId [KEY] String True False

Id of the parent.

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