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