FLOWSHEET_META_VAL

Description:

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_META_LOOSE, and key category values, for keys that have been assigned category values, are held on FLOWSHEET_META_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	THRDPRTY_META_VAL	VARCHAR	No
	Within a line, each position represents a value in a dictionary of third-party metadata attached to the Flowsheets value with the corresponding line number. The same line/position in Third Party Metadata Key (FSD-1320) corresponds to the key name and (if the particular key is recognized by Epic) in Sensitive Encounter Programming point (FSD-1310) corresponds to the category-value representation of the key.