Payments Reference Report - data

Payments Reference Report shows summary of payment references received from payers.

Payment References Worksheet

The worksheet contains the summary of all payment references submitted by payers in Remittance.Advice transactions.

Data in the worksheet is sorted by:

The table below describes columns presented on this worksheet.

Column	Description
Payer ID	License number of an insurance company that is the payer of a number of claims grouped by the same payment reference number.
Payer Name	Name of an insurance company that is the payer of a number of claims grouped by the same payment reference number.
Settlement Date	Settlement date of the payment.
Payment Reference	Payment reference number.
Payment Amount	The sum of all Activity.PaymentAmount across all received Remittance.Advice transactions for the same Settlement Date and Payment Reference.

Thie worksheet contains payment references for every claim submitted by payers in Remittance.Advice transactions.

Data in the worksheet is sorted by:

The table below describes columns presented on this worksheet.

Column	Description
Payer ID	License number of an insurance company that is the payer of a claim.
Payer Name	Name of an insurance company that is the payer of a claim.
Claim ID	ID assigned to a claim by a provider.
Claim ID Payer	ID assigned to a claim by a payer.
Encounter Start	Encounter start date and time. If a claim has more than one encounter, then this value is taken from the earliest encounter.
Member ID	Insurance card number of a patient.
MRN	Patient Medical Record Number assigned by the provider.
Settlement Date	Settlement date of the payment.
Payment Reference	Payment reference number.
Payment Amount	Payment amount for the clai. Calculates as the sum of Activity.PaymentAmount for the respective activities.

The worksheet contains payment references for every activity submitted by payers in Remittance.Advice transactions.

Data in the worksheet is sorted by:

The table below describes columns presented on this worksheet.

Column	Description
Payer ID	License number of an insurance company that is the payer of a claim.
Payer Name	Name of an insurance company that is the payer of a claim.
Claim ID	ID assigned to a claim by the provider.
Claim ID Payer	ID assigned to a claim by the payer.
Member ID	Insurance card number of patient.
MRN	Patient Medical Record Number assigned by the provider.
Activity ID	ID of an activity.
Auth. Number	Prior authorization number.
Rx Number	Rx Number. It is taken from an observation with Observation.Code = Prescription No. Column is shown if there is at least one activity with the said observation.
Fill Counter	Fill Counter. It is taken from an observation with Observation.Code = Refills or Fill Counter. Column is shown if there is at least one activity with the said observation
Service Date	Date of the provided service.
Settlement Date	Settlement date of the payment.
Payment Reference	Payment reference number.
Payment Amount	Payment amount for an activity.