Tables
The provider models the data in Workday as a list of tables in a relational database that can be queried using standard SQL statements.
CData ADO.NET Provider for Workday Tables
| Name | Description |
| AdHocProjectTimeTransactions | Retrieves an ad hoc project time transaction instance. |
| Attachments | Will return attachments |
| BillableTransactions | Retrieves a single billable transaction instance. |
| Cases | Retrieves a case with the specified ID that the user is secured to view. |
| CasesTimeline | Retrieves a comment timeline item for a case with the specified timeline ID. |
| EventDrivenIntegrationVendorResponse | Retrieves a single Event-Driven Integration vendor response. |
| ExpenseEntries | Retrieves a single instance of a Quick Expense. |
| ExpenseEntriesAttachments | Reads attachments entries from the ExpenseEntries table |
| ExpenseReports | Retrieves a single instance of an Expense Report. |
| ExternalCreators | Retrieves contact details for a single external \~case\~ contact instance. |
| HomeContactInformationChangesAddresses | An address as it exists staged for update by the parent business process. |
| HomeContactInformationChangesEmailAddresses | An email address as it exists staged for update by the parent business process. |
| HomeContactInformationChangesInstantMessengers | An instant messenger as it exists staged for update by the parent business process. |
| HomeContactInformationChangesPhoneNumbers | A phone number as it exists staged for update by the parent business process. |
| HomeContactInformationChangesWebAddresses | A web address as it exists staged for update by the parent business process. |
| ImmigrationEventsDependentImmigrationData | Retrieves a dependent immigration data instance for the specified student ID. |
| ImmigrationEventsImmigrationData | Retrieves an immigration data instance for the specified immigration event. |
| InterviewsFeedback | No description available |
| JobChangesAdministrative | Retrieves the administrative options for the specified job change ID. |
| JobChangesBusinessTitle | Retrieves a business title for the specified job change ID. |
| JobChangesComment | Returns the comment information for the specified job change ID. |
| JobChangesContract | Retrieves the contract options for the specified change job ID. |
| JobChangesJobClassification | Retrieves a job classification for the specified job change ID. |
| JobChangesJobProfile | Retrieves a job profile for the specified job change ID. |
| JobChangesLocation | Returns the location information for the specified job change ID. |
| JobChangesMoveTeam | Retrieves a move team option from the specified job change ID. |
| JobChangesOpening | Retrieves the opening options for the specified job change ID. |
| JobChangesPosition | Retrieves a position for the specified job change ID. |
| JobChangesStartDetails | Retrieves the start details for the specified job change ID. |
| MessageTemplates | Retrieves a message template with the specific ID. |
| OrganizationAssignmentChangesBusinessUnit | Retrieves a business unit for the specified organization assignment change ID. |
| OrganizationAssignmentChangesComment | Retrieves the comment information for the specified organization assignment change ID. |
| OrganizationAssignmentChangesCompany | Retrieves a company for the specified organization assignment change ID. |
| OrganizationAssignmentChangesCostCenter | Retrieves a cost center for the specified organization assignment change ID. |
| OrganizationAssignmentChangesCosting | Retrieves the costing organizations for the specified organization assignment change ID. |
| OrganizationAssignmentChangesCustomOrganizations | Retrieves the custom organizations for the specified organization assignment change ID. |
| OrganizationAssignmentChangesRegion | Retrieves a region for the specified organization assignment change ID. |
| OrganizationAssignmentChangesStartDetails | Retrieves the start details for the specified organization assignment change ID. |
| PayGroupsPeriods | Retrieves a payroll period for the specified Payroll Interface pay group ID. |
| Payments | Retrieves a single customer invoice payment instance. |
| PaymentsRemittanceDetails | Retrieves a single customer invoice payment remittance line instance. |
| PayrollInputs | Retrieves a single payroll input instance. |
| PayrollInputsInputDetails | Reads inputDetails entries from the PayrollInputs table |
| PayrollInputsRunCategories | Reads runCategories entries from the PayrollInputs table |
| PayrollInputsWorktags | Reads worktags entries from the PayrollInputs table |
| PlanPhases | Retrieves a single project plan phase instance. |
| PlanTasks | Retrieves a single project plan task instance. |
| Projects | Retrieves a single project instance. |
| Prospects | Retrieves a single \~prospect\~ instance. |
| ProspectsEducations | Retrieves a single education instance for a \~prospect\~. |
| ProspectsExperiences | Retrieves a single experience instance for a \~prospect\~. |
| ProspectsLanguages | Retrieves a single language instance for a \~prospect\~. |
| ProspectsResumeAttachments | Retrieves a single resume attachment instance for a \~prospect\~. |
| ProspectsSkills | Retrieves a single skill instance for a \~prospect\~. |
| Requests | Retrieves the request with the specified ID. |
| Requisitions | Retrieves a requisition. |
| RequisitionsAttachments | Retrieves the metadata or the attachment content of the specified requisition. |
| RequisitionsRequisitionLines | Retrieves a requisition line for the specified requisition. |
| RequisitionsRequisitionLinesWorktags | Reads worktags entries from the RequisitionsRequisitionLines table |
| RequisitionsWorktags | Reads worktags entries from the Requisitions table |
| ResourceForecastLinesAllocations | Retrieve Resource Forecast Line Allocation. |
| ResourcePlanLines | Retrieves a single resource plan line instance. |
| ScorecardResults | Provides the ability to set up and retrieve Scores on Scorecard Results. |
| Scorecards | Retrieves Compensation Scorecard information. |
| ScorecardsDefaultScorecardGoals | Reads defaultScorecardGoals entries from the Scorecards table |
| ScorecardsScorecardProfiles | Reads scorecardProfiles entries from the Scorecards table |
| StudentsPayments | Retrieves a single student payment instance for the specified student ID. |
| SupplierInvoiceRequests | Retrieves a single supplier invoice instance. |
| SupplierInvoiceRequestsAttachments | Retrieves a single attachment instance. |
| TaskResources | Retrieves a single task resource instance. |
| TaskResourcesProjectResources | Reads projectResources entries from the TaskResources table |
| TimeClockEvents | Retrieves a time clock event. |
| WorkContactInformationChangesAddresses | An address as it exists staged for update by the parent business process. |
| WorkContactInformationChangesEmailAddresses | An email address as it exists staged for update by the parent business process. |
| WorkContactInformationChangesInstantMessengers | An instant messenger as it exists staged for update by the parent business process. |
| WorkContactInformationChangesPhoneNumbers | A phone number as it exists staged for update by the parent business process. |
| WorkContactInformationChangesWebAddresses | A web address as it exists staged for update by the parent business process. |
| WorkersAnytimeFeedbackEvents | Retrieves a feedback given event instance with the specified ID. |
| WorkersBusinessTitleChanges | Retrieves a business title change instance for a specific worker. |
| WorkersCheckIns | Retrieves a single Check-In instance. |
| WorkersCheckInsAssociatedTopics | Reads associatedTopics entries from the WorkersCheckIns table |
| WorkersCheckInsCheckInAttachments | Reads checkInAttachments entries from the WorkersCheckIns table |
| WorkersCheckInTopics | Retrieves a single Check-In topic instance. |
| WorkersCheckInTopicsAssociatedCheckIns | Reads associatedCheckIns entries from the WorkersCheckInTopics table |
| WorkersCheckInTopicsCheckInTopicAttachments | Reads checkInTopicAttachments entries from the WorkersCheckInTopics table |