S AllDiagnoses table

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

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 that don't have corresponding s_alldiagnoses entry
   • 2014-02-09 there were 1854
2. some had Subcode 97 - -182
3. some had Subcode 96 - -182
4. handful of odd ones, see entries with "legacy" as area
5. infections for meningoencephalitis and Viral Hep...