PublishedProjects
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. |