Projects
Retrieve projects.
Columns
Name | Type | References | Description |
ProjectId [KEY] | String | ||
EnterpriseProjectTypeDescription | String | ||
EnterpriseProjectTypeId | String | ||
EnterpriseProjectTypeIsDefault | Bool | ||
EnterpriseProjectTypeName | String | ||
OptimizerCommitDate | Datetime | ||
OptimizerDecisionAliasLookupTableId | String | ||
OptimizerDecisionAliasLookupTableValueId | String | ||
OptimizerDecisionID | Int | ||
OptimizerDecisionName | String | ||
OptimizerSolutionName | String | ||
ParentProjectId | String | ||
PlannerCommitDate | Datetime | ||
PlannerDecisionAliasLookupTableId | String | ||
PlannerDecisionAliasLookupTableValueId | String | ||
PlannerDecisionID | Int | ||
PlannerDecisionName | String | ||
PlannerEndDate | Datetime | ||
PlannerSolutionName | String | ||
PlannerStartDate | Datetime | ||
ProjectActualCost | Decimal | ||
ProjectActualDuration | Decimal | ||
ProjectActualFinishDate | Datetime | ||
ProjectActualOvertimeCost | Decimal | ||
ProjectActualOvertimeWork | Decimal | ||
ProjectActualRegularCost | Decimal | ||
ProjectActualRegularWork | Decimal | ||
ProjectActualStartDate | Datetime | ||
ProjectActualWork | Decimal | ||
ProjectACWP | Decimal | ||
ProjectAuthorName | String | ||
ProjectBCWP | Decimal | ||
ProjectBCWS | Decimal | ||
ProjectBudgetCost | Decimal | ||
ProjectBudgetWork | Decimal | ||
ProjectCalculationsAreStale | Bool | ||
ProjectCalendarDuration | Int | ||
ProjectCategoryName | String | ||
ProjectCompanyName | String | ||
ProjectCost | Decimal | ||
ProjectCostVariance | Decimal | ||
ProjectCPI | Decimal | ||
ProjectCreatedDate | Datetime | ||
ProjectCurrency | String | ||
ProjectCV | Decimal | ||
ProjectCVP | Decimal | ||
ProjectDepartments | String | ||
ProjectDescription | String | ||
ProjectDuration | Decimal | ||
ProjectDurationVariance | Decimal | ||
ProjectEAC | Decimal | ||
ProjectEarlyFinish | Datetime | ||
ProjectEarlyStart | Datetime | ||
ProjectEarnedValueIsStale | Bool | ||
ProjectEnterpriseFeatures | Bool | ||
ProjectFinishDate | Datetime | ||
ProjectFinishVariance | Decimal | ||
ProjectFixedCost | Decimal | ||
ProjectIdentifier | String | ||
ProjectKeywords | String | ||
ProjectLastPublishedDate | Datetime | ||
ProjectLateFinish | Datetime | ||
ProjectLateStart | Datetime | ||
ProjectManagerName | String | ||
ProjectModifiedDate | Datetime | ||
ProjectName | String | ||
ProjectOvertimeCost | Decimal | ||
ProjectOvertimeWork | Decimal | ||
ProjectOwnerId | String | ||
ProjectOwnerName | String | ||
ProjectPercentCompleted | Int | ||
ProjectPercentWorkCompleted | Int | ||
ProjectRegularCost | Decimal | ||
ProjectRegularWork | Decimal | ||
ProjectRemainingCost | Decimal | ||
ProjectRemainingDuration | Decimal | ||
ProjectRemainingOvertimeCost | Decimal | ||
ProjectRemainingOvertimeWork | Decimal | ||
ProjectRemainingRegularCost | Decimal | ||
ProjectRemainingRegularWork | Decimal | ||
ProjectRemainingWork | Decimal | ||
ProjectResourcePlanWork | Decimal | ||
ProjectSPI | Decimal | ||
ProjectStartDate | Datetime | ||
ProjectStartVariance | Decimal | ||
ProjectStatusDate | Datetime | ||
ProjectSubject | String | ||
ProjectSV | Decimal | ||
ProjectSVP | Decimal | ||
ProjectTCPI | Decimal | ||
ProjectTimephased | String | ||
ProjectTitle | String | ||
ProjectType | Int | ||
ProjectVAC | Decimal | ||
ProjectWork | Decimal | ||
ProjectWorkspaceInternalUrl | String | ||
ProjectWorkVariance | Decimal | ||
ResourcePlanUtilizationDate | Datetime | ||
ResourcePlanUtilizationType | Int | ||
WorkflowError | String | ||
WorkflowErrorResponseCode | Int | ||
WorkflowInstanceId | String | ||
WorkflowOwnerId | String | ||
WorkflowOwnerName | String | ||
LinkedAssignmentBaselines | String | ||
LinkedAssignments | String | ||
LinkedDeliverables | String | ||
LinkedDependencies | String | ||
LinkedIssues | String | ||
LinkedRisks | String | ||
LinkedStagesInfo | String | ||
LinkedTasks | String |