S Pathogens table: Difference between revisions

Retrieved from "https://ccmdb.kuality.ca/index.php?title=S_Pathogens_table"

@@ Line 1: / Line 1: @@
-The '''S_Pathogens''' table contains the possible values for the sub-codes for [[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]].
+}}
-== to do before de-stubbing ==
+{{LegacyContent
-* explain data structure
+| 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.
-{{stub}}
+== Data structure ==
-[[Category: 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 (old)]]
+}}