FLOWSHEET_METAEDIT_LOOSE
Description:
Historical third-party metadata (e.g. from Apple's HealthKit) is split across three tables. This table holds key names from each key-value pair. The key category values, for keys that have been assigned category values, are held on table FLOWSHEET_METAEDIT_STRICT, and the values are held on FLOWSHEET_METAEDIT_VAL. 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_KEY VARCHAR No
Within a line, each position represents a key in a dictionary of third-party metadata attached to the historical Flowsheets value with the corresponding line number. This item stores the key's full name as a string, and is not intended to be programmed against nor indexed.