S Pathogens table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Text replacement - "Pathogens" to "Pathogens (old)") |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The '''S_Pathogens''' table contains the possible values for the sub-codes for [[:Category:Infection | {{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]]. | |||
}} | |||
{{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. | 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: Data structure]] | ||
[[Category: UPL (old)]] | [[Category: UPL (old)]] | ||
}} | |||
Latest revision as of 22:22, 2023 June 15
|
|
|
Legacy Content
This page contains Legacy Content.- Explanation: old facet table for dx data
- Successor: Pathogens in S ICD10 table
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.
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: |