device license number
dev_lic_nbrDefinition
ISO-11179 Definition
Captures the regulatory license or authorization number issued by a governing body such as the FDA or Health Canada for a specific medical device. Used in device registry and compliance systems to verify that deployed devices hold valid market authorization and to support recall or adverse event reporting workflows.
Standard Abbreviation
dev_lic_nbr
Category
Production DDL — FACT_SUPPLY_ORDER
CREATE OR REPLACE TABLE FACT_SUPPLY_ORDER (
sply_ord_key INTEGER NOT NULL -- surrogate key,
sply_ord_id VARCHAR(50) NOT NULL -- supply order ID,
mbr_key INTEGER NOT NULL -- FK to DIM_MEMBER,
prvdr_key INTEGER NOT NULL -- FK to DIM_PROVIDER,
item_cd VARCHAR(20) -- item code,
item_nm VARCHAR(255) -- item name,
hcpcs_cd VARCHAR(10) -- HCPCS code,
qty_ord DECIMAL(10,2) -- quantity ordered,
qty_dspnd DECIMAL(10,2) -- quantity dispensed,
unit_cst_amt DECIMAL(10,2) -- unit cost amount,
tot_cst_amt DECIMAL(10,2) -- total cost amount,
ord_dt DATE -- order date,
dspnd_dt DATE -- dispensed date,
prior_auth_nbr VARCHAR(30) -- prior authorization number,
load_dt TIMESTAMP_NTZ NOT NULL -- load timestamp
);
Standard Snowflake DDL for the canonical supply table. Convert to BigQuery or Databricks →
Why This Term Matters
Healthcare data terminology is foundational for any data engineer working in this industry. Precise understanding of standard terms enables accurate schema design, reduces downstream data quality issues, and ensures pipelines meet the regulatory and interoperability requirements imposed by HIPAA, HL7 FHIR, and CMS reporting frameworks. Without this foundation, even technically well-built pipelines produce data that fails validation when it reaches payers or regulators.
Related Content
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms