Claims

Hierarchy position assigned to a clinical or utilization management review within EHR, UM, and care management platforms. Indicates depth in a nested review structure, enabling data engineers to filter, aggregate, and route review records by organizational tier or complexity.

The professional state license number of the clinician or reviewer conducting a clinical or utilization review. Used to verify credentials, ensure reviews are performed by appropriately licensed practitioners, and meet regulatory requirements for utilization management and peer review documentation.

The marital status of the individual associated with a clinical or administrative review record, such as single, married, divorced, or widowed. Captured during intake or enrollment to support care coordination, benefits determination, and demographic reporting in health management systems.

The enterprise master identifier assigned to a clinical or administrative review record, enabling consistent cross-system linkage across EHR, claims, and care management platforms. Used to eliminate duplicate records and maintain a single source of truth for the review entity across the healthcare organization.

The upper threshold value established for a clinical or administrative review, such as a maximum allowable authorization count, benefit limit, dosage ceiling, or score cap. Used in utilization management and clinical decision support to enforce coverage rules and flag records that exceed defined thresholds.

The medical record number of the patient associated with a clinical review, linking the review record to the patient's longitudinal health history within the facility's EHR or health information system. Used to correlate clinical reviews with inpatient, outpatient, and ancillary service documentation.

The middle name or initial of the individual associated with a clinical or administrative review record. Used in conjunction with first and last name fields to support accurate patient or member identity matching, reducing misidentification risk during care coordination and claims adjudication workflows.

The lower threshold value established for a clinical or administrative review, such as a minimum authorization quantity, benefit floor, dosage baseline, or score floor. Used in utilization management and clinical decision support to enforce coverage policies and identify records that fall below required thresholds.

The mobile phone number associated with the individual linked to a clinical or administrative review record. Used to facilitate outreach, appointment reminders, care gap notifications, and follow-up communication as part of care management, utilization review, or member engagement workflows.

The username or system identifier of the user who last updated a clinical or administrative review record. Captured as part of the audit trail to support accountability, compliance, and change tracking requirements in care management, utilization review, and quality reporting systems.

Timestamp recording the most recent update to a clinical evaluation or utilization review record in EHR, UM, or care management systems. Critical for incremental ETL pipelines, audit trails, and change data capture processes to ensure data currency and integrity.

The timestamp recording when a clinical or administrative review record was last updated. Used in audit logging, data synchronization, and change management workflows to track record history, support compliance requirements, and identify the most current version of a review across healthcare systems.

Descriptive display label assigned to a clinical evaluation or utilization management review in EHR, UM, and care management platforms. Used by data engineers for lookup table joins, UI rendering, and report labeling to identify review types across integrated healthcare data systems.

Free-text annotation captured during a clinical evaluation or utilization review in EHR, UM, and care management systems. Contains clinician or reviewer commentary requiring NLP processing, PHI masking, and unstructured data handling pipelines in downstream healthcare data workflows.

Unique numeric reference identifier assigned to a clinical evaluation or utilization management review in EHR, claims, and UM systems. Serves as the primary join key across review-related tables, enabling data engineers to link review records to authorizations, claims, and member encounters.

The date on which symptoms, conditions, or events relevant to a clinical review first appeared or were reported by the patient. Used in utilization management, care coordination, and clinical documentation to establish the timeline of illness or injury and support medical necessity determinations and authorization decisions.

The peripheral blood oxygen saturation percentage recorded as part of a clinical review or assessment, typically measured via pulse oximetry. Used to document respiratory status, monitor patient acuity, support inpatient utilization review decisions, and track clinical outcomes in care management programs.

The actual dollar amount disbursed as payment for services associated with a clinical or administrative review, such as an authorized procedure or care episode. Used in financial reconciliation, claims auditing, and utilization management reporting to confirm that payment aligns with authorized and adjudicated service values.

The date on which payment was issued for services associated with a clinical or administrative review. Used in claims reconciliation, financial reporting, and accounts payable workflows to confirm payment completion and support audit trails linking authorization approvals to corresponding remittance activity.

Identifier referencing the superior or originating review record in a hierarchical review structure within EHR, UM, and care management systems. Enables data engineers to reconstruct parent-child review trees, support recursive queries, and model nested authorization or appeal workflows.