Data Lineage Research

Trace transaction data across systems and time periods

Search for Data Lineage

Enter a value or pick a quick search below.

Quick searches:

Data Flow Visualization

Distributor Cardinal Health
Source Data
Transaction TXN-892341
Oct 15, 2024
Validation Eligibility Check
Passed
Claim CLM-Q3-045
Oct 31, 2024
Settlement STL-12456
Paid
Source
Transaction
Validation
Claim
Settlement

Source Data Details Transaction Details Validation Details Claim Details Settlement Details Select a Node All Node Details

Source Data

Source System

Cardinal EDI Feed

File Name

CH_SALES_20241015.dat

Received Date

Oct 15, 2024 08:32 AM

Record Count

12,456 records

Line Number

8,234

Import Status

Successful

Transaction

Transaction ID

TXN-2024-892341

Invoice Number

INV-789234

Product NDC

12345-678-90

Quantity

100 units

Unit Price

$45.00

Extended Amount

$4,500.00

Customer

Memorial Hospital

Ship-To DEA

AB1234567

Validation

Contract Eligibility: Passed
GPO Membership: Verified (Vizient)
Product Match: Exact NDC Match
Tier Qualification: Tier 2 (5%)
Date Range: Within Contract Period
Calculated Rebate

$225.00

5% of $4,500.00

Claim

Claim Number

CLM-2024-Q3-045

Transaction ID

TXN-2024-892341

Submission Date

Oct 31, 2024

Contract

SPA-CH-2024-001

Claim Amount

$225.00

Status

Paid

Settlement

Settlement ID

STL-2024-12456

Payment Date

Nov 22, 2024

Payment Method

ACH Transfer

Reference

REF-7823456

Expected Amount

$225.00

Received Amount

$225.00

Exact Match - No Variance

Click on a node in the diagram above to view details

Data Comparison

Compare data values across different stages

Field Source System Match
NDC 12345-678-90 12345-678-90
Quantity 100 100
Unit Price $45.00 $45.00
Ship-To DEA AB1234567 AB1234567
Invoice Date 10/15/2024 10/15/2024
Rebate % 5% 5%
All fields match - Data integrity verified

Audit Trail

Settlement Confirmed Nov 22, 2024 2:34 PM

Payment matched to claim CLM-2024-Q3-045. Amount: $225.00

Claim Submitted Oct 31, 2024 11:15 AM

Claim CLM-2024-Q3-045 submitted to Cardinal Health via EDI 844

Rebate Calculated Oct 28, 2024 09:00 AM

Auto-calculated rebate of $225.00 for transaction TXN-2024-892341 (5% Tier 2)

Validation Passed Oct 15, 2024 09:12 AM

All eligibility checks passed. GPO: Vizient, Contract: CTR-2024-001

Data Imported Oct 15, 2024 08:32 AM

Transaction imported from Cardinal EDI feed CH_SALES_20241015.dat (Line 8234)