Data Template: Claims Processing

Universal process mining template
Data Template: Claims Processing

Your Claims Processing Data Template

Universal process mining template

This is our generic process mining data template for Claims Processing. Use our system-specific templates for more specific guidance.

Select a specific system
  • Structured guidance on essential data attributes.
  • Key process activities for a complete journey view.
  • A flexible framework, universally applicable to any claims system.

Claims Processing Attributes

Below, you will find a list of recommended data fields and their descriptions, essential for creating a detailed event log for your Claims Processing analysis.
5 Required 7 Recommended 6 Optional
NameDescription
Activity Name
ActivityName
The name of the business activity or event that occurred at a specific point in time for a claim.
Description

The Activity Name describes a specific step, task, or event within the claims processing lifecycle. These activities represent the work being done, such as 'Claim Registered', 'Investigation Started', or 'Payment Issued'. Each activity is a distinct point in the process captured in the event log.

For process mining analysis, activities are the building blocks of the process map. Analyzing the sequence, frequency, and duration of these activities reveals the actual process flow, common pathways, bottlenecks, and deviations from the standard procedure. Clear and consistent activity naming is crucial for creating an understandable and actionable process model.

Why it matters

Activities form the core of the process map, defining the steps and tasks whose sequence and duration are analyzed to understand process performance.

Where to get

Typically found in event logs, audit trails, or transaction records within the claims management system.

Examples
Claim RegisteredLoss AssessedPayment IssuedClaim Denied
Claim ID
ClaimId
The unique identifier for a single insurance claim, which serves as the primary case identifier for process mining.
Description

The Claim ID is a unique key assigned to each insurance claim upon its registration. It acts as the central thread that connects all related activities, events, and data points throughout the claim's lifecycle, from initial submission to final closure.

In process mining, the Claim ID is fundamental for reconstructing the end-to-end journey of each claim. By grouping all events with the same Claim ID, the software can visualize the process flow, identify variations, and calculate case-level metrics. It ensures that every action, from adjuster assignment to payment issuance, is correctly attributed to the specific claim it belongs to, enabling a coherent and accurate process analysis.

Why it matters

This is the essential case identifier that links all related events together, making it possible to trace the end-to-end journey of each claim.

Where to get

Typically found in the header or primary record of a claim file or claim management system transaction.

Examples
CL-2023-001234A789-C54329876543210
Start Time
StartTime
The timestamp indicating when a specific activity or event began.
Description

The Start Time is a precise date and time marker indicating the moment an activity commenced. It is a critical piece of data for each event in the process log, providing the temporal context needed for performance analysis.

In process mining, Start Time is essential for ordering events chronologically to reconstruct the case journey accurately. It is the basis for calculating key performance indicators such as cycle times, waiting times, and processing times. Analyzing timestamps helps identify delays between steps, measure adherence to service level agreements (SLAs), and understand the temporal dynamics of the claims process.

Why it matters

This timestamp is essential for ordering events correctly and calculating all time-related metrics, such as cycle times and bottlenecks.

Where to get

Typically recorded in event logs, audit trails, or transaction data, often labeled as 'event time' or 'creation date'.

Examples
2023-03-15T09:00:00Z2023-05-20T14:35:10Z2023-07-01T11:21:05Z
Last Data Update
LastDataUpdate
The timestamp of the most recent data refresh or extraction from the source system.
Description

Last Data Update indicates the last time the event log data was refreshed from the source systems. This timestamp provides context on the freshness of the data being analyzed, ensuring that stakeholders are aware of the data's currency.

In any process analysis, knowing the timeliness of the data is critical for making informed decisions. This attribute helps users understand if they are viewing a near real-time process or a historical snapshot. It is particularly important for ongoing monitoring dashboards and for ensuring that any conclusions drawn are based on relevant and up-to-date information.

Why it matters

Provides crucial context on the timeliness of the data, ensuring that analysis and decisions are based on up-to-date information.

Where to get

This is typically metadata generated during the data extraction, transformation, and loading (ETL) process.

