Put a worked result beside the definition
Synthetic request records: R-1 opened 1 April and closed 2 April; R-2 opened 1 April and remains open; R-3 opened 2 April and remains open. At end of 2 April, reopened cases are absent in this fixture.
| Report term | Agreed meaning in fixture | Worked answer | Owner to approve |
|---|---|---|---|
| Opened on 1 April | Opening date equals 1 April, whatever current state | R-1 and R-2: 2 | Process owner |
| Open at end of 2 April | State at that snapshot is open | R-2 and R-3: 2 | Process owner |
| Closed on 2 April | Recorded closing date equals 2 April | R-1: 1 | Process owner |
Equal totals can represent different records
The first two rows both show 2. Are their definitions interchangeable?
Show the worked answer
No. The opening-date set is R-1/R-2; the snapshot-open set is R-2/R-3. Approve the intended question and identities, not just a matching total.
This is buyer sign-off on meaning, not a query implementation or a performance report. Reopening, time zones and additional statuses need explicit rules before extending the example.