Engineering directors, regional retail leaders, and operations managers ask HR Business Partners and Recruiting Ops the same three questions every week: “How many active headcount do I have across my subordinate teams right now?”, “Which open job requisitions are still unfilled vs. Ready for Hire?”, and “Do I have any approved unfilled position seats without a requisition open yet?” Running live Workday Query Language (WQL) and RaaS reads under each manager’s own Workday security answers all three inside Claude, ChatGPT, or Gemini in seconds—eliminating weekly spreadsheet exports.
Managers rarely avoid Workday because the data is missing; they avoid it because piecing together filled headcount, future-dated hires, open requisitions, and frozen seats requires jumping across multiple staffing and recruiting reports (Staffing Activity Summary, org charts, and recruiting dashboards) and manually reconciling the rows.
Why Headcount Spreadsheets Always Disagree with Workday
In almost every mid-market and enterprise company, FP&A, Recruiting, and Department Heads maintain rival Google Sheets or Excel trackers exported from Workday on Monday morning. Within 24 hours, four normal Workday events break those trackers:
- Offer Acceptances Moving to
Ready for Hire: Once a candidate completesOfferand entersHire(Ready for Hire), the job requisition may still showOpenuntil the hire business process reaches a specific completion threshold, or a future-dated worker now occupies the position effective next month. - Position Management vs. Job Management Nuances: In Position Management Supervisory Organizations, finance approves a Position (
P-10482), and a manager later opens a Job Requisition (JR-2091) against that position. Counting active workers plus open requisitions misses approved Unfilled Positions that do not have a requisition created yet. - Subordinate Supervisory Org Reorgs: When a team lead is promoted and a new subordinate Supervisory Organization is carved out underneath an engineering director, hardcoded spreadsheet filters miss the new org ID unless someone edits the filter list.
- Confidential Replacements and Executive Searches: Exporting a master tenant requisition CSV via an admin or ISU account risks leaking confidential backfill requisitions or compensation grade ranges (
cf_RPTLRVJobRequisition_CompGradeRefID) to managers who have no business seeing peer orgs.
The Live WQL Data Sources That Power Manager Headcount Answers
Workday delivers purpose-built WQL data sources that automatically respect the signed-in manager’s constrained role-based security (Manager on their Supervisory Organization and subordinate orgs):
| Manager Question | Workday WQL Data Source / Alias | Key Delivered Fields to Select |
|---|---|---|
| Manager Question“Who is currently active across all teams rolling up to me?” | Workday WQL Data Source / AliasmyDirectAndIndirectWorkers |
Key Delivered Fields to Selectworker, businessTitle, position, supervisoryOrganization, workersManager, location, timeType, onLeave, firstDayOfWork |
| Manager Question“Which job requisitions are open or frozen in my org, and what are their target hire dates?” | Workday WQL Data Source / AliasallJobRequisitions or jobRequisitionsByRole (or jobRequisitions_Indexed) |
Key Delivered Fields to SelectjobRequisitionEvent, jobPostingTitle, jobRequisitionStatus, targetHireDate, supervisoryOrganization, position, jobRequisitionPrimaryLocation, workerTypeHiringRequirement, createJobRequisitionReason |
| Manager Question“Show filled vs. unfilled positions across all staffing models in my hierarchy” | Workday WQL Data Source / AliasindexedPositionsAndJobs_AllStaffingModels (or a curated Position Management RaaS report) |
Key Delivered Fields to SelectPosition ID, filled/unfilled state, future-dated occupant, attached jobRequisition, supervisoryOrganization, and costCenters |
Concrete WQL Query Examples
When a manager asks “List my open job requisitions sorted by earliest target hire date, including location and hiring reason”, a live connector executes a scoped WQL query against allJobRequisitions (or jobRequisitions_Indexed):
SELECT jobPostingTitle,
jobRequisitionStatus,
targetHireDate,
supervisoryOrganization,
jobRequisitionPrimaryLocation,
position,
workerTypeHiringRequirement,
createJobRequisitionReason
FROM allJobRequisitions
WHERE jobRequisitionStatus in ('Open', 'Frozen')
ORDER BY targetHireDate ASCAnd to count active direct and indirect headcount grouped by subordinate Supervisory Organization without touching terminated workers:
SELECT supervisoryOrganization,
count(worker) AS activeHeadcount
FROM myDirectAndIndirectWorkers
GROUP BY supervisoryOrganizationBecause myDirectAndIndirectWorkers is explicitly scoped to “workers that roll up to the current user and does not include terminated workers”, Workday computes the exact subordinate roll-up dynamically—automatically including any newly created child Supervisory Organization the moment its reorganization event completes.
Enforcing Strict Manager Security Without Admin Bottlenecks
The critical architectural decision is how the AI assistant authenticates to Workday.
If an engineering team builds an internal Slackbot backed by a single Workday Integration System User (Register API Client for Integrations), that bot sees every requisition in the company—including confidential executive replacements and peer departments—forcing your developers to re-implement Workday’s Supervisory Organization tree, intersection security groups, and matrix-manager visibility rules in Python or TypeScript. One bug in that custom filter leaks sensitive staffing plans.
Kiweely Bridge (coming next) takes the opposite approach:
- User-Delegated Workday OAuth (
Register API Client): Every hiring manager signs in once on Workday’s own SSO screen (Authorization Code Grant with PKCE). Every WQL, REST, or RaaS call runs under that manager’s own Workday security groups (Manager,Recruiting Manager) and domain policies (Worker Data: Current Staffing Information,Worker Data: Job Requisitions,Worker Data: Headcount Reports). - Field-Level Guardrails in RAM: Even if a manager’s security group technically grants read access to sensitive fields on a requisition or worker object—such as internal compensation benchmark fields or home contact attributes—your HRIS admin uses Bridge’s AI admin agent to strip those fields in memory before tool output reaches Claude, ChatGPT, or Gemini, and verifies the exact response as a
Managerpersona in Sandbox. - Read-Only by Default, Out-of-Band Check for Writes: Managers can reconcile headcount, check target hire dates, and spot requisitions past their target date with zero risk of mutating tenant data. If your admin later enables an approval or requisition task, Bridge pauses for an out-of-band browser approval card showing Now and After.
- Predictable Company-Wide Cost: Priced flat per company by licensed Workday employee count ($499/mo up to 1,000 employees, $1,499/mo for 1,001–5,000, $3,999/mo for 5,001–20,000, with unlimited calls across Production and all Sandbox tenants, and free on a personal developer tenant), IT never has to ration per-query credits when managers ask follow-up questions during quarterly headcount planning.
Visual Dashboards for Managers Who Prefer One Screen Over Chat
Some plant managers, store directors, and operations leads prefer glancing at a single visual card rather than typing prompts in chat. With Kiweely Leaf (coming next), an HRIS admin can describe a Manager Headcount & Open Roles view in plain English—displaying filled seats, future hires with start dates, open requisitions, and who is out this week—and publish it to a browser URL, Microsoft Teams, Slack, DingTalk, Lark, or the Kiweely Leaf phone app. Like Bridge, Leaf runs as a stateless pass-through under each manager’s own Workday OAuth token with zero HR data stored at rest and no Workday Extend license required.
Frequently asked questions
Can a hiring manager see open requisitions or compensation grades in a peer VP's org?
No. When queries execute under the manager's own user-delegated Workday OAuth grant, Workday constrains results to the Supervisory Organizations where that worker holds the Manager (or Recruiting Manager) role and its subordinate organizations.
What is the difference between Position Management unfilled positions and open Job Requisitions in Workday?
In Position Management, a Supervisory Organization can hold approved unfilled Position restrictions that do not yet have an open Job Requisition attached, whereas a Job Requisition represents an active recruiting opening (Open, Frozen, or Ready for Hire).
Why do exported weekly recruiting spreadsheets go stale within hours?
Offer acceptances, Ready for Hire handoffs, requisition freezes, and internal transfers mutate position and requisition states continuously inside Workday, turning static Monday CSV exports into conflicting headcount counts by Tuesday.
What if frontline or operations managers do not use Claude or ChatGPT?
HRIS teams can publish a dedicated Manager Headcount & Open Roles view with Kiweely Leaf (coming next) that opens in Microsoft Teams, Slack, a browser, or the Kiweely Leaf phone app on the same live, zero-storage Workday OAuth foundation.