Tables
The cmdlet models the data in Workday as a list of tables in a relational database that can be queried using standard SQL statements.
CData Cmdlets PowerShell Module for Workday Tables
| Name | Description |
| AdHocProjectTimeTransactions | Retrieves a collection of ad hoc project time transactions. |
| Attachments | Uploads an attachment when creating a case. |
| AttributeAttributeValues | No description available. |
| AttributeAttributeValuesRestrictToEnvironments | Reads /restrictToEnvironments entries from the AttributeAttributeValues table. |
| BillableTransactions | Retrieves a single billable transaction instance. |
| Cases | Retrieves a list of cases that the user is secured to view. |
| CasesTimeline | Retrieves a list of comment timeline items for a case. |
| CasesTimelineAttachments | Reads /attachments entries from the CasesTimeline table. |
| Configurations | No description available. |
| ConfigurationsAttributes | No description available. |
| ConfigurationsAttributesValues | Reads /values entries from the ConfigurationsAttributes table. |
| Definitions | Retrieves a custom object definition. |
| DefinitionsConditionRules | Retrieves a collection of condition rules in a custom object definition. |
| DefinitionsFields | Retrieves a field in a custom object definition. |
| DefinitionsFieldsAuthorizedUsages | Reads /authorizedUsages entries from the DefinitionsFields table. |
| DefinitionsFieldsCategories | Reads /categories entries from the DefinitionsFields table. |
| DefinitionsFieldsDisplayOptions | Reads /displayOptions entries from the DefinitionsFields table. |
| DefinitionsFieldsPrompts | Reads /prompts entries from the DefinitionsFields table. |
| DefinitionsFieldsValidations | Reads /validations entries from the DefinitionsFields table. |
| DefinitionsValidations | Retrieves a collection of validations in a custom object definition. |
| EventDrivenIntegrationVendorResponse | Updates a specific vendor response instance of Event-Driven Integration with the specified data after the third-party payroll system completes processing of the worker changes. |
| EventDrivenIntegrationVendorResponseErrorMessageSetErrors | Reads /errorMessageSet/errors entries from the EventDrivenIntegrationVendorResponse table. |
| 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. |
| FieldTypes | Retrieves a collection of custom field types. |
| FieldTypesListInfoValues | Reads /listInfo/values entries from the FieldTypes table. |
| FieldTypesListValues | Retrieves a list value for a custom lists in a custom object definition. |
| GiveRequestedFeedbackEvents | Retrieves a collection of feedback given events about the user that responded to the feedback request. |
| GiveRequestedFeedbackEventsBusinessProcessParametersAttachments | Reads /businessProcessParameters/attachments entries from the GiveRequestedFeedbackEvents table. |
| GiveRequestedFeedbackEventsFeedbackComments | Reads /feedbackComments entries from the GiveRequestedFeedbackEvents table. |
| HomeContactInformationChangesAddresses | Retrieve all existing addresses staged for update by the parent business process |
| HomeContactInformationChangesEmailAddresses | Retrieve all existing addresses staged for update by the parent business process |
| HomeContactInformationChangesInstantMessengers | An instant messenger as it exists staged for update by the parent business process. |
| HomeContactInformationChangesPhoneNumbers | Retrieve all existing phone numbers staged for update by the parent business process |
| HomeContactInformationChangesWebAddresses | Retrieve all existing web addresses 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 collection of payroll periods 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 collection of Project Plan Tasks for a specified Project or Project Plan Phase. |
| Projects | Retrieves a collection of Projects. |
| ProjectsBusinessEventRecords | Reads /businessEventRecords entries from the Projects table. |
| ProjectsGroups | Reads /groups entries from the Projects table. |
| ProjectsOptionalHierarchies | Reads /optionalHierarchies entries from the Projects table. |
| ProjectsProjectDependencies | Reads /projectDependencies entries from the Projects table. |
| ProjectsWorktags | Reads /worktags entries from the Projects table. |
| Prospects | Create prospects. |
| ProspectsCandidatePools | Reads /candidatePools entries from the Prospects table. |
| ProspectsCandidateTags | Reads /candidateTags entries from the Prospects table. |
| ProspectsEducations | Retrieves the education of a single prospect instance. |
| ProspectsExperiences | Retrieves a single experience instance for a prospect. |
| ProspectsLanguages | Retrieves a single language instance for a prospect. |
| ProspectsLanguagesAbilities | Reads /abilities entries from the ProspectsLanguages table. |
| 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. |
| RequestsQuestionnaireResponsesQuestionnaireAnswers | Reads /questionnaireResponses/questionnaireAnswers entries from the Requests table. |
| Requisitions | Retrieves a collection of requisitions. |
| 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 | Retrieves a Resource Forecast Line Allocation for the specified ID. |
| ResourcePlanLines | Retrieves a single resource plan line instance. |
| ResourcePlanLinesExcludedWorkers | Reads /excludedWorkers entries from the ResourcePlanLines table. |
| ResourcePlanLinesRequirements | Reads /requirements entries from the ResourcePlanLines table. |
| ScorecardResults | Provides the ability to set up and retrieve Scores on Scorecard Results. |
| ScorecardResultsDefaultScorecardGoalsResultPerformanceScores | Reads /defaultScorecardGoalsResult/performanceScores entries from the ScorecardResults table. |
| ScorecardResultsProfileScorecardGoalsResult | Reads /profileScorecardGoalsResult entries from the ScorecardResults table. |
| 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 collection of supplier invoices. |
| SupplierInvoiceRequestsAttachments | Retrieves a single attachment instance. |
| TaskResources | Retrieves a collection of Task Resources. |
| TaskResourcesProjectResources | Reads /projectResources entries from the TaskResources table. |
| TaxRates | Retrieves a single or a collection of company SUI rates. |
| TimeClockEvents | Retrieves a collection of time clock events for a worker for a date range. |
| WorkContactInformationChangesAddresses | An address as it exists staged for update by the parent business process. |
| WorkContactInformationChangesEmailAddresses | Retrieve all existing addresses 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. |
| WorkersAnytimeFeedbackEventsBusinessProcessParametersAttachments | Reads /businessProcessParameters/attachments entries from the WorkersAnytimeFeedbackEvents table. |
| WorkersAnytimeFeedbackEventsFeedbackAlsoAbout | Reads /feedbackAlsoAbout entries from the WorkersAnytimeFeedbackEvents table. |
| WorkersAnytimeFeedbackEventsWorkersToNotify | Reads /workersToNotify entries from the WorkersAnytimeFeedbackEvents table. |
| 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 collection of Check-Ins topics. |
| WorkersCheckInTopicsAssociatedCheckIns | Reads /associatedCheckIns entries from the WorkersCheckInTopics table. |
| WorkersCheckInTopicsCheckInTopicAttachments | Reads /checkInTopicAttachments entries from the WorkersCheckInTopics table. |
| WorkersExplicitSkills | Get Explicit Skills for Skill Enabled |
| WorkersExplicitSkillsSkillSources | Reads /skillSources entries from the WorkersExplicitSkills table. |
| WorkersExternalSkillLevel | Retrieves all external skill level information for a worker. You can filter the external skill levels by externalSkillId. |
| WorkersRequestedFeedbackOnSelfEvents | Retrieves a single self-requested feedback event instance for the specified worker. |
| WorkersRequestedFeedbackOnSelfEventsBusinessProcessParametersAttachments | Reads /businessProcessParameters/attachments entries from the WorkersRequestedFeedbackOnSelfEvents table. |
| WorkersRequestedFeedbackOnSelfEventsFeedbackQuestions | Reads /feedbackQuestions entries from the WorkersRequestedFeedbackOnSelfEvents table. |
| WorkersRequestedFeedbackOnSelfEventsFeedbackResponders | Reads /feedbackResponders entries from the WorkersRequestedFeedbackOnSelfEvents table. |
| WorkersRequestedFeedbackOnWorkerEvents | Retrieves a single requested feedback event instance for the specified worker. |
| WorkersRequestedFeedbackOnWorkerEventsBusinessProcessParametersAttachments | Reads /businessProcessParameters/attachments entries from the WorkersRequestedFeedbackOnWorkerEvents table. |
| WorkersRequestedFeedbackOnWorkerEventsFeedbackQuestions | Reads /feedbackQuestions entries from the WorkersRequestedFeedbackOnWorkerEvents table. |
| WorkersRequestedFeedbackOnWorkerEventsFeedbackResponders | Reads /feedbackResponders entries from the WorkersRequestedFeedbackOnWorkerEvents table. |
| WorkersSkillItems | Returns skill items. |