Claims

A code indicating whether a submitted claim is an original, replacement, or void of a previously submitted claim. Defined under HIPAA transaction standards, this value guides payer adjudication logic to determine how the current claim should be processed relative to prior submissions for the same episode of care.

The complete name of the patient or insured individual, combining given, middle, and family name components as recorded on a submitted insurance claim. Used for identity verification, member matching, and accurate attribution of claims to the correct beneficiary during payer adjudication workflows.

The biological sex or gender identity of the patient as recorded on a submitted insurance claim. Used to validate procedure and diagnosis code combinations during adjudication, support health equity analytics, and meet regulatory reporting requirements for demographic data collection across payer systems.

The blood glucose measurement documented in conjunction with a submitted insurance claim, typically captured for diabetic patients or during inpatient stays. Supports medical necessity validation, clinical documentation integrity, and quality measure reporting tied to chronic disease management billing codes.

The insurance group plan identifier associated with the patient's coverage at the time a claim is submitted. Links the claim to a specific employer-sponsored or group benefit plan, enabling payers to apply the correct benefit structure, coordination of benefits rules, and contractual reimbursement rates during adjudication.

The hemoglobin measurement documented in association with a submitted insurance claim, commonly captured for anemia management, chronic kidney disease, or inpatient care billing. Supports medical necessity validation, clinical documentation requirements, and quality measure reporting linked to applicable diagnosis and procedure codes.

A structured narrative describing the onset, duration, and progression of the patient's current condition as documented on a submitted insurance claim. Captured from clinical notes, this element supports medical necessity determination, coding accuracy validation, and audit defense during payer review and adjudication.

The claim identifier (clm_id) is the unique primary key assigned to each healthcare claim submitted by a provider or facility for reimbursement of services rendered to a patient. In the HIPAA 837 EDI transaction standard, the claim identifier appears in the CLM01 element of the CLM (Claim Information) segment and must be unique within the context of a trading partner relationship — it is the provider's own internal reference number for the claim, not a number assigned by the payer. When the payer adjudicates the claim and returns a remittance (835 transaction), the same claim ID appears in the CLP01 element of the Claim Payment/Adjustment (CLP) segment, enabling reconciliation between the original claim and the payment response. Different systems may call this field claim number, claim reference number, document control number (DCN), or internal control number (ICN). The claim identifier is the foundational join key in any claims data model, linking the claim header to claim lines, diagnosis codes, remittance records, and authorization data. Poor claim ID management is one of the most common sources of claims data quality failures: duplicate claim IDs from different source systems appearing in the same data warehouse, claim IDs that change when a claim is reprocessed or corrected, and claim IDs that are not globally unique when combining claims from multiple payers or clearinghouses into a single analytical platform. These problems cause double-counting of paid amounts, incorrect denial rate calculations, and failed revenue cycle reconciliations. Healthcare data engineers store clm_id as VARCHAR(50) to accommodate the full range of claim identifier formats used across payer and provider systems — some are short numeric sequences, others are long alphanumeric strings with date and system prefix components. When combining claims from multiple sources, a composite surrogate key is often necessary: concatenating the source system identifier with the original claim ID creates a globally unique key that prevents collision. Critical data quality checks include deduplication on (clm_id, svc_from_dt, billed_amt, billing_npi) before loading into the warehouse, validation that clm_id is never null, and a referential integrity check that every claim line record links to an existing claim header. Claim IDs must be preserved through reversals and reprocessing cycles to maintain a complete audit trail of the claim lifecycle from submission through final payment.

Numeric or alphanumeric positional identifier assigned to a claim record within EHR, claims adjudication, and payer systems. Used by data engineers to uniquely sort, partition, and retrieve claim records in high-volume batch processing pipelines and data warehouse fact tables.

A binary yes or no flag associated with a healthcare claim indicating the presence or absence of a specific claim characteristic or condition. Used in claims data warehouses to capture boolean claim attributes such as coordination of benefits indicator, crossover claim indicator, or late filing indicator.

Structured or free-text guidance associated with a claim record in payer adjudication and clearinghouse systems, directing processing logic such as coordination of benefits or billing overrides. Critical for data engineers parsing EDI 837 transactions and claims workflow automation tables.

A system-generated or assigned primary key value that uniquely identifies a claim record within a healthcare data warehouse or claims processing system. Used to link related claim transactions, adjudication events, and payment records across tables for reporting, reconciliation, and downstream analytics workflows.

A human-readable descriptor or tag assigned to an insurance claim record for display, categorization, or workflow routing purposes. Used in claims management systems to identify claim types, processing queues, or adjudication statuses in user interfaces and operational reporting dashboards.

The preferred spoken or written language of the patient associated with a submitted insurance claim. Captured to support member communications, Explanation of Benefits delivery, and regulatory compliance with language access requirements under federal and state healthcare equity and non-discrimination mandates.

The family or surname of the patient or insured individual as recorded on a submitted insurance claim. Used alongside other demographic fields to verify patient identity, match claim records to member enrollment data, and ensure accurate benefit attribution during payer adjudication and payment processing.

The officially registered full name of the patient or insured individual as it appears on government-issued identification, recorded on a submitted insurance claim. Used for identity verification, fraud detection, coordination of benefits validation, and compliance with CMS and payer enrollment matching requirements.

Categorical attribute in utilization management systems that designates whether a claim is being processed at the header, line, or service level. Used in EHR and payer platforms to control adjudication granularity and is essential for data engineers designing hierarchical claims fact models and utilization reporting pipelines.

The state-issued professional license number of the rendering or billing provider associated with a submitted insurance claim. Used by payers to verify provider credentials, validate licensure status during adjudication, and ensure compliance with state scope-of-practice requirements for reimbursement eligibility.

The marital status of the patient or insured individual as recorded on a submitted insurance claim. Used to support coordination of benefits determinations, identify potential secondary coverage through a spouse's plan, and fulfill demographic data collection requirements for population health and regulatory reporting.

The enterprise-level master identifier assigned to uniquely represent a specific insurance claim across all systems within a payer or health system's data environment. Serves as the authoritative reference key for linking claim transactions, adjustments, remittance records, and audit trails throughout the full claims lifecycle.