Reconciliation report

This report shows mapping between claims and remittance advices. Report contains all claims submitted by providers. Some claims will have Remittance Advices, the other claims will not have them. However, all claims present in this report.

Claim Reconciliation Report

This worksheet contains history of all claims submitted by provider in Claim.Submission transactions.
Data in the worksheet are sorted by:
1. Sender ID
2. Claim ID
3. Submission Date.
Table below describes columns presented on this worksheet.

Column	CS Field	Description
First CS Date
Last CS Date
First RA Date
Last RA Date
Claim ID	Claim.ID
Claim ID Payer
Pt Visit Date
Pt Visit Date Time
Sender ID
Reciever ID
Payer ID
Provider ID
Member ID
MRN
Original Claimed Amount
Current Claimed Amount
Patient Share
Pending Amount
Original Paid Amount
Paid Amount
Denied Amount
Write Off Amount
Final Denied Amount
Denied Clearing Error
Processed Amount
Principal Diagnosis
Diagnosis Text
Secondary Diagnosis 1...N
Diagnosis Text
Payment Status
Claim Status
Missed Take Back

Activity Reconciliation Report

Table below describes columns in the report.

Column	Transaction Field	Description
First CS Date	Header.TransactionDate	Date and time of the first Claim.Submission transaction.
Last CS Date	Header.TransactionDate	Date and time of the last Claim.Resubmission, either Correction or Internal Complaint. If a claim has no resubmission, then it equals First CS Date.
First RA Date	Header.TransactionDate	Date and time of the first Remittance.Advice transaction.
Last RA Date	Header.TransactionDate	Date and time of the last Remittance.Advice transaction.
Rx Number	Observation.Value	Rx Number; value is taken for observation with Observation.Code = "Prescription No".
Fill Counter	Observation.Value	Fill Counter; value is taken for observation with Observation.Code = "Refills" or "Fill Counter".
Code	Activity.Code	Activity code specified by activity type.
Type		Activity type.
Description		Activity code description.
Claim ID	Claim.ID	Unique identifier assigned to a claim by the provider.
Claim ID Payer	Claim.IDPayer	Unique identifier assigned to a claim by the payer.
Activity ID	Activity.ID	Unique identifier of an activity within a claim.
Auth. Number	Activity.PriorAuthorizationID	Prior authorization number.
Auth. Approval Date		Always N/A until future versions.
Service Date	Activity.Start	Date of the provided service.
Service Date Time	Activity.Start	Date and time of the provided service.
Ord. Clinician License	Activity.OrderingClinician	License number of the clinician who ordered an activity or referred the patient for an activity.
Ord. Clinician Name		Full name of the clinician who ordered an activity or referred the patient for an activity..
Disp. Clinician License	Activity.Clinician	License number of the clinician who provided an activity (treatment or care) for the patient.
Disp. Clinician Name		Full name of the clinician who provided an activity (treatment or care) for the patient..
Sender ID	Header.SenderID	License number of a facility that is the sender of Claim.Submission transaction.
Receiver ID	Header.ReceiverID	License number of an insurance company or TPA that is the receiver of Claim.Submission transaction.
Payer ID	Claim.PayerID	License number of an insurance company that is the payer of a claim.
Provider ID	Claim.ProviderID	License number of the provider.
Member ID	Claim.MemberID	Insurance card number of the patient.
MRN	Encounter.PatientID	Patient Medical Record Number assigned by the provider.
Sales Price		Sales price for the drug. It has value only if Activity.Type = 5.
Quantity	Activity.Quantity	Dispensed quantity for an activity.
Original Claimed Amount		Activity.Net value in the first Claim.Submission transaction.
Current Claimed Amount	Activity.Net	Claimed amount.
Patient Share		Always N/A until future versions.
Pending Amount		Pending Amount is shown as described in the logic above.
Original Paid Amount	Activity.PaymentAmount	Paid Amount is sum of all Remittance Advices for this claim.
Paid Amount		This column is the same as Original Paid Amount considered all workarounds described above.
Missed Take Back		Logic to calculate this value is described in section 74716133. Default value for this column is No
Denied Amount		Denied Amount is calculated using the following logic: Claimed Amount from the latest Remitted Claim – Total Paid Amount for this claim.
Write Off Amount		Write Off Amount as per latest /wiki/spaces/RES/pages/75961340.
Write Off Date		Date when the amount is written off as per latest /wiki/spaces/RES/pages/75961340.
Final Denied Amount		Calculates as Denied Amount – Write Off Amount.
Denied Clearing Error		Logic to calculate this value is described in seciton 74716133.
Processed Amount		Calculates as Paid Amount + Denied Amount.
Denial Code		Denial code for a rejected activity.
Denial Reason		Denial code description.
Principal Diagnosis	Diagnosis.Code	Principal diagnosis code.
Diagnosis Text		Principal diagnosis description.
Secondary Diagnosis 1...N	Diagnosis.Code	Secondary diagnosis code. This value is taken from diagnosis that has Diagnosis.Type <> Principal.
Diagnosis Text		Secondary diagnosis description.
Payment Status		Claim status that may have one of the following values: `Paid` — claim is fully paid (payment is the same as claimed amount or greater). `Partly Paid` — claim is partly paid (payment is less than claimed). `Denied` — claim is fully denied (payment is zero). `In Process` — remittance advice is not received for the claim. Claims will have this status in the following scenario: New claim is submitted and no remittance advice is yet received. Claim resubmission (correction or internal complaint) is submitted and no remittance advice is yet received. In this case Paid Amount may have value from previous claim submissions. `Written Off` — claim is written off using /wiki/spaces/RES/pages/75961340.
Claim Status		This column may have the following values: Original — if this is initial claim submission. Resubmission 1 — if this is first claim resubmission. Resubmission N — if this is N claim resubmission.