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.