S AllDiagnoses table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
m Text replacement - "L_Dxs" to "L_Dxs table" |
||
| Line 1: | Line 1: | ||
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]]. 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]]. | ||
== Data Structure == | == Data Structure == | ||
| Line 17: | Line 17: | ||
== re-integrating old records == | == re-integrating old records == | ||
# found all entries in L_Dxs that don't have corresponding s_alldiagnoses entry | # found all entries in L_Dxs table that don't have corresponding s_alldiagnoses entry | ||
#* 2014-02-09 there were 1854 | #* 2014-02-09 there were 1854 | ||
# some had [[Subcode 97]] - -182 | # some had [[Subcode 97]] - -182 | ||
Revision as of 16:50, 2017 November 29
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 - -182
- some had Subcode 96 - -182
- handful of odd ones, see entries with "legacy" as area
- infections for meningoencephalitis and Viral Hep...