IP_FLOWSHEET_ROWS

Description:

This table contains flowsheet row (FLO) data for an encounter. This table is a key table in tying LDA assessment row lines in flowsheet data records to the LDAs, and the necessary joins are: IP_FLOWSHEET_ROWS.IP_LDA_ID with IP_LDA_NOADDSINGLE.IP_LDA_ID IP_FLOWSHEET_ROWS.INPATIENT_DATA_ID with IP_FLWSHT_REC.INPATIENT_DATA_ID IP_FLOWSHEET_ROWS.LINE with IP_FLWSHT_MEAS.OCCURANCE IP_FLWSHT_REC.FSD_ID with IP_FLWSHT_MEAS.FSD_ID.

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 ID of the inpatient data store record.
2	LINE	INTEGER	No
	The line count for the item.
3	FLO_MEAS_ID	VARCHAR	No
	The unique ID of the flowsheet group/row.
4	FLO_MEAS_ID_DISP_NAME	VARCHAR	No
	The display name given to the flowsheet group/row.
5	FLOWSHT_ROW_NAME	VARCHAR	No
	The flowsheet row name. Especially comes into play when a custom name is given to a duplicable row/group, either by a user typing it upon manually adding a row/group or from the order that fired the task template which added the duplicable row/group.
6	IP_LDA_ID	VARCHAR	No
	Stores the Lines/Drains/Airways (LDA) ID for the flowsheet group.
7	ROW_VARIANCE_C_NAME	VARCHAR	No
	The flowsheet row variance. May contain organization-specific values: No Category Entries: Add Remove