FLOWSHEET_METAEDIT_VAL

Description:

Historical third-party metadata (e.g. from Apple's HealthKit) is split across three tables. This table holds values from each key-value pair. The key names are held on table FLOWSHEET_METAEDIT_LOOSE, and key category values, for keys that have been assigned category values, are held on FLOWSHEET_METAEDIT_STRICT. Reporting on this metadata can be more easily accomplished by joining these tables on primary key (FSD_ID, GROUP_LINE, VALUE_LINE).

Primary Key

Column Name	Ordinal Position
FSD_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	FSD_ID	VARCHAR	No
	The unique identifier for the Flowsheets data record.
2	GROUP_LINE	INTEGER	No
	The line number for the information associated with this record.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple values associated with a specific group of data within this record.
4	EDITD_3P_META_VAL	VARCHAR	No
	Within a line, each position represents a value in a dictionary of third-party metadata attached to the historical Flowsheets value with the corresponding line number. The same line/position for the edited third party metadata key (I FSD 2320) corresponds to the key name and (if the particular key is recognized by Epic) on the edited third party metadata value (I FSD 2310) corresponds to the category-value representation of the key.