S Pathogens table: Difference between revisions

← Older edit

@@ 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.
-{{stub}}
+See [[Pathogens (old)]] for the actual list and for further info.
-[[Category: Data structure]]
+== 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)]]
+}}