IP_FLWSHT_EDITED

Description: |
This table contains the previous values from edited flowsheet records.

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