V_EHI_FLO_MEAS_EDITED
Description:
This view converts the MEAS_VALUE column in IP_FLWSHT_EDITED into an external-facing format for EHI Export. This table should be used in tandem with IP_FLWSHT_EDITED, using the FSD_ID and LINE columns to join the two together.

Primary Key
Column Name Ordinal Position
FSD_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 FSD_ID VARCHAR No
The unique ID for the flowsheet data record.
2 LINE INTEGER No
The line count for the item.
3 MEAS_VALUE_EXTERNAL VARCHAR No
The actual value of the flowsheet reading. This value is converted to an external format, depending on the value type (I FLO 825). For category values, this column will contain the category title. For date values, this column will contain a date string in Mon D YYYY HH:MMAM/PM format (e.g., Jan 1 2015 12:01AM). For time values, this column will contain a timestamp string in HH24:MM:SS format (e.g., 15:05:31 for 3:05 PM). For all other value types, the value matches what is stored in IP_FLWSHT_EDITED__MEAS_VALUE.
4 UNITS VARCHAR No
The units associated with the flowsheet value. For temperature flowsheet rows, this column contains '°F'. For height flowsheet rows, this column contains 'inches'. For weight flowsheet rows, this column contains 'ounces'. Otherwise, this column contains the unit value (I FLO 835) for the associated flowsheet row.
5 VALUE_TYPE_C_NAME VARCHAR No
The type of data in the record (i.e. numeric, string, temperature, etc.).
May contain organization-specific values: No
Category Entries:
Numeric Type
String Type
Category Type
Blood Pressure
Patient Weight
Patient Height
Temperature
Custom List
Date
Time
Weight
Height
Dose
Rate
Concentration
Line/Drain/Airway Link
MAR Action
Dosing Parameter
Networked
Image
6 FLO_MEAS_ID VARCHAR No
The unique ID of the flowsheet group/row.
7 FLO_MEAS_ID_DISP_NAME VARCHAR No
The display name given to the flowsheet group/row.