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