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: | ||
{{LegacyContent | |||
|explanation=pre-ICD10 | |||
|successor=[[S ICD10 table]], [[S CCI 1 table]], [[S CCI 2 table]], [[S CCI Picklist table]] | |||
|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]]. | 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]]. | ||
| Line 23: | Line 27: | ||
# handful of odd ones, see entries with "legacy" as area | # handful of odd ones, see entries with "legacy" as area | ||
# infections for meningoencephalitis and Viral Hep... | # infections for meningoencephalitis and Viral Hep... | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
}} | |||
Revision as of 09:58, 2020 June 5
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:
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...