material medical record number
matl_mrnDefinition
ISO-11179 Definition
A reference to the patient medical record number associated with the use or dispensing of a specific medical supply or material item. Links supply chain and inventory transactions to individual patient encounters, supporting charge capture, clinical documentation, and utilization tracking in healthcare data systems.
Standard Abbreviation
matl_mrn
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
Related Definitions
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms