Projects

Stores information about various projects, allowing retrieval of project metadata, statuses, and associated attributes for organizational planning and execution.

Workday Resource Information

Retrieves a collection of projects for the specified IDs. When you don't specify the search string, Workday retrieves all projects.

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. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

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. */
     -descriptor: Text /* A description of the instance */
     -href: Text /* A link to the instance */
     *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 */
         -descriptor: Text /* A description of the instance */
         -href: Text /* A link to the instance */
         *id: Text /* wid / id / reference id */
      }
  }]
  completedByPerson: { /* The person that completed the step as Assignee */
     -descriptor: Text /* A description of the instance */
     -href: Text /* A link to the instance */
     *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: { /* The business process associated with the project you're editing. */
     -descriptor: Text /* A description of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
  id: Text /* Id of the instance */
  status: { /* The status of this business process step. */
     -descriptor: Text /* A description of the instance */
     -href: Text /* A link to the instance */
     *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	A unique identifier for the project instance within the system. Used to reference the project in various Workday transactions.
Billable	Bool	False	Indicates whether the project is billable. When set to True, the project is expected to generate revenue through client invoicing or internal chargebacks.
BusinessEventRecords_Aggregate	String	False	Represents the aggregated record of business events related to the project, such as approvals, modifications, and financial adjustments, which are tracked within Workday.
Capital	Bool	False	Indicates whether the project is a capital project. Capital projects involve significant financial investment, typically in infrastructure, equipment, or long-term assets.
Company_Descriptor	String	False	A textual representation of the company associated with the project, providing a user-friendly reference for reporting and selection.
Company_Href	String	False	A URL link to the company entity within Workday, enabling quick navigation to company details from the project record.
Company_Id	String	False	A unique identifier, either the Workday ID (WID) or reference ID, for the company associated with the project. This is used for system-level integration and reporting.
Currency_Descriptor	String	False	A human-readable description of the currency in which the project transactions are denominated, such as 'US Dollar' or 'Euro'.
Currency_Id	String	False	A system-generated identifier for the currency associated with the project, ensuring financial consistency in transactions.
Customer_Descriptor	String	False	A descriptive label representing the customer linked to the project, typically used in billing and reporting.
Customer_Href	String	False	A URL link to the customer's record within Workday, allowing users to quickly access customer details.
Customer_Id	String	False	A unique identifier (WID, reference ID) for the customer associated with the project, ensuring accurate tracking of customer-related transactions.
Description	String	False	A detailed narrative explaining the purpose, scope, and key details of the project, often used for documentation and reporting.
Descriptor	String	False	A brief summary of the project instance, often used for quick reference within Workday dashboards and reports.
EndDate	Datetime	False	The scheduled completion date of the project, signifying when all planned work should be finalized.
EstimatedBudget_Currency	String	False	The currency in which the estimated project budget is calculated, ensuring consistency in financial tracking.
EstimatedBudget_Value	Decimal	False	The total estimated budget allocated to the project, as recorded in the project financials summary, expressed in the designated project currency.
EstimatedRevenueSavings_Currency	String	False	The currency in which the estimated revenue (for billable projects) or savings (for non-billable projects) is calculated.
EstimatedRevenueSavings_Value	Decimal	False	The projected revenue or cost savings expected from the project, based on financial forecasts and business case analysis.
ExternalLink	String	False	A hyperlink to an external system, document, or resource relevant to the project, such as a client portal or project management tool.
ExternalProjectReference	String	False	An identifier or reference code used by external systems to link to this project, facilitating integration between Workday and other project management platforms.
Groups_Aggregate	String	False	A collection of project groups associated with this project. Project groups are used to classify projects for organizational or financial tracking.
Href	String	False	A hyperlink to the project record within Workday, enabling direct navigation for users reviewing project details.
ImportanceRating_Descriptor	String	False	A descriptive label indicating the significance of the project, typically used in prioritization and decision-making.
ImportanceRating_Href	String	False	A URL link to the importance rating definition in Workday, allowing for quick reference to rating criteria.
ImportanceRating_Id	String	False	A unique identifier for the importance rating assigned to the project, used for reporting and sorting projects by priority.
InScope	String	False	A detailed description of tasks, deliverables, and activities that are explicitly included within the project's scope. Helps define project boundaries.
Inactive	Bool	False	Indicates whether the project is currently inactive. When set to True, no further financial or operational actions can be performed on this project.
IncludeProjectIDInName	Bool	False	Determines whether the project ID should be automatically included in the project name for easier identification.
MeasuresOfSuccess	String	False	Specific criteria used to evaluate the success of the project, such as key performance indicators (KPIs), milestones achieved, or financial performance.
Name	String	False	The official, approved name of the project, used for reporting, budgeting, and communication.
Objective	String	False	A clear and concise statement of the project’s goals and intended outcomes, providing guidance to stakeholders and team members.
OptionalHierarchies_Aggregate	String	False	A collection of optional project hierarchies to which this project belongs, providing flexibility in organizational structure.
OutOfScope	String	False	A detailed description of tasks, deliverables, and activities that are explicitly excluded from the project's scope, helping manage stakeholder expectations.
Overview	String	False	A high-level summary of the project, including key objectives, stakeholders, and critical details to provide context to team members.
Owner_Descriptor	String	False	A human-readable label representing the project owner, often a manager or lead responsible for overseeing project execution.
Owner_Href	String	False	A URL link referencing the specific project owner instance within the system. This link allows navigation to the detailed record of the project owner.
Owner_Id	String	False	A unique identifier (WID, ID, or reference ID) assigned to the project owner, ensuring proper linkage to related records.
PercentComplete	Decimal	False	The percentage of work completed for the project, represented as a decimal value. This field helps track progress towards project completion.
PrimaryHierarchy_Descriptor	String	False	A descriptive name or label for the primary hierarchy associated with this project, providing context about its placement within the organization's structure.
PrimaryHierarchy_Href	String	False	A URL link pointing to the specific instance of the primary hierarchy related to the project, allowing users to access detailed hierarchy information.
PrimaryHierarchy_Id	String	False	A unique identifier (WID, ID, or reference ID) associated with the primary hierarchy of the project, used for tracking and data integrity.
Priority_Descriptor	String	False	A text-based description of the priority level assigned to the project, such as High, Medium, or Low, indicating its relative importance.
Priority_Href	String	False	A URL link referencing the specific priority instance for the project, providing additional details about its classification.
Priority_Id	String	False	A unique identifier (WID, ID, or reference ID) assigned to the priority level of the project, ensuring proper categorization.
ProbabilityOfSuccess	Decimal	False	A numeric value representing the likelihood of project success, typically expressed as a decimal percentage based on risk assessment and historical data.
ProblemStatement	String	False	A detailed statement outlining the problem or challenge that the project aims to resolve, providing context for stakeholders.
ProjectDependencies_Aggregate	String	False	A list of dependencies that the project relies on, including other projects, resources, or key milestones that must be met for successful execution.
ProjectID	String	False	A unique alphanumeric identifier assigned to the project, used for tracking and reference purposes.
ProjectState_Descriptor	String	False	A text description of the project's current state, such as In Progress, Completed, or On Hold, providing insights into its lifecycle stage.
ProjectState_Href	String	False	A URL link directing users to the specific instance of the project state, enabling access to more details about its status.
ProjectState_Id	String	False	A unique identifier (WID, ID, or reference ID) assigned to the project's state, ensuring consistency in tracking and reporting.
RealizedRevenueSavings_Currency	String	False	The currency in which the project's realized revenue (for billable projects) or cost savings (for non-billable projects) is expressed, ensuring clarity in financial reports.
RealizedRevenueSavings_Value	Decimal	False	The actual amount of revenue earned (for billable projects) or savings achieved (for non-billable projects), represented in the project’s designated currency.
RiskLevel_Descriptor	String	False	A descriptive label indicating the risk level associated with the project, such as Low, Medium, or High, based on project complexity and uncertainty.
RiskLevel_Href	String	False	A URL link referencing the specific risk level instance, allowing users to review additional risk-related details.
RiskLevel_Id	String	False	A unique identifier (WID, ID, or reference ID) associated with the project's risk level, ensuring accurate classification.
StartDate	Datetime	False	The official start date of the approved project, determining when work on the project is scheduled to begin.
Status_Descriptor	String	False	A text-based description of the project's current status, providing a clear indication of its progress, such as Active, On Hold, or Completed.
Status_Href	String	False	A URL link pointing to the specific instance of the project's status, allowing users to view more detailed status information.
Status_Id	String	False	A unique identifier (WID, ID, or reference ID) associated with the project status, ensuring accurate tracking in reports and dashboards.
SuccessRating_Descriptor	String	False	A description of the project's overall success rating, based on predefined criteria such as performance metrics and stakeholder satisfaction.
SuccessRating_Href	String	False	A URL link directing users to the success rating instance, enabling further analysis of the project's outcomes.
SuccessRating_Id	String	False	A unique identifier (WID, ID, or reference ID) associated with the project's success rating, facilitating structured reporting.
TotalSavingsRemaining_Currency	String	False	The currency in which the remaining projected savings for the project are expressed, ensuring financial clarity and consistency.
TotalSavingsRemaining_Value	Decimal	False	The total estimated amount of cost savings still available for the project, represented in the project’s designated currency.
Worktags_Aggregate	String	False	A collection of keywords or tags assigned to the project to categorize financial transactions, such as Cost, Organization, or Funding Source, enhancing tracking and reporting.

ODBC Driver for Workday