IP_FLWSHT_MEAS
Description:
This table contains the patient-specific measurements from flowsheets.

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 FLO_MEAS_ID VARCHAR No
The unique ID for the flowsheet group/row associated with this reading.
4 FLO_MEAS_ID_DISP_NAME VARCHAR No
The display name given to the flowsheet group/row.
5 OCCURANCE INTEGER No
If the flowsheet group/row appears multiple times, this will distinguish the occurrence.
6 RECORDED_TIME DATETIME (Local) No
The instant the reading was taken.
7 ENTRY_TIME DATETIME (Local) No
The instant the reading was entered.
8 TAKEN_USER_ID VARCHAR No
The unique ID of the user taking the flowsheet readings.
9 TAKEN_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
10 ENTRY_USER_ID VARCHAR No
The unique ID of the user entering the readings.
11 ENTRY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 MEAS_COMMENT VARCHAR No
The free text comments associated with the reading.
13 EDITED_LINE INTEGER No
The line number of the previous value of an edited record.
14 ISACCEPTED_YN VARCHAR No
Determines if this flowsheet record has been accepted.
May contain organization-specific values: No
Category Entries:
No
Yes
15 IP_SIGNIFICANT_YN VARCHAR No
This stores whether the flowsheet data is marked as significant. If a value is not marked as significant, this column returns NULL.
The category values for this column were already listed for column: ISACCEPTED_YN
16 CAPTURE_DEVICE_ID VARCHAR No
This item stores information of the Device ID for the device from which data is captured from.
17 CAPTURE_DEVICE_ID_DEVICE_NAME VARCHAR No
The name for this device.
18 RECEIVED_INSTANT DATETIME (Local) No
Instant at which value was received at the interface
19 NEEDS_COSIGN_C_NAME VARCHAR No
If this item is blank or 0 (No), then this flowsheet data does not need a cosign. If this item is 1 (Required Yes), then a cosign is required for this data and can only be pended. If this item is 2 (Chosen Yes), then a cosign has been requested for this data but it is not required. If this item is 3 (Required Yes Can File), then a cosign is required for the data and the data can be filed.
May contain organization-specific values: No
Category Entries:
No
Required Yes
Chosen Yes
Required Yes Can File
20 FLT_ID VARCHAR No
The unique ID of the flowsheet template (FLT) which was used to enter the data in this cell.
21 FLT_ID_DISPLAY_NAME VARCHAR No
The display name associated with this template.
22 FLO_DAT_USED NUMERIC No
This column stores the contact date (DAT) of the flowsheet row or group that is used to define the data.
23 FLO_CNCT_DATE_REAL NUMERIC No
This column converts the contact date (DAT) of the flowsheet group or row to DTE, based on the value in column FLO_DAT_USED.
24 USER_PENDED_BY_ID VARCHAR No
User ID of the user who pended this flowsheet value.
25 USER_PENDED_BY_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
26 INSTANT_PENDED_DTTM DATETIME (Local) No
Date/time at which a flowsheet value is pended.
27 ABNORMAL_C_NAME VARCHAR No
Stores whether or not the value is abnormal
May contain organization-specific values: No
Category Entries:
Yes
28 THRDPRTY_SRC_C_NAME VARCHAR No
Identifies the third-party framework that a Flowsheets value originally came from, if applicable. Intended to be used to track values that are sourced from health/fitness frameworks (e.g. Apple's HealthKit) to provide additional context when examining attached metadata.
May contain organization-specific values: Yes
Category Entries:
Apple HealthKit
Withings
Fitbit
Google Fit
FHIR
Health Connect
Bluetooth Low Energy
29 PAT_REPORTED_STATUS_C_NAME VARCHAR No
Indicates if the data was directly entered by the patient or a patient proxy and whether the data has been validated by a clinician
May contain organization-specific values: Yes
Category Entries:
Not Patient Reported
Patient reported, not clinician validated
Patient reported, clinician validated
30 MYPT_ID VARCHAR No
The MyChart account from which the data was entered.
31 IS_FROM_SPEECH_YN VARCHAR No
Indicates whether a filed flowsheet value was entered using speech entry.
32 ABNORMAL_TYPE_C_NAME VARCHAR No
This column stores metadata for abnormal flowsheet values. It is only populated for data where ABNORMAL_C - Abnormal is set to 1-Yes. It is set to 1-Low for data that is below the minimum warning level and it is set to 2-High for data that is above the maximum warning level for flowsheet data of types: numeric, blood pressure, temperature, height, patient height, weight and patient weight. It is set to 0-Unspecified for data that is abnormal for other reasons. This is the only value that can be set for flowsheet data of type: custom list.
May contain organization-specific values: No
Category Entries:
Unspecified
Low
High
Patient-Entered Flowsheet Rule Abnormal
33 FLO_NETWORKED_INI VARCHAR No
The INI to which the value for this row is associated.
34 DOC_METHOD_C_NAME VARCHAR No
Indicates the method the user used to enter the line of flowsheet data.
May contain organization-specific values: No
Category Entries:
Value from Macro
Patient Reported
Proxy Reported
Value from Copy Forward
Value Moved from Another Time
Value from Wound Model
Value Moved to Another Time
Value from Proximity
Value from Mom/Baby Copy
35 MACRO_RECORD_ID NUMERIC No
When the documentation method in FSD-1360 is 1-Value From Macro this is the macro HGM record ID.
36 MACRO_RECORD_ID_RECORD_NAME VARCHAR No
The name of the Scripting Template.
37 DOCUMENTING_INPATIENT_DATA_ID VARCHAR No
Stores the INP ID of the encounter where the property documentation occurred. This item will not be populated for non-property rows, or for any property values documented prior to the existence of this item.
38 SPEECH_ENTERED_METHOD_C_NAME VARCHAR No
Indicates what speech-based entry method was used to enter this value. A value of 0 ("N") or (null) indicates that the value was entered using manual entry.
May contain organization-specific values: Yes
Category Entries:
No
Speech to Enter Flowsheets
Ambient Flowsheets