Data Template: Claims Processing
Your Claims Processing Data 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
| Name | Description | ||
|---|---|---|---|
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 | |||
Claims Processing Activities
| Activity | Description | ||
|---|---|---|---|
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 | |||
Extraction Guides
Extraction methods vary by system. For detailed instructions,
