|
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 |
LINE_NUM |
INTEGER |
No |
|
|
|
| The line number of the reading that replaced this flowsheet reading. |
|
|
| 7 |
RECORDED_TIME |
DATETIME (Local) |
No |
|
|
|
| The instant the reading was taken. |
|
|
| 8 |
ENTRY_TIME |
DATETIME (Local) |
No |
|
|
|
| The instant the reading was entered. |
|
|
| 9 |
TAKEN_USER_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the user taking the flowsheet readings. |
|
|
| 10 |
TAKEN_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 11 |
ENTRY_USER_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the user entering the readings. |
|
|
| 12 |
ENTRY_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 13 |
EDIT_COMMENT |
VARCHAR |
No |
|
|
|
| The free text comments associated with the reading. |
|
|
| 14 |
EDITED_LINE |
INTEGER |
No |
|
|
|
| Determines if this flowsheet record has been edited. |
|
|
| 15 |
ACCEPTED_YN |
VARCHAR |
No |
|
|
|
| Determines if this flowsheet record has been accepted. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 16 |
IP_SIGNIFCNT_EDI_YN |
VARCHAR |
No |
|
|
|
| Stores edited information on whether the user marked the data value as being significant. |
| The category values for this column were already listed for column: ACCEPTED_YN |
|
|
| 17 |
EDITED_DEV_ID |
VARCHAR |
No |
|
|
|
| This item stores information of the Device ID for the device from which data is captured from when the data is edited. |
|
|
| 18 |
EDITED_DEV_ID_DEVICE_NAME |
VARCHAR |
No |
|
|
|
| The name for this device. |
|
|
| 19 |
EDITED_RECEIVE_INST |
DATETIME (Local) |
No |
|
|
|
| This item stores the Instant at which value was received at the interface when the data is edited. |
|
|
| 20 |
AUDIT_NEED_COSIG_YN |
VARCHAR |
No |
|
|
|
| Indicates whether a value needing a co-sign is stored for the audit record for the flowsheet data record. Yes indicates that a value needing a co-sign gets over-written with a value not needing a co-sign. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Required Yes |
| Chosen Yes |
| Required Yes Can File |
|
|
| 21 |
EDITED_FLT_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the flowsheet template (FLT) which was used to enter this data into the cell. |
|
|
| 22 |
EDITED_FLT_ID_DISPLAY_NAME |
VARCHAR |
No |
|
|
|
| The display name associated with this template. |
|
|
| 23 |
EDT_FLO_DAT_USED |
NUMERIC |
No |
|
|
|
| If the contact date (DAT) used to define data for a flowsheet group or row (see column FLO_DAT_USED) is changed, this column stores the prior value. |
|
|
| 24 |
EDITED_PENDED_ID |
VARCHAR |
No |
|
|
|
| History of the user ID of the user who pended a flowsheet value. |
|
|
| 25 |
EDITED_PENDED_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 26 |
EDITED_INSTANT_DTTM |
DATETIME (Local) |
No |
|
|
|
| History of date/time at which a flowsheet value was pended. |
|
|
| 27 |
AUDIT_ABNORMAL_C_NAME |
VARCHAR |
No |
|
|
|
| Stores whether or not the edited value is abnormal |
| May contain organization-specific values: No |
| Category Entries: |
| Yes |
|
|
| 28 |
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. |
|
|
| 29 |
EDITD_3P_SRC_C_NAME |
VARCHAR |
No |
|
|
|
| History of identification of 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 |
|
|
| 30 |
PAT_REPORTED_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
| Indicates if the edited 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 |
|
|
| 31 |
MYPT_ID |
VARCHAR |
No |
|
|
|
| The MyChart account from which the edited data was entered. |
|
|
| 32 |
EDIT_IS_FROM_SPEECH_YN |
VARCHAR |
No |
|
|
|
| Indicates whether an edited flowsheet value was entered using speech entry. |
|
|
| 33 |
EDITED_ABNORMAL_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| This column stores metadata for abnormal flowsheet values. Edited Abnormal Type is only populated for data where AUDIT_ABNORMAL_C 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 |
|
|
| 34 |
EDIT_FLO_NET_INI |
VARCHAR |
No |
|
|
|
| The INI to which the value for this row is associated. |
|
|
| 35 |
EDIT_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 |
|
|
| 36 |
EDITED_MACRO_RECORD_ID |
NUMERIC |
No |
|
|
|
| When the documentation method in FSD-2360 is 1-Value From Macro this is the macro HGM record ID. |
|
|
| 37 |
EDITED_MACRO_RECORD_ID_RECORD_NAME |
VARCHAR |
No |
|
|
|
| The name of the Scripting Template. |
|
|
| 38 |
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. |
|
|
| 39 |
EDIT_SPEECH_ENTERED_METHOD_C_NAME |
VARCHAR |
No |
|
|
|
| Indicates whether an edited flowsheet value was entered using speech entry. A value of 1 ("Y") indicates that the value was entered using speech entry. 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 |
|
|
