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