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
39 | FSD_AI_FILE_METHOD_C_NAME | NUMERIC | No |
Indicates that the line of flowsheet data was filed by AI without user intervention. If this item is empty, the line of data was not filed independently by AI. If it has a value, the category reflects how AI was used to file the data.
May contain organization-specific values: No
Category Entries:
Asked and Recorded by AI