S Pathogens table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
Line 17: 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

  • added: 2023-05-17
  • action: 2023-05-17
  • Cargo


  • Categories

Legacy Content

This page contains Legacy Content.

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: