INFECTION_INDICATOR

Description:

The INFECTION_INDICATOR table contains detailed information about the auto-infection and rule-out infection rules that were used to add or indicate infections.

Primary Key

Column Name	Ordinal Position
INFECTION_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	INFECTION_ID	NUMERIC	No
	The unique identifier for the infection 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	INF_INDICATOR_TYPE_C_NAME	VARCHAR	No
	The indicator type category ID describing the method by which the infection was indicated. May contain organization-specific values: No Category Entries: Manual Procedure Rule Organism Rule Rule-Out Lab Result Definition Rule External Organization
4	INDICATED_UTC_DTTM	DATETIME (UTC)	No
	The UTC instant when the infection was indicated.
5	INDICATING_ORDER_ID	NUMERIC	No
	The unique ID of the order that indicated the infection.
6	INDICATING_PROC_ID_PROC_NAME	VARCHAR	No
	The name of each procedure.
7	INDICATING_COMPONENT_ID	NUMERIC	No
	The unique ID of the component specified in the auto-infection rule.
8	INDICATING_COMPONENT_ID_NAME	VARCHAR	No
	The name of the component.
9	INDICATING_ORGANISM_ID	NUMERIC	No
	The unique ID of the organism where the auto-infection or rule-out infection rule that indicated the infection is specified.
10	INDICATING_ORGANISM_ID_NAME	VARCHAR	No
	The name of the organism.
11	INDICATING_ANTIBIOTIC_C_NAME	VARCHAR	No
	The antibiotic category ID matching the antibiotic specified in the auto-infection rule. May contain organization-specific values: Yes
12	INDICATING_SUSCEPT_C_NAME	VARCHAR	No
	The susceptibility category ID specified in the auto-infection rule. May contain organization-specific values: Yes
13	INDICATING_LRD_ID_RECORD_NAME	VARCHAR	No
	The record name for the Lab Result Definition.