Operations

The calendar date on which a specialist referral authorization becomes valid for use. Used in EHR, managed care, and claims systems to enforce referral validity windows during adjudication, ensuring services rendered outside the effective period are flagged for review or denial by data engineers.

The unique patient identifier assigned by a healthcare facility and associated with a specialist or ancillary referral. Used to link the referral record to the patient's clinical history across sending and receiving providers, ensuring continuity of care documentation and accurate patient matching during referral tracking.

The calendar date on which a referred specialist or ancillary service appointment is planned to occur. Used in care coordination and utilization management systems to monitor referral completion timelines, track appointment adherence, and ensure members receive referred services within clinically appropriate and plan-required timeframes.

The specific time of day at which a referred specialist or ancillary appointment is planned. Used alongside the referral scheduled date in care coordination systems to confirm appointment details, send member reminders, and track whether referred services are completed within required clinical and regulatory timeframes.

A code indicating the current state of a patient referral from a primary care or referring provider to a specialist or facility, such as initiated, sent, acknowledged, appointment scheduled, completed, or expired. Referral status tracking is critical for measuring referral leakage, care coordination effectiveness, and compliance with managed care authorization requirements.

The physical street address of the receiving specialist, facility, or ancillary service location associated with a referral. Used in care coordination and member communication workflows to provide patients with accurate directions, support network validation, and confirm that the referred provider's location falls within the member's service area.

The unit of measure quantifying an authorized service within a referral, such as number of visits, hours, or procedures. Used in EHR, managed care, and claims platforms to track consumed versus authorized units, supporting utilization management and referral authorization reconciliation in data pipelines.

The calendar date on which a pharmacy prescription refill is planned to be dispensed or picked up. Used in pharmacy management systems to coordinate medication supply continuity, track adherence windows, and prevent gaps in chronic disease therapy for patients on maintenance medications.

The specific time of day at which a pharmacy prescription refill is planned to be dispensed or made available for patient pickup. Used alongside the refill scheduled date in pharmacy workflow systems to manage dispensing queues, staffing, and automated refill program coordination.

The unit of measure associated with a prescription renewal dispensing event, such as tablets, capsules, or milliliters. Used in PBM, pharmacy, and claims systems to validate dispensed quantity against authorized refill allowances, supporting drug utilization review and member adherence analytics for data engineers.

The number of records that failed to load into a target system during a data pipeline execution due to data quality violations such as null values in required fields, duplicate key violations, referential integrity failures, or type conversion errors. Rejected record counts and rejection reason analysis are essential for data pipeline monitoring and data quality management in healthcare data warehouses.

Physical or mailing address associated with the recipient or originating facility of a structured clinical report, such as a lab result or radiology summary. Used in EHR and health information exchange systems to route documents correctly and validate provider or patient demographics during data integration workflows.

The date on which a structured clinical report, such as a lab result, radiology finding, or quality measure summary, becomes active or authoritative. Used in EHR and analytics systems to establish temporal validity for SCD processing, trend analysis, and compliance reporting by healthcare data engineers.

The calendar date on which a clinical, administrative, or operational report is planned to be generated or delivered. Used in healthcare reporting systems to manage report distribution cycles, regulatory submission timelines, and recurring quality or utilization review outputs.

The specific time of day at which a clinical, administrative, or operational report is planned to be generated or distributed. Used in healthcare reporting systems to coordinate automated report runs, data extract jobs, and delivery to downstream consumers or regulatory bodies.

The physical street address associated with the entity or location to which a clinical or administrative report is directed or attributed. Used in report distribution and mailing workflows to ensure accurate delivery of documents to facilities, departments, or external recipients such as payers or regulators.

The unit of measure applied to values within a structured clinical report, such as mg/dL for lab results or mmHg for vitals. Used in EHR, lab information systems, and clinical analytics platforms to standardize dimensional metadata, enabling accurate cross-system comparisons and data normalization in ETL pipelines.

The physical or mailing address associated with a specific regulatory, contractual, or clinical requirement record. Used in compliance and enrollment systems to identify the location of the responsible party, plan, or entity accountable for fulfilling the requirement within member or plan administration workflows.

The age value associated with a specific regulatory, clinical, or eligibility requirement, typically representing a minimum or maximum age threshold that must be met. Used in member eligibility, benefit plan administration, and prior authorization systems to evaluate age-based qualification criteria for services or coverage.

The maximum dollar amount permitted for reimbursement under a specific contractual or regulatory requirement. Used in claims adjudication and benefit plan administration to enforce payment limits tied to coverage conditions, prior authorization criteria, or payer-specific reimbursement policies.