S AllDiagnoses table

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

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: