ODBC Driver for Workday

Build 24.0.9060

Requests

Retrieves the request with the specified ID.

Workday Resource Information

Retrieves the specified request, including the completed questionnaire associated to it. Returned results are secured based on the processing person's View access to the request.

Secured by: Core Navigation

Scope: Adaptive Planning for Financial Plans, Adaptive Planning for the Workforce, Tenant Non-Configurable

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.

QuestionnaireResponses_QuestionnaireAnswers_Aggregate


[{
  answerDate: Date /* The answer in a date format. */
  answerMultipleChoices: [{
      descriptor: Text /* A preview of the instance */
      id: Text /* Id of the instance */
  }]
  answerNumeric: Numeric /* The answer in a numeric format. */
  answerText: Text /* The text answer for a questionnaire. */
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
  questionItem: { /* Question Item for Questionnaire Answer. Question item represents the question in a questionnaire. */
     *id: Text /* wid / id / reference id */
  }
  questionnaireAttachments: [{
      contentType: { /* Content type of the attachment */
         *id: Text /* wid / id / reference id */
      }
      descriptor: Text /* A preview of the instance */
      fileLength: Numeric /* File length of the attachment */
      fileName: Text /* File name of the attachment */
      id: Text /* Id of the instance */
  }]
}]

Columns

Name Type ReadOnly Description
Id [KEY] String False

Id of the instance

Comment String False

Supported for: INSERT. Latest Comment for the Request Event of the Request

CompletionDate Datetime False

Supported for: SELECT. The date the request was completed.

Description String False

Supported for: SELECT, INSERT. Returns the description of the Request

Descriptor String False

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

Href String False

Supported for: SELECT. A link to the instance

Initiator_Descriptor String False

Supported for: SELECT. A description of the instance

Initiator_Href String False

Supported for: SELECT. A link to the instance

Initiator_Id String False

Supported for: SELECT. wid / id / reference id

OnBehalfOf_Descriptor String False

Supported for: SELECT. A description of the instance

OnBehalfOf_Href String False

Supported for: SELECT. A link to the instance

OnBehalfOf_Id String False

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

QuestionnaireResponses_BusinessProcessType_Descriptor String False

Supported for: SELECT. A description of the instance

QuestionnaireResponses_BusinessProcessType_Href String False

Supported for: SELECT. A link to the instance

QuestionnaireResponses_BusinessProcessType_Id String False

Supported for: SELECT. wid / id / reference id

QuestionnaireResponses_CreationDate Datetime False

Supported for: SELECT. The submission date for the Questionnaire Response

QuestionnaireResponses_Descriptor String False

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

QuestionnaireResponses_Id String False

Supported for: SELECT, INSERT. Id of the instance

QuestionnaireResponses_QuestionnaireAnswers_Aggregate String False

Supported for: INSERT. A JSON aggregate. The set of answers for a questionnaire.

QuestionnaireResponses_QuestionnaireResponseStatus_Descriptor String False

Supported for: SELECT. A description of the instance

QuestionnaireResponses_QuestionnaireResponseStatus_Href String False

Supported for: SELECT. A link to the instance

QuestionnaireResponses_QuestionnaireResponseStatus_Id String False

Supported for: SELECT. wid / id / reference id

QuestionnaireResponses_QuestionnaireTargetContext_Descriptor String False

Supported for: SELECT. A description of the instance

QuestionnaireResponses_QuestionnaireTargetContext_Href String False

Supported for: SELECT. A link to the instance

QuestionnaireResponses_QuestionnaireTargetContext_Id String False

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

QuestionnaireResponses_QuestionnaireTarget_Descriptor String False

Supported for: SELECT. A description of the instance

QuestionnaireResponses_QuestionnaireTarget_Href String False

Supported for: SELECT. A link to the instance

QuestionnaireResponses_QuestionnaireTarget_Id String False

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

QuestionnaireResponses_TotalScore Decimal False

Supported for: SELECT. The total score for a questionnaire response is the sum of the questionnaire answers' score.

RequestDate Datetime False

Supported for: SELECT. The date that the request business process was initiated.

RequestEvent_Descriptor String False

Supported for: SELECT. A description of the instance

RequestEvent_Href String False

Supported for: SELECT. A link to the instance

RequestEvent_Id String False

Supported for: SELECT. wid / id / reference id

RequestID String False

Supported for: INSERT. Request ID

RequestId_2 String False

Supported for: SELECT. The ID of the request based on the ID generator format.

RequestType_Descriptor String False

Supported for: SELECT. A description of the instance

RequestType_Href String False

Supported for: SELECT. A link to the instance

RequestType_Id String False

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

ResolutionDetails_Descriptor String False

Supported for: SELECT. A description of the instance

ResolutionDetails_Href String False

Supported for: SELECT. A link to the instance

ResolutionDetails_Id String False

Supported for: SELECT. wid / id / reference id

Resolution_Descriptor String False

Supported for: SELECT. A description of the instance

Resolution_Href String False

Supported for: SELECT. A link to the instance

Resolution_Id String False

Supported for: SELECT. wid / id / reference id

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. wid / id / reference id

Subtype_Descriptor String False

Supported for: SELECT. A description of the instance

Subtype_Href String False

Supported for: SELECT. A link to the instance

Subtype_Id String False

Supported for: SELECT. wid / id / reference id

WorkdayObjectValue_Descriptor String False

Supported for: SELECT. A description of the instance

WorkdayObjectValue_Href String False

Supported for: SELECT. A link to the instance

WorkdayObjectValue_Id String False

Supported for: SELECT. wid / id / reference id

CompletedOnOrAfter_Prompt Date False

No description available.

CompletedOnOrBefore_Prompt Date False

No description available.

InitiatedOnOrAfter_Prompt Date False

No description available.

InitiatedOnOrBefore_Prompt Date False

No description available.

Initiator_Prompt String False

Accepts multiple inputs. The WID for the person who initiated the request. You can GET /workers in the /common service to retrieve a worker's WID.

OnBehalfOf_Prompt String False

The Workday ID of the person this request is being initiated on behalf of.

RequestId_Prompt String False

The ID of the request based on the ID generator format.

RequestSubtype_Prompt String False

Accepts multiple inputs. The Workday ID of the request subtype. You can specify more than 1 requestSubtype query parameter.

RequestType_Prompt String False

Accepts multiple inputs. The Workday ID of the request type. You can specify more than 1 requestType query parameter.

ResolutionDetails_Prompt String False

Accepts multiple inputs. The Workday ID of the resolution details. You can specify more than 1 resolutionDetails query parameter.

Resolution_Prompt String False

Accepts multiple inputs. The Workday ID of the resolution of the request. You can specify more than 1 resolution query parameter.

WorkdayObjectValue_Prompt String False

Accepts multiple inputs. The Workday ID of the business object associated with the request.

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