Clinical

Minimum and maximum value boundaries defined for a radiology measurement or result parameter in RIS, PACS, and clinical decision support systems. Used by data engineers to validate imaging result values, flag outliers, and enforce data quality rules in analytics pipelines.

Unit price or reimbursement rate assigned to a radiology procedure in claims, fee schedule, or contract management systems. Used by data engineers to calculate expected payments, perform pricing audits, and reconcile billed amounts against contracted rates in healthcare financial data workflows.

Explanatory text or coded value indicating the clinical justification for ordering a radiology service, such as ICD-10 diagnosis codes or clinical indications in RIS and EHR systems. Used by data engineers to support medical necessity validation and prior authorization analytics.

External pointer or cross-system identifier linking a radiology service record to related entities such as orders, encounters, or prior studies in RIS, EHR, and PACS systems. Used by data engineers to establish foreign key relationships and trace imaging data lineage across integrated platforms.

Outcome measurement or finding associated with a completed radiology service, including structured measurements, impression text, or LOINC-coded observations in PACS and RIS systems. Used by data engineers to populate clinical data warehouses and support quality measure calculation pipelines.

Calculated numeric rating derived from radiology findings, such as a BI-RADS, Lung-RADS, or ASPECTS score in RIS and clinical analytics systems. Used by data engineers to extract structured severity indicators from imaging reports and integrate them into risk stratification and outcomes models.

Ordering number assigned to a radiology procedure or image series within a study, protocol, or workflow in RIS and PACS systems. Used by data engineers to maintain correct processing order during ETL operations, reconstruct imaging session timelines, and sort multi-series study records.

Classification of condition seriousness associated with a radiology finding or imaging result in RIS, EHR, and clinical decision support systems. Used by data engineers to categorize imaging outcomes into risk tiers, support alert generation logic, and enable severity-based cohort analysis in analytics platforms.

Identifies the originating system, facility, or modality that generated a medical imaging service record. In EHR and RIS systems, rad_src distinguishes between PACS feeds, external imaging centers, teleradiology vendors, and in-house equipment, enabling data engineers to reconcile imaging data across integrated sources.

The date on which a medical imaging service was initiated, captured in RIS, PACS, and EHR systems as rad_start_dt. Critical for calculating imaging turnaround times, validating claims timelines in payer systems, and ensuring date sequencing integrity in radiology encounter data pipelines.

Represents the current workflow state of a medical imaging service, such as ordered, in-progress, completed, or cancelled. In RIS and EHR systems, rad_sts drives downstream processing logic, report release workflows, and is used by data engineers to filter active versus finalized imaging records in analytics pipelines.

Identifies the destination system, facility, or provider to which a medical imaging study or result is routed. In RIS and EHR integration pipelines, rad_tgt is used by data engineers to map imaging result delivery to ordering providers, referring facilities, or downstream PACS and reporting systems.

The time of day at which a medical imaging service was performed or recorded, stored separately from the date in some RIS and EHR systems as rad_tm. Data engineers use this field to reconstruct full imaging timestamps, calculate procedure durations, and support shift-level operational analytics in radiology departments.

A combined date and time value marking a specific event in the lifecycle of a medical imaging service, such as order creation, image acquisition, or report finalization. Stored as rad_ts in RIS and EHR systems, this field is essential for audit trails, SLA monitoring, and time-series analysis in radiology data pipelines.

Represents the aggregate count or summed monetary value associated with a medical imaging service, such as total images acquired, total charges, or total RVUs. In claims and RIS systems, rad_tot supports financial reconciliation, utilization reporting, and cost analysis across imaging service lines for data engineering workflows.

Classifies a medical imaging service into a defined category such as MRI, CT, X-ray, ultrasound, PET, or fluoroscopy. Captured as rad_typ in RIS, EHR, and claims systems, this field drives modality-specific processing logic, CPT code validation, reimbursement routing, and utilization stratification in healthcare data pipelines.

Risk Adjustment Factor score — a numeric value calculated by CMS representing a Medicare Advantage member's predicted healthcare costs relative to the average Medicare beneficiary. A RAF score of 1.0 represents average predicted cost. Scores above 1.0 indicate higher than average predicted costs. CMS multiplies the health plan base payment rate by the member RAF score to determine monthly capitation payments. RAF scores are calculated from two components: demographic factors including age, gender, and enrollment status, plus diagnosis components from HCC categories mapped from submitted ICD-10 codes. Higher RAF scores generate higher monthly payments to Medicare Advantage health plans to account for higher expected member utilization. The CMS-HCC V28 model is the current standard for payment year 2026. Healthcare data engineers store RAF scores as DECIMAL(10,3) values in member risk score tables, used in risk adjustment pipelines processing CMS RAPS and EDPS submissions.

Boolean flag indicating whether a defined reference range for a laboratory or clinical measurement is currently active and applicable for use in result interpretation. Inactive ranges are retained for historical comparison but excluded from current result flagging logic in laboratory information systems.

Status value describing the current operational state of a clinical reference range, such as active, inactive, or pending. Used in laboratory information systems to control which normal value boundaries are applied during result interpretation and abnormal flag generation for patient test results.

This field appears to be a data model artifact where address attributes were incorrectly associated with a reference range entity. Reference ranges in laboratory and clinical systems define normal value boundaries for test results and do not carry address attributes. Review data model for mapping errors.