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
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