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