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: @@
-The '''S_Pathogens''' table contains the possible values for the sub-codes for [[:Category:Infection|Infections]] diagnoses to be encoded in the [[L_Dxs]] table on the PDA and in the [[CCMDB.mdb]].
+{{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]].
+}}
-See [[Pathogens]] for the actual list and for further info.
+{{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 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 ==
+{{Related Articles}}
 [[Category: Data structure]]
-[[Category: UPL]]
+[[Category: UPL (old)]]
+}}