Examples
2023-10-26T02:00:00Z2023-10-27T02:00:00Z2023-10-28T02:00:00Z
Source System
SourceSystem
The system of record from which the event data was extracted.
Description

The Source System attribute identifies the specific IT application or platform where the activity was originally recorded. In complex environments, claims processing data may come from multiple systems, such as a core claims platform, a document management system, or a customer relationship management (CRM) tool.

Understanding the source system is valuable for data validation and for analyzing process fragmentation. It helps in tracing data quality issues back to their origin and can reveal inefficiencies caused by manual data transfers or work handoffs between different systems. This analysis can highlight opportunities for better system integration and automation.

Why it matters

Identifies the origin of event data, which is crucial for data validation and for analyzing process execution across multiple IT systems.

Where to get

This information may be part of the data extraction logic or stored as a field in the event logs of integrated systems.

Examples
Claims Management SuiteCRM PortalDocument Handling System
Assigned Adjuster
AssignedAdjuster
The name or ID of the user, such as a claims adjuster, responsible for handling the claim or activity.
Description

The Assigned Adjuster identifies the individual employee or user who performed a specific activity or is responsible for the claim at a certain point in time. This attribute links process steps to the human resources executing them.

Analyzing data by adjuster is crucial for workload management, performance evaluation, and identifying training needs. It allows managers to compare performance across team members, ensure equitable distribution of work, and spot high-performers or those who may require additional support. This resource-level view is key for dashboards related to team performance and workload balance.

Why it matters

Links process activities to the individuals who perform them, enabling analysis of workload, team performance, and resource allocation.

Where to get

Found in transaction records, audit logs, or user assignment fields within the claims management system.

Examples
John SmithUSER789Emily Jonesadjuster_team_a
Claim Severity
ClaimSeverity
A classification of the claim's estimated complexity or potential financial impact, such as Low, Medium, or High.
Description

Claim Severity provides an assessment of the claim's complexity, urgency, or potential financial cost. This classification helps in prioritizing claims and routing them to adjusters with the appropriate skill level. Severity can be determined by factors like the estimated loss amount, the nature of the incident, or the presence of litigation.

Analyzing the process based on Claim Severity is critical for understanding if handling procedures are appropriately tailored. For example, high-severity claims might be expected to have longer cycle times but should follow a more rigorous investigation path. This attribute helps verify that complex claims receive the necessary attention while simple claims are processed quickly, optimizing resource allocation and customer satisfaction.

Why it matters

Helps differentiate between simple and complex claims, enabling analysis of whether process execution is appropriately tailored to claim complexity.

Where to get

Often determined by business rules at claim intake and stored as a field in the main claim record.

Examples
LowMediumHighCatastrophic
Claim Type
ClaimType
The category of the insurance claim, which helps segment and compare process performance for different types of claims.
Description

Claim Type is a classification that categorizes claims based on the line of business or nature of the loss, such as 'Auto', 'Property', 'Liability', or 'Disability'. Different claim types often follow distinct process paths and have different complexity levels and SLAs.

Segmenting the process analysis by Claim Type is a fundamental technique for gaining meaningful insights. It allows for the comparison of cycle times, costs, and process conformance across different categories. This analysis can reveal that a process that is efficient for auto claims may be inefficient for property claims, guiding targeted improvement efforts. This attribute is essential for the 'Performance by Claim Category' dashboard.

Why it matters

Allows for segmentation of claims to compare processes and performance across different business lines, revealing category-specific issues.

Where to get

A standard field in the main claim record, typically set when the claim is first created.

Examples
AutomobilePropertyWorkers CompensationGeneral Liability
Department
Department
The business unit, team, or department responsible for handling the activity or claim at a given time.
Description

The Department attribute specifies the organizational group responsible for a claim at a particular stage in its lifecycle. Examples include 'First Notice of Loss', 'Investigation Unit', or 'Payments Department'.

This information is vital for understanding handoffs and collaboration between different parts of the organization. Analyzing the process from a departmental view can reveal delays that occur when a claim moves from one team to another. It helps identify inter-departmental bottlenecks and is essential for assessing team-specific workloads and performance, supporting KPIs like Adjuster Workload Balance and dashboards on Team Performance.

Why it matters

Helps analyze process handoffs between teams and identify inter-departmental bottlenecks, supporting organizational performance analysis.

Where to get

Typically stored in the claim record, often associated with the assigned user or the current process stage.

Examples
Intake TeamSpecial Investigations UnitLiability AssessmentFinance & Payments
End Time
EndTime
The timestamp indicating when a specific activity or event was completed.
Description

The End Time is a precise date and time marker indicating the moment an activity was concluded. When available alongside a Start Time, it allows for the exact measurement of how long an activity took to complete.

This attribute is extremely valuable for detailed performance analysis. The difference between Start Time and End Time provides the 'processing time' or 'activity duration', a key metric for identifying inefficient steps. Analyzing processing times helps pinpoint which activities consume the most resources and where efforts to streamline operations should be focused. It is fundamental for creating dashboards related to process bottlenecks and team performance.

Why it matters

Enables the precise calculation of activity processing times, which is critical for identifying bottlenecks and analyzing resource efficiency.

Where to get

Typically found in event logs or audit trails alongside the start time. It might need to be derived if only change events are logged.

Examples
2023-03-15T11:30:00Z2023-05-20T15:05:45Z2023-07-01T11:29:15Z
Resolution Target Date
ResolutionTargetDate
The target date by which the claim is expected to be resolved, based on service level agreements (SLAs) or regulations.
Description

The Resolution Target Date, or due date, is the deadline set for completing the claims process. This date is often dictated by regulatory requirements or internal service level agreements (SLAs) designed to ensure timely customer service.

This attribute is fundamental for compliance and performance monitoring. By comparing the actual claim closure date with the target date, organizations can measure their SLA Adherence Rate. Process mining can highlight which process steps or variants are most likely to cause SLA breaches. This enables proactive management of deadlines and helps prioritize improvements that have the greatest impact on timely resolution, directly supporting the 'SLA and Deadline Adherence' dashboard.

Why it matters

Enables the measurement of on-time performance against SLAs or regulatory deadlines, a critical measure of process effectiveness.

Where to get

Typically calculated based on business rules when a claim is created and stored in the main claim record.

Examples
2023-04-142023-06-192023-08-30
Settlement Amount
SettlementAmount
The final financial amount paid to the claimant or a third party to resolve the claim.
Description

The Settlement Amount represents the total monetary value paid out to settle a claim. This is a critical outcome metric that reflects the financial impact of the claim. It is typically determined after the loss has been assessed and a decision has been made.

In process mining, this attribute is essential for cost-based analysis. It allows for the calculation of KPIs like 'Average Cost per Claim' and enables investigation into how process variations affect financial outcomes. For instance, analysis might show that claims with certain rework loops or longer cycle times tend to result in higher settlement amounts. This provides a direct link between process efficiency and financial performance, underpinning the 'Claim Cost Analysis' dashboard.

Why it matters

This is a key outcome metric that directly links process behavior to financial impact, enabling cost-benefit analysis of process improvements.

Where to get

Located in the financial or payment records associated with the claim, finalized upon claim closure or payment.

Examples
1500.0025000.50125.750.00
Claim Status
ClaimStatus
The overall status of the claim at a given point in time, such as Open, Pending, or Closed.
Description

Claim Status indicates the state of the claim within its lifecycle at the time of an event. This status provides a high-level summary of where the claim is in the process, for example 'Under Investigation', 'Awaiting Information', or 'Settled'.

While process mining reconstructs the detailed flow from activities, the Claim Status attribute offers a valuable contextual layer. It can be used to validate the process flow (e.g., does a 'Payment Issued' activity correctly move the status to 'Closed'?) and to analyze the duration claims spend in particular states. This helps in understanding how long cases remain pending and can highlight systemic delays or inefficiencies.

Why it matters

Provides context on the state of a claim at any given time, helping to analyze time spent in different stages and validate the process flow.

Where to get

