V_EHI_FLO_MEAS_VALUE

Description:

This view converts the MEAS_VALUE column in IP_FLWSHT_MEAS into an external-facing format for EHI Export. This table should be used in tandem with IP_FLWSHT_MEAS, 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_MEAS__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.