______________________________________________________________________________
PICANet PIM Calculator v2.1
Database utility to allow calculation of PIM and PIM 2 using local PICANet data
______________________________________________________________________________
Introduction This database utility has been produced to allow local calculation of PIM,
PIM with recalibrated coefficients provided by UKPICOS and PIM 2 using
the local PICANet database. It is simple to use and will produce output in
Microsoft Excel for use in other programs. Please note that it does not
take into account the ratio of inspired oxygen to arterial oxygen tension
when details of oxygen delivery are given in l min-1 or l kg1 min1 via face
mask with reservoir bag, nasal cannulae/face mask or nasopharyngeal
airway/catheter. This is due to the difficulty in estimating FiO2 from this
data.
Using the utility Unzip the database and place it in a suitable folder. When you run it for
the first time you will see the following screen :
Click on the button that says ‘Link to data’ and you will see the following
browse dialog box: find the ‘PICANet Site data.mdb’ database and click
on ‘Link’.
3fd8c3de-920a-467c-9b50-2842fabb4e2f.doc Roger Parslow January 2004
Once you have done this select ‘tblEpisodes’ and click ‘OK’.
Once you have done this the database is ready to use. You may delete
the links to the data using the ‘Delete data link’ button.
Viewing/export You may view or export the data with the options listed on the opening
form. The view/export PIM buttons give you patient identifiers and the PIM
probability of death (multiply by 100 to get % probability of death). If you
select the ‘with PIM variables’ buttons, the data used to produce the PIM
score is included. Variable names are listed at the end of this document.
Exported files are produced in Microsoft Excel format and can be saved
into a folder of your choice.
Extracting extra data If you are conversant with Microsoft Access, you can extract additional
information and link using the PICANet ID.
Feedback Please send any feedback to: Roger Parslow, r.c.parslow@leeds.ac.uk ,
tel 0113 343 4856.
Disclaimer Please do not use the data produced by this utility without completing a
full, independent check of your data and recalculating the PIM probability
of death. Note that PIM and PIM 2 are not intended to aid clinical
decision-making.
3fd8c3de-920a-467c-9b50-2842fabb4e2f.doc Roger Parslow November 2005
Variable descriptions These are brief descriptions of the data output.
Short output PICANETID PICANet unique identifier for episode
CASENO Casenote number
ADNO Admission number
NHSNO
SEX Sex (1=male; 2=female, 3 = Ambiguous; 9 =N/K)
ADDATE Admission date
UNITDISDATE Discharge date
DOB Date of birth
DOD Date of death
PIM PIM probability of death
PIMrecal recalibrated PIM % probability of death
PIM2 PIM 2 probability of death
Additional PIM vars
These are defined in the PICANet Data definitions manual available from
www.picanet.org.uk.
References
Brady AR, Harrison D, Black S, Jones S, Rowan K, Pearson G, Ratcliffe J, Parry
GJ, on behalf of the UK PICOS Study Group. Assessment and Optimization of
Mortality Prediction Tools for Admissions to Pediatric Intensive Care in the United
Kingdom. Pediatrics 2006; 117: 733-742
Pearson GA, Stickley J, Shann F. Calibration of the paediatric index of mortality in
UK paediatric intensive care units Arch. Dis. Child., Feb 2001;84:125-128.
Shann F, Slater A, Pearson G. PIM 2: a revised version of the Paediatric Index of
mortality. Intensive Care Med 2003; 29:278-285
3fd8c3de-920a-467c-9b50-2842fabb4e2f.doc Roger Parslow November 2005