REST
When ConnectionType is set to REST, the server models Workday information as an easy-to-use SQL database with tables and views.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Workday account.
Common tables include:
| Table | Description |
| Workers | Retrieves detailed worker records, including employment history, job assignments, and organizational roles. |
| Jobs | Retrieves detailed job positions within the organization, including job titles, descriptions, and classifications. |
| JobProfiles | Defines the attributes and requirements of various job roles, such as necessary skills and qualifications. |
| Organizations | Represents the company's organizational structure, including departments, divisions, and teams. |
| SupervisoryOrganizations | Specifies reporting hierarchies and management relationships within the organization. |
| PayGroups | Stores and retrieves structured data related to payroll groups, including identification, eligibility rules, and payment processing settings. |
| PayrollInputs | Captures and manages individual payroll input records, including employee-specific earnings, deductions, and adjustments for payroll processing. |
| TimeClockEvents | Retrieves a collection of time clock entries for a worker within a specified date range, capturing punch-in/out details and timestamps. |
| JobChangesAdministrative | Tracks administrative updates to a worker's job details, such as employment status changes, worker type adjustments, or organizational assignment shifts. |
| JobChangesJobProfile | Captures changes to an employee’s job profile, including updates to the role's classification, responsibilities, or title. |
| Projects | Stores information about various projects, allowing retrieval of project metadata, statuses, and associated attributes for organizational planning and execution. |
| Requisitions | Manages purchase requisitions, tracking details such as requested items, approvers, and statuses. |
| ExpenseReports | Contains detailed records of employee-submitted expense reports, including submission status, approval workflow, and reimbursement amounts. |
| ExpenseEntries | Stores individual expense line items within an expense report, detailing transaction-specific information like expense type, date, amount, and associated project or cost center. |
| EffectiveChanges | Maintains a log of all effective-dated changes applied to worker or organizational data, such as job changes, compensation adjustments, or transfers. |
| Scorecards | Represents structured templates used to assess employee performance, often containing goals, competencies, and evaluation criteria. |
| Payments | Records and retrieves customer invoice payment transactions, including amounts, payment methods, and processing statuses. |
| SupplierInvoiceRequests | Stores supplier invoice requests, including approval and payment details. |
| Cases | Maintains a record of cases that a user has access to view. Supports issue tracking, employee relations cases, IT service requests, and customer support interactions. |
| Requests | Contains user-initiated requests for business processes such as time off, job changes, or compensation updates. Acts as a centralized repository for pending, approved, or denied requests, providing visibility and control over employee-driven actions. |