Tables

The connector models the data in Workday as a list of tables in a relational database that can be queried using standard SQL statements.

CData Python Connector for Workday Tables


Name	Description
AdHocProjectTimeTransactions	Records ad hoc project-time transactions. This table allows tracking of manually entered work hours for project-based assignments, workforce planning, payroll processing, and cost allocation.
Attachments	Will return attachments
BillableTransactions	Contains detailed records of billable transactions. This table captures information such as transaction amounts, associated accounts, billing periods, and customer details for financial processing and revenue tracking.
Cases	Maintains a record of cases that a user has access to view.This table supports issue tracking, employee relations cases, IT service requests, and customer support interactions.
CasesComment	Retrieves a comment timeline item for a case with the specified comment timeline ID.
CasesCommentAttachments	Reads /attachments entries from the CasesComment table.
CasesInternalNoteTimeline	Retrieves an internal note timeline item for a case with the specified internal note timeline ID.
CasesInternalNoteTimelineActions	Reads /actions entries from the CasesInternalNoteTimeline table.
CasesInternalNoteTimelineAttachments	Reads /attachments entries from the CasesInternalNoteTimeline table.
CasesInternalNoteTimelineGuidanceKbArticleCurrentArticleData	Reads /guidance/kbArticle/currentArticleData entries from the CasesInternalNoteTimeline table.
CasesInternalNoteTimelineQuestionnaireResponseQuestionAnswerPair	Reads /questionnaireResponse/questionAnswerPair entries from the CasesInternalNoteTimeline table.
Definitions	Stores metadata definitions for custom objects within Workday, detailing their attributes, structure, and relationships. This table provides foundational information for managing custom object schemas.
DefinitionsConditionRules	Contains predefined condition rules associated with custom object definitions. These rules dictate how data should be validated or processed within a custom object framework.
DefinitionsFields	Defines individual fields within custom objects, outlining their properties, data types, and relationships. This table serves as a reference for understanding the structure of custom objects.
DefinitionsFieldsAuthorizedUsages	Tracks authorized usages for fields within custom object definitions. This ensures that fields are utilized in accordance with predefined security and access policies.
DefinitionsFieldsCategories	Categorizes fields within custom object definitions, helping users organize and classify data attributes based on functional groupings or business needs.
DefinitionsFieldsDisplayOptions	Stores display preferences and UI rendering configurations for fields in custom object definitions. This table dictates how fields appear in Workday interfaces.
DefinitionsFieldsPrompts	Contains prompt settings for fields within custom objects, providing context-sensitive guidance to users when entering or selecting data.
DefinitionsFieldsValidations	Defines validation rules for fields in custom objects, ensuring data integrity by enforcing constraints such as format checks, value ranges, and mandatory requirements.
DefinitionsValidations	Stores validation rules applicable to custom object definitions, governing how data is verified and ensuring compliance with business rules.
EffectiveChanges	Tracks effective change data related to organizations and workers, providing insights into historical and upcoming changes in employment, organizational structure, and worker attributes.
EffectiveChangesRequestCriteriaOrganizations	Defines organization-based filtering criteria for effective change data, allowing users to query modifications related to specific organizational entities.
EffectiveChangesRequestCriteriaResponseFilterAdditionalNameTypes	Specifies additional name types to be included in response filtering when querying effective change data, ensuring comprehensive retrieval of name-related updates.
EffectiveChangesRequestCriteriaResponseFilterOrganizationRoles	Stores role-based filtering criteria for effective change data, ensuring that changes affecting specific organizational roles are retrieved accurately.
EffectiveChangesRequestCriteriaResponseFilterOrganizationTypes	Defines filters based on organization types for refining effective change queries, enabling users to segment data retrieval according to business units, departments, or other classifications.
EffectiveChangesRequestCriteriaResponseFilterPaymentElectionRules	Maintains filtering rules for payment elections in the effective change dataset, ensuring that financial and compensation-related modifications are accurately captured.
EffectiveChangesRequestCriteriaWorkerOverrides	Stores override criteria for workers in effective change queries, allowing exceptions or special conditions to be applied when retrieving worker-related changes.
EffectiveChangesResponseDataDocuments	Contains response data documents generated from effective change queries, providing structured outputs for reporting, auditing, and compliance purposes.
EventDrivenIntegrationVendorResponse	Manages vendor response data within an event-driven integration process, ensuring seamless updates after third-party payroll processing is completed.
EventDrivenIntegrationVendorResponseErrorMessageSetErrors	Stores error messages related to vendor responses in event-driven integrations, aiding in troubleshooting and process optimization.
ExpenseEntries	Stores individual Quick Expense entries, detailing cost, category, and payment information for employee reimbursements and financial reporting.
ExpenseEntriesAttachments	Retrieves attachment records linked to expense entries, providing access to receipts, invoices, and other supporting documents submitted with expenses.
ExpenseReports	Stores and retrieves structured data for expense reports, including employee submissions, approval status, total amounts, and attached supporting documentation.
ExternalCreators	Retrieves a collection of external contact details.
FieldTypes	Defines custom field types that can be used across different Workday objects, enabling organizations to extend standard data structures.
FieldTypesListInfoValues	Contains metadata and structural information about lists used within FieldTypes, supporting data consistency and validation.
FieldTypesListValues	Stores actual values for custom lists defined in FieldTypes, providing selectable options for custom fields and configurations.
GiveRequestedFeedbackEvents	Tracks feedback request events initiated within the system, recording responses and associated feedback details about employees.
GiveRequestedFeedbackEventsBusinessProcessParametersAttachments	Links attachments submitted as part of business process parameters related to feedback request events, ensuring supporting documents are available for review.
GiveRequestedFeedbackEventsFeedbackComments	Holds detailed comments provided as feedback for employees, offering qualitative insights into performance and professional growth.
HomeContactInformationChangesAddresses	Tracks address changes staged for update in an employee's home contact details, reflecting modifications pending approval.
HomeContactInformationChangesEmailAddresses	Maintains a record of email address changes in employee contact information, ensuring updated communication channels.
HomeContactInformationChangesInstantMessengers	Captures updates to instant messaging details within employee contact information, ensuring real-time communication availability.
HomeContactInformationChangesPhoneNumbers	Logs updates to employee phone numbers within the home contact details, ensuring current contact records are maintained.
HomeContactInformationChangesWebAddresses	Stores pending changes to web addresses within employee contact details, supporting profile updates and digital presence tracking.
ImmigrationEventsDependentImmigrationData	Retrieves a dependent immigration data instance for the specified student ID.
ImmigrationEventsImmigrationData	Retrieves an immigration data instance for the specified immigration event.
InterviewsFeedback	Stores feedback provided by interviewers on candidate performance, helping in decision-making for hiring processes.
JobChangesAdministrative	Provides administrative options related to a specific job change, including approval workflows and policy adherence.
JobChangesBusinessTitle	Retrieves the updated business title associated with a specific job change, reflecting new roles or responsibilities.
JobChangesComment	Returns comments or notes associated with a specific job change, providing additional context on the update.
JobChangesContract	Retrieves contract-related details for a job change, including modifications to employment agreements or terms.
JobChangesJobClassification	Retrieves job classification details for a specific job change, ensuring accurate categorization based on organizational standards.
JobChangesJobProfile	Retrieves a job profile for a given job change, providing role-specific details such as responsibilities and required skills.
JobChangesLocation	Returns location-related details associated with a job change, ensuring proper worksite assignments and compliance.
JobChangesMoveTeam	Retrieves team movement details related to a job change, supporting internal team transfers and reassignments.
JobChangesOpening	Retrieves details on open job positions associated with a job change, helping manage job transfers and internal mobility.
JobChangesPosition	Retrieves position details for a given job change, ensuring updates align with organizational structure and reporting lines.
JobChangesStartDetails	Retrieves start date and other onboarding-related details for a specific job change.
MessageTemplates	Retrieves predefined message templates used for notifications and communications related to HR and job processes.
OrganizationAssignmentChangesBusinessUnit	Retrieves business unit details associated with organization assignment changes.
OrganizationAssignmentChangesComment	Retrieves comment details related to an organization assignment change, providing additional context.
OrganizationAssignmentChangesCompany	Retrieves company details linked to an organization assignment change, ensuring correct entity alignment.
OrganizationAssignmentChangesCostCenter	Retrieves cost center information associated with an organization assignment change, supporting financial tracking.
OrganizationAssignmentChangesCosting	Retrieves costing organization details related to an organization assignment change, ensuring accurate cost allocation.
OrganizationAssignmentChangesCustomOrganizations	Retrieves custom organization details linked to an organization assignment change, allowing for specialized tracking.
OrganizationAssignmentChangesRegion	Retrieves region details associated with an organization assignment change, ensuring correct geographical placement.
OrganizationAssignmentChangesStartDetails	Retrieves start date and onboarding details for an organization assignment change.
PayGroupsPeriods	Supports a collection of payroll periods associated with a specific Payroll Interface pay group ID, facilitating accurate period-based payroll calculations.
Payments	Records and retrieves customer invoice payment transactions, including amounts, payment methods, and processing statuses.
PaymentsRemittanceDetails	Stores detailed breakdowns of remittance lines associated with customer invoice payments, ensuring complete financial reconciliation.
PayrollInputs	Captures and manages individual payroll input records, including employee-specific earnings, deductions, and adjustments for payroll processing.
PayrollInputsInputDetails	Stores detailed breakdowns of payroll input records, including itemized earnings, deductions, and tax components applied to each payroll entry.
PayrollInputsRunCategories	Organizes and categorizes payroll input records by run category, enabling precise payroll runs based on defined processing rules.
PayrollInputsWorktags	Links payroll input records with relevant worktags to ensure proper accounting and reporting of payroll expenses.
PlanPhases	Stores and retrieves details about specific phases within a project plan, tracking key milestones and timelines for effective project management.
PlanTasks	Maintains a collection of tasks within a project plan, including assignments, deadlines, and dependencies for a given project or project phase.
Projects	Stores information about various projects, allowing retrieval of project metadata, statuses, and associated attributes for organizational planning and execution.
ProjectsBusinessEventRecords	Maintains records of business events linked to projects, such as approvals, status updates, and key decision points, for auditing and tracking purposes.
ProjectsGroups	Stores group associations within projects, enabling retrieval of information about team structures, project roles, and collaborations.
ProjectsOptionalHierarchies	Captures optional hierarchical structures within projects, allowing flexible organization and classification of project elements.
ProjectsProjectDependencies	Tracks dependencies between different projects, providing insight into interrelated project timelines and potential scheduling conflicts.
ProjectsWorktags	Stores worktags associated with projects, helping in financial tracking, categorization, and reporting based on project-specific IDs.
Prospects	Manages and stores information about prospective candidates for recruitment, allowing for the creation and tracking of potential hires within the system.
ProspectsCandidatePools	Associates prospects with candidate pools, facilitating segmentation of potential hires based on skill sets, experience, or job roles.
ProspectsCandidateTags	Stores tags linked to prospects, enabling categorization based on skills, experience, or recruitment status.
ProspectsEducations	Retrieves educational background details for a specific prospect, providing insights into qualifications and academic history.
ProspectsExperiences	Stores and retrieves work experience details of prospects, allowing recruiters to assess career history and job suitability.
ProspectsLanguages	Retrieves the languages of a single prospect instance.
ProspectsLanguagesAbilities	Links language abilities to a prospect’s language records, detailing their proficiency levels and specific linguistic skills.
ProspectsResumeAttachments	Stores and retrieves resume attachments uploaded by prospects, ensuring easy access to applicant documentation.
ProspectsSkills	Retrieves the skills of a single prospect instance.
Requests	Retrieves details for a specific request using its unique ID.
RequestsQuestionnaireResponsesQuestionnaireAnswers	Contains answers submitted for questionnaire responses associated with specific requests.
Requisitions	Manages purchase requisitions, tracking details such as requested items, approvers, and statuses.
RequisitionsAttachments	Stores metadata and file content for attachments linked to requisitions.
RequisitionsRequisitionLines	Manages line items within requisitions, including requested quantities and pricing.
RequisitionsRequisitionLinesWorktags	Stores worktag values associated with requisition line items.
RequisitionsWorktags	Links worktags to requisitions at a header level for tracking and cost allocation.
ResourceForecastLinesAllocations	Manages specific allocations within resource forecast lines.
ResourcePlanLines	Stores individual resource planning line items, detailing resource allocation.
ResourcePlanLinesExcludedWorkers	Tracks workers who are excluded from specific resource plans.
ResourcePlanLinesRequirements	Defines specific resource requirements within a resource plan.
ScorecardResults	Stores and retrieves scorecard evaluations used for performance tracking.
ScorecardResultsDefaultScorecardGoalsResultPerformanceScores	Retrieves performance scores from default scorecard goal evaluations.
ScorecardResultsProfileScorecardGoalsResult	Retrieves profile-based scorecard goal results for performance analysis.
Scorecards	Manages compensation scorecard data for performance-based evaluations.
ScorecardsDefaultScorecardGoals	Stores default scorecard goals for use in performance assessments.
ScorecardsScorecardProfiles	Links scorecards to profiles for tracking and managing performance results.
StudentsPayments	Stores student payment transactions and billing information.
SuccessionPlanEvents	Get Succession Plan Events
SuccessionPlanEventsBusinessProcessParametersAttachments	Reads /businessProcessParameters/attachments entries from the SuccessionPlanEvents table.
SuccessionPlanEventsCandidates	Retrieves a collection of information for succession plan candidates for a succession plan event.
SuccessionPlans	Get succession plans
SupplierInvoiceRequests	Stores supplier invoice requests, including approval and payment details.
SupplierInvoiceRequestsAttachments	Manages attachments linked to supplier invoice requests.
TaskResources	Retrieves a collection of task resources, including metadata and dependencies associated with tasks within Workday.
TaskResourcesProjectResources	Fetches project resource data linked to tasks, enabling project tracking and resource allocation analysis.
TaxRates	Retrieves a single or a collection of State Unemployment Insurance (SUI) tax rates configured for different company entities.
TimeClockEvents	Retrieves a collection of time clock entries for a worker within a specified date range, capturing punch-in/out details and timestamps.
TimeClockEventsWorkerTimeAttestations	Reads /workerTimeAttestations entries from the TimeClockEvents table.
WorkContactInformationChangesAddresses	Represents address updates pending approval as part of a worker's contact information change process.
WorkContactInformationChangesEmailAddresses	Retrieves all email address changes staged for update as part of a Workday business process.
WorkContactInformationChangesInstantMessengers	Captures pending updates to a worker’s instant messaging details within the Workday system.
WorkContactInformationChangesPhoneNumbers	Records phone number changes for a worker before they are officially updated in Workday.
WorkContactInformationChangesWebAddresses	Tracks updates to a worker's web address details, such as personal or professional websites, awaiting approval.
WorkersAnytimeFeedbackEvents	Retrieves feedback events given to or about a worker, including manager and peer reviews.
WorkersAnytimeFeedbackEventsBusinessProcessParametersAttachments	Fetches attachments associated with business process events related to anytime feedback.
WorkersAnytimeFeedbackEventsFeedbackAlsoAbout	Lists additional workers referenced in a feedback event, providing context on multi-person evaluations.
WorkersAnytimeFeedbackEventsWorkersToNotify	Lists workers notified about a specific feedback event, including managers and HR personnel.
WorkersBusinessTitleChanges	Retrieves historical and pending changes to a worker’s business title, tracking career progression.
WorkersCheckIns	Retrieves detailed information on a worker’s check-in records, including topics discussed and feedback received.
WorkersCheckInsAssociatedTopics	Lists topics associated with check-in meetings, providing insights into recurring themes in discussions.
WorkersCheckInsCheckInAttachments	Fetches attachments related to worker check-ins, such as documents or notes shared during a session.
WorkersCheckInTopics	Retrieves a collection of discussion topics covered in worker check-ins, aiding in performance management.
WorkersCheckInTopicsAssociatedCheckIns	Lists check-in sessions that reference a specific topic, useful for tracking recurring discussions over time.
WorkersCheckInTopicsCheckInTopicAttachments	Fetches files or supporting materials attached to check-in topics for enhanced documentation.
WorkersDevelopmentItems	Retrieves development items for a worker, including skill-building tasks and career advancement plans.
WorkersExplicitSkills	Retrieves explicitly recorded skills for a worker that are tracked and maintained as part of their professional profile in Workday.
WorkersExplicitSkillsSkillSources	Fetches sources of explicit skills, such as self-reported skills, manager endorsements, or third-party assessments, providing context for skill validation.
WorkersExternalSkillLevel	Retrieves externally acquired skill levels for a worker from third-party systems, certifications, or external assessments.
WorkersRequestedFeedbackOnSelfEvents	Retrieves instances where a worker has requested feedback on their own performance from colleagues, managers, or peers.
WorkersRequestedFeedbackOnSelfEventsBusinessProcessParametersAttachments	Fetches attachments linked to feedback requests initiated by a worker, such as self-evaluations or supporting documents.
WorkersRequestedFeedbackOnSelfEventsFeedbackQuestions	Lists questions included in a worker’s self-requested feedback, enabling structured evaluation.
WorkersRequestedFeedbackOnSelfEventsFeedbackResponders	Retrieves details on who has responded to a worker's self-requested feedback and their responses.
WorkersRequestedFeedbackOnWorkerEvents	Retrieves feedback requests initiated by managers or peers regarding a specific worker.
WorkersRequestedFeedbackOnWorkerEventsBusinessProcessParametersAttachments	Fetches attachments related to feedback requests initiated by managers or peers for a worker.
WorkersRequestedFeedbackOnWorkerEventsFeedbackQuestions	Lists evaluation questions used in peer or manager-initiated feedback for a worker.
WorkersRequestedFeedbackOnWorkerEventsFeedbackResponders	Retrieves a list of individuals who provided feedback in response to a manager or peer request regarding a worker.
WorkersSkillItems	Lists skill items associated with a worker, including validated competencies and self-reported skills.