FLOWSHEET_META_STRICT

Description: |
Third-party metadata (e.g. from Apple's HealthKit) is split across three tables. This table holds category values used to represent keys from each key-value pair. The corresponding key names are held on table FLOWSHEET_META_LOOSE, and the values are held on FLOWSHEET_META_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 | THRDPRTY_META_KEY_C_NAME | VARCHAR | No |
Within a line, each non-null position represents a key in a dictionary of third-party metadata attached to the Flowsheets value with the corresponding line number. Keys are represented with category values, allowing them to be more easily programmed against and indexed. If a key does not have a representative category value, it is left null in this item.
May contain organization-specific values: Yes
Category Entries:
UUID
Blood Glucose Meal Time
Insulin Delivery Reason
App Orchard Client ID
VO2 Max Test Type
Manually Entered
Source Device UUID
Source Device Name
HOD Pre-Charting Data Move
Blood Pressure Percentile