SEVERE_SEPSIS_EVENTS
Description:
Each row represents one Severe Sepsis Event recorded during a patient's inpatient encounter. A Severe Sepsis Event is a documented clinical finding or provider note that helps determine when the patient first met the CMS SEP-1 definition of sepsis. Each row stores the event type, the date and time it occurred, and a reference to the note, order, flowsheet row, or SmartData element that caused it.

Primary Key
Column Name Ordinal Position
INPATIENT_DATA_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 INPATIENT_DATA_ID VARCHAR No
The unique identifier (.1 item) for the inpatient 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 SEV_SEPSIS_EVENT_C_NAME VARCHAR No
The severe sepsis event category ID for this row, identifying whether the event was a provider note documenting severe sepsis or septic shock, a patient meeting clinical criteria, or a provider note documenting no sepsis.
May contain organization-specific values: No
Category Entries:
Provider Note contains Severe Sepsis/Septic Shock
Patient meets Clinical Criteria
Provider Note contains No Sepsis
4 SEV_SEPSIS_EVENT_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the severe sepsis event occurred.
5 SEV_SEPSIS_EVENT_NOTE_CSN_ID NUMERIC No
The unique contact serial number of the note that caused the severe sepsis event for this row. This column is empty if a note did not cause the event.
6 SEV_SEPSIS_EVENT_ORDER_ID NUMERIC No
The unique ID of the order that caused the severe sepsis event for this row. This column is empty if an order did not cause the event.
7 SEV_SEPSIS_EVENT_FLO_MEAS_ID VARCHAR No
The unique ID of the flowsheet row that caused the severe sepsis event for this row. This column is empty if a flowsheet row did not cause the event.
8 SEV_SEPSIS_EVENT_FLO_MEAS_ID_DISP_NAME VARCHAR No
The display name given to the flowsheet group/row.
9 SEV_SEPSIS_EVENT_CAT_C_NAME NUMERIC No
The category ID of the clinical finding that caused the severe sepsis event for this row, such as a vital sign, a lab result, documentation of infection, or a note documenting severe sepsis or septic shock. This column is empty for events from a provider note documenting no sepsis.
May contain organization-specific values: No
Category Entries:
Temperature
Heart Rate
Respiratory Rate
White Blood Cell Count
Systolic Blood Pressure
Mean Arterial Pressure
Creatinine
Urine Output
Total Bilirubin
Platelet Count
INR
PTT
Lactate
WBC Band
Infection
Severe Sepsis
Septic Shock
10 SEV_SEPSIS_EVENT_INVALID_YN VARCHAR No
Indicates whether a later note edit invalidated the severe sepsis event in this row. 'Y' indicates that the event has been invalidated. 'N' or NULL indicate that the event is still valid.
May contain organization-specific values: No
Category Entries:
No
Yes
11 INF_NOTE_CSN_ID NUMERIC No
The unique contact serial number of the note that documented the infection for the severe sepsis event in this row. This column is empty if a note did not document the infection.
12 SEV_SEPSIS_EVENT_HLV_ID NUMERIC No
The unique ID of the SmartData element that caused the severe sepsis event for this row. This column is empty if a SmartData element did not cause the event.
13 INF_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the infection was documented for the severe sepsis event in this row.
14 INF_ORDER_ID NUMERIC No
The unique ID of the order that documented the infection for the severe sepsis event in this row. This column is empty if an order did not document the infection.
15 INF_FLO_MEAS_ID VARCHAR No
The unique ID of the flowsheet row that documented the infection for the severe sepsis event in this row. This column is empty if a flowsheet row did not document the infection.
16 INF_FLO_MEAS_ID_DISP_NAME VARCHAR No
The display name given to the flowsheet group/row.
17 INF_HLV_ID NUMERIC No
The unique ID of the SmartData element that documented the infection for the severe sepsis event in this row. This column is empty if a SmartData element did not document the infection.
18 SIRS_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the patient met two or more SIRS criteria for the severe sepsis event in this row.
19 SIRS_FLO_MEAS_ID VARCHAR No
The unique ID of the flowsheet row that recorded the SIRS criterion met for the severe sepsis event in this row. This column is empty if a flowsheet row did not record the criterion.
20 SIRS_FLO_MEAS_ID_DISP_NAME VARCHAR No
The display name given to the flowsheet group/row.
21 SIRS_ORDER_ID NUMERIC No
The unique ID of the order that recorded the SIRS criterion met for the severe sepsis event in this row. This column is empty if an order did not record the criterion.
22 SIRS_SEV_SEPSIS_EVENT_CAT_C_NAME NUMERIC No
The category ID of the SIRS criterion met for the severe sepsis event in this row, such as temperature, heart rate, respiratory rate, or white blood cell count.
The category values for this column were already listed for column: SEV_SEPSIS_EVENT_CAT_C_NAME
23 OD_UTC_DTTM DATETIME (UTC) No
The UTC date and time when organ dysfunction was documented for the severe sepsis event in this row.
24 OD_FLO_MEAS_ID VARCHAR No
The unique ID of the flowsheet row that recorded the organ dysfunction documented for the severe sepsis event in this row. This column is empty if a flowsheet row did not record the organ dysfunction.
25 OD_FLO_MEAS_ID_DISP_NAME VARCHAR No
The display name given to the flowsheet group/row.
26 OD_ORDER_ID NUMERIC No
The unique ID of the order that recorded the organ dysfunction documented for the severe sepsis event in this row. This column is empty if an order did not record the organ dysfunction.
27 OD_SEV_SEPSIS_EVENT_CAT_C_NAME NUMERIC No
The category ID of the organ dysfunction documented for the severe sepsis event in this row, such as creatinine, total bilirubin, platelet count, INR, or lactate.
The category values for this column were already listed for column: SEV_SEPSIS_EVENT_CAT_C_NAME