Clinical

Stores the formal clinical name or descriptive label assigned to an active health condition on the patient problem list. This human-readable designation accompanies coded diagnosis values and is displayed in clinical workflows, care summaries, and patient-facing documentation to communicate the condition clearly across care settings.

Aggregate numeric sum of all active health condition entries recorded in EHR or clinical data systems for a patient encounter or longitudinal record. Used by data engineers to calculate cumulative problem burden scores, population health metrics, and chronic condition load across care episodes.

Represents the cumulative number of occurrences or encounters associated with an active health condition on the patient problem list. Used in clinical analytics and population health reporting to measure diagnosis frequency, recurrence patterns, and condition burden across patient cohorts over defined time periods.

Categorical classification assigned to an active patient health condition in EHR and clinical data systems, distinguishing between chronic, acute, episodic, or behavioral diagnoses. Supports downstream filtering, cohort segmentation, and clinical analytics pipelines using ICD-coded problem list data.

Records the most recent date on which an active health condition on the patient problem list was modified, including changes to status, description, coding, or associated clinical details. Used in EHR audit trails and data governance workflows to track problem list maintenance and ensure documentation currency.

Indicates the clinical urgency or priority level assigned to an active health condition on the patient problem list, such as routine, urgent, or emergent. Used in care management workflows to triage patient needs, prioritize clinical interventions, and support escalation protocols within EHR and care coordination systems.

Tracks the sequential version number of an active health condition record on the patient problem list, incrementing with each update or modification. Used in EHR audit and data governance processes to maintain historical accuracy, support record change tracking, and enable rollback or comparison of prior problem list states.

Stores the postal ZIP code associated with an active health condition record on the patient problem list, typically referencing the patient or facility location at the time of diagnosis. Used in population health analytics to assess geographic distribution of conditions and support social determinants of health reporting.

Stores the unique account identifier linking a clinical procedure to a specific patient billing or encounter account within healthcare financial and administrative systems. Used in revenue cycle management to associate procedure records with claim submissions, remittance tracking, and patient account reconciliation across EHR and billing platforms.

A binary flag indicating whether a clinical procedure record is currently active within the healthcare system. Used in EHR and data warehouse environments to filter valid procedure entries from inactive, cancelled, or historically deprecated records during clinical reporting, billing reconciliation, and quality measure calculations.

Indicates the current operational state of a clinical procedure record, such as active, inactive, cancelled, or pending, within EHR and administrative systems. Used to control procedure visibility in clinical workflows, ensure accurate billing submissions, and support data governance by distinguishing current from historical procedure documentation.

Physical location or facility address where a medical treatment or intervention was performed, recorded in claims, EHR, and provider data systems. Used in healthcare analytics and network management platforms to associate procedures with rendering locations, supporting geographic analysis, credentialing, and claims adjudication workflows.

Captures the dollar value of financial adjustments applied to a clinical procedure charge, including contractual write-offs, payer discounts, or billing corrections during claims processing. Used in revenue cycle management to reconcile billed charges against allowed amounts and net reimbursements within healthcare financial reporting systems.

Date a patient was formally admitted to a hospital or facility in association with a specific medical procedure, recorded in claims and EHR systems. Used in inpatient claims processing, DRG grouping, and length-of-stay calculations within revenue cycle management and utilization review platforms to ensure accurate billing and reporting.

The patient's age at the time a medical procedure was performed, calculated in years. Used in clinical analytics to identify age-specific procedure patterns, support age-based eligibility rules, and enable population health stratification across care settings.

The maximum dollar amount a payer will reimburse for a specific procedure based on the contracted fee schedule or benefit plan terms. Used in claims adjudication to calculate member cost-sharing obligations and determine provider payment after billed charges are evaluated.

Monetary value representing the billed, allowed, or paid amount associated with a specific medical procedure in claims, EHR, or provider billing systems. Used in revenue cycle management, remittance processing, and healthcare financial analytics to support adjudication, cost reporting, and downstream actuarial and contract performance analyses.

The current authorization or approval state of a scheduled or completed procedure, such as pending, approved, or denied. Used in prior authorization workflows to track whether clinical review has been completed and payer or utilization management approval has been granted.

The identifier or name of the clinician, administrator, or utilization management reviewer who granted authorization for the procedure. Used in audit trails and prior authorization records to establish accountability and support compliance with clinical governance requirements.

The recorded timestamp indicating when a patient arrived for a scheduled or urgent procedure encounter. Used in clinical operations and throughput analytics to measure patient flow efficiency, calculate wait times, and assess scheduling adherence across care settings.