S AllDiagnoses table

Legacy Content

This page contains Legacy Content.

• Explanation: pre-ICD10
• Successor: S ICD10 table, S CCI 1 table, S CCI 2 table, S CCI Picklist table

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:

• Check ORDx
• Check IsolationDXs

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