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