# NLM AccessGUDID — Device Identity (FDA Global UDI Database)

`drug_silver.dim_device_udi` · Provider identity · status live · 5,129,241 rows

The FDA Global UDI Database (via NLM AccessGUDID) — every marketed medical device by its Device Identifier (PrimaryDI): brand, version/model, catalog number, company (DUNS), description, commercial-distribution status, and flags (single-use, sterile, MRI safety, Rx/OTC, kit, combination product). Resolves the UDI/DI on an itemized bill or implant log to canonical device identity — de-anonymizes high-cost implant/device line items driving chargemaster markups. ~5.1M devices, partition by release_month.

**Grain.** One row per device (release_month, PrimaryDI) — brand/model/company + flags.

| column | type | meaning |
|---|---|---|
| release_month | string |  |
| primary_di | string |  |
| public_device_record_key | string |  |
| version_status | string |  |
| record_status | string |  |
| public_version_date | string |  |
| commercial_distribution_status | string |  |
| commercial_distribution_end_date | string |  |
| brand_name | string |  |
| version_model_number | string |  |
| catalog_number | string |  |
| duns_number | string |  |
| company_name | string |  |
| device_description | string |  |
| dm_exempt | string |  |
| device_hctp | string |  |
| device_kit | string |  |
| device_combination_product | string |  |
| single_use | string |  |
| lot_batch | string |  |
| serial_number | string |  |
| mri_safety_status | string |  |
| rx | string |  |
| otc | string |  |
| device_sterile | string |  |
| device_count | double |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM drug_silver.dim_device_udi WHERE ... LIMIT 100`; read `describe_data_source("drug_silver.dim_device_udi")` first.