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
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.
The category values for this column were already listed for column: ACCEPTED_YN
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_FLO_CAT_INI VARCHAR No
The INI of an edited category flowsheet value
36 EDIT_FLO_CAT_ITEM VARCHAR No
The item number of a category flowsheet value
37 EDIT_FLO_CAT_VALUE VARCHAR No
The category value of an edited flowsheet row
38 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
39 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.
40 EDITED_MACRO_RECORD_ID_RECORD_NAME VARCHAR No
The name of the Scripting Template.