S Pathogens table: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-{{LegacyContent
+{{DISPLAYTITLE:s_Pathogens table}}
-|explanation=pre-ICD10
+{{Todo
-|successor=[[S ICD10 table]], [[S CCI 1 table]], [[S CCI 2 table]], [[S CCI Picklist table]]
+ | who = Tina
-|content=
+ | 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]].
+}}
-The '''S_Pathogens''' table contains the possible values for the sub-codes for [[:Category:Infection (old)]] diagnoses to be encoded in the [[L_Dxs table]] table on the PDA and in the [[CCMDB.mdb]].
+{{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 ==
@@ Line 12: / Line 28: @@
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: UPL (old)]]
+[[Category:UPL (old)]]
 }}