JDBC Driver for Microsoft Project

Build 24.0.9062

Projects

Retrieve and modify projects.

Columns

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

ApprovedEnd Datetime True False

ApprovedStart Datetime True False

CalculateActualCosts Bool True False

CalculatesActualCosts Bool True False

CheckedOutDate Datetime True False

CheckOutDescription String True False

CheckOutId String True False

CreatedDate Datetime True False

CriticalSlackLimit Int True False

DefaultFinishTime Datetime True False

DefaultOvertimeRateUnits Int True False

DefaultStandardRateUnits Int True False

DefaultStartTime Datetime True False

HasMppPendingImport Bool True False

HonorConstraints Bool True False

IsCheckedOut Bool True False

LastPublishedDate Datetime True False

LastSavedDate Datetime True False

ListId String True False

MoveActualIfLater Bool True False

MoveActualToStatus Bool True False

MoveRemainingIfEarlier Bool True False

MoveRemainingToStatus Bool True False

MultipleCriticalPaths Bool True False

OptimizerDecision Int True False

PercentComplete Int True False

PlannerDecision Int True False

ProjectSiteUrl String True False

ProjectType Int True False

SplitInProgress Bool True False

SpreadActualCostsToStatus Bool True False

SpreadPercentCompleteToStatus Bool True False

SummaryTaskId String True False

TaskListId String True False

WebId String True False

LinkedCheckedOutBy String False False

LinkedCustomFields String False False

LinkedEngagements String False False

LinkedEnterpriseProjectType String False False

LinkedPhase String False False

LinkedProjectSummaryTask String False False

LinkedQueueJobs String False False

LinkedStage String False False

LinkedUserPermissions String False False

CurrencyCode String False False

CurrencyDigits Int False False

CurrencyPosition Int False False

CurrencySymbol String False False

CurrentDate Datetime False False

DaysPerMonth Int False False

DefaultEffortDriven Bool False False

DefaultEstimatedDuration Bool False False

DefaultFixedCostAccrual Int False False

DefaultOvertimeRate Double False False

DefaultStandardRate Double False False

DefaultTaskType Int False False

DefaultWorkFormat Int False False

Description String False False

FinishDate Datetime False False

FiscalYearStartMonth Int False False

MinutesPerDay Int False False

MinutesPerWeek Int False False

Name String False False

NewTasksAreManual Bool False False

NumberFiscalYearFromStart Bool False False

OwnerId String False False

ProjectIdentifier String False False

ProtectedActualsSynch Bool False False

ScheduledFromStart Bool False False

ShowEstimatedDurations Bool False False

StartDate Datetime False False

StatusDate Datetime False False

TrackingMode Int False False

UtilizationDate Datetime False False

UtilizationType Int False False

WeekStartDay Int False False

WinprojVersion Decimal False False

LinkedAssignments String False False

LinkedCalendar String False False

LinkedIncludeCustomFields String False False

LinkedOwner String False False

LinkedProjectResources String False False

LinkedTaskLinks String False False

LinkedTasks String False False

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