S AllDiagnoses table

From CCMDB Wiki
Revision as of 09:58, 2020 June 5 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

The S AllDiagnoses table can be found in CCMDB.mdb program. It contains the all the diagnoses labels and numeric codes used that can be entered into L_Dxs table. A filtered subset of this table contains the values Comorbid Diagnosis that can be selected and entered into the L_Como table.

Data Structure

  • Area - Organs system or similar classification
  • MainDiagnosis
  • SubDiagnosis - explain uppercasing
  • DiagnosisCode - primary key
  • Notes
  • IsInfection
  • Como
  • Diag
  • ComoPoints

Related Tables:

re-integrating old records

  1. found all entries in L_Dxs table that don't have corresponding s_alldiagnoses entry
    • 2014-02-09 there were 1854
  2. some had Subcode 97 (old) - -182
  3. some had Subcode 96 (old) - -182
  4. handful of odd ones, see entries with "legacy" as area
  5. infections for meningoencephalitis and Viral Hep...

Related articles

Related articles: