[ { "phenotype_id": "PH845", "phenotype_version_id": 1769, "name": "Knee Diagnosis", "definition": "Introduction:\n\nGeneral practice is integral to the Australian healthcare system. Outcome Health’s POpulation Level Analysis and Reporting (POLAR) database uses de-identified electronic health records to analyse general practice data in Australia. Previous studies using routinely collected health data for research have not consistently reported the codes and algorithms used to describe the population, exposures, interventions and outcomes in sufficient detail to allow replication. This paper reports a study protocol investigating patterns of care for people presenting with musculoskeletal conditions to general practice in Victoria, Australia. Its focus is on the systematic approach used to classify and select eligible records from the POLAR database to facilitate replication. This will be useful for other researchers using routinely collected health data for research.\n\n\nMethods and analysis:\n\nThis is a retrospective cohort study. Patient-related data will be obtained through electronic health records from a subset of general practices across three primary health networks (PHN) in southeastern Victoria. Data for patients with a low back, neck, shoulder and/or knee condition and who received at least one general practitioner (GP) face-to-face consultation between 1 January 2014 and 31 December 2018 will be included. Data quality checks will be conducted to exclude patients with poor data recording and/or non-continuous follow-up. Relational data files with eligible and valid records will be merged to select the study cohort and the GP care received (consultations, imaging requests, prescriptions and referrals) between diagnosis and 31 December 2018. Number and characteristics of patients and GPs, and number, type and timing of imaging requests, prescriptions for pain relief and referrals to other health providers will be investigated.\n\n\nEthics and dissemination:\n\nEthics approval was obtained from the Cabrini and Monash University Human Research Ethics Committees (Reference Numbers 02-21-01-19 and 16975, respectively). Study findings will be reported to Outcome Health, participating PHNs, disseminated in academic journals and presented in conferences.\n\n\n\n\n\n\n\n\n", "implementation": "", "publications": [ { "doi": null, "details": "Romi Haas, Ljoudmila Busija, Alexandra Gorelik, Denise A O'Connor, Christopher Pierce, Danielle Mazza, Rochelle Buchbinder, Patterns of care for people presenting to Australian general practice with musculoskeletal complaints based on routinely collected data: protocol for an observational cohort study using the Population Level Analysis and Reporting (POLAR) database. BMJ Open, 11(e055528), 2021." } ], "validation": "", "citation_requirements": "", "created": "2022-04-04T07:06:43.979086Z", "author": "Romi Haas, Ljoudmila Busija, Alexandra Gorelik, Denise A O'Connor, Christopher Pierce, Danielle Mazza, Rochelle Buchbinder", "collections": [ { "name": "ClinicalCodes Repository", "value": 25 }, { "name": "Phenotype Library", "value": 18 } ], "tags": null, "organisation": null, "world_access": 1, "updated": "2022-04-04T07:06:43.979111Z", "sex": [ { "name": "Both", "value": "3" } ], "type": [ { "name": "Disease or syndrome", "value": "2" } ], "ontology": null, "phenoflowid": "", "data_sources": [ { "name": "POpulation Level Analysis and Reporting (POLAR) Database Australia", "value": 34, "datasource_id": 34 } ], "coding_system": [ { "name": "SNOMED CT codes", "value": 9 } ], "event_date_range": "01/01/2014 - 31/12/2018", "concept_information": [ { "concept_id": 2601, "concept_version_id": 6615, "concept_name": "Knee Diagnosis - Primary Care", "coding_system": { "id": 9, "name": "SNOMED CT codes", "description": "SNOMED CT codes" }, "phenotype_id": "PH845", "phenotype_version_id": 1769, "phenotype_name": "Knee Diagnosis", "code_attribute_header": [ "Entity type", "Coding System (SNOMED)", "Category" ], "codes": [ { "code": "111243002.0", "description": "Bursitis of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "1126007.0", "description": "Knee locking", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "125601008.0", "description": "Injury of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "17059001.0", "description": "Prepatellar bursitis", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "178158006.0", "description": "Repair of patellar tendon", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "202381003.0", "description": "Knee joint effusion", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "202413005.0", "description": "Haemarthrosis of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "209508007.0", "description": "Strain of patellar tendon", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "209627008.0", "description": "Complete tear, knee, medial collateral ligament", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "22878006.0", "description": "Contusion of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239312004.0", "description": "Osteotomy of proximal tibia", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239419007.0", "description": "Repair of meniscus", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239426007.0", "description": "Repair of anterior cruciate ligament of knee joint", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239446002.0", "description": "Stabilisation of patellofemoral joint", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239720000.0", "description": "Tear of meniscus of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239725005.0", "description": "Rupture of anterior cruciate ligament", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239727002.0", "description": "Rupture of posterior cruciate ligament", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239729004.0", "description": "Rupture of medial collateral ligament of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239732001.0", "description": "Disorder of patellofemoral joint", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239733006.0", "description": "Anterior knee pain", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239832006.0", "description": "Calcium pyrophosphate deposition disease", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239838005.0", "description": "Chondrocalcinosis", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "239873007.0", "description": "Osteoarthritis of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "240003004.0", "description": "Suprapatellar bursitis", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "240008008.0", "description": "Synovial cyst of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "241641004.0", "description": "MRI of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "248491001.0", "description": "Swollen knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "249913002.0", "description": "knee stiff", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "250102002.0", "description": "Unstable knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "250111002.0", "description": "Patellar maltracking", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "263059002.0", "description": "Subluxation of patellofemoral joint", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "269113006.0", "description": "Acute meniscal tear, medial", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "274056002.0", "description": "Arthrodesis of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "281543009.0", "description": "Strain of tendon of medial thigh muscle", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "281810004.0", "description": "Aspiration of knee joint", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "281814008.0", "description": "Arthroscopic lateral patellar release", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "299330008.0", "description": "Knee joint valgus deformity", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "299331007.0", "description": "Knee joint - varus deformity", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "302490008.0", "description": "Arthroscopic meniscectomy", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "302932006.0", "description": "Tear of medial meniscus of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "302933001.0", "description": "Tear of lateral meniscus of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "309431009.0", "description": "Arthroscopy of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "309566008.0", "description": "Problem knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "30989003.0", "description": "Knee pain", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "31757006.0", "description": "Osteotomy of tibia", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "35726004.0", "description": "Sprain of lateral collateral ligament of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "35926005.0", "description": "Repair of knee cruciate ligaments", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "36071006.0", "description": "Chondromalacia of patella", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "36701003.0", "description": "Both knees", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "371081002.0", "description": "Arthritis of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "37785001.0", "description": "Patellar tendonitis", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "38964008.0", "description": "Arthroscopy of knee with lateral meniscectomy", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "397529006.0", "description": "Finding of tear meniscus", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "415748002.0", "description": "Traumatic rupture of patellar tendon", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "423466006.0", "description": "Arthroscopic procedure", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "428257007.0", "description": "Fracture of tibial plateau", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "429696002.0", "description": "Patellar instability", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "430698003.0", "description": "Replacement of total knee joint", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "430725003.0", "description": "Patellofemoral stress syndrome", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "443681002.0", "description": "Total replacement of left knee joint", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "443682009.0", "description": "Total replacement of right knee joint", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "444470001.0", "description": "Injury of anterior cruciate ligament", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "445247000.0", "description": "Inflammation of bursa of patella", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "450521003.0", "description": "Patellofemoral osteoarthritis", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "47123000.0", "description": "Rupture of cruciate ligaments", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "52349002.0", "description": "Structure of prepatellar bursa", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "54888009.0", "description": "Sprain of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "58992007.0", "description": "Patellectomy", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "609588000.0", "description": "Total knee replacement", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "6188005.0", "description": "Arthrotomy of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "63643000.0", "description": "Derangement of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "6757004.0", "description": "Structure of right knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "72696002.0", "description": "Knee region structure", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "74016001.0", "description": "Radiologic examination of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "76934002.0", "description": "Repair of knee collateral ligaments", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "81512004.0", "description": "Loose body in knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "81902001.0", "description": "Sprain of medial collateral ligament of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "82169009.0", "description": "Structure of left knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "82675004.0", "description": "Synovial cyst of popliteal space", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "86255002.0", "description": "Arthroscopy of knee with medial meniscectomy", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } }, { "code": "941000000000.0", "description": "Strain of knee", "attributes": { "Entity type": "res174: knee diagnoses", "Coding System (SNOMED)": "SNOMED", "Category": "diagnostic" } } ] } ], "status": 2, "doi": "https://doi.org/10.48533/k5q4-m930", "is_deleted": null, "publish_status": 2, "owner": "ieuan.scanlon", "template": { "id": 1, "name": "Clinical-Coded Phenotype", "description": "Phenotype definitions that are based on lists of clinical codes, or algorithms using clinical codes.", "version_id": 1 }, "versions": [ { "version_id": 1769, "version_name": "Knee Diagnosis", "version_date": "2022-04-04T07:06:44.006229Z", "is_published": true, "is_latest": true } ] } ]