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
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.
The category values for this column were already listed for column: ISACCEPTED_YN
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 FLO_CATEGORY_INI VARCHAR No
The INI of a category flowsheet value
35 FLO_CATEGORY_ITEM VARCHAR No
The item number of a category flowsheet value
36 FLO_CATEGORY_VALUE VARCHAR No
The category value of a flowsheet row
37 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
38 MACRO_RECORD_ID NUMERIC No
When the documentation method in FSD-1360 is 1-Value From Macro this is the macro HGM record ID.
39 MACRO_RECORD_ID_RECORD_NAME VARCHAR No
The name of the Scripting Template.