ASSOCD_ORGANISMS

Description: |
This table contains the organisms which have been associated with infection cases. This can be used to find infection cases which were associated with a specific organism or MDRO definition.
These are not NHSN pathogens which are stored in NHSN_PS_FORM.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
REGISTRY_DATA_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REGISTRY_DATA_ID | NUMERIC | No |
The unique identifier (.1 item) for the registry data record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | ASSOCD_ORGANISM_ID | NUMERIC | No |
Stores the organisms records associated with the case. The allowed types are " (non-Beaker LLO), 1 (Beaker LLO), and 4 (MDRO Definition).
4 | ASSOCD_ORGANISM_ID_NAME | VARCHAR | No |
The name of the organism.