MGT001
BloodNetFresh Blood Product Management Report
Specification
MGT001 - Fresh Blood Product Management Report
Version Control
Version / Revision Date / Revision Description0.1 / 07/07/2014 / Initial Draft.
0.2 / 04/08/2014 / Changed after feedback.
0.3 / 22/08/2014 / Major modifications based on producing the report soley for Print and for a single AHP
0.4 / 26/08/2014 / Minor modifications after feedback from Sandra C.
0.5 / 20/01/2015 / Additional sections added, explanation of Stock On hand calculation added
Creative Commons
With the exception of any logos and registered trademarks, and where otherwise noted, all material presented in this document is licensed by the NBA under a Creative Commons Attribution 3.0 Australia ( licence. In essence this licence allows you to copy, communicate and adapt the work, as long as you attribute the work to the National Blood Authority and abide by the other licence terms.
The details of the relevant licence conditions are available on the Creative Commons website (accessible using the links provided) as is the full legal code for the CC BY 3.0 AU licence (
The content obtained from this document or derivative of this work must be attributed as the National Blood Authority BloodNetPSO ReportSpecification.
Page 1
MGT001 - Fresh Blood Product Management Report
Contents
1.Introduction
1.1Purpose
2.Report Details
2.1Description
2.2Business Rules
2.3BloodNet Source Data
2.4FUL010e – Fresh Blood Orders and Issues
2.5FATE007 - Fresh Component Health Provider Discards
2.6FATE007e – Fresh Component Health Provider Discards Extract
3.Report Content
3.1Parameters
3.2Report Field Description
3.3Cover Page
3.4Report Detail
7.Appendix A – Report Layout
8.Appendix B – Component Groups
9.Appendix C - Fulfilment Matching
1.Introduction
1.1Purpose
The purpose of this document is to describe the user specification for the BloodNetFresh Blood Product Management Report.
The purpose of the report is to allow facility administrators to view and monitor their fresh blood demand and stock management
Page 1
MGT001 - Fresh Blood Product Management Report
2.Report Details
2.1Description
A report to provide a high level view of various metrics of fresh blood products for inidvidualfacilities on BloodNet.
The report combines data already present in BloodNet reports as well as incorporating new data and summaries.
The report covers Fresh Blood Products distributed by the Blood Service.
2.2Business Rules
- For the purposes of fulfilment, identifing matching transactions between orders and issues the following process takes place.
- When making an order for Fresh Products, the AHP will select a Component(Id) + ABO +_ Rh. For example
- Red Cells O+
- Cryopreciptiate B+
- When an order is filled by the Blood Service they provide a SupplierComponentIdentifier + ABO + Rh. For example
- 04250 – Red Cells in Optisol O+
- 12010 – Platelets Apheresis AB-
- When BloodNet receives the Issue Note, the SupplierComponent is mapped to a Component so that it can be matched with the order and fulfilment determined.
- Supplier Components are also linked to CostGroups. Cost groups determine the cost of the product supplied by the Blood service. For example
- 04250 Red Cells in Optisol 2a WB Red Cell
- 12010 Platelets Apheresis 3d Apheresis Platelet - Leucodepleted
A full List of mappings for Component to Cost groups and (a sample of) Supplier Components can be found in Appendix C
- Component Groups
Just as Components and Supplier Components can be mapped to Cost Groups, there is also a mapping to ComponentGroups. Using Component Groups allows the report to condense orders and issues to a common derivative, and also allow further comparisons between orders and issues when it comes to Fate and Orders.
A full list of component groups can be found in Appendix B
- Supplier Faults.
The following discard reasons are deemed to be faults that are attributable to the Supplier and out of the control of the AHP, therefore play no part in the calculation of the DAPI (Discards as a Percentage of Issues)
Supplier Fault Discard Reasons
- Damaged – Supplier Transit
- Recall – By Supplier
- Transport – Temperature failure from supplier
- Transport – Incorrect packing from supplier
2.3BloodNet Source Data
The data from BloodNet used to create this report match data presented in the reports below.
2.4FUL010e – Fresh Blood Orders and Issues
Both the Issues and Orders tabs are used and can be used to reconcile a mixture of data in the report
2.5FATE007 - Fresh Component Health Provider Discards
The DAPI calculations are used. This report DAPI will will only be comparible Top level groups (highlighted below)appearing in FATE007 as Fate007 is based on Issued products
2.6FATE007e – Fresh Component Health Provider Discards Extract
This extract presents the data that determines the results for FATE007. It lists individual transactions for issue, transfers (in and out) and discards on separate tabs.
The information in FATE007e should also correlate with data in FATE001 and FATE003.
3.Report Content
3.1Parameters
The following parameters will be available and all are mandatory
Name / Description / Control Type / Values/Value List / Default ValueState / All Australian States listed / Drop down / All States
/ All States
Health Provider / All facilities, filtered by the State selected above. The report can only be run for one AHP within one State. / Drop down / All available facilities / <none>
Start Date / Start date of the reporting period / Date Picker / Any valid Date / <None>
End Date / End Date of the Reporting Period
Validate the Start and End dates to ensure there is no more than a years worth of data to report, and the start and end dates do not cross FY / Date Picker / Any Valid Date / <None>
3.2Report Field Description
The report will consist of up to 12 pages(or 18 pages if paediatrics are separated) and specifically designed to be exported to PDF for printing and offline inspection. If there is no data for a specific component for the period, then that component is not shown.
The following outlines the page numbers and contents if Report on Paediatric Separately parameter is set to No
Page 1 – Cover Page
Pages 2/3 –Red CellsAdult
Pages 4/5 –Platelets Adult
Pages 6/7 – Clinical Fresh Frozen Plasma Adult
Pages 8/9 – Cryoprecipitate
Pages 10/11 – Cryodepleted Plasma
Page 12 – Back cover - BloodNet News. 2 latest news items relevant to the facility. These items are the same as the first 2 currently displayed news items for the facility on the BloodNet home page. (note the report will not show images within the news items as they are ignored by the reporting engine.
If Report on Paediatric Separately parameter is set to YES, then add the following pages immediately after their corresponding component
Pages 3a/3b – Red Cells Paediatric
Pages 5a/5b – Platelets Paediatric
Pages 7a/7b – Clinical Fresh Frozen Plasma Paediatric
3.3Cover Page
Data / DescriptionReport Title / Fresh Blood Management Report
Facility Name / Health provider selected from parameter, include AHPCode
Start Date and End Dates of reports / Show the parameters entered in long format,
Eg. 1 July 2013 to 30 June 2014
3.4Report Detail
View Appendix A for the layout of Report parts.
The information below relates to the information presented for each Fresh Blood Product group on a double page spread.
Summary Table
For each of the fields below, display the values for the selected date period
For each Component, each of the values below will be broken down into ABO and a total
Field Name / DescriptionAverage Age at Issue / The average of the age at issue (determined by days betweenthe date the component was collected and thedate it was issued by the Blood Service)
Average Age at Transfusion / The average of the age at Transfusion (determined as days between Date Collected and Transfusion Date). Note: Only LIS enabled sites will have this information
Order Quantity / The sum of the order quantity for finalised orders for the period. Includes Special and Stock Orders
Order Qty % of Total Orders / The amount ordered for this bloodgroup as a percentage of all blood groups for the period.
*Issued Quantity / For each ABO, the issued quantity performed through *BloodNet for the period
Issue Qty % of Total Issues / For each ABO, the number issued for this bloodgroup as a percentage of all issues for the period.
Receipted Quantity / The sum of the quantity reportedly receipted in BloodNet for the period
Transfers In / The sum of the number of components transferred in to the facility for the period
Transfers Out / The sum of the number of components transferred Outof the facility for the period
Net Issues / A calculation = (Issued Quantity – Transfers Out + Transfers In)
ǂDiscards / The sum of the number of discards for each component/ABO for the period.
ǂnote this figure excludes discards that were caused by the supplier – see Supplier Faults)
ǂ DAPI / Discards as a Percentage of Net Issues. A calculation of Discards/Net Issues.
ǂ Note the calculation for DAPI in this field excludes discards that were caused by the Supplier – see Supplier Faults)
(Excluding Transfers) ǂ DAPI / Discards as a Percentage of Net Issues excluding Transfers. The purpose of this value it to remove the effect of transfers when calculating the DAPI. (i.e. some hospitals get transfers of stock when the stock is close to expiry. Often this stock is then discarded which has the effect of increasing the DAPI for the hospital. This value aims to remove that effect by:
- If a Component was transferred In (In this period) and subsequently discarded (at any time), the component is removed from the NetIssues before calculating DAPI
- If a component was discarded in this period, but previously transferred in (at any time) the component is removed from the Discards before calculating the DAPI
(Expired Discards Only) ǂDAPI / Discards as a Percentage ofNetIssues. A calculation of Discards/Net Total Issues.
ǂ Note the calculation for DAPI in this report only includes discards that have a discard reason of Expired – Time Expired
% Issued (or Ordered) / Sum of Issued Qty / Sum of Order Qty
% Receipted (of Issued) / Sum of Receipted Qty / Sum of Issued Qty
Orders
Field Name / DescriptionSpecial Order Quantity
Stock Order Quantity / Order Qty – sum of units ordered from special orders
Order Qty – sum of units ordered from stock orders
Total / Total number of stock and special orders and the % of Stock vs Special
Order Types
This table displays the number of Orders at each priority (Standard, Urgent, Life Threatening) for Stock and Special Orders as well as the quanties of each component ordered at each priority. Counts only include finalised orders where the OrderQty > 0
Special Orders / StockOrders / Total Orders / Special Order Qty / Stock Order Qty / Total Order Qty
Life Threatening
Urgent
Standard
Total
Units Issued and DAPI Chart
Display a chart with 4 separate series
- 2 Barchart series showing the number of fresh products issued for each month during the period and the same period 12 months earlier
- 2 Line Charts showing each showing the respective DAPI for each month within the selected period, and the same period 12months earlier. Display the DAPI value above each series for each month.
Inventory Level Chart
Display a line graph showing Average Stock on Hand, Max Stock and Order Quantity for each day. Only display values for finalised stock orders (special orders take no part in this chart) and values displayed correlate with INV010.
Note: the stock on hand figure needs to be extrapolated from previously entered data, with the assumption being ‘Stock On Hand doesn’t change if there is no entry to state otherwise’
Eg – Using the following subset of orders to illustrate the point.
Orders are placed for Red Cells Irradiated on July 1,4 and 5, because there was no Stock on Hand entered for July 2,3 and 6, these figures are derived from the previous entry (light grey being derived figures used in the calculation in the chart).
Note that even though there was an order on the 4th, there was no Stock on Hand entered with the order, so the derived value is used from the previous entry.
Order Date / Product / Order Qty / Stock On Hand1 July / Red Cells Irradiated / 3 / 5
2 July / Red Cells Irradiated / 0 / 5
3 July / Red Cells Irradiated / 0 / 5
4 July / Red Cells Irradiated / 7 / <Not Entered>
5
5 July / Red Cells Irradiated / 9 / 0
6 July / Red Cells Irradiated / 0 / 0
Age at Issue Chart
Display a chart showing the age at issuefor the fresh component for the Facility. Overlay the State and National values for comparison.
The Facility data is shown as a barchart with the height indicating the PERCENT issued, for the product at that age over all products issued during that time.
For each age of product display the total number of issues as well as the percentage as part of the chart.
Eg if 10 red cells were issued @ 2 days old, but the total issue for the period for Red Cells was 100 Red Cells (of any age), the barchart would show 10%.
Above each column, show the percentage and total issues for each age
The age at issue is presented in days or months(depending on the fresh component) and presented as a range of ages banded togetheralong the y axis. The Banding has been determined based on expected age of fresh component at usage. Banding is described further in Appendix D
For very small percentages (less than 0.5% of the total) the text above each column is not shown. This issue (as well as rounding anomalies) may cause the total of the percentages display to differ from 100%
If the banding is displayed in Months, each month equates to 30 days
- 1 month = 0-30 days old
- 2 months = 31-60 days old
- 3 months = 61-90 days old, etc
Age at Transfusion Chart
For LIS enabled facilities this graph appears similar to the Age at Issue but for transfusion data (number of days between Collection Date and Transfusion date). If the AHP is not LIS interfaced the space will be used for promotional material to get AHPs to integrate their LIS.
Some Issues do not have Collection Date (previous to 2012) in this instance the collection date is assumed to be the same as the issue date
For very small percentages (less than 0.5% of the total) the display the text above each age is not shown.
If the banding is displayed in Months, each month equates to 30 days
- 1 month = 0-30 days old
- 2 months = 31-60 days old etc
Order Fulfilment Chart
Histogram of Orders vs Issues. The X-axis is ABO with the Y-Axis as difference in Order and Issues quantity. The difference between Ordered Quantityand Issued Quantity and that difference as as a percentage is included above each bar. This is for Stock orders only that are finalised. A line showing the average difference between orders and issuesis also displayed on this graph.
Discard by Reason Chart
A horizontal bar chart showing the reasons for discards.
The Y-axis is Discard Reason with the X-Axis as Number of Discards. The number of discards is displayed at the end of each bar, along with a percentage of total discards for the period.
If a discard reason was not used during the period it will not appear.
Supplier faults (section 2.2.3) discards are displayed in a different colour hightlight the differences.
DAPI by ABO Chart
Stacked Bar chart of DAPI. The chart is stacked with Supplier Faults and all-other Discard Reasons, and the total DAPI correlate with the summary table.
The X-axis is ABO split into the selected FY and the previous FY.The Y-Axis and labels areDAPIpercentages for each blood type.
DAPI Comparators Chart
Bar Chart of DAPI, where X–axis is the DAPI for the AHP, the States, the Peer Group (as defined in FATE007) and the National comparators and the Y-Axis as percentages. The bars are labelled with the DAPI for the product group.
If there is a target benchmark for the fresh product DAPI, it is displayed as a red line.
Page 1
MGT001 - Fresh Blood Product Management Report
7.Appendix A–Report Layout
Double page spread layout for product groupshowing layout from Page 2 onward
Page 1
MGT001 - Fresh Blood Product Management Report
8.Appendix B – Component Groups
ComponentNameWhat can be ordered / ComponentGroup
Group by fresh product type / CondensedComponentGroup
Incorporate Paediatrics into Group
Whole Blood / Whole Blood / Whole Blood
Red Cells / Red Cells / Red Cells
Red Cells Paediatric / Red Cells Paediatric / Red Cells
Platelets Pooled / Platelets / Platelets
Platelets Apheresis / Platelets / Platelets
Platelets Pooled Paediatric / Platelets Paediatric / Platelets
Platelets Apheresis Paediatric / Platelets Paediatric / Platelets
Fresh Frozen Plasma / Clinical Fresh Frozen Plasma / Clinical Fresh Frozen Plasma
Fresh Frozen Plasma Paediatric / Clinical Fresh Frozen Plasma Paediatric / Clinical Fresh Frozen Plasma
Cryoprecipitate / Cryoprecipitate / Cryoprecipitate
Cryoprecipitate Apheresis / Cryoprecipitate / Cryoprecipitate
Cryo-Depleted Plasma / Cryo-depleted Plasma / Cryo-depleted Plasma
9.Appendix C - Fulfilment Matching
Component / Component Group / Cost GroupSupplierComponent
Red Cells / Red Cells / 2a WB Red Cell
04210-RED CELLS IN ADSOL
04250-RED CELLS IN OPTISOL
04060-RED CELLS PREPARED FROM CPDA-1
Red Cells / Red Cells / 2bWB Red Cell - Leucodepleted
04310-RED CELLS IN ADSOL LEUCOCYTE DEPLETED
04311-RED CELLS IN ADSOL 1 OF 2 LEUCOCYTE DEPLETED
04312-RED CELLS IN ADSOL 2 OF 2 LEUCOCYTE DEPLETED
Red Cells / Red Cells / 2cWB Red Cell - Buffy Coat Poor
04610-RED CELLS IN ADSOL BUFFY COAT REMOVED
04650-RED CELLS IN OPTISOL BUFFY COAT REMOVED
04680-RED CELLS IN SAG-M BUFFY COAT REMOVED
Red Cells / Red Cells / 2eWB Washed Red Cell
04900-RED CELLS WASHED NO ADDITIVE
04910-RED CELLS WASHED IN ADSOL
04900-RED CELLS WASHED NO ADDITIVE
Red Cells / Red Cells / 2fWB Washed Red Cell - Leucodepleted
04800-RED CELLS LEUCOCYTE DEPLETED WASHED NO ADDITIVE
04801-RED CELLS 1 OF 2 LEUCOCYTE DEPLETED WASHED NO ADDITIVE
04802-RED CELLS 2 OF 2 LEUCOCYTE DEPLETED WASHED NO ADDITIVE
Red Cells / Red Cells / 2gApheresis Red Cell - Leucodepleted
04381-RED CELLS IN SAG-M 1 OF 2 APHERESIS LEUCODEPLETED
04382-RED CELLS IN SAG-M 2 OF 2 APHERESIS LEUCODEPLETED
04381-RED CELLS IN SAG-M 1 OF 2 APHERESIS LEUCODEPLETED
Red Cells Paediatric / Red Cells Paediatric / 2dWB Paediatric Red Cell - Leucodepleted (1 of 4)
34311-RED CELLS IN ADSOL 1 OF 4 LEUCOCYTE DEPLETED PAEDIATRIC
34312-RED CELLS IN ADSOL 2 OF 4 LEUCOCYTE DEPLETED PAEDIATRIC
34313-RED CELLS IN ADSOL 3 OF 4 LEUCOCYTE DEPLETED PAEDIATRIC
Platelets Apheresis / Platelets / 3dApheresis Platelet - Leucodepleted
12070-PLATELETS APHERESIS IN T-SOL
12071-PLATELETS APHERESIS 1 OF 2 IN T-SOL
12072-PLATELETS APHERESIS 2 OF 2 IN T-SOL
Platelets Pooled / Platelets / 3aWB Platelet
12000-PLATELETS
12900-PLATELETS WASHED
12001-PLATELETS 1 OF 2
Platelets Pooled / Platelets / 3bWB Platelet - Leucodepleted
12300-PLATELETS LEUCOCYTE DEPLETED
12321-PLATELETS POOLED IN T-SOL LEUCOCYTE DEPLETED
12320-PLATELET POOLED LEUCODEPLETED SSP+
Platelets Pooled / Platelets / 3cWB Platelet - Buffy Coat Poor
12021-PLATELETS POOLED IN T-SOL
12021-PLATELETS POOLED IN T-SOL
12021-PLATELETS POOLED IN T-SOL
Platelets Apheresis Paediatric / Platelets Paediatric / 3ePaediatric Apheresis Platelet - Leucodepleted (1 of 4)
32641-PLATELETS 1 OF 4 PAEDIATRIC LEUCOCYTE DEPLETED
32642-PLATELETS 2 OF 4 PAEDIATRIC LEUCOCYTE DEPLETED
32643-PLATELETS 3 OF 4 PAEDIATRIC LEUCOCYTE DEPLETED
Fresh Frozen Plasma / Clinical Fresh Frozen Plasma / 4bWB Clinical FFP - Buffy Coat Poor
18200-FRESH FROZEN PLASMA
18201-FRESH FROZEN PLASMA 1 OF 2
18202-FRESH FROZEN PLASMA 2 OF 2
Fresh Frozen Plasma / Clinical Fresh Frozen Plasma / 4dApheresis Clinical FFP
18210-FRESH FROZEN PLASMA APHERESIS
18211-FRESH FROZEN PLASMA 1 OF 2 APHERESIS
18212-FRESH FROZEN PLASMA 2 OF 2 APHERESIS
Fresh Frozen Plasma Paediatric / Clinical Fresh Frozen Plasma Paediatric / 4cPaediatric WB Clinical FFP (1 of 4)
18241-FRESH FROZEN PLASMA PAEDIATRIC 1 OF 4
18242-FRESH FROZEN PLASMA PAEDIATRIC 2 OF 4
18243-FRESH FROZEN PLASMA PAEDIATRIC 3 OF 4
Cryoprecipitate / Cryoprecipitate / 5aWB Cryoprecipitate
10100-CRYOPRECIPITATE
10100-CRYOPRECIPITATE
10100-CRYOPRECIPITATE
Cryoprecipitate Apheresis / Cryoprecipitate / 5bApheresis Cryoprecipitate
10110-CRYOPRECIPITATE APHERESIS
10110-CRYOPRECIPITATE APHERESIS
10110-CRYOPRECIPITATE APHERESIS
Cryo-Depleted Plasma / Cryo-depleted Plasma / 6aWB Cryo-depleted Plasma
18400-CRYO-DEPLETED PLASMA
18400-CRYO-DEPLETED PLASMA
18400-CRYO-DEPLETED PLASMA
Cryo-Depleted Plasma / Cryo-depleted Plasma / 6bApheresis Cryo-depleted Plasma
18410-CRYO-DEPLETED PLASMA APHERESIS
18410-CRYO-DEPLETED PLASMA APHERESIS
18410-CRYO-DEPLETED PLASMA APHERESIS
10.Appendix D – Component Age Banding.