JDBC Driver for Workday

Build 23.0.8839

Projects

Retrieves a single project instance.

Workday Resource Information

Retrieves a project reference data with the specified WID.

Secured by: Manage: Project Details, Self-Service: Project, View: Project

Scope: Project Tracking, Projects

Aggregate Fields

The 本製品 represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

BusinessEventRecords_Aggregate


[{
  delayedDate: Date /* The date the delayed step will trigger. */
  businessProcessStep: { /* Retired. We retire this report field because it doesn't return all the steps on the business process definition that are associated with the business process event step. A business process event step can be associated with multiple steps from the business process definition if those steps were automatically skipped. Example: Entry conditions to those steps aren't met. We recommend that you use the Steps report field instead. */
     *id: Text /* wid / id / reference id */
  }
  businessEventValidation: [{
      conditionRule: Text /* The condition rule as a text expression. */
      descriptor: Text /* A preview of the instance */
      id: Text /* Id of the instance */
  }]
  status: { /* The status of this business process step. */
     *id: Text /* wid / id / reference id */
  }
  event: { /* Identifies the business process and allows you to drill into the details and access related actions. */
     *id: Text /* wid / id / reference id */
  }
  completedByPerson: { /* The person that completed the step as Assignee */
     *id: Text /* wid / id / reference id */
  }
  completedOn: Date /* The date when this step was completed */
  due: Date /* Returns the due date for this step. */
  creationDate: Date /* The date when the event record was created. */
  awaitingPersons: [{
      descriptor: Text /* A preview of the instance */
      id: Text /* Id of the instance */
  }]
  comments: [{
      person: { /* Comment made by Person */
         *id: Text /* wid / id / reference id */
      }
      conmentDate: Date /* Gives the moment at which the instance was originally created. */
      comment: Text /* Comment */
  }]
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
}]

Groups_Aggregate


[{
  id: Text /* Id of the instance */
  descriptor: Text /* A preview of the instance */
}]

OptionalHierarchies_Aggregate


[{
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
}]

ProjectDependencies_Aggregate


[{
  id: Text /* Id of the instance */
  descriptor: Text /* A preview of the instance */
}]

Worktags_Aggregate


[{
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
}]

Columns

Name Type ReadOnly Description
Id [KEY] String False

Id of the instance

Billable Bool False

Supported for: SELECT, INSERT. True if the project is billable.

BusinessEventRecords_Aggregate String False

Supported for: INSERT. A JSON aggregate. The Project Event business process record that's initiated when you create or change a project.

Capital Bool False

Supported for: SELECT, INSERT. True if the project is capital.

Company_Descriptor String False

Supported for: SELECT. A description of the instance

Company_Href String False

Supported for: SELECT. A link to the instance

Company_Id String False

Supported for: SELECT, INSERT. wid / id / reference id

Currency_Descriptor String False

Supported for: SELECT, INSERT. A preview of the instance

Currency_Id String False

Supported for: SELECT, INSERT. Id of the instance

Customer_Descriptor String False

Supported for: SELECT. A description of the instance

Customer_Href String False

Supported for: SELECT. A link to the instance

Customer_Id String False

Supported for: SELECT, INSERT. wid / id / reference id

Description String False

Supported for: SELECT, INSERT. The description of the project.

Descriptor String False

Supported for: SELECT, INSERT. A preview of the instance

EndDate Datetime False

Supported for: SELECT, INSERT. The approved project end date.

EstimatedBudget_Currency String False

Supported for: SELECT, INSERT. The estimated budget allocated to the project, as defined in the project financials summary. Workday provides the amount in the project currency.

EstimatedBudget_Value Decimal False

Supported for: SELECT, INSERT. The estimated budget allocated to the project, as defined in the project financials summary. Workday provides the amount in the project currency.

EstimatedRevenueSavings_Currency String False

Supported for: SELECT, INSERT. The estimated revenue (billable project) or savings (non-billable project) gained from the project and expressed in the project currency.

EstimatedRevenueSavings_Value Decimal False

Supported for: SELECT, INSERT. The estimated revenue (billable project) or savings (non-billable project) gained from the project and expressed in the project currency.

ExternalLink String False

Supported for: SELECT, INSERT. The link to an external site.

ExternalProjectReference String False

Supported for: SELECT, INSERT. Returns the external project reference.

Groups_Aggregate String False

Supported for: INSERT. A JSON aggregate. Identifies the project groups of a project. Project groups are used to organize projects for worktag prompting.

Href String False

Supported for: SELECT, INSERT. A link to the instance

ImportanceRating_Descriptor String False

Supported for: SELECT. A description of the instance

ImportanceRating_Href String False

Supported for: SELECT. A link to the instance

ImportanceRating_Id String False

Supported for: SELECT, INSERT. wid / id / reference id

InScope String False

Supported for: SELECT, INSERT. A description of what is considered to be in scope for the project.

Inactive Bool False

Supported for: SELECT, INSERT. True if the current project or the associated project hierarchy is inactive.

IncludeProjectIDInName Bool False

Supported for: SELECT, INSERT. Indicates whether to display the ID in the Project name.

MeasuresOfSuccess String False

Supported for: SELECT, INSERT. A description of what the project will be measured against to determine if it is successful.

Name String False

Supported for: SELECT, INSERT. The approved project name.

Objective String False

Supported for: SELECT, INSERT. A description of the desired outcome of the project.

OptionalHierarchies_Aggregate String False

Supported for: INSERT. A JSON aggregate. Optional Project Hierarchies

OutOfScope String False

Supported for: SELECT, INSERT. A description of what is considered to be out of scope for the project.

Overview String False

Supported for: SELECT, INSERT. Project overview describing additional details about the project

Owner_Descriptor String False

Supported for: SELECT. A description of the instance

Owner_Href String False

Supported for: SELECT. A link to the instance

Owner_Id String False

Supported for: SELECT, INSERT. wid / id / reference id

PercentComplete Decimal False

Supported for: SELECT, INSERT. The percent complete for the project.

PrimaryHierarchy_Descriptor String False

Supported for: SELECT. A description of the instance

PrimaryHierarchy_Href String False

Supported for: SELECT. A link to the instance

PrimaryHierarchy_Id String False

Supported for: SELECT, INSERT. wid / id / reference id

Priority_Descriptor String False

Supported for: SELECT. A description of the instance

Priority_Href String False

Supported for: SELECT. A link to the instance

Priority_Id String False

Supported for: SELECT, INSERT. wid / id / reference id

ProbabilityOfSuccess Decimal False

Supported for: SELECT, INSERT. The number indicating the probability of project success.

ProblemStatement String False

Supported for: SELECT, INSERT. A description of the problem to be resolved by the project.

ProjectDependencies_Aggregate String False

Supported for: INSERT. A JSON aggregate. Project Dependencies

ProjectID String False

Supported for: SELECT, INSERT. Project_ID

ProjectState_Descriptor String False

Supported for: SELECT. A description of the instance

ProjectState_Href String False

Supported for: SELECT. A link to the instance

ProjectState_Id String False

Supported for: SELECT, INSERT. wid / id / reference id

RealizedRevenueSavings_Currency String False

Supported for: SELECT, INSERT. The actual revenue (billable project) or savings (non-billable project) gained from the project and expressed in the project currency.

RealizedRevenueSavings_Value Decimal False

Supported for: SELECT, INSERT. The actual revenue (billable project) or savings (non-billable project) gained from the project and expressed in the project currency.

RiskLevel_Descriptor String False

Supported for: SELECT. A description of the instance

RiskLevel_Href String False

Supported for: SELECT. A link to the instance

RiskLevel_Id String False

Supported for: SELECT, INSERT. wid / id / reference id

StartDate Datetime False

Supported for: SELECT, INSERT. Start Date

Status_Descriptor String False

Supported for: SELECT. A description of the instance

Status_Href String False

Supported for: SELECT. A link to the instance

Status_Id String False

Supported for: SELECT, INSERT. wid / id / reference id

SuccessRating_Descriptor String False

Supported for: SELECT. A description of the instance

SuccessRating_Href String False

Supported for: SELECT. A link to the instance

SuccessRating_Id String False

Supported for: SELECT, INSERT. wid / id / reference id

TotalSavingsRemaining_Currency String False

Supported for: SELECT. The total amount of savings remaining in project currency.

TotalSavingsRemaining_Value Decimal False

Supported for: SELECT. The total amount of savings remaining in project currency.

Worktags_Aggregate String False

Supported for: INSERT. A JSON aggregate. Worktags

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