A core field in the main claim record, which is updated as the claim progresses through its lifecycle.

Examples
OpenPending - Awaiting Customer InfoClosed - PaidClosed - Denied
Claimed Amount
ClaimedAmount
The total monetary amount initially requested by the policyholder when the claim is filed.
Description

The Claimed Amount is the initial estimate of the loss or the amount requested by the claimant at the start of the process. This value may be revised later during the investigation and assessment phase.

This attribute is useful for several types of analysis. It can be used to set an initial severity level for the claim and to track the variance between the initial claim and the final settlement amount. Analyzing this variance can provide insights into the accuracy of initial estimates and the effectiveness of the cost control measures within the claims process. It is a key input for financial forecasting and reserving.

Why it matters

Represents the initial financial scope of the claim, useful for severity assessment and for analyzing the variance with the final settlement amount.

Where to get

Captured during the initial claim filing process and stored in the financial section of the claim record.

Examples
2000.0035000.00500.00
Denial Reason
DenialReason
The specific reason provided when a claim is denied or rejected.
Description

The Denial Reason is a code or text description that explains why a claim was not paid. Reasons can range from issues with coverage under the policy, fraudulent activity, or failure to provide required documentation.

Analyzing denial reasons is crucial for identifying opportunities to improve both internal processes and customer communication. For example, if a large number of claims are denied due to missing information, it may indicate a need to improve the intake process. Root cause analysis on denial reasons can lead to clearer policy language, better customer education, and reduced administrative effort spent on claims that will ultimately be denied.

Why it matters

Provides insight into why claims are not paid, enabling root cause analysis to improve customer communication and front-end processes.

Where to get

Selected from a predefined list or entered as text by an adjuster when a 'Claim Denied' activity occurs.

Examples
Not covered under policySuspected FraudIncomplete DocumentationDuplicate Claim
Loss Date
LossDate
The date on which the incident or loss that triggered the insurance claim occurred.
Description

The Loss Date marks the actual date of the event (e.g., car accident, property damage) that led to the claim. This is distinct from the date the claim was reported or registered in the system.

The difference between the Loss Date and the claim registration date is known as the 'reporting lag'. Analyzing this lag is important for understanding customer behavior and identifying potential fraud risks (e.g., unusually long delays in reporting). It provides a more complete timeline of the entire claims experience, from incident to resolution, offering a broader view than just the internal processing time.

Why it matters

Establishes the date of the actual incident, allowing for analysis of reporting delays and the full timeline from event to closure.

Where to get

Provided by the claimant during the 'First Notice of Loss' and stored in the main claim record.

Examples
2023-03-102023-05-182023-06-25
Policy Number
PolicyNumber
The unique identifier of the insurance policy under which the claim was filed.
Description

The Policy Number is the unique reference for the insurance contract that covers the reported loss. It links the claim to a specific customer, policy terms, coverage limits, and other contractual details.

While not always directly used in the process flow analysis itself, the Policy Number is a crucial piece of contextual information. It allows for aggregating claim data at the policy or customer level, which can reveal patterns such as frequent claims by a single policyholder. It also enables enrichment of the claims data with policy-level details (e.g., policy type, coverage amount) for more advanced segmentation and analysis.

Why it matters

Links the claim to the specific insurance contract, enabling enrichment with policy data for deeper, more contextual analysis.

Where to get

A fundamental piece of data captured at claim intake and stored in the header of the claim record.

Examples
POL-987654A-100-200-300555444333
Submission Channel
SubmissionChannel
The method or channel through which the claim was initially submitted.
Description

The Submission Channel identifies how a claim was first reported to the company. Common channels include an online customer portal, a mobile app, an agent, a broker, or traditional mail.

Analyzing the process by submission channel can reveal important differences in data quality, efficiency, and customer experience. For example, claims submitted through a digital portal may have fewer data entry errors and faster initial processing times compared to those submitted by mail. These insights can inform strategic decisions about which channels to promote and where to invest in automation and process improvement.

Why it matters

Helps analyze how the intake channel impacts process efficiency, data quality, and overall cycle time.

Where to get

Typically captured during the 'First Notice of Loss' (FNOL) process and stored in the main claim record.

Examples
Web PortalAgentPhoneMail
Required Recommended Optional

Claims Processing Activities

This section outlines the primary process steps and significant milestones to record, enabling precise process discovery and analysis of your claims operations.
7 Recommended 8 Optional
ActivityDescription
Claim Closed
This is the final administrative activity, marking the closure of the claim file after payment has been issued or the claim has been denied. All activities are complete at this stage.
Why it matters

This is the primary end event for the process. It is essential for calculating the total end-to-end cycle time for all claims.

Where to get

Captured by the final status update to 'Closed' or 'Finalized' in the system after all other processing is complete.

Capture

Identify the timestamp when the claim's main status field is updated to its final 'Closed' value.

Event type inferred
Claim Decision Made
A pivotal milestone where the insurer makes a formal decision to approve, partially approve, or deny the claim based on the investigation. This represents the official outcome of the adjudication process.
Why it matters

This is a critical decision point that determines the subsequent path of the claim (payment or denial). It is essential for analyzing decision-making time and outcomes.

Where to get

This is almost always captured as an explicit status change within the system to a state like 'Approved', 'Denied', or 'Settled'.

Capture

Look for the first status update to a terminal decision state such as 'Approved' or 'Denied'.

Event type inferred
Claim Denied
This activity represents the final outcome for a claim that is not approved for payment. This follows a 'deny' decision and involves finalizing the claim record with a denied status.
Why it matters

This is a key terminal event for one of the main process variants. Analyzing denied claims is crucial for understanding denial rates and reasons.

Where to get

This event is captured when the claim's final status is definitively set to 'Denied' or 'Rejected'.

Capture

Look for a final status update to 'Denied', 'Rejected' or a similar terminal state, which may occur after the initial decision.

Event type inferred
Claim Registered
This activity marks the formal creation of a claim record within the processing system after the First Notice of Loss (FNOL). At this point, a unique Claim ID is officially assigned and the case is formally opened for processing.
Why it matters

This is the primary start event for the claims process. It is essential for measuring the overall claim cycle time from official registration to closure.

Where to get

This event is typically captured from the creation timestamp of the primary claim record or case object in the source system.

Capture

Identify the creation event or the first status update in the claim's history log.

Event type explicit
Initial Review Completed
Represents the completion of the first comprehensive review of the claim by the assigned adjuster. During this step, the adjuster assesses the claim's validity, details, and determines the next required actions.
Why it matters

This milestone helps measure the initial triage and assessment time. Delays here can significantly impact the total claim cycle time.

Where to get

Often inferred from a status change in the system, such as moving from 'New' or 'Assigned' to 'Under Review' or 'Investigation'.

Capture

Look for a status change that signifies the end of the initial assessment phase and the beginning of active processing.

Event type inferred
Loss Assessed
This milestone marks the point where the financial impact of the claim is estimated and a reserve is set. It signifies the formal estimation of the claim's potential cost.
Why it matters

This is a key financial event in the process. Analyzing when and how often reserves are adjusted provides insights into valuation accuracy and process efficiency.

Where to get

This event is captured when reserve amounts are first entered or subsequently adjusted in the system's financial records for the claim.

Capture

Capture the timestamp of the first transaction in the financial reserve log for the claim.

Event type explicit
Payment Issued
This activity marks the execution of the financial transaction to pay the claim. It represents the moment the payment is dispatched to the claimant or provider.
Why it matters

This is a critical financial event and often marks the end of the 'happy path' process. It's vital for measuring the time-to-payment from claim approval.

Where to get

This is recorded as an explicit transaction log or a final payment status update, often triggered by an integration with a financial system.

Capture

Identify the event when a payment record associated with the claim is marked as 'Paid', 'Issued', or 'Disbursed'.

Event type explicit
Additional Information Received
Marks the receipt of the requested documents or information, which allows the claim processing to resume. This activity concludes the 'wait' state initiated by the request.
Why it matters

This event closes the information request loop. The time between requesting and receiving information is a key indicator of external dependencies and bottlenecks.

Where to get

Typically inferred when the claim status is updated from a 'Pending Information' state back to an active state like 'Under Review'.

Capture

Detect the status change from a 'pending' state back to an 'active' processing state.

Event type inferred
Additional Information Requested
This activity occurs when the adjuster determines that more information is needed from the claimant or a third party to proceed. This often initiates a 'wait' state in the process.
Why it matters

This activity is the start of a common rework or waiting loop. Analyzing its frequency and duration helps identify issues with initial data collection and communication.

Where to get

This is often captured by a specific status change (e.g., 'Pending Information') or by logging an outgoing communication event.

Capture

Identify status changes to a 'pending information' state or the creation of a task/communication related to an information request.

Event type inferred
Adjuster Assigned
This activity captures the assignment of the claim to a specific claims adjuster, handler, or team. It establishes ownership and accountability for managing the claim through its lifecycle.
Why it matters

Tracking assignments is crucial for analyzing workload distribution, team performance, and identifying delays in claim handoffs.

Where to get

This information is usually recorded in an assignment log or by tracking changes to the 'owner' or 'assignee' field on the claim record.

Capture

Capture updates to the user or group assignment fields associated with the claim case.

Event type explicit
Claim Reopened
Occurs when a previously closed or denied claim is reactivated for further review or processing. This is typically due to an appeal, new information, or the discovery of an error.
Why it matters

Reopened claims represent significant rework. Tracking this activity is critical for identifying process failures, reasons for appeal, and their impact on costs.

Where to get

This event is captured by a status change from a 'Closed' or 'Denied' state back to an active state like 'Under Review'.

Capture

Detect a status change from a terminal state (e.g., 'Closed') back to a non-terminal, active state.

Event type inferred
Investigation Completed
Represents the conclusion of all investigation activities, where all necessary facts have been gathered and documented. This step is a prerequisite for making a final decision on the claim.
Why it matters

This milestone marks the end of the evidence-gathering phase. The duration until this point is critical for understanding investigation efficiency.

Where to get

Typically inferred when the claim status moves from 'Under Investigation' to a decision-making status like 'Pending Decision' or 'Ready for Assessment'.

Capture

Identify the status change that signifies the end of investigation and the readiness for a final decision.

Event type inferred
Investigation Started
This activity signifies the beginning of the formal, in-depth investigation phase of the claim. This may involve assigning specialists, scheduling inspections, or other evidence-gathering activities.
Why it matters

Tracking the start of the investigation helps to isolate and measure the duration of this often complex and time-consuming phase of the claims process.

Where to get

This is often inferred from a change in the claim's status to 'Under Investigation' or a similar state, or the creation of the first investigation-related task.

Capture

Look for a status change to 'Under Investigation' or the creation of the first formal investigation task.

Event type inferred
Payment Authorized
Represents the formal approval for the calculated settlement amount to be paid. This is often a distinct step involving a manager or a separate authority to prevent fraud and ensure accuracy.
Why it matters

This is a critical control point. Analyzing the time between calculation and authorization can highlight approval bottlenecks or compliance issues.

Where to get

This is captured by a specific approval transaction or a status change like 'Approved for Payment' in the system.

Capture

Capture the timestamp of the payment approval event or a status change to 'Approved for Payment'.

Event type explicit
Settlement Calculated
Following an approval decision, this activity represents the calculation of the final settlement or payment amount. This is based on policy limits, deductibles, and assessed losses.
Why it matters

The time taken for this step can reveal bottlenecks between the claim decision and payment authorization. It is a key step in the financial settlement process.

Where to get

This is likely captured when the final payment or settlement amount field is entered and confirmed in the system's financial module.

Capture

Identify when the final settlement amount is populated or a payment record is created in a 'pending approval' state.

Event type explicit
Recommended Optional

Extraction Guides

How to get your data for process mining.

Extraction methods vary by system. For detailed instructions,

read our ETL guide

or select a specific process and system.