S Pathogens table: Difference between revisions

Latest revision as of 21:22, 2023 June 15

	This table could be moved to CFE with S AllDiagnoses table since it is no longer used in CCMDB.accdb.	added: 2023-05-17 action: 2023-05-17

This page contains Legacy Content.

Click Expand to show legacy content.

The S_Pathogens table in CFE contains the possible values for the sub-codes for Category:Infection (old) diagnoses encoded in the L_Dxs table table in CCMDB.mdb.

The s_Pathogens table is used by CFE and MCHP Export.accdb to reference old diagnosis data.

See Pathogens (old) for the actual list and for further info.

Related articles:
S AllDiagnoses table ‎ (← links) CCMDB.mdb Change Log 2016 ‎ (← links) CCMDB.mdb Change Log 2017 ‎ (← links) Legacy Content ‎ (← links) Pathogens (old) ‎ (← links) CCMDB.accdb Change Log 2020 ‎ (← links) To do list ‎ (← links) User:Ttenbergen/questions for tina ‎ (← links)

@@ 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. '''
+{{DISPLAYTITLE:s_Pathogens table}}
+{{Todo
+ | who = Tina
+ | todo_added = 2023-05-17
+ | todo_action = 2023-05-17
+ | question =
+* This table could be moved to [[CFE]] with [[S AllDiagnoses table]] since it is no longer used in [[CCMDB.accdb]].
+}}
-Counterpart  to this table used now are [[S ICD10 table]].
+{{LegacyContent
+| explanation=old facet table for dx data
+| successor=[[Pathogens]] in [[S ICD10 table]]
+| content=
+The '''S_Pathogens''' table in [[CFE]] contains the possible values for the sub-codes for [[:Category:Infection (old)]] diagnoses encoded in the [[L_Dxs table]] table in [[CCMDB.mdb]].
-The '''S_Pathogens''' table contains the possible values for the sub-codes for [[:Category:Infection (old)]] diagnoses encoded in the [[L_Dxs table]] table in [[CCMDB.mdb]].
+The s_Pathogens table is used by [[CFE]] and [[MCHP Export.accdb]] to reference old diagnosis data.
 See [[Pathogens (old)]] for the actual list and for further info.
+== Data structure ==
+* pathogenSubCode - long integer - unique ID as used in L_Dxs
+* type - short text - anaerobe, bacteria, etc
+* pathogen - short text - name of pathogen
+* active - boolean
 == Related articles ==
@@ Line 13: / Line 30: @@
 [[Category: Data structure]]
 [[Category: UPL (old)]]
+}}