To answer a hiring manager’s live headcount and open-role questions in Workday without over-exposing executive searches or confidential pay bands, combine staffing/v7 and common/v1 REST (GET /workers/{ID}/supervisoryOrganizationsManaged, GET /supervisoryOrganizations/{ID}/members) for active team rosters with Workday Query Language (POST /wql/v1/data) on jobRequisitionsByRole and openPositionsByOrganization for open requisitions and unfilled position seats.
A common surprise for engineers building manager dashboards is discovering that recruiting/v4 REST (GET /jobPostings) only lists externally published career-site postings—missing unposted internal backfills, frozen requisitions, and unfilled Position Management chairs that do not yet have a requisition attached. Knowing which Workday API surface owns each piece of the staffing model prevents miscounted headcount.
Mapping Workday Staffing & Recruiting Surfaces
| Question to Answer | Best API Surface | Resource / Data Source / Operation | Required Scope & Security Domains |
|---|---|---|---|
| Question to AnswerWhich Supervisory Orgs does this manager lead? | Best API SurfaceREST common/v1 |
Resource / Data Source / OperationGET /workers/{ID}/supervisoryOrganizationsManaged |
Required Scope & Security DomainsScope: Organizations and Roles; Domain: Reports: Organization. |
| Question to AnswerWho is currently active in this Supervisory Org? | Best API SurfaceREST staffing/v7 or common/v1 |
Resource / Data Source / OperationGET /supervisoryOrganizations/{ID}/members & /orgChart |
Required Scope & Security DomainsScope: Organizations and Roles / Staffing; Domains: View: Supervisory Organization, Reports: Organization. |
| Question to AnswerWhich Job Requisitions are open for my team? | Best API SurfaceWQL (wql/v1) or SOAP Recruiting |
Resource / Data Source / OperationWQL jobRequisitionsByRole / allJobRequisitions; SOAP Get_Job_Requisitions |
Required Scope & Security DomainsScope: Recruiting / Staffing; Role-constrained Job Requisition domains. |
| Question to AnswerWhich Position Management seats are unfilled or frozen? | Best API SurfaceWQL (wql/v1) or SOAP Staffing |
Resource / Data Source / OperationWQL openPositionsByOrganization / allOpenPositions; SOAP Get_Positions |
Required Scope & Security DomainsScope: Staffing / Jobs & Positions; Position Management reporting domains. |
| Question to AnswerWhich roles are live on the external career site? | Best API SurfaceREST recruiting/v4 |
Resource / Data Source / OperationGET /jobPostings |
Required Scope & Security DomainsScope: Recruiting; Domain: Job Postings: External. |
Step 1: Resolve Managed Supervisory Organizations and Active Headcount
In Workday, headcount belongs to a Supervisory Organization (Supervisory Organization), and managers frequently oversee both a top-level org and nested subordinate teams (see subordinate org security intersection).
Start by querying GET /common/v1/workers/{ID}/supervisoryOrganizationsManaged under the signed-in manager’s OAuth credential, then read active filled members via GET /staffing/v7/supervisoryOrganizations/{org_ID}/members (or GET /common/v1/workers/{ID}/directReports for immediate direct reports under Self-Service: My Team). Always check whether your definition of headcount counts Employees only or includes Contingent Workers, and whether workers currently (On Leave) with Allow Job Overlap for Leave enabled occupy the same position alongside a temporary backfill.
Step 2: Query Open Job Requisitions via WQL (jobRequisitionsByRole)
To list open, pending-approval, or frozen requisitions—including target hire dates, days open, and recruiting start dates—run a WQL query against jobRequisitionsByRole:
SELECT
workdayID,
referenceID1,
jobPostingTitle,
supervisoryOrganization,
jobProfileHiringRequirement,
jobRequisitionPrimaryLocation,
workerTypeHiringRequirement,
timeTypeHiringRequirement,
jobRequisitionStatus,
recruitingStartDate,
targetHireDate,
numberOfDaysOpen
FROM jobRequisitionsByRole
WHERE jobRequisitionStatus IN ('Open', 'Frozen')
ORDER BY recruitingStartDate ASCWhy prefer jobRequisitionsByRole over allJobRequisitions for manager self-service?
- Constrained Role Filtering:
jobRequisitionsByRolescopes rows to requisitions where the signed-in user holds an authorized role (Manager,Recruiting Manager,Primary Recruiter, orHR Partner) on that Supervisory Organization. - Confidential Job Requisitions Excluded: When executive recruiting creates a Confidential Job Requisition (for example, replacing an incumbent leader), Workday isolates access strictly to explicitly assigned confidential recruiting roles—preventing subordinate or peer managers from discovering confidential backfills through org-wide queries.
- Evergreen vs. Standard Requisitions: Note that
allJobRequisitionsandjobRequisitionsByRoleinclude both standard requisitions and high-volume Evergreen Requisitions; inspect linked positions or requisition type fields so high-volume retail evergreen funnels do not double-count approved seats alongside linked child requisitions. - Multi-Org Requisition Display (
tyc1482947881469): In Position Management organizations, if a non-confidential Job Requisition spans multiple positions across different Supervisory Organizations, Workday displays a single primary Supervisory Organization based on its multi-position resolution rules—so always reconcile againstopenPositionsByOrganizationwhen auditing exact seat counts per manager.
Reconciling Headcount Math Across Filled, On-Leave, and Open Seats
Before presenting a headcount summary to a department leader, verify these four reconciliation rules against your tenant’s staffing model:
- Position Management vs. Job Management: A Supervisory Organization uses either Position Management (individual seat IDs with explicit hiring restrictions) or Job Management (org-level hiring restrictions without seat IDs).
openPositionsByOrganizationreturns position-level rows for Position Management orgs, whereas Job Management orgs track open demand primarily throughjobRequisitionsByRoleand headcount plans (headcountPlanLines). - Job Overlap During Leaves of Absence: When
Allow Job Overlap for Leaveis active on a Position Management seat, both the employee on parental/medical leave and their temporary backfill occupy the same position—filter active vs.(On Leave)status explicitly so budgeted seat counts match Finance numbers. - Committed Pre-Hires (
futurePositionFill_EffectiveDate): Separate truly vacant seats from seats where an offer has been accepted (Offercompleted,Hireeffective next month) so managers do not open duplicate requisitions. - SOAP Alternative (
Get_Job_Requisitions&Get_Positions): When downstream systems require nested XML structures such as full qualification profiles or position restriction details, invokeGet_Job_Requisitions(RecruitingSOAP) andGet_Positions(StaffingSOAP) using the signed-in manager’s OAuth 2.0 Bearer header.
Step 3: Reconcile Unfilled Positions in Position Management (openPositionsByOrganization)
In Position Management organizations, an approved seat (P-00841) can sit unfilled before a manager opens a Job Requisition, or after a requisition closes unfilled. Query openPositionsByOrganization (which requires the organization parameter) to capture total approved capacity:
SELECT
workdayID,
positionAndJob_AllStaffingModels,
supervisoryOrganization,
jobProfile,
hiringRestrictions_Location,
hiringRestrictions_WorkerType,
scheduledWeeklyHours,
availabilityDate,
earliestHireDate,
hiringFreeze,
positionCount_Filled,
positionsUnfilled,
positionCount_Available,
futurePositionFill_EffectiveDate
FROM openPositionsByOrganization(
organization = '7a19d402c8e5100014b28890ab120055'
)Pay close attention to futurePositionFill_EffectiveDate and pre_HiresConsideredForPositionCount: a position where a candidate has already accepted an offer and has a future Hire effective date next Monday is technically unfilled today, yet already committed—showing futurePositionFill_EffectiveDate stops hiring managers from double-requesting a backfill.
Protecting Confidential Compensation Boundaries
Even when a manager has full View: Supervisory Organization visibility into open positions and job requisitions, compensation fields carry independent domain security:
- Domain Separation inside WQL and SOAP: On
openPositionsByOrganization, fields likedefaultBasePaySegmentandhasDefaultCompensationare secured separately fromjobProfileandavailabilityDate. Under user-delegated OAuth, if a frontline supervisor lacks position/requisition compensation domain permissions, Workday either refuses aSELECTcontaining unauthorized pay columns or returns blank values depending on the field’s security policy. - Select Only Needed Non-Pay Columns by Default: Keep default staffing queries scoped to structural fields (
jobPostingTitle,jobProfile,location,targetHireDate,jobRequisitionStatus,hiringFreeze), and pair external connectors with in-memory field-level redaction if HR partners with broader tenant permissions share screen views during planning meetings.
Organizations tired of exporting weekly Excel headcount trackers can publish a live, one-page Manager View using Kiweely Leaf (coming next—showing filled headcount, open requisitions, unfilled seats, and who is out this week on live Workday APIs without a Workday Extend license), or let leaders ask headcount and requisition questions directly inside Claude, ChatGPT, and Gemini via Kiweely Bridge (coming next, enforcing each manager’s own Workday role boundaries and RAM-level field redaction rules).
Frequently asked questions
Why doesn't the Workday recruiting v4 REST API return internal open job requisitions and headcount?
The recruiting v4 REST API exposes external career-site jobPostings, prospects, interviews, and candidate offers—not internal unposted requisitions or position seats. Query WQL jobRequisitionsByRole / allJobRequisitions or Recruiting SOAP Get_Job_Requisitions for internal requisition status.
What is the difference between an unfilled Position and an Open Job Requisition in Workday?
In Position Management supervisory organizations, a Position (P-xxxxx) is an approved headcount seat that may be unfilled with no active recruiting, frozen, or linked to an open Job Requisition (JR-xxxxx). Job Management organizations skip individual seats and recruit directly against Job Requisitions.
Which WQL data source automatically scopes job requisitions to a hiring manager's role?
Use jobRequisitionsByRole (Primary Business Object: Job Requisition) under user-delegated OAuth. Workday restricts returned rows to requisitions the signed-in user is authorized to view through their Manager, Recruiting Manager, or Recruiter role assignments, excluding confidential executive searches.
How does Workday prevent peer managers or recruiters from seeing confidential requisition compensation?
Target requisition compensation, replacement worker names, and position defaultBasePaySegment fields sit behind separate domain security policies (such as Job Requisition Compensation and Worker Data: Compensation) rather than general View: Supervisory Organization or Reports: Organization domains.