Barcode

A machine-readable optical label encoded with product, medication, or patient identifiers used across EHR, pharmacy dispensing, and supply chain systems to automate data capture and reduce manual entry errors. Data engineers rely on barcode scan transaction logs for medication administration reconciliation, inventory tracking, and bedside verification audit trails.

• PBM claims adjudication and drug utilization review
• Controlled substance monitoring and DEA compliance
• Pharmacy data warehouse and ETL pipeline design
• Prior authorization and step therapy workflows
• Medicare Part D reporting and CMS submissions

ISO-11179 snake_case standard

-- Recommended column name
barcd

-- Example DDL
CREATE TABLE healthcare_data (
  record_id   VARCHAR(50)   NOT NULL,
  barcd        VARCHAR(100),  -- Barcode (max 100 chars)
  created_dt  TIMESTAMP     NOT NULL DEFAULT NOW()
);

Column names follow the ISO-11179 naming convention: lowercase, underscore-separated, using the standard abbreviation as a prefix where applicable.