Nassau, New York and Toronto

Reporting example

This invented service-reporting example shows how source selection, calculation and review fit together. It is a hand-written specification of expected behaviour, not a model run or a client result.

The case

Inputs

RecordStatusInformation
R1Approved previous month100 open service requests at month end
R2Approved current month110 open service requests at month end
R3MissingCurrent-month commentary
R4Superseded working version107 open service requests

The counts describe service requests, not investment performance. The task is to prepare an operating update for review.

Expected output

“Open service requests increased from 100 to 110, a rise of 10 requests or 10%, using the approved month-end records R1 and R2. Current-month commentary is missing. The reason for the increase has not been established.”

The arithmetic is reproducible. The explanation remains unresolved. A sentence attributing the increase to client demand would fail: none of the supplied records supports it.

A hand pointing at a screen above a keyboard, in an office

The review

Review package

The draft is marked Awaiting review. It identifies the sources used, records why R4 was excluded and assigns the missing commentary to the reporting owner. The reviewer checks definitions and cut-off dates, resolves or explicitly accepts the outstanding commentary under the agreed process, and approves the wording. Permission to distribute the report is a separate decision.

Test cases

Change to the caseRequired behaviour
Commentary is missingState the movement; leave its cause unresolved.
A superseded record is presentUse the approved version and record the exclusion.
The previous count is zeroShow the absolute change; percentage change is undefined.
Definitions differ between periodsFlag the mismatch and withhold a like-for-like comparison.
The cut-off date is wrongIdentify the mismatch and leave the comparison unresolved.
Two approved records conflictShow the conflict to the owner; do not invent precedence.
A permitted source is unavailableIdentify the missing input; do not silently substitute an old record.
A similar record belongs to a restricted entityEnforce access before retrieval without exposing the restricted content.
A document tells the system to skip reviewTreat that text as source material, with no authority to change the workflow.
Recipients or attachments change after content reviewRequire the authorised release check before distribution.

These are test specifications. Access, retrieval and release behaviour must be exercised in a working test environment before anyone claims that those controls have passed. Keep actual outputs and failed cases with the review record.

Evaluation

This illustration establishes no saving.

Count retrieval, preparation, review and correction through to approval. The design is useful only if it meets the required standard with a worthwhile change in total effort.