SOME EXPERIENCES IN LABORATORY DATA COLLATION AT THE

SOME EXPERIENCES IN LABORATORY DATA COLLATION AT THE HOSPITAL WARD LEVEL Dr Tom Hartley and Dr Peter Georgius Royal Hobart Hospital

TOPICS • Mind Sets - The Pathology Request Cycle vs the Pathology Lab Process • Outline of how a typical Pathology Laboratory Information Management System (LIMS) collects data • Examples of how Pathology Data is made available on the Wards • A description of the Wards’ preference for pathology data presentation - a collated cross sectional view • Description of a prototype solution ‘driven’ by the doctors and not the laboratory • Lessons learned

PRIVATE PRACTICE Patient Consultation Pathology Request Specimen Collection and Analysis Reporting Clinical Interpretation

WARD PRACTICE UNIT Patient Consultation Ward Round Pathology Request Specimen Collection and Analysis Reporting Clinical Interpretation

MIND SETS WARD ROUNDS DEAL WITH GROUPS OF PATIENTS LABS DEAL WITH SPECIMENS THAT ARRIVE SINGLY FROM ANYWHERE

THE ‘NOTORIOUS’ HAND WRITTEN PATHOLOGY REQUEST FORM

LIMS SPECIMEN REGISTRATION

CUMULATIVE RESULTS LOOKUP IN LIMS BY PATIENT

CHECKING OUT ABNORMAL RESULT IN LIMS

WHAT VIEWS OF THE DATA CAN THE DOCTORS GET ? • The mini LIMS View - Cut down version of the ‘native’ LIMS application - Results by Patient • WWW Browser views - two examples one view by patient, one semi-cross sectional view by patients in the Unit • The Collated Cross Sectional View Results for all patients by User specified Unit and date range

WWW BROWSER INTERFACE TO LIMS

INTRANET RESULTS PORTAL FOR CASUALTY

PROTOTYPE SOLUTION TO WARD BASED COLLATED RESULTS VIEWER • • What are the datasets required ? Obtain them electronically from the LIMS Use simple, flexible and rugged design Obtain them automatically

UNIT SPECIFIC DATASETS

DATA EXTRACTION SCRIPT IN LIMS

DATA EXTRACTION SCRIPT MENU

DATA EXTRACTIONS - USER INPUTS

TYPICAL DATA EXTRACT PRESENTED IN EXCEL

PROTOTYPE SOLUTION TO WARD BASED COLLATED RESULTS VIEWER • • What are the datasets required ? Obtain them electronically from the LIMS Use simple, flexible and rugged design Obtain them automatically

DATA EXTRACTION AUTOMATION SCRIPTING TOOL

AUTOMATED INTRANET RESULTS SHEET FOR CORE LAB

LESSONS LEARNED • • • The pressures on Doctors at Ward level is high They need data and they need it now They need it in a cross sectional and collated format This is possible in our environment The benefits are that the Doctors are better prepared for Ward Rounds. The chance of transcription errors has been reduced The solution is cheap The solution is fast The data extractions could be automated and be ready for the Doctors to process at any time they like Continuing Education …. . continually

THE END - back to the Lab Taken from Bioclone advert