---
title: "Live Workday Open Roles & Headcount for Hiring Managers"
description: "How engineering and operations managers check open job requisitions, target hire dates, and filled vs unfilled seats via live WQL under manager security."
url: https://kiweely.com/blog/live-headcount-open-requisitions-answers-for-hiring-managers
---

# Giving Hiring Managers Live Workday Open Roles and Headcount Answers in Chat

Hiring managers ping HR Business Partners and Recruiting Ops for open requisition IDs, target hire dates, and unfilled seats because Workday staffing reports take too many clicks. Live WQL queries under each manager’s own Workday security answer those questions directly in chat.

-   By Kiweely
-   November 15
-   5 min read

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:

1.  **Offer Acceptances Moving to `Ready for Hire`:** Once a candidate completes `Offer` and enters `Hire` (`Ready for Hire`), the job requisition may still show `Open` until the hire business process reaches a specific completion threshold, or a future-dated worker now occupies the position effective next month.
2.  **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.
3.  **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.
4.  **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 |
| --- | --- | --- |
|  *“Who is currently active across all teams rolling up to me?”* | `myDirectAndIndirectWorkers` | `worker`, `businessTitle`, `position`, `supervisoryOrganization`, `workersManager`, `location`, `timeType`, `onLeave`, `firstDayOfWork` |
|  *“Which job requisitions are open or frozen in my org, and what are their target hire dates?”* | `allJobRequisitions` or `jobRequisitionsByRole` (or `jobRequisitions_Indexed`) | `jobRequisitionEvent`, `jobPostingTitle`, `jobRequisitionStatus`, `targetHireDate`, `supervisoryOrganization`, `position`, `jobRequisitionPrimaryLocation`, `workerTypeHiringRequirement`, `createJobRequisitionReason` |
|  *“Show filled vs. unfilled positions across all staffing models in my hierarchy”* | `indexedPositionsAndJobs_AllStaffingModels` (or a curated Position Management RaaS report) | Position 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`):

sql

```
SELECT jobPostingTitle,
       jobRequisitionStatus,
       targetHireDate,
       supervisoryOrganization,
       jobRequisitionPrimaryLocation,
       position,
       workerTypeHiringRequirement,
       createJobRequisitionReason
FROM allJobRequisitions
WHERE jobRequisitionStatus in ('Open', 'Frozen')
ORDER BY targetHireDate ASC
```

And to count active direct and indirect headcount grouped by subordinate Supervisory Organization without touching terminated workers:

sql

```
SELECT supervisoryOrganization,
       count(worker) AS activeHeadcount
FROM myDirectAndIndirectWorkers
GROUP BY supervisoryOrganization
```

Because `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](https://kiweely.com/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 `Manager` persona 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](https://kiweely.com/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.

## Read next

[All posts](https://kiweely.com/blog)

-   [November 15 ### HR Portal Suites (ServiceNow Employee Center, Applaud) vs. AI-Built Pass-Through Screens](https://kiweely.com/blog/kiweely-leaf-vs-servicenow-employee-center-applaud-workday)
-   [November 15 ### AI Chat Connector vs. Custom Screen: Choosing Between Kiweely Bridge and Kiweely Leaf](https://kiweely.com/blog/kiweely-bridge-vs-kiweely-leaf-ai-chat-or-custom-screen)
-   [November 15 ### Turning Workday Onboarding Tasks into a Clean Day-One Checklist in Teams or the Browser](https://kiweely.com/blog/interactive-onboarding-checklists-in-teams-and-slack-on-workday)

### More guides on More Workday guides

[All 46 guides](https://kiweely.com/guides#more)

-   [Workday Cost Centers and Workers to NetSuite After a Reorg](https://kiweely.com/guides/workday-cost-centers-workers-to-netsuite)
-   [Workday Headcount to Snowflake When Data Cloud Is Not Enough](https://kiweely.com/guides/workday-headcount-to-snowflake-beyond-data-cloud)
-   [Performance Check-In and Goals Screens Managers Will Open](https://kiweely.com/guides/performance-check-in-goals-screens-managers-open)
-   [Building an Open Enrollment Decision Screen on Live Workday Elections](https://kiweely.com/guides/open-enrollment-decision-screen-live-workday-elections)
-   [Mandatory Learning and Acknowledgements with Live Workday Status](https://kiweely.com/guides/mandatory-learning-acknowledgements-live-workday-status)
-   [Day-One Tax, Payment Election, and Form I-9 Pages as Pass-Through](https://kiweely.com/guides/day-one-tax-payment-i9-pass-through-pages)
-   [Compensation Statement Screens and Peer Pay Redaction](https://kiweely.com/guides/compensation-statement-field-redaction-manager-peers)
-   [Publishing One Employee Screen to Web, Teams, and Phone](https://kiweely.com/guides/one-screen-definition-web-teams-phone)

## Your Workday work, done by AI.

Kiweely Vine is the AI agent that builds, deploys and tests Extend apps as real people, makes changes in any Workday task screen, answers from your real tenant and builds reports.

[Start for free](https://kiweely.com/download) [See how it works](https://kiweely.com/vine/how-it-works)

## Get the next one in your inbox.

One email a month for Workday teams: what’s changing in Workday and what to retest, one tip tried in a real tenant, and what’s new at Kiweely.
