Requisition aging, the chase list

How many requisitions are open, and how long have they been open? The count moves between meetings because the delivered view is a moving state, filled positions linger in it, and last month’s version is gone. Snapshots hold still.

RuleAge requisitions from the daily snapshot: opened date to snapshot date, banded, with the oldest names listed, not just counted.

Neverreport open counts from the live view alone. Filled-but-showing-open artifacts and mid-meeting edits make it a different number every time it is read.

◆ Open requisitions by age, May 31, 2026banded, totaled, chase list below.

Age band	Open requisitions
0 to 30 days	14
31 to 60 days	9
61 to 90 days	4
Over 90 days	3
Open at month end	30

The three over-90 requisitions are the chase list, by name: the report lists them with recruiter, hiring manager, and days open, because an aged requisition is a conversation, not a statistic. Sample values are illustrative, never client data.

◆ Why the live count will not hold stillstates move, and filled lingers as open.

The delivered workspace reads current requisition states, and practitioners report filled positions displaying open until the start date passes, so Monday's count includes fills that Tuesday's excludes. There is also no yesterday: the live view answers now, and the trend of open load across quarters has nothing to stand on.

The daily snapshot fixes both at once, the same way headcount history does for people: the month-end count is a stored row, the aging is arithmetic against opened dates, and the trend is a filter across snapshot dates.

◆ The queryone snapshot date, banded.

-- open requisitions banded by age, from the daily snapshot
SELECT CASE
         WHEN days_open <= 30 THEN '0 to 30'
         WHEN days_open <= 60 THEN '31 to 60'
         WHEN days_open <= 90 THEN '61 to 90'
         ELSE 'over 90'
       END AS age_band,
       COUNT(*) AS open_requisitions
FROM (SELECT requisition_key,
             DATEDIFF('day', opened_date, snapshot_date) AS days_open
      FROM fct_requisition_day
      WHERE snapshot_date = DATE '2026-05-31' AND is_open)
GROUP BY 1 ORDER BY MIN(days_open)

Use case

Problem

Open requisition counts change between meetings, aged openings hide inside totals, and there is no history of open load.

What we build

A daily requisition snapshot with aging banded from opened dates and the over-90 list named, not just counted.

What you get

A month-end count that holds still, a chase list with owners, and an open-load trend across any number of quarters.

Which three requisitions have been open longest, and who owns them?

We ship the snapshot, the bands, and the chase list with names on it.

Talk to us

Terms on this page

age band: A range of days open, such as 31 to 60.
chase list: The oldest open requisitions, listed with owners for follow-up.
opened date: When the requisition became an active opening. The aging clock’s start.
open load: How many requisitions are open over time. Needs snapshots to exist.
workspace: The delivered live view of requisitions. Reads current state only.
snapshot: A dated copy of a state, kept so the past stays queryable.
lingering open: A filled position still displaying open until its start date passes.