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