Projects

Retrieves a collection of Projects.

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 driver 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

[{
awaitingPersons: [{
descriptor: Text /* A preview of the instance */
id: Text /* Id of the instance */
}]
businessEventValidation: [{
conditionRule: Text /* The condition rule as a text expression. */
descriptor: Text /* A preview of the instance */
id: Text /* Id of the instance */
}]
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 */
}
comments: [{
comment: Text /* Comment */
conmentDate: Date /* Gives the moment at which the instance was originally created. */
person: { /* Comment made by Person */
*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 */
creationDate: Date /* The date when the event record was created. */
delayedDate: Date /* The date the delayed step will trigger. */
descriptor: Text /* A preview of the instance */
due: Date /* Returns the due date for this step. */
event: { /* Identifies the business process and allows you to drill into the details and access related actions. */
*id: Text /* wid / id / reference id */
}
id: Text /* Id of the instance */
status: { /* The status of this business process step. */
*id: Text /* wid / id / reference id */
}
}]

Groups_Aggregate

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

OptionalHierarchies_Aggregate

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

ProjectDependencies_Aggregate

[{
  descriptor: Text /* A preview of the instance */
  id: Text /* Id 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. When True, the project becomes a billable project.
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. When true, 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 end date for the approved project .
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. (Currency name)
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. (Value)
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. (Currency name)
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. (Value)
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. When True, the current project or the associated project hierarchy becomes inactive.
IncludeProjectIDInName	Bool	False	Supported for: SELECT, INSERT. When true, displays 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. Indicates the probability of the project's 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. (Currency name)
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. (Value)
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. The start date of the approved project.
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. (Currency name)
TotalSavingsRemaining_Value	Decimal	False	Supported for: SELECT. The total amount of savings remaining in project currency. (Value)
Worktags_Aggregate	String	False	Supported for: INSERT. A JSON aggregate. Key words for projects to categorize transactions, such as Cost, Organization, etc.

ODBC Driver for Workday