Questions tagged [icd]

ICD is the International Classification of Diseases, a numerical classification system

ICD is the International Classification of Diseases, a numerical classification system is the classification used to code health conditions and related information. The ICD is copyrighted by the World Health Organization (WHO), which owns and publishes the classification. The ICD has been revised periodically to incorporate changes in the medical field. The current version is ICD10, but ICD9 is still in use and ICD11 is in development.

38 questions
0
votes
1 answer

Import ICD-10 codes xml file to database

I have a xml file with ICD-10 codes, downloaded from http://www.who.int/classifications/icd/en/ How can i import it to sql database?
Meenakshi
  • 79
  • 1
  • 7
0
votes
1 answer

Access compare wildcard values to table

This is a simple question on its own, but my dilemma is I'm comparing 1,000+ medical diagnosis codes to the overall ICD9 table. I have a list of truncated codes to compare to the entire database. For example, I have truncated code 010, but the…
jeffrey406
  • 11
  • 1
0
votes
1 answer

Find (ICD9 code) and replace parentheses with |

I'm using Notepad++ v6.9.2. I need to find ICD9 Codes which will take the following forms: (X##.), (X##.#) or (X##.##) where X is a letter and always at the beginning and # is a number (##.), (##.#), (##.##), (###.), (###.#), (###.##) or (###.###)…
G83
  • 89
  • 1
  • 7
0
votes
3 answers

Regex for determining if Alphanumeric code is in range

I'm working on an ICD10 diagnosis code application. I need to determine if one ICD10 code falls in a certain range. For example: Code: 4A1H7EZ Range: 4A1H7CZ - 4A1H7HZ This should return 'True'. I've tried converting the alpha characters to numbers…
Kieran Quinn
  • 1,085
  • 2
  • 22
  • 49
0
votes
1 answer

ICD 10 dropdown for a Spring application with mysql database in the background

I am currently working on a Spring healthcare application where the doctor can enter the diagnosis codes in the input tag of a page. What I want is that the doctor should be able to select the codes from a drop-down menu, the problem with ICD10…
Chirag Shah
  • 21
  • 1
  • 5
0
votes
2 answers

Insert a value If a match is found in join table

I have a table of ICD9 codes where several of them are not coded properly. I would like to insert "No" into a column in that table if a match can not be found in another table. So for example, I have a code 292300 and It should be 2923. I want to…
grath
  • 66
  • 1
  • 9
0
votes
2 answers

Running multiple subqueries

I am pulling one code (ICD9) which is in table AbsDrgDiagnosis.Diagnosis. I need to pull another code (SNOMED_CT) which is in another table DMisNomenclatureMapCodes.CodeID when DMisNomenclatureMapCodes.CodeSetID = 'SNOMED_CT' Then only way to link…
Rich
  • 49
  • 8
-1
votes
1 answer

How do I filter a column of character strings based on their first and 3rd characters?

I've got a dataset of ICD codes, 5 digit codes which describe the diagnosis of a hospital patients, which looks like this (but with 16000 patients): df <- c('S48.10', 'H38.13', 'R40.12') I need to filter them based on the first character being an S…
1 2
3