JDBC Driver for Workday

Build 23.0.8839

テーブル

本製品 はWorkday のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

CData JDBC Driver for Workday テーブル

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

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