INFECTIONS
Description:
This table contains basic information about patient infections.

Primary Key
Column Name Ordinal Position
INFECTION_ID 1

Column Information
Name Type Discontinued?
1 INFECTION_ID NUMERIC No
The unique identifier for the infection record.
2 RECORD_STATUS_C_NAME VARCHAR No
The record status category ID for the infection.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 INFECTION_RECORD_TYPE_C_NAME VARCHAR No
The record type category ID for the infection.
May contain organization-specific values: No
Category Entries:
Encounter Level
Patient Level
4 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
5 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
6 INFECTION_TYPE_C_NAME VARCHAR No
The infection type category ID for the infection.
May contain organization-specific values: Yes
7 INF_STATUS_C_NAME VARCHAR No
The infection status category ID for the infection.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Infection Expired
Deleted
Rule-Out Test Resulted
Encounter Ended
Rule-Out Test Canceled
Patient Deceased
8 HOW_ADDED_C_NAME VARCHAR No
The how added category ID for the infection. This indicates the method by which the infection was added to the patient chart.
May contain organization-specific values: No
Category Entries:
User
Import
Auto-Update (Result)
Rule-Out (Order Placed)
Interface
Conversion
OPA Follow-Up (Manual)
OPA Follow-Up (Automatic)
Bulk Action - Add Infection
Bulk Action - Contact Trace Add Infection
User - From External
9 ADD_UTC_DTTM DATETIME (UTC) No
The UTC date and time that the infection was added to the patient chart.
10 ADD_USER_ID VARCHAR No
The unique ID associated with the user who added the infection. This column is frequently used to link to the CLARITY_EMP table.
11 ADD_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 RESOLVE_UTC_DTTM DATETIME (UTC) No
The UTC date and time that the infection was resolved in the patient chart.
13 RESOLVE_USER_ID VARCHAR No
The unique ID associated with the user who resolved the infection. This column is frequently used to link to the CLARITY_EMP table.
14 RESOLVE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
15 EXPIRATION_DATE DATETIME No
The date when the infection is set to automatically expire.
16 DOESNT_EXPIRE_YN VARCHAR No
Indicates whether the infection should not automatically expire. 'Y' indicates that the infection requires clinical judgement to be marked as resolved. 'N' or NULL indicates that it is safe for the infection to expire automatically if an expiration date is given.
May contain organization-specific values: No
Category Entries:
No
Yes
17 REVIEW_DATE DATETIME No
The date that the infection should be reviewed.
18 ONSET_DATE DATETIME No
The date that the infection began.
19 COMMENTS VARCHAR No
User-entered comments associated with the infection.
20 SPECIMEN_TYPE_C_NAME VARCHAR No
The specimen type category ID for the infection.
May contain organization-specific values: Yes
21 SPECIMEN_SOURCE_C_NAME VARCHAR No
The specimen source category ID for the infection.
May contain organization-specific values: Yes
22 RECORD_CREATION_DATE DATETIME No
The date the infection record was created.
23 ADD_LOCAL_DTTM DATETIME (Attached) No
The local date and time that the infection was added to the patient chart.
24 RESOLVE_LOCAL_DTTM DATETIME (Attached) No
The local date and time that the infection was resolved in the patient chart.
25 ISOLATION_LINKS_CALCULATED_YN VARCHAR No
Indicates whether all linked isolations have been calculated. 'Y' indicates all linked isolations have been calculated. 'N' or NULL indicates that there may be isolations that would be considered linked to the infection, but that pre-date the linking calculation.
The category values for this column were already listed for column: DOESNT_EXPIRE_YN