maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
One row per device (grain device_id): device name/type/manufacturer/ active ingredient/variant count, plus test_count, replicate_total, and the distinct standards cited across its tests, joined to the parent opportunity's entity / study_type / region.
Watch out for
- mediumTreating replicate_total as sample count
replicate_total sums replicates_per_variant across the device's tests; it is not the total number of physical samples (which also depends on variant count and destructive/non-destructive reuse).
Questions this answers
- “Which autoinjector devices have the most tests?”
- “What standards apply to a given device?”
15 of 15
Column
Type
Description
Tests · PII
device_id
String
Primary key — grain of this mart.
2 tests
entity
String
Issuing Smithers legal entity (from the opportunity).
study_type
String
Study type (from the opportunity).
client_region
String
Client region (from the opportunity).
device_nickname
Nullable(String)
Short device mnemonic (PFS-NSD, OBI, AI …).
device_name
Nullable(String)
Full device name.
device_type
String
Device type.
manufacturer
Nullable(String)
Device manufacturer.
active_ingredient
Nullable(String)
Active pharmaceutical ingredient.
variant_count
Nullable(UInt16)
Number of variants under test.
test_count
UInt64
Number of test methods for this device.
replicate_total
UInt64
Sum of replicates_per_variant across the device's tests.
standards
String
Flattened distinct list of standard references cited across the device's tests.
confidence
Nullable(String)
Provenance of the device record.