Technology

The system-generated unique identifier assigned to a medical imaging capture event, such as an X-ray, CT, or MRI scan. Used to link imaging data to patient records, radiology workflows, and diagnostic reporting across picture archiving and communication systems (PACS).

The highest level of healthcare interoperability in which exchanged data is not only syntactically structured consistently but also carries the same meaning at the receiving system, achieved through the use of shared clinical terminologies such as SNOMED CT, LOINC, and RxNorm that map local codes to standard concepts. Semantic interoperability is the prerequisite for cross-organizational population health analytics and clinical decision support that can reliably compare data from different EHR systems.

A business-oriented abstraction layer built on top of a physical data warehouse that defines metrics, dimensions, and business logic in a centralized, reusable way, enabling consistent metric definitions across all BI tools, dashboards, and data applications without duplicating SQL logic. In healthcare data platforms, a semantic layer defined in tools such as dbt Metrics, Looker, or Cube.js ensures that total cost of care, PMPM calculations, and HEDIS measure rates are calculated consistently regardless of which reporting tool a user accesses.

The system-generated unique identifier assigned to a recorded substance sensitivity or reactivity for a patient. Used to track adverse reactions to medications, foods, or environmental agents across clinical allergy management, prescribing safety, and medication reconciliation systems.

A sequentially assigned numeric identifier used to uniquely identify records within a healthcare data table or processing batch. Often used for claim line numbers, diagnosis sequence numbers, and procedure sequence numbers to indicate the order and hierarchy of related records.

The system-generated unique identifier assigned to a serum antibody or antigen test record. Used to track serological test orders, results, and interpretations across laboratory information systems, infectious disease monitoring, and immunology clinical workflows.

The system-generated unique identifier assigned to a discrete therapy or treatment occurrence, such as a physical therapy, dialysis, or behavioral health session. Used to track attendance, progress notes, and billing across care management and clinical documentation systems.

The system-generated unique identifier assigned to an observable clinical indicator documented during a patient encounter, such as edema or jaundice. Used to track clinical findings across encounter documentation, diagnostic coding, and clinical decision support systems.

The second layer in a medallion architecture containing cleaned, validated, deduplicated, and lightly transformed data derived from the bronze layer. In healthcare data platforms, the silver layer applies data quality rules such as ICD-10 code validation, NPI format checks, and referential integrity enforcement, producing standardized records that are suitable for joining and analysis but have not yet been aggregated into business-specific data marts.

The system-generated unique identifier assigned to a care delivery location, such as a clinic, hospital campus, or outpatient facility. Used to associate clinical and administrative records with a specific physical location across scheduling, billing, and network management systems.

The system-generated unique identifier assigned to an available appointment time block within a provider or facility schedule. Used to manage scheduling availability, booking status, and capacity across patient access systems, scheduling platforms, and referral management workflows.

A dimensional data modeling pattern that extends the star schema by normalizing dimension tables into multiple related tables, reducing storage redundancy at the cost of additional joins during query execution. In healthcare data warehouses, snowflake schema normalization is sometimes applied to large provider and facility dimensions where taxonomy and specialty hierarchies are maintained in separate tables, though most modern cloud warehouse implementations prefer star schemas for query simplicity and performance.

The originating application or system from which a record was extracted into a healthcare data warehouse. Used as a standard audit column in ETL pipelines to track data lineage and support troubleshooting. Common values include EHR system names, claims processing systems, pharmacy benefit managers, and enrollment platforms.

The system-generated unique identifier assigned to a physician or clinician recognized in a specific medical specialty. Used to route referrals, manage credentialing, and associate specialty care with claims and clinical encounters across provider directories and care coordination systems.

The system-generated unique identifier assigned to an established clinical or operational guideline, such as a care protocol or quality measure. Used to link clinical decisions, workflows, and outcomes to governing standards across quality management and compliance reporting systems.

The system-generated unique identifier assigned to a patient account or billing statement. Used to track itemized charges, payment activity, and balance information across revenue cycle management, patient billing, and financial reporting systems in healthcare organizations.

The system-generated unique identifier assigned to an inpatient hospitalization episode. Used to associate admissions, clinical events, discharge records, and claims data with a single care stay across hospital information systems, utilization management, and inpatient billing workflows.

The system-generated unique identifier assigned to a specific drug concentration value, such as 500mg or 10mg/mL. Used to distinguish medication formulations in pharmacy dispensing, formulary management, prescribing workflows, and drug database reference systems.

The system-generated unique identifier assigned to a diagnostic imaging examination order or completed radiology study. Used to coordinate image acquisition, radiologist interpretation, and result delivery across radiology information systems, PACS, and clinical order management platforms.

The system-generated unique identifier assigned to a pharmacy dispensing event where an alternative medication was substituted, such as a generic for a brand-name drug. Used to track substitution approvals, therapeutic equivalence, and dispensing compliance across pharmacy and claims systems.