ClinicalCodes.org

An online clinical codes repository to improve validity and reproducibility of medical database research

Research article:

Protocol for an observational cohort using routinely collected data from the POpulation Level Analysis and Reporting (POLAR) database in Australia to understand patterns of care for people presenting to general practice with musculoskeletal condition

Reference:

Haas R, Busija L, Gorelik A, O'Connor D, Pearce C, Mazza D, Buchbinder R.(2020) Protocol for an observational cohort using routinely collected data from the POpulation Level Analysis and Reporting (POLAR) database in Australia to understand patterns of care for people presenting to general practice with musculoskeletal condition. , doi:

Link to article
Abstract
Introduction General practice is a key component of the Australian health care system. Outcome Health’s POpulation Level Analysis and Reporting (POLAR) data space system uses de-identified electronic health records to enable data analysis at the general practice level in Australia. Previous studies using routinely collected health data for research purposes have not consistently reported the codes and algorithms used to describe the population, exposures or interventions, and outcomes in sufficient detail to allow replication. The aim of this study is to describe the methods used to classify, identify and merge eligible records from the POLAR data space system into a customised database so as to examine patterns of care for people presenting to general practice in Victoria, Australia. In doing so, this study will provide a framework for other researchers using routinely collected health data for research purposes. Methods and analysis This is a retrospective, observational cohort study. Patient-related data will be obtained through electronic health records from general practices across three primary health networks in South Eastern Victoria. Study participants will include people diagnosed with low back (aged 18 years and over), or shoulder, knee or neck conditions (aged 45 years and over) from 2014 to 2018 who were receiving care from a general practitioner (GP). Eligible records were identified deductively using coding conducted by Outcome Health and where necessary we coded data inductively. Data quality checks will be conducted and data files with eligible records will be merged to select the study cohort and create customised databases for analyses. The numbers, timing and characteristics of patients, GPs, consultations, prescriptions for pain relief, referrals to other health providers and requests for imaging tests will be examined throughout the study duration.
Author for correspondence
Romi Haas
Email for correspondence
romi.haas@monash.edu

Code list: res174: knee diagnoses

81 codes in list

Code Coding system Description Entity type List name
111243002 SNOMED Bursitis of knee diagnostic res174: knee diagnoses
1126007 SNOMED Knee locking diagnostic res174: knee diagnoses
125601008 SNOMED Injury of knee diagnostic res174: knee diagnoses
17059001 SNOMED Prepatellar bursitis diagnostic res174: knee diagnoses
178158006 SNOMED Repair of patellar tendon diagnostic res174: knee diagnoses
202381003 SNOMED Knee joint effusion diagnostic res174: knee diagnoses
202413005 SNOMED Haemarthrosis of knee diagnostic res174: knee diagnoses
209508007 SNOMED Strain of patellar tendon diagnostic res174: knee diagnoses
209627008 SNOMED Complete tear, knee, medial collateral ligament diagnostic res174: knee diagnoses
22878006 SNOMED Contusion of knee diagnostic res174: knee diagnoses
239312004 SNOMED Osteotomy of proximal tibia diagnostic res174: knee diagnoses
239419007 SNOMED Repair of meniscus diagnostic res174: knee diagnoses
239426007 SNOMED Repair of anterior cruciate ligament of knee joint diagnostic res174: knee diagnoses
239446002 SNOMED Stabilisation of patellofemoral joint diagnostic res174: knee diagnoses
239720000 SNOMED Tear of meniscus of knee diagnostic res174: knee diagnoses
239725005 SNOMED Rupture of anterior cruciate ligament diagnostic res174: knee diagnoses
239727002 SNOMED Rupture of posterior cruciate ligament diagnostic res174: knee diagnoses
239729004 SNOMED Rupture of medial collateral ligament of knee diagnostic res174: knee diagnoses
239732001 SNOMED Disorder of patellofemoral joint diagnostic res174: knee diagnoses
239733006 SNOMED Anterior knee pain diagnostic res174: knee diagnoses
239832006 SNOMED Calcium pyrophosphate deposition disease diagnostic res174: knee diagnoses
239838005 SNOMED Chondrocalcinosis diagnostic res174: knee diagnoses
239873007 SNOMED Osteoarthritis of knee diagnostic res174: knee diagnoses
240003004 SNOMED Suprapatellar bursitis diagnostic res174: knee diagnoses
240008008 SNOMED Synovial cyst of knee diagnostic res174: knee diagnoses
241641004 SNOMED MRI of knee diagnostic res174: knee diagnoses
248491001 SNOMED Swollen knee diagnostic res174: knee diagnoses
249913002 SNOMED knee stiff diagnostic res174: knee diagnoses
250102002 SNOMED Unstable knee diagnostic res174: knee diagnoses
250111002 SNOMED Patellar maltracking diagnostic res174: knee diagnoses
263059002 SNOMED Subluxation of patellofemoral joint diagnostic res174: knee diagnoses
269113006 SNOMED Acute meniscal tear, medial diagnostic res174: knee diagnoses
274056002 SNOMED Arthrodesis of knee diagnostic res174: knee diagnoses
281543009 SNOMED Strain of tendon of medial thigh muscle diagnostic res174: knee diagnoses
281810004 SNOMED Aspiration of knee joint diagnostic res174: knee diagnoses
281814008 SNOMED Arthroscopic lateral patellar release diagnostic res174: knee diagnoses
299330008 SNOMED Knee joint valgus deformity diagnostic res174: knee diagnoses
299331007 SNOMED Knee joint - varus deformity diagnostic res174: knee diagnoses
302490008 SNOMED Arthroscopic meniscectomy diagnostic res174: knee diagnoses
302932006 SNOMED Tear of medial meniscus of knee diagnostic res174: knee diagnoses
302933001 SNOMED Tear of lateral meniscus of knee diagnostic res174: knee diagnoses
309431009 SNOMED Arthroscopy of knee diagnostic res174: knee diagnoses
309566008 SNOMED Problem knee diagnostic res174: knee diagnoses
30989003 SNOMED Knee pain diagnostic res174: knee diagnoses
31757006 SNOMED Osteotomy of tibia diagnostic res174: knee diagnoses
35726004 SNOMED Sprain of lateral collateral ligament of knee diagnostic res174: knee diagnoses
35926005 SNOMED Repair of knee cruciate ligaments diagnostic res174: knee diagnoses
36071006 SNOMED Chondromalacia of patella diagnostic res174: knee diagnoses
36701003 SNOMED Both knees diagnostic res174: knee diagnoses
371081002 SNOMED Arthritis of knee diagnostic res174: knee diagnoses
37785001 SNOMED Patellar tendonitis diagnostic res174: knee diagnoses
38964008 SNOMED Arthroscopy of knee with lateral meniscectomy diagnostic res174: knee diagnoses
397529006 SNOMED Finding of tear meniscus diagnostic res174: knee diagnoses
415748002 SNOMED Traumatic rupture of patellar tendon diagnostic res174: knee diagnoses
423466006 SNOMED Arthroscopic procedure diagnostic res174: knee diagnoses
428257007 SNOMED Fracture of tibial plateau diagnostic res174: knee diagnoses
429696002 SNOMED Patellar instability diagnostic res174: knee diagnoses
430698003 SNOMED Replacement of total knee joint diagnostic res174: knee diagnoses
430725003 SNOMED Patellofemoral stress syndrome diagnostic res174: knee diagnoses
443681002 SNOMED Total replacement of left knee joint diagnostic res174: knee diagnoses
443682009 SNOMED Total replacement of right knee joint diagnostic res174: knee diagnoses
444470001 SNOMED Injury of anterior cruciate ligament diagnostic res174: knee diagnoses
445247000 SNOMED Inflammation of bursa of patella diagnostic res174: knee diagnoses
450521003 SNOMED Patellofemoral osteoarthritis diagnostic res174: knee diagnoses
47123000 SNOMED Rupture of cruciate ligaments diagnostic res174: knee diagnoses
52349002 SNOMED Structure of prepatellar bursa diagnostic res174: knee diagnoses
54888009 SNOMED Sprain of knee diagnostic res174: knee diagnoses
58992007 SNOMED Patellectomy diagnostic res174: knee diagnoses
609588000 SNOMED Total knee replacement diagnostic res174: knee diagnoses
6188005 SNOMED Arthrotomy of knee diagnostic res174: knee diagnoses
63643000 SNOMED Derangement of knee diagnostic res174: knee diagnoses
6757004 SNOMED Structure of right knee diagnostic res174: knee diagnoses
72696002 SNOMED Knee region structure diagnostic res174: knee diagnoses
74016001 SNOMED Radiologic examination of knee diagnostic res174: knee diagnoses
76934002 SNOMED Repair of knee collateral ligaments diagnostic res174: knee diagnoses
81512004 SNOMED Loose body in knee diagnostic res174: knee diagnoses
81902001 SNOMED Sprain of medial collateral ligament of knee diagnostic res174: knee diagnoses
82169009 SNOMED Structure of left knee diagnostic res174: knee diagnoses
82675004 SNOMED Synovial cyst of popliteal space diagnostic res174: knee diagnoses
86255002 SNOMED Arthroscopy of knee with medial meniscectomy diagnostic res174: knee diagnoses
9.41E+11 SNOMED Strain of knee diagnostic res174: knee diagnoses

0 comments have been posted.

Please log in to leave a comment.

Quick links:

Code list links:

Only the original uploading author or an administrator can add, edit or delete this article and its associated codes.

University of Manchester IPH ClinicalCodes is a project at the University of Manchester Institute of Population Health

Funded by NIHR School for Primary Care The ClinicalCodes project is funded by the National Institute for Health Research (NIHR) School for Primary Care Research (SPCR)

© 2013-2014 University of Manchester all rights reserved