This page provides a guide to Establishing a Connection to Microsoft Project in CData Cloud, as well as information on the available resources, and a reference to the available connection properties.

Connecting to Microsoft Project

Establishing a Connection shows how to authenticate to Microsoft Project and configure any necessary connection properties to create a database in CData Cloud

Accessing Data from CData Cloud Services

Accessing data from Microsoft Project through the available standard services and CData Cloud administration is documented in further details in the CData Cloud Documentation.

Connect to Microsoft Project by selecting the corresponding icon in the Database tab. Required properties are listed under Settings. The Advanced tab lists connection properties that are not typically required.

Connecting to Microsoft Project

To connect to the Microsoft Project data source, set these connection properties:

• URL: A valid Microsoft Project Web App URL, such as http://contoso.com/sites/pwa/.
• Schema: Either ODataV1 or ODataV2 (default). While ODataV2 can be used for full CRUD operations, ODataV1, which provides more granular data and exposes the custom fields, is superior for reporting purposes. For more information about the available functionality in each Schema, see Data Model.
• ProjectId (optional): If the Schema is ODataV2, you can use this property to specify a default Project Id for all the operations that require one.

Authenticating to Microsoft Project

There are several authentication methods available for connecting to Microsoft Project, including the SharePoint Online Cookie Service, ADFS, OAuth, and SSO. The supported SSO identity providers are Azure AD, OneLogin, and OKTA.

SharePoint Online Cookie Service

To use your login credentials to connect to Microsoft Project on SharePoint Online, set the AuthScheme to SharePointOnlineCookies, User to your user login, and Password to your user login password.

OAuth

To enable this authentication from all Microsoft Project OAuth flows, you must create a custom OAuth application, and set AuthScheme to OAuth.

The following subsections describe how to authenticate to Microsoft Project from three common authentication flows. For information about how to create a custom OAuth application, see Creating a SharePoint Add-in (Legacy OAuth Model). For a complete list of connection string properties available in Microsoft Project, see Connection.

Automatic refresh of the OAuth access token:

To have the Cloud automatically refresh the OAuth access token:

1. Before connecting to data for the first time, set these connection parameters:
   • InitiateOAuth: REFRESH.
   • OAuthClientId: The client Id in your application settings.
   • OAuthClientSecret: The client secret in your application settings.
   • OAuthAccessToken: The access token returned by GetOAuthAccessToken.
   • OAuthSettingsLocation: The path where you want the Cloud to save the OAuth values, which persist across connections.
2. On subsequent data connections, set:
   • InitiateOAuth
   • OAuthSettingsLocation

Manual refresh of the OAuth access token:

The only value needed to manually refresh the OAuth access token is the OAuth refresh token.

1. To manually refresh the OAuthAccessToken after the ExpiresIn period (returned by GetOAuthAccessToken) has elapsed, call the RefreshOAuthAccessToken stored procedure.
2. Set these connection properties:
   • OAuthClientId: The Client Id in your application settings.
   • OAuthClientSecret: The Client Secret in your application settings.

3. Call RefreshOAuthAccessToken with OAuthRefreshToken set to the OAuth refresh token returned by GetOAuthAccessToken.
4. After the new tokens have been retrieved, set the OAuthAccessToken property to the value returned by RefreshOAuthAccessToken. This opens a new connection.

Store the OAuth refresh token so that you can use it to manually refresh the OAuth access token after it has expired.

ADFS

To connect to ADFS, set the AuthScheme to ADFS, and set these properties:

• User: The ADFS user.
• Password: The ADFS user's password.
• SSOLoginURL: The SSO provider's login url.

Example connection string:

AuthScheme=ADFS;User=username;Password=password;SSOLoginURL='https://sts.company.com';

ADFS Integrated

The ADFS Integrated flow indicates you are connecting with the currently logged in Windows user credentials. To use the ADFS Integrated flow, do not specify the User and Password, but otherwise follow the same steps in the ADFS guide above.

Supported SSO Providers

Okta

To connect to Okta, set the AuthScheme to Okta, and set these properties:

• User: The Okta user.
• Password: The Okta user's password.
• SSOLoginURL: The SSO provider's login URL.

If you are using a trusted application or proxy that overrides the Okta client request OR configuring MFA, you must use combinations of SSOProperties to authenticate using Okta. Set any of the following, as applicable:

• APIToken: When authenticating a user via a trusted application or proxy that overrides the Okta client request context, set this to the API Token the customer created from the Okta organization.
• MFAType: If you have configured the MFA flow, set this to one of the following supported types: OktaVerify, Email, or SMS.
• MFAPassCode: If you have configured the MFA flow, set this to a valid passcode.
  If you set this to empty or an invalid value, the Cloud issues a one-time password challenge to your device or email. After the passcode is received, reopen the connection where the retrieved one-time password value is set to the MFAPassCode connection property.
• MFARememberDevice: True by default. Okta supports remembering devices when MFA is required. If remembering devices is allowed according to the configured authentication policies, the Cloud sends a device token to extend MFA authentication lifetime. If you do not want MFA to be remembered, set this variable to False.

Example connection string:

AuthScheme=Okta;SSOLoginURL='https://example.okta.com/home/appType/0bg4ivz6cJRZgCz5d6/46';User=oktaUserName;Password=oktaPassword;

OneLogin

To connect to OneLogin, set the AuthScheme to OneLogin, and set these properties:

• User: The OneLogin user.
• Password: The OneLogin user's password.

To authenticate to OneLogin, set these SSOProperties:

• OAuthClientId: The OAuthClientId, which can be obtained by selecting Developers > API Credentials > Credential > ClientId.
• OAuthClientSecret: The OAuthClientSecret, which can be obtained by selecting Developers > API Credentials > Credential > ClientSecret.
• Subdomain: The subdomain of the OneLogin user accessing the SSO application. For example, if your OneLogin URL is splinkly.onelogin.com, splinkly is the subdomain value.
• AppId: The Id of the SSO application.
• Region (optional): The region your OneLogin account resides in. Legal values are US (default) or EU.

The following example connection string uses an API key to connect to OneLogin:

AuthScheme=OneLogin;User=OneLoginUserName;Password=OneLoginPassword;SSOProperties='OAuthClientID=3fc8394584f153ce3b7924d9cd4f686443a52b;OAuthClientSecret=ca9257fd5cc3277abb5818cea28c06fe9b3b285d73d06;Subdomain=OneLoginSubDomain;AppId=1433920';

Azure AD

To authenticate using Microsoft Entra ID (formerly Azure Active Directory), set the AuthScheme to AzureAD. This method allows the Cloud to access your Project Web App (PWA) data through SharePoint Online on behalf of a signed-in user using delegated OAuth permissions.

You must create a custom OAuth application in the Azure Portal and configure it with a redirect URI and the necessary delegated permissions. For complete setup instructions, see Creating a Custom Entra ID (Azure AD) Application.

After registering the application, set the following connection properties:

• AuthScheme: AzureAD
• InitiateOAuth: GETANDREFRESH
• OAuthClientId: The client Id assigned when you registered your custom OAuth application.
• OAuthClientSecret: The client secret assigned when you registered your custom OAuth application.
• URL: The project's web app URL.
• CallbackURL: (optional) The redirect URI that was defined when you registered your application. For example, http://localhost:33333 (or your configured redirect URI)
• AzureTenant: (optional) The Directory (tenant) ID

If you do not set a custom Scope, the Cloud automatically generates default scopes based on the URL:

https://yourtenant.sharepoint.com/ProjectWebApp.FullControl
https://yourtenant.sharepoint.com/AllSites.FullControl

You can override these by setting a custom Scope value

For example:

AuthScheme=AzureAD;
InitiateOAuth=GETANDREFRESH;
OAuthClientId=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;
OAuthClientSecret=xxxxxxxxxxxxxxxxxxxx;
CallbackURL=http://localhost:33333;
URL=https://contoso.sharepoint.com/sites/pwa/;
AzureTenant=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;
Scope=https://contoso.sharepoint.com/ProjectWebApp.FullControl https://contoso.sharepoint.com/AllSites.Read

Creating a Custom OAuth Application

For users who will authenticate via OAuth, you must create a custom OAuth application to deliver the required OAuth-specific credentials, then add the scope permissions required to access the Microsoft Project API.

Note: This topic describes the legacy SharePoint App-only registration flow that uses the AppRegNew and AppInv pages to create an OAuth application. This method applies only to older or on-premises Project Web App (PWA) environments that rely on the SharePoint Add-in model.

For most modern Microsoft 365 and SharePoint Online environments, you should instead create your OAuth application in Microsoft Entra ID (formerly Azure Active Directory) through the Azure Portal. See Creating a Custom Entra ID (Azure AD) Application for current guidance.

Create the Application

Note: The tenant administrator must perform the following steps to create a custom OAuth application, as only they have the necessary permissions to access the required URLs.

1. Log into the Project Web App Site through your site's UI, or by entering your site's Create App link into your browser: https://{site}.sharepoint.com/sites/{Project_Web_App_Site}/_layouts/15/appregnew.aspx.
2. Fill in the required fields. When specifying the application's Callback URL (a website page where you want users to land after they grant permission to your custom OAuth application), do one of the following:
   • Specify a secure URL for the page (should begin with https://).
     OR
   • Specify https://oauth.cdata.com/oauth/ as the callback URL, then add an extra state connection property that contains the actual redirect callback.

   Record the ClientID and ClientSecret for later use.

Add Scope Permissions

In order to access the Microsoft Project API, you must give the new OAuth application scope permissions.

1. Log in at https://{site}.sharepoint.com/sites/{Project_Web_App_Site}/_layouts/15/AppInv.aspx.
2. In the App Id field, enter the ClientID you obtained when creating the application.
3. Click Lookup. The other fields should automatically populate with application details like Title, App Domain and Redirect URL.
4. To specify the default permissions needed for full API access, enter the following text in the permissions request XML box:
   

     <AppPermissionRequests>
       <AppPermissionRequest Scope="http://sharepoint/projectserver" Right="Manage"/>
       <AppPermissionRequest Scope="http://sharepoint/projectserver/projects" Right="Write"/>
       <AppPermissionRequest Scope="http://sharepoint/projectserver/enterpriseresources" Right="Write"/>
       <AppPermissionRequest Scope="http://sharepoint/projectserver/reporting" Right="Read"/>
     </AppPermissionRequests>

Note: The logged in user should also have the appropriate permissions to access the API.

Granting User Access to Web Services

There are two different ways to give users access to web services, depending on whether your Project Web Applicat (PWA) is in Project permission mode or SharePoint permission mode.

Project Permission Mode

If your PWA is in Project Permission mode, you can grant users access to Web Services by editing their global permissions. For each user you want to add, do the following:

1. Open the PWA's PWA Settings page.
2. In the Security section, click Manage Users.
3. Find the user name of the interested user. Click their name. The PWA displays an Edit User box.
4. Expand the Global Permissions section.
5. Under Access Project Server Reporting Service, check Allow.

SharePoint Permission Mode

If your PWA is in SharePoint permission mode, you can grant user access to Web Services by adding them to one of four Security Groups that have at least "Access Project Server Reporting Service" access. For each user you want to add, do the following:

1. Open the PWA's PWA Settings page.
2. In the Security section, click Manage Users.
3. Find the user name of the interested user. Click their name. The PWA displays an Edit User box.
4. Under the Security Groups section, select one of the groups with the required access permissions, such as Portfolio Viewers, Portfolio Managers, and Administrators.
5. To add the user, click > .

There have been some changes made to the Cloud in the 2020 edition that should be taken into consideration.

CSOM Support Discontinued

Prior to the 2020 edition of the Cloud, connections to Microsoft Project using both the CSOM and OData interface were supported, which lead to difficulties in maintaining the two schemas concurrently.

By removing support for the CSOM, connections to Microsoft Project are streamlined due to the lack of special connection properties made specifically for each schema. Also, the OData interface can now perform all of the same CRUD operations that the CSOM is capable of. Lastly, the CSOM is poorly documented and more error-prone than OData.

For these reasons, the decision was made to deprecate support for the CSOM in favor of exclusively supporting the OData interface.

Customizing the SSL Configuration

To enable TLS, set the following:

• URL: Prefix the connection string with https://

With this configuration, the Cloud attempts to negotiate TLS with the server. The server certificate is validated against the default system trusted certificate store. You can override how the certificate gets validated using the SSLServerCert connection property.

To specify another certificate, see the SSLServerCert connection property.

Connecting Through a Firewall or Proxy

HTTP Proxies

To authenticate to an HTTP proxy, set the following:

• ProxyServer: the hostname or IP address of the proxy server that you want to route HTTP traffic through.
• ProxyPort: the TCP port that the proxy server is running on.
• ProxyAuthScheme: the authentication method the Cloud uses when authenticating to the proxy server.
• ProxyUser: the username of a user account registered with the proxy server.
• ProxyPassword: the password associated with the ProxyUser.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

Overview

The CData Cloud models Microsoft Project objects as relational tables and views. A Microsoft Project object has relationships to other objects; in the tables, these relationships are expressed through foreign keys.

Connecting with the ODataV2 Schema

The ODataV2 Data Model (default) can be used for full CRUD operations. Main columns metadata is dynamically retrieved for each entity, but the schema is fixed and custom fields are not included.

Tables and Views describe a sample the tables available in the ODataV2 API.

Connecting with the ODataV1 Schema

The ODataV1 Data Model can only be used for reading data. Metadata is dynamically retrieved, including the custom fields for this schema.

Views describe a sample the views available in the ODataV1 API.

Key Features

• The Cloud models Microsoft Project entities as relational tables and views, allowing you to write SQL to query Microsoft Project data.
• Stored procedures allow you to execute operations to Microsoft Project.
• Live connectivity to these objects means any changes to your Microsoft Project account are immediately reflected when using the Cloud.

The ODataV2 schema implements the ProjectServer service endpoints, which has support for full CRUD operations.

Tables

Tables are retrieved dynamically from the authenticated Microsoft Project account.

Views

Read-only Views are retrieved dynamically from the authenticated Microsoft Project account.

Stored Procedures

Stored Procedures are function-like interfaces to Microsoft Project. Stored procedures allow you to execute operations to Microsoft Project.

ODataV2 advantages compared to ODataV1

• Supports write operations (INSERT, UPDATE and DELETE) on the exposed tables.

ODataV2 limitations

• In order to query some tables and views, such as DraftAssignments, DraftProjectResources, DraftTaskLinks and DraftTasks, the ProjectId must be specified either in the query's WHERE clause criteria or via the ProjectId connection property.
• The custom fields are not exposed.

The Cloud models the data in Microsoft Project as a list of tables in a relational database that can be queried using standard SQL statements.

CData Cloud - Microsoft Project Tables

Name	Description
Calendars	Retrieve and modify calendars.
DraftAssignments	Retrieve and modify draft assignments.
DraftProjectResources	Retrieve and modify draft project resources.
DraftProjects	Retrieve and modify draft projects.
DraftTaskLinks	Retrieve and modify draft task links.
DraftTasks	Retrieve and modify draft tasks.
EnterpriseProjectTypes	Retrieve and modify project types.
EnterpriseResources	Retrieve and modify resources.
EventHandlers	Retrieve and modify project event handlers.
Phases	Retrieve and modify project phases.
PublishedProjects	Retrieve and modify published projects.
StageDetailPages	Retrieve and modify stage project detail pages.
Stages	Retrieve and modify project stages.
TimeSheetLines	Retrieve and modify timesheet lines.
TimeSheets	Retrieve and modify timesheets.

Retrieve and modify calendars.

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
Created	Datetime	False		False
IsStandardCalendar	Bool	False		False
Modified	Datetime	False		False
Name	String	False		False
OriginalId	String	False		False
LinkedBaseCalendarExceptions	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.

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

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
ActualCostWorkPerformed	Double	False		False
ActualOvertimeCost	Double	False		False
BaselineCost	Double	False		False
BaselineCostPerUse	Double	False		False
BaselineFinish	Datetime	False		False
BaselineStart	Datetime	False		False
BaselineWork	String	False		False
BaselineWorkMilliseconds	Int	False		False
BaselineWorkTimeSpan	Time	False		False
BudgetedCostWorkPerformed	Double	False		False
BudgetedCostWorkScheduled	Double	False		False
CostVariance	Double	False		False
CostVarianceAtCompletion	Double	False		False
Created	Datetime	False		False
CurrentCostVariance	Double	False		False
Finish	Datetime	False		False
FinishVariance	String	False		False
FinishVarianceMilliseconds	Int	False		False
FinishVarianceTimeSpan	Time	False		False
IsConfirmed	Bool	False		False
IsOverAllocated	Bool	False		False
IsPublished	Bool	False		False
IsResponsePending	Bool	False		False
IsUpdateNeeded	Bool	False		False
LevelingDelay	String	False		False
LevelingDelayMilliseconds	Int	False		False
LevelingDelayTimeSpan	Time	False		False
Modified	Datetime	False		False
Notes	String	False		False
OvertimeCost	Double	False		False
RemainingCost	Double	False		False
RemainingOvertimeCost	Double	False		False
Resume	Datetime	False		False
ScheduleCostVariance	Double	False		False
Start	Datetime	False		False
StartVariance	String	False		False
StartVarianceMilliseconds	Int	False		False
StartVarianceTimeSpan	Time	False		False
Stop	Datetime	False		False
WorkContourType	Int	False		False
WorkVariance	String	False		False
WorkVarianceMilliseconds	Int	False		False
WorkVarianceTimeSpan	Time	False		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
Owner_Id	Int	True		False
Parent_Id	String	True		False
Resource_Id	String	True		False
Task_Id	String	True		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. This column only supports equality (=) and IN filters.

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.

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

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
ActualCost	Double	False		False
ActualCostWorkPerformed	String	False		False
ActualCostWorkPerformedMilliseconds	Int	False		False
ActualCostWorkPerformedTimeSpan	Time	False		False
ActualOvertimeCost	Double	False		False
ActualOvertimeWork	String	False		False
ActualOvertimeWorkMilliseconds	Int	False		False
ActualOvertimeWorkTimeSpan	Time	False		False
ActualWork	String	False		False
ActualWorkMilliseconds	Int	False		False
ActualWorkTimeSpan	Time	False		False
AvailableFrom	Datetime	False		False
AvailableTo	Datetime	False		False
BaselineCost	Double	False		False
BaselineWork	String	False		False
BaselineWorkMilliseconds	Int	False		False
BaselineWorkTimeSpan	Time	False		False
BudetCostWorkPerformed	Double	False		False
BudgetedCost	Double	False		False
BudgetedCostWorkScheduled	Double	False		False
BudgetedWork	String	False		False
BudgetedWorkMilliseconds	Int	False		False
BudgetedWorkTimeSpan	Time	False		False
Cost	Double	False		False
CostVariance	Double	False		False
CostVarianceAtCompletion	Double	False		False
Created	Datetime	False		False
CurrentCostVariance	Double	False		False
Finish	Datetime	False		False
IsBudgeted	Bool	False		False
IsGenericResource	Bool	False		False
IsOverAllocated	Bool	False		False
Modified	Datetime	False		False
Notes	String	False		False
OvertimeCost	Double	False		False
OvertimeWork	String	False		False
OvertimeWorkMilliseconds	Int	False		False
OvertimeWorkTimeSpan	Time	False		False
PeakWork	String	False		False
PeakWorkMilliseconds	Int	False		False
PeakWorkTimeSpan	Time	False		False
PercentWorkComplete	Int	False		False
RegularWork	String	False		False
RegularWorkMilliseconds	Int	False		False
RegularWorkTimeSpan	Time	False		False
RemainingCost	Double	False		False
RemainingOvertimeCost	Double	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
ScheduleCostVariance	Double	False		False
Start	Datetime	False		False
Work	String	False		False
WorkMilliseconds	Int	False		False
WorkTimeSpan	Time	False		False
WorkVariance	String	False		False
WorkVarianceMilliseconds	Int	False		False
WorkVarianceTimeSpan	Time	False		False
EnterpriseResource_Id	String	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
DefaultAssignmentOwner_Id	Int	True		False
LinkedAssignments	String	False		False
LinkedDefaultAssignmentOwner	String	False		False
ProjectId [KEY]	String	True		False	Id of the parent. This column only supports equality (=) and IN filters.

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.

Retrieve and modify draft projects.

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
ApprovedEnd	Datetime	False		False
ApprovedStart	Datetime	False		False
CalculateActualCosts	Bool	False		False
CalculatesActualCosts	Bool	False		False
CheckedOutDate	Datetime	False		False
CheckOutDescription	String	False		False
CheckOutId	String	False		False
CreatedDate	Datetime	False		False
CriticalSlackLimit	Int	False		False
DefaultFinishTime	Datetime	False		False
DefaultOvertimeRateUnits	Int	False		False
DefaultStandardRateUnits	Int	False		False
DefaultStartTime	Datetime	False		False
HasMppPendingImport	Bool	False		False
HonorConstraints	Bool	False		False
IsCheckedOut	Bool	False		False
LastPublishedDate	Datetime	False		False
LastSavedDate	Datetime	False		False
ListId	String	False		False
MoveActualIfLater	Bool	False		False
MoveActualToStatus	Bool	False		False
MoveRemainingIfEarlier	Bool	False		False
MoveRemainingToStatus	Bool	False		False
MultipleCriticalPaths	Bool	False		False
OptimizerDecision	Int	False		False
PercentComplete	Int	False		False
PlannerDecision	Int	False		False
ProjectSiteUrl	String	False		False
ProjectType	Int	False		False
SplitInProgress	Bool	False		False
SpreadActualCostsToStatus	Bool	False		False
SpreadPercentCompleteToStatus	Bool	False		False
SummaryTaskId	String	False		False
TaskListId	String	False		False
WebId	String	False		False
CheckedOutBy_Id	Int	True		False
EnterpriseProjectType_Id	String	True		False
Phase_Id	String	True		False
ProjectSummaryTask_Id	String	True		False
Stage_Id	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
Calendar_Id	String	True		False
IncludeCustomFields_Id	String	True		False
Owner_Id	Int	True		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

Retrieve and modify draft task links.

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 DraftTaskLinks WHERE ProjectId = '99a38309-dc1d-eb11-bf8a-00155d9c6312'

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
DependencyType	Int	False		False
EndId	String	False		False
LinkLagDuration	String	False		False
PredecessorTaskId	String	False		False
StartId	String	False		False
SuccessorTaskId	String	False		False
End_Id	String	True		False
Start_Id	String	True		False
LinkedEnd	String	False		False
LinkedStart	String	False		False
ProjectId [KEY]	String	True		False	Id of the parent. This column only supports equality (=) and IN filters.

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.

Retrieve and modify draft tasks.

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 DraftTasks WHERE ProjectId = '99a38309-dc1d-eb11-bf8a-00155d9c6312'

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
ActualCostWorkPerformed	Double	False		False
ActualDuration	String	False		False
ActualDurationMilliseconds	Int	False		False
ActualDurationTimeSpan	Time	False		False
ActualOvertimeCost	Double	False		False
ActualOvertimeWork	String	False		False
ActualOvertimeWorkMilliseconds	Int	False		False
ActualOvertimeWorkTimeSpan	Time	False		False
BaselineCost	Double	False		False
BaselineDuration	String	False		False
BaselineDurationMilliseconds	Int	False		False
BaselineDurationTimeSpan	Time	False		False
BaselineFinish	Datetime	False		False
BaselineStart	Datetime	False		False
BaselineWork	String	False		False
BaselineWorkMilliseconds	Int	False		False
BaselineWorkTimeSpan	Time	False		False
BudgetCost	Double	False		False
BudgetedCostWorkPerformed	Double	False		False
BudgetedCostWorkScheduled	Double	False		False
Contact	String	False		False
CostPerformanceIndex	Double	False		False
CostVariance	Double	False		False
CostVarianceAtCompletion	Double	False		False
CostVariancePercentage	Int	False		False
Created	Datetime	False		False
CurrentCostVariance	Double	False		False
DurationVariance	String	False		False
DurationVarianceMilliseconds	Int	False		False
DurationVarianceTimeSpan	Time	False		False
EarliestFinish	Datetime	False		False
EarliestStart	Datetime	False		False
EstimateAtCompletion	Double	False		False
ExternalProjectUid	String	False		False
ExternalTaskUid	String	False		False
FinishSlack	String	False		False
FinishSlackMilliseconds	Int	False		False
FinishSlackTimeSpan	Time	False		False
FinishVariance	String	False		False
FinishVarianceMilliseconds	Int	False		False
FinishVarianceTimeSpan	Time	False		False
FreeSlack	String	False		False
FreeSlackMilliseconds	Int	False		False
FreeSlackTimeSpan	Time	False		False
IgnoreResourceCalendar	Bool	False		False
IsCritical	Bool	False		False
IsDurationEstimate	Bool	False		False
IsExternalTask	Bool	False		False
IsOverAllocated	Bool	False		False
IsRecurring	Bool	False		False
IsRecurringSummary	Bool	False		False
IsRolledUp	Bool	False		False
IsSubProject	Bool	False		False
IsSubProjectReadOnly	Bool	False		False
IsSubProjectScheduledFromFinish	Bool	False		False
IsSummary	Bool	False		False
LatestFinish	Datetime	False		False
LatestStart	Datetime	False		False
LevelingDelay	String	False		False
LevelingDelayMilliseconds	Int	False		False
LevelingDelayTimeSpan	Time	False		False
Modified	Datetime	False		False
Notes	String	False		False
OutlinePosition	String	False		False
OvertimeCost	Double	False		False
OvertimeWork	String	False		False
OvertimeWorkMilliseconds	Int	False		False
OvertimeWorkTimeSpan	Time	False		False
PercentWorkComplete	Int	False		False
PreLevelingFinish	Datetime	False		False
PreLevelingStart	Datetime	False		False
RegularWork	String	False		False
RegularWorkMilliseconds	Int	False		False
RegularWorkTimeSpan	Time	False		False
RemainingCost	Double	False		False
RemainingOvertimeCost	Double	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
Resume	Datetime	False		False
ScheduleCostVariance	Double	False		False
ScheduledDuration	String	False		False
ScheduledDurationMilliseconds	Int	False		False
ScheduledDurationTimeSpan	Time	False		False
ScheduledFinish	Datetime	False		False
ScheduledStart	Datetime	False		False
SchedulePerformanceIndex	Double	False		False
ScheduleVariancePercentage	Int	False		False
StartSlack	String	False		False
StartSlackMilliseconds	Int	False		False
StartSlackTimeSpan	Time	False		False
StartVariance	String	False		False
StartVarianceMilliseconds	Int	False		False
StartVarianceTimeSpan	Time	False		False
Stop	Datetime	False		False
ToCompletePerformanceIndex	Double	False		False
TotalSlack	String	False		False
TotalSlackMilliseconds	Int	False		False
TotalSlackTimeSpan	Time	False		False
WorkBreakdownStructure	String	False		False
WorkVariance	String	False		False
WorkVarianceMilliseconds	Int	False		False
WorkVarianceTimeSpan	Time	False		False
SubProject_Id	String	True		False
LinkedCustomFields	String	False		False
LinkedSubProject	String	False		False
ActualCost	Double	False		False
ActualFinish	Datetime	False		False
ActualStart	Datetime	False		False
ActualWork	String	False		False
ActualWorkMilliseconds	Int	False		False
ActualWorkTimeSpan	Time	False		False
AddAfterId	String	False		False
BudgetWork	String	False		False
BudgetWorkMilliseconds	Int	False		False
BudgetWorkTimeSpan	Time	False		False
Completion	Datetime	False		False
ConstraintStartEnd	Datetime	False		False
ConstraintType	Int	False		False
Cost	Double	False		False
Deadline	Datetime	False		False
Duration	String	False		False
DurationMilliseconds	Int	False		False
DurationTimeSpan	Time	False		False
Finish	Datetime	False		False
FinishText	String	False		False
FixedCost	Double	False		False
FixedCostAccrual	Int	False		False
IsActive	Bool	False		False
IsEffortDriven	Bool	False		False
IsLockedByManager	Bool	False		False
IsManual	Bool	False		False
IsMarked	Bool	False		False
IsMilestone	Bool	False		False
LevelingAdjustsAssignments	Bool	False		False
LevelingCanSplit	Bool	False		False
Name	String	False		False
OutlineLevel	Int	False		False
ParentId	String	False		False
PercentComplete	Int	False		False
PercentPhysicalWorkComplete	Int	False		False
Priority	Int	False		False
RemainingDuration	String	False		False
RemainingDurationMilliseconds	Int	False		False
RemainingDurationTimeSpan	Time	False		False
Start	Datetime	False		False
StartText	String	False		False
TaskType	Int	False		False
UsePercentPhysicalWorkComplete	Bool	False		False
Work	String	False		False
WorkMilliseconds	Int	False		False
WorkTimeSpan	Time	False		False
Calendar_Id	String	True		False
Parent_Id	String	True		False
StatusManager_Id	Int	True		False
LinkedAssignments	String	False		False
LinkedCalendar	String	False		False
LinkedParent	String	False		False
LinkedPredecessors	String	False		False
LinkedStatusManager	String	False		False
LinkedSuccessors	String	False		False
ProjectId [KEY]	String	True		False	Id of the parent. This column only supports equality (=) and IN filters.

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.

Retrieve and modify project types.

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
Departments	String	False		False
Description	String	False		False
ImageUrl	String	False		False
IsDefault	Bool	False		False
IsManaged	Bool	False		False
Name	String	False		False
Order	Int	False		False
PermissionSyncEnable	Bool	False		False
ProjectPlanTemplateId	String	False		False
SiteCreationOption	Int	False		False
SiteCreationURL	String	False		False
TaskListSyncEnable	Bool	False		False
WorkflowAssociationId	String	False		False
WorkflowAssociationName	String	False		False
WorkspaceTemplateLCID	Int	False		False
WorkspaceTemplateName	String	False		False
LinkedProjectDetailPages	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.

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.

Retrieve and modify project event handlers.

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
AssemblyName	String	False		False
ClassName	String	False		False
Description	String	False		False
EndpointUrl	String	False		False
EventId	Int	False		False
Name	String	False		False
Order	Int	False		False
Event_Id	Int	True		False
LinkedEvent	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.

Retrieve and modify project phases.

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
Description	String	False		False
Name	String	False		False
LinkedStages	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.

Retrieve and modify published projects.

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
ApprovedEnd	Datetime	False		False
ApprovedStart	Datetime	False		False
CalculateActualCosts	Bool	False		False
CalculatesActualCosts	Bool	False		False
CheckedOutDate	Datetime	False		False
CheckOutDescription	String	False		False
CheckOutId	String	False		False
CreatedDate	Datetime	False		False
CriticalSlackLimit	Int	False		False
DefaultFinishTime	Datetime	False		False
DefaultOvertimeRateUnits	Int	False		False
DefaultStandardRateUnits	Int	False		False
DefaultStartTime	Datetime	False		False
HasMppPendingImport	Bool	False		False
HonorConstraints	Bool	False		False
IsCheckedOut	Bool	False		False
LastPublishedDate	Datetime	False		False
LastSavedDate	Datetime	False		False
ListId	String	False		False
MoveActualIfLater	Bool	False		False
MoveActualToStatus	Bool	False		False
MoveRemainingIfEarlier	Bool	False		False
MoveRemainingToStatus	Bool	False		False
MultipleCriticalPaths	Bool	False		False
OptimizerDecision	Int	False		False
PercentComplete	Int	False		False
PlannerDecision	Int	False		False
ProjectSiteUrl	String	False		False
ProjectType	Int	False		False
SplitInProgress	Bool	False		False
SpreadActualCostsToStatus	Bool	False		False
SpreadPercentCompleteToStatus	Bool	False		False
SummaryTaskId	String	False		False
TaskListId	String	False		False
WebId	String	False		False
CheckedOutBy_Id	Int	True		False
EnterpriseProjectType_Id	String	True		False
Phase_Id	String	True		False
ProjectSummaryTask_Id	String	True		False
Stage_Id	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
EnterpriseProjectTypeId	String	False		False
FinishDate	Datetime	False		False
FiscalYearStartMonth	Int	False		False
IsEnterpriseProject	Bool	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
Calendar_Id	String	True		False
Draft_Id	String	True		False
IncludeCustomFields_Id	String	True		False
Owner_Id	Int	True		False
ProjectWorkflowInstance_Id	String	True		False
LinkedAssignments	String	False		False
LinkedCalendar	String	False		False
LinkedDraft	String	False		False
LinkedEntityLinks	String	False		False
LinkedIncludeCustomFields	String	False		False
LinkedOwner	String	False		False
LinkedProjectResources	String	False		False
LinkedProjectWorkflowInstance	String	False		False
LinkedTaskLinks	String	False		False
LinkedTasks	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.

Retrieve and modify stage project detail pages.

Columns

Name	Type	ReadOnly	References	Required	Description
StageId [KEY]	String	True		False	Id of the parent. This column only supports equality (=) and IN filters.
Id [KEY]	String	False		False
Description	String	False		False
Position	Int	False		False
RequiresAttention	Bool	False		False
LinkedPhase	String	True		False
LinkedStage	String	True		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.

Retrieve and modify project stages.

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
Behavior	Int	False		False
CheckInRequired	Bool	False		False
Description	String	False		False
Name	String	False		False
SubmitDescription	String	False		False
Phase_Id	String	True		False
WorkflowStatusPage_Id	String	True		False
LinkedCustomFields	String	False		False
LinkedPhase	String	False		False
LinkedProjectDetailPages	String	False		False
LinkedWorkflowStatusPage	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.

Retrieve and modify timesheet lines.

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
Comment	String	False		False
LineClass	Int	False		False
ProjectName	String	False		False
Status	Int	False		False
TaskName	String	False		False
TotalWork	String	False		False
TotalWorkMilliseconds	Int	False		False
TotalWorkTimeSpan	Time	False		False
ValidationType	Int	False		False
Assignment_Id	String	True		False
TimeSheet_Id	String	True		False
LinkedAssignment	String	False		False
LinkedTimeSheet	String	False		False
LinkedWork	String	False		False
PeriodId [KEY]	String	True		False	Id of the parent. This column only supports equality (=) and IN filters.

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.

Retrieve and modify timesheets.

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
Comments	String	False		False
EntryMode	Int	False		False
IsControlledByOwner	Bool	False		False
IsProcessed	Bool	False		False
Name	String	False		False
Status	Int	False		False
TotalActualWork	String	False		False
TotalActualWorkMilliseconds	Int	False		False
TotalActualWorkTimeSpan	Time	False		False
TotalNonBillableOvertimeWork	String	False		False
TotalNonBillableOvertimeWorkMilliseconds	Int	False		False
TotalNonBillableOvertimeWorkTimeSpan	Time	False		False
TotalNonBillableWork	String	False		False
TotalNonBillableWorkMilliseconds	Int	False		False
TotalNonBillableWorkTimeSpan	Time	False		False
TotalOvertimeWork	String	False		False
TotalOvertimeWorkMilliseconds	Int	False		False
TotalOvertimeWorkTimeSpan	Time	False		False
TotalWork	String	False		False
TotalWorkMilliseconds	Int	False		False
TotalWorkTimeSpan	Time	False		False
WeekStartsOn	Int	False		False
Creator_Id	Int	True		False
Manager_Id	Int	True		False
Period_Id	String	True		False
LinkedCreator	String	False		False
LinkedLines	String	False		False
LinkedManager	String	False		False
LinkedPeriod	String	False		False
PeriodId [KEY]	String	True		False	Id of the parent. This column only supports equality (=) and IN filters.