Technology

The date on which a record was loaded into a healthcare data warehouse or data lake by an ETL process. Distinct from the transaction date or service date — load date reflects when data arrived in the warehouse, not when the healthcare event occurred. Used for incremental load tracking and data freshness monitoring.

The precise date and time at which a record was loaded into a healthcare data warehouse including hours, minutes, and seconds. More granular than load date — used when multiple ETL batches run within the same day. Standard audit column in Data Vault and lakehouse architectures for healthcare data.

Unique surrogate key assigned by the source system to a mammography screening or diagnostic imaging record. Enables tracking of breast imaging studies across radiology, claims, and preventive care quality measurement systems including HEDIS breast cancer screening measures.

A boolean indicator identifying records that were manually entered or modified by a user rather than generated automatically by a healthcare data system. Used to distinguish system-generated transactions from manual adjustments in claims processing, enrollment, and provider data management.

Unique surrogate key assigned by the source system to a quantified performance or clinical metric record. Supports tracking of calculated measurements used in quality reporting, contract performance evaluation, provider scorecards, and population health management analytics.

Unique surrogate key assigned by the source system to a morbidity measurement record. Used in population health, actuarial, and clinical analytics systems to track disease burden, condition prevalence, and comorbidity data that inform risk stratification and care management programs.

Unique surrogate key assigned by the source system to a mortality measurement record. Used in population health surveillance, quality reporting, and actuarial systems to track death rate data across member populations, conditions, and care settings for outcomes analysis.

Unique surrogate key assigned by the source system to a magnetic resonance imaging study record. Used in radiology information systems, prior authorization workflows, and medical claims processing to track MRI procedures across diagnostic imaging episodes and utilization management reviews.

A unique identifier that exists in the source business system and has inherent business meaning, such as a member ID, NPI number, or claim number. Used alongside surrogate keys in healthcare data warehouses to maintain traceability back to source systems. Also called a business key or source key.

Unique surrogate key assigned by the source system to a nephrology specialty care record. Enables tracking of kidney disease-related encounters, referrals, and treatment episodes across care management, claims, and chronic kidney disease quality measurement programs.

Unique surrogate key assigned by the source system to a neurology specialty care record. Supports tracking of nervous system disorder-related encounters, referrals, and treatment episodes across medical claims, care management, and specialty utilization reporting systems.

Unique surrogate key assigned by the source system to a clinical documentation note record. Used in electronic health records and care management platforms to track individual documentation entries such as progress notes, discharge summaries, and care plan narratives across patient encounters.

Unique surrogate key assigned by the source system to a licensed nursing professional record. Used in clinical staffing, care coordination, and provider credentialing systems to uniquely identify RNs, LPNs, and advanced practice nurses involved in patient care delivery and documentation.

Unique surrogate key assigned by the source system to an obstetric care record. Enables tracking of pregnancy-related encounters, prenatal visits, and delivery episodes across medical claims, care management, and maternal health quality measurement programs including prenatal care HEDIS measures.

Unique surrogate key assigned by the source system to a surgical operation record. Used in surgical scheduling, facility claims, and operative documentation systems to track individual surgical procedures across inpatient, outpatient, and ambulatory surgical center care settings.

Unique surrogate key assigned by the source system to an ophthalmology specialty care record. Supports tracking of eye care encounters, procedures, and referrals across medical claims, diabetic eye exam quality measures, and specialty utilization management systems.

Unique surrogate key assigned by the source system to a clinical order record. Used in order entry, lab, pharmacy, and radiology systems to track clinician-initiated service requests including medication orders, diagnostic tests, and referrals across the care delivery workflow.

Unique system-generated key assigned to an orthopedic specialty record, such as a musculoskeletal encounter, surgical case, or joint procedure. Used to link orthopedic clinical data across EHR, imaging, surgical scheduling, and clinical data warehouse systems for continuity of care tracking.

Unique system-generated key assigned to an otolaryngology specialty record covering ear, nose, and throat conditions or procedures. Enables consistent cross-system linkage of ENT encounters, audiological data, and surgical records across clinical and administrative healthcare platforms.

A boolean indicator showing that a standard business rule or system default was manually overridden for a specific record in a healthcare data system. Used in claims adjudication, prior authorization, and formulary management to track exceptions and manual interventions for audit compliance.