S AllDiagnoses table

This table could be moved to CFE with S Pathogens table since it is no longer used in CCMDB.accdb.

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:

• Check ORDx

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...