JDBC Driver for Microsoft Project

Build 25.0.9434

EnterpriseResources

Retrieve and modify resources.

Columns

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

CanLevel Bool False False

Code String False False

CostAccrual Int False False

CostCenter String False False

Created Datetime False False

DefaultBookingType Int False False

Email String False False

ExternalId String False False

Group String False False

HireDate Datetime False False

HyperlinkName String False False

HyperlinkUrl String False False

Initials String False False

IsActive Bool False False

IsBudget Bool False False

IsCheckedOut Bool False False

IsGeneric Bool False False

IsTeam Bool False False

MaterialLabel String False False

Modified Datetime False False

Name String False False

Phonetics String False False

RequiresEngagements Bool False False

ResourceIdentifier Int False False

ResourceType Int False False

TerminationDate Datetime False False

BaseCalendar_Id String True False

DefaultAssignmentOwner_Id Int True False

Self_Id String True False

TimesheetManager_Id Int True False

User_Id Int True False

LinkedAssignments String False False

LinkedBaseCalendar String False False

LinkedCostRateTables String False False

LinkedCustomFields String False False

LinkedDefaultAssignmentOwner String False False

LinkedEngagements String False False

LinkedResourceCalendarExceptions String False False

LinkedSelf String False False

LinkedTimesheetManager String False False

LinkedUser String False False

LinkedUserPermissions String False False

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 functions. Set to 'ODATA' to use standard ODATA insert functionality. Only applicable during inserts.

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