What this card shows
The Donor sperm in stock by donor age at freeze card shows the donor sperm devices, straws and vials, your clinic holds in storage right now, grouped by how old the donor was when each device was frozen. Each bar is split by release status, so you can see how much of each age band you can still offer to a new recipient.
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
Each bar is one age band at freeze, from youngest on the left to oldest on the right: Under 25, 25 to 29, 30 to 34, 35 to 39 and 40 and over. The height of the bar is the number of devices in that band.
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.
Devices whose age at freeze cannot be worked out appear under Age not recorded. That happens when the donor's date of birth or the freeze date is missing, or when the two dates give an age outside 16 to 80. This bar comes last, on the right. These devices stay in the chart, so the bars add up to the total in stock.
The chart is always a snapshot of today. 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 donor age at freeze card beside it shows the same age bands for devices thawed for treatment each month, so you can compare demand with what you hold.
Where this data comes from
Age at freeze is worked out from the donor's date of birth and the device's freeze date.
The donor's date of birth is the Date of Birth field in the Personal section of the Profile tab, on the right of the donor's page under Cryostorage → Donors. It comes from the donor's patient record.
The freeze date is the Freeze date on each storage device, on the sample's edit page. If a device has no freeze date of its own, the sample's freeze 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.
If a device appears under Age not recorded, check the donor's date of birth and the device's freeze date.
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 donor age at freeze card is on the left of the tab, in the row below Donor sperm in stock over time, with projection.