s_Pathogens table

This table could be moved to CFE with S AllDiagnoses table since it is no longer used in CCMDB.accdb.

added: 2023-05-17 action: 2023-05-17

• Cargo

• Categories

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