Let AI do the work for you
Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.
Payroll costs by job title
SQL query for Workday
Get the payroll costs by job title.
SELECT jobs.job_title, SUM(workers.salary) AS payroll_cost FROM workers JOIN jobs ON workers.job_id = jobs.job_id GROUP BY jobs.job_title
Workday data model
Table Workers
Table Organizations
Table Job Profiles
Table Positions
Table Agencies
Table Citizenship Statuses
Table Collective Agreements
Table Creditable Service
Table Fse Worker Category Criterias
Table Functionality For Staffing Transactions
Table Global Staffing Eligibility Rules
Table Global Staffing Eligibility Rules Without Dependencies
Table Job Overlap Routing Exclusion Rules
Table Legal Authorities
Table Maintain Employee Contract Rules For Country
Table Maintain Job Overlap Routing Exclusion Rule
Table Maintain Notice Periods For Country
Table Maintain Probation Periods For Country
Table Maintain Working Time For Country
Table Manager Integrated Organization
Table Nature Of Actions
Table Notice Period Eligibility Rules
Table Notice Period Eligibility Rules Without Dependencies
Table Notice Periods For Worker
Table Personnel Action Request Status On Mass Action
Table Probation Period Eligibility Rules
Table Probation Period Eligibility Rules Without Dependencies
Table Probation Period Outcome
Table Probation Period Outcomes
Table Probation Periods For Workers
Table Remarks
Table Role Assignments For Role Assigners
Table Staffing Field Defaults
Table Staffing Field Defaults Condition Rules
Table Staffing Field Defaults Condition Rules Without Dependencies
Table Student Employment Eligibility Data
Table Student Employment Eligibility Rule Set
Table Student Employment Eligibility Rules
Table Worker Documents
Table Working Time Eligibility Rules
Table Job Families
Table Job Classifications
Table Aboriginal Indigenous Identification Details
Table Academic Appointee
Table Academic Appointment Track Additional Data
Table Academic Ranks
Table Academic Unit Hierarchies
Table Academic Units
Table Active Consent By Country
Table Active Consent Preferences By Country For Role
Table Active Consent Processing Purposes
Table Appointment Specialties
Table Assign Establishment Events
Table Assign User Based Security Group
Table Change Government Ids
Table Change Home Contact Information
Table Change Legal Name
Table Change Licenses
Table Change Other Ids
Table Change Passports And Visas
Table Change Personal Information
Table Change Preferred Name
Table Change Veteran Status Identification
Table Change Work Contact Information
Table Committee Classification Groups
Table Committee Classifications
Table Committee Definition
Table Committee Meetings
Table Committee Membership Types
Table Committee Types
Table Company Insider Types
Table Country Specific Configurable Personal Information Sections
Table Creditable Service Types
Table Difficulty To Fill
Table Disabilities
Table Disability Configuration
Table E Verify Employer Agent Client Company Ids
Table Eeo Data Record
Table Email Match Exclusions
Table Employee Image
Table Establishments
Table Ethnicities
Table External Disability Self Identification Records
Table External Form I
Table External Form I Section
Table External Form I Source
Table External Urls
Table External Us Federal Disability Self Identification Records
Table External Us Federal Ethnicity And Race Self Identification Records
Table Form I Business Address
Table Former Worker Documents
Table Former Workers
Table Frequencies
Table Gender Identities
Table Genders
Table Holiday Calendars
Table Job Categories
Table Job Family Groups
Table Lgbt Identifications
Table Location Attributes
Table Location Hierarchy Organization Assignments
Table Locations
Table Maintain Non Country Nationalities
Table Match Rules
Table Military Discharge Types
Table Name Match Exclusions
Table National Id Type Cache Statuses
Table Non Country Specific Configurable Personal Information Sections
Table Onboarding Announcements
Table Onboarding Audience Condition Rules
Table Onboarding Audiences
Table Onboarding Bulletins
Table Onboarding Content Cards
Table Onboarding Content Messages
Table Onboarding Content Videos
Table Onboarding External Brands
Table Onboarding Notifications
Table Onboarding Plan Assignments
Table Onboarding Plan Audiences
Table Onboarding Plans
Table Onboarding Section Configurations
Table Organization Reference Ids
Table Organizations Names
Table Period Reporting Calendars
Table Person Merge Records
Table Person Name Pronunciations
Table Person Photos
Table Personal Information Help Text
Table Political Affiliations
Table Preferred Communication Language
Table Previous System Job History
Table Pronouns
Table Provisioning Group Assignments
Table Provisioning Groups
Table Public Profile Preferences
Table Race Ethnicity Details
Table Related Person Relationships
Table Report Safety Incident
Table Safety Incident Locations
Table Search Settings
Table Service Center Representative Workday Accounts
Table Service Center Representatives
Table Sexual Orientations
Table Social Benefits Localities
Table Sort Order Enableds
Table Supervisory Organization Assignment Restrictions
Table Training Types
Table Uniform Service Reserve Statuses
Table Universal Identifier
Table User Based Security Group Assignments
Table Vaccination Event Types
Table Vaccination Status
Table Vaccinations
Table Vaccine Manufacturer
Table Vaccine Types
Table Vaccines
Table Veterans Preferences
Table Work Schedule Calendar Groups
Table Work Schedule Calendars
Table Work Shifts
Table Work Status Rule Sets
Table Workday Account
Table Workday Benchmarking Job Profile Mappings
Table Worker Event History
Table Worker Photos
Table Worker Preferred Time Zones
Table Worker Start Date Correction Defaulting Rules
Table Workers Compensation Codes
Table Workplace Test Results
Table Workplace Test Types
Table Workplace Tests
Table Workteams
Table Job Requisitions
Table Candidates
Table Job Applications
Table Applicants
Table Assess Candidate
Table Assign Recruiting Self Schedule Calendars
Table Background Check
Table Background Check Packages
Table Candidate Attachments
Table Candidate Availability Templates
Table Candidate Photos
Table Candidate Ranking Templates
Table Candidate Rating Templates
Table Evergreen Requisitions
Table External Reference
Table Interview Feedbacks
Table Interviews
Table Job Application Additional Data
Table Job Application Template Translation
Table Job Posting Sites
Table Job Postings
Table Job Requisition Candidate Availability Defaults
Table Job Requisition Interview Settings
Table Maintain Candidate List Assignment
Table Masked Job Requisition Defaults
Table Masked Recruiting Configurations
Table Questionnaires
Table Ranking Data Mappings
Table Rating Data Mappings
Table Recruiting Agencies
Table Recruiting Agency Additional Data
Table Recruiting Agency Users
Table Recruiting Assessment Categories
Table Recruiting Assessment Category Security Segments
Table Recruiting Self Schedule Calendar Types
Table Recruiting Self Schedule Calendars
Table Referees
Table Regions For Recruiting
Table Site Brands
Table Veteran Statuses
Table Web Conference Interview Data
Table Compensation Grades
Table Compensation Grade Hierarchy
Table Compensation Plans
Table Benchmark Jobs
Table Compensation Change Templates
Table Compensation Eligibility Rules
Table Compensation Eligibility Rules No Deps
Table Compensation Matrices
Table Compensation Scorecard Results
Table Compensation Scorecards
Table Compensation Survey Job Details
Table Compensation Survey Job Matches
Table Configurable Compensation Basis
Table Eligible Earnings
Table Enhanced Severance Matrices
Table Future Payment Plan Assignments
Table Locality Pay Areas
Table One Time Payment Plan Categories
Table One Time Payment Plans
Table Pay Rate Determinants
Table Period Activity Rate Matrices
Table Period Activity Tasks
Table Previous System Compensation History
Table Stock Participation Rate Tables
Table Compensation Review Events
Table Compensation Review Participation Rule Sets
Table Compensation Review Templates
Table Compensation Review Validation Rules
Table Deferred Bonus Calculations
Table Eligibility Waiting Periods
Table Employee Awards
Table Employee Proration Segment Details
Table Compensation Review Budget Pools
Table Benefit Plans
Table Benefit Elections
Table Benefit Providers
Table Benefit Plan Year Definitions
Table Health Care Rates
Table Insurance Rates
Table Benefit Annual Rates
Table Benefit Individual Rates
Table Benefits Billing Events
Table Pay Groups
Table Period Schedules
Table Payroll Results
Table Advanced Lookup Tables
Table Common Paymasters
Table Company Payment Dates
Table Company Us Tax Reporting
Table Efw Year End Employer Filing Data
Table Efw Year End Worker Filing Data
Table Employer Paid Expense Costing Defaults Criterias
Table Flexible Payment And Deduction Event
Table Input Value Lookup Tables
Table Monthly Worker Tax Filing Data
Table Multicriteria Lookup Tables
Table Multiple Worksite Report
Table Pay Component Group Exceptions
Table Pay Component Group Exceptions Flat Sum Bonus
Table Paycheck Deliveries
Table Payment Election Rules
Table Payroll Accounting Options
Table Payroll Balances
Table Payroll Deduction Recipients
Table Payroll Federal W Tax Election
Table Payroll History Payments
Table Payroll Involuntary Withholding Orders
Table Payroll Limit Overrides
Table Payroll Off Cycle Payments
Table Payroll Payee Ficas
Table Payroll Payee Futas
Table Payroll Payee Ongoing Work Jurisdiction Tax Election
Table Payroll Payee Pt S
Table Payroll Payee Td S
Table Payroll Payee Tax Location Mappings
Table Payroll Payslips
Table Payroll Pre Printed Payslips
Table Payroll Reporting Codes For Workers
Table Payroll Tax Mappings On Location
Table Payroll Usa State Convenience Rule Elections
Table Payroll Usa State And Local Tax Elections
Table Payroll Worker Tax Treaties
Table Periodic Company Can Tax Remittance Data
Table Periodic Company Tax Filing Data
Table Periodic Worker Tax Filing Data
Table Quarterly Worker Tax Filing Data
Table Run Pay Calculation
Table Single Legal Entities
Table Submit Payroll Inputs
Table Successor Employers
Table Tax Document Deliveries
Table Tax Levy Deduction Restrictions
Table W Pr Control Numbers
Table W W C Printing Election
Table Withholding Order Local Minimum Wage Rate
Table Worker Costing Allocations
Table Worker Payroll Tax Filing Overrides
Table Batches
Table Pi Employer Paid Expense Costing Defaults Criterias
Table External Pay Groups
Table External Payroll Deductions
Table External Payroll Earnings
Table External Payroll Inputs
Table Payees
Table Pi Payroll Accounting Options
Table Pi Period Schedules
Table Pi Worker Costing Allocations
Table Worker Effective Change Integration Systems
Table Leave Types
Table Absence Inputs
Table Time Off Plan Balances
Table Accrual Expiration Overrides
Table Carryover Overrides
Table Override Balances
Table Employee Reviews
Table Organization Goals
Table Certification Issuers
Table Certifications
Table Check In Topics
Table Check Ins
Table Competencies
Table Competency Categories
Table Degrees
Table Employee Review Templates
Table Feedback Badges
Table Feedback Questions
Table Fields Of Study
Table Goal Payout Bands
Table Goal Units
Table Rating Scales
Table Review Question Categories
Table Review Questions
Table Review Types
Table School Types
Table Skill Source Precedences
Table Update Employee Review Ratings
Table Learning Courses
Table Learning Enrollments
Table Archived External Learning User
Table Custom Validation Rules
Table Equivalency Rules
Table Extended Enterprise Affiliations
Table Extended Enterprise Job Profiles
Table Extended Enterprise Learner Types
Table Extended Enterprise Learners
Table External Learning Assessors
Table External Learning Instructors
Table External Learning Users
Table Internal Learning Assessors
Table Internal Learning Instructors
Table Learner Group Rules
Table Learner Group Rules Without Dependencies
Table Learner Pricing Rules
Table Learning Blended Courses
Table Learning Catalogs
Table Learning Certification Rules
Table Learning Content Subscriptions
Table Learning Course Offerings
Table Learning Course Offerings Additional Data
Table Learning Courses Additional Data
Table Learning Custom Sliders
Table Learning Digital Courses
Table Learning Enrollment Pricing Records
Table Learning Imported Contents
Table Learning Imported Records
Table Learning Lessons
Table Learning Navigation Items
Table Learning Organization Payment Configuration
Table Learning Other Unit Types
Table Learning Page Items
Table Learning Prerequisite Rules
Table Learning Program Additional Data
Table Learning Programs
Table Learning Security Categories
Table Learning Security Segments
Table Learning Spotlight Cards
Table Learning Topics
Table Learning Vendors
Table Learning Virtual Classrooms
Table Media Settings
Table Observational Checklists
Table Sales Items
Table Self Registration Urls
Table Training Credit Mappings
Table Version Schemas
Table Virtual Classroom Attendance Records
Table Time Blocks
Table Time Requests
Magical SQL for Workday with Peliqan.io
Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.
- Power BI
- Metabase
- Tableau
