s_AllDiagnoses table

From CCMDB Wiki
Revision as of 16:36, 2023 May 17 by Ttenbergen (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

  • added: 2023-05-17
  • action: 2023-05-17
  • Cargo


  • Categories

This table needs to be kept in CCMDB.accdb because it is being used by CFE and MCHP Export.accdb to reference old diagnosis data.

Counterparts to this table used now are s_ICD10 table, s_CCI_1 table, s_CCI_2 table, s_CCI_Picklist table.

The S AllDiagnoses table can be found in CCMDB.accdb program. It contains the all the diagnosis labels and numeric codes used that were entered into L_Dxs table. A filtered subset of this table contains the values Comorbid Diagnosis that could 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: