S AllDiagnoses table: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m →Data Structure: that one never got implemented |
||
| (19 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
The '''S AllDiagnoses''' table contains the all the | {{Todo | ||
| who = Tina | |||
| todo_added = 2023-05-17 | |||
| todo_action = 2023-05-17 | |||
| question = | |||
* This table could be moved to [[CFE]] with [[S Pathogens table]] since it is no longer used in [[CCMDB.accdb]]. | |||
}} | |||
{{DISPLAYTITLE:s_AllDiagnoses table}}'''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 == | == Data Structure == | ||
* [[Area]] - Organs system or similar classification | * [[Area]] - Organs system or similar classification | ||
* MainDiagnosis | * MainDiagnosis | ||
* SubDiagnosis - ''explain uppercasing'' | * SubDiagnosis - ''explain uppercasing'' | ||
| Line 13: | Line 25: | ||
Related Tables: | Related Tables: | ||
* [[Check ORDx]] | * [[Check ORDx]] | ||
* [[ | |||
== 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... | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
Latest revision as of 20:29, 2024 March 29
|
|
|
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...