What this card shows
The Donor sperm in stock by consent expiry card groups the donor sperm devices, straws and vials, your clinic holds in storage right now by how long the consent to store them still has to run. Each bar is split by release status.
The two left-hand bars are the ones to act on. Devices already past their expiry date, and devices expiring within three months, need a decision before they have to be discarded rather than used in treatment.
A device counts as donor sperm when it is recorded as donated. A donor's own samples, frozen for their own future treatment, are not counted. A device stays in stock until it is thawed or shipped out to another clinic.
Reading the card
The bars run from the soonest expiry to the latest: Already past expiry, Within 3 months, 3 to 6 months, 6 to 12 months and More than 12 months, then No expiry recorded. A band with no devices in it has no bar.
Devices with no expiry date recorded are shown separately. A missing date is not the same as a long time remaining.
Each bar is split by release status: Free to allocate (no restriction on release, not reserved for a recipient and not in quarantine), Reserved for a recipient, Quarantined, Sibling use only, Family limit reached, On hold, Blocked and Not recorded. Hover over a segment to see its count.
The chart is always a snapshot of today, so devices move into earlier bands as their expiry dates approach. It does not change with the dashboard's Date filter.
The Clinic filter at the top of the dashboard narrows the chart to the clinics you choose. Here, clinic means the site the storage tank belongs to, so a device counts toward the clinic where it is physically stored.
The Donor sperm used, by consent remaining at use card beside it shows how much consent was left on the devices you thawed for treatment.
Where this data comes from
The consent expiry is the Expiry date on each storage device, on the sample's edit page. If a device has no expiry date of its own, the sample's Expiry date is used instead.
A device counts as donated when, on the sample's storage devices, its Freeze purpose or Use status is set to a donation value: Donation or Known donation for the freeze purpose, Donation or Donated to bank for the use status. A donor's device frozen without a donation value is treated as the donor's own sample and is not counted.
To move a device out of No expiry recorded, enter an expiry date on the device or on its sample.
Opening this card
In wawa, open Insights from the sidebar, then go to Standard Reports → Donor → Donor and choose the Sperm tab. The Donor sperm in stock by consent expiry card is on the left of the tab, in the row below Donor sperm in stock by donor type.