S AllDiagnoses table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
'''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. | 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 == | == Data Structure == | ||
| Line 32: | Line 32: | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||
Revision as of 10:48, 2020 June 10
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
- found all entries in L_Dxs table that don't have corresponding s_alldiagnoses entry
- 2014-02-09 there were 1854
- some had Subcode 97 (old) - -182
- some had Subcode 96 (old) - -182
- handful of odd ones, see entries with "legacy" as area
- infections for meningoencephalitis and Viral Hep...