stg_gcs__mdt_devices

staging view

Devices under test, typed.

Definition

One row per device under test; nickname is the join key across tests + pricing.

15 of 15

Column

Description

Tests · PII

device_id

UUID5 primary key.

3 tests

opportunity_id

FK to stg_gcs__mdt_opportunities.

name

Full device name as stated by the client.

nickname

Short mnemonic; the FK across test/pricing (e.g. PFS-NSD, OBI, AI).

1 test

device_type

Device type (autoinjector, PFS, cartridge, inhaler, …).

manufacturer

Device manufacturer / brand owner.

active_ingredient

Active pharmaceutical ingredient / molecule.

strength_or_variant

Strength and variant detail.

variant_count

Number of variants under test.

msds_provided

Whether an MSDS was supplied (0/1).

drawings_provided

Whether technical drawings were supplied (0/1).

confidence

Provenance of the device record.

1 test

source_file_url

Airbyte _ab_source_file_url.

source_file_modified_at

Airbyte source object mtime.

airbyte_extracted_at

When Airbyte extracted this row.