S Pathogens table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{DISPLAYTITLE:s_Pathogens table}} | {{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 | {{LegacyContent | ||
| explanation=old facet table for dx data | | explanation=old facet table for dx data | ||
| Line 9: | Line 17: | ||
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 == | ||
Latest revision as of 21: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: |