Payments Reference Report shows summary of payment references received from payers. This is an Excel file containing three worksheets - levels of data aggregation:
- Payment References
- Claim Payments
- Activity Payments
Payment References worksheet
The worksheet contains summary of all payment references submitted by payers in Remittance.Advice transactions.
...
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 | Payment amount for claims batch. Calculates as the sum of Activity.PaymentAmount for the respective activities. |
Data in the worksheet is sorted by:
- Settlement Date, descending;
- Payer ID, ascending;
- Payment Reference, ascending.
Claim Payments worksheet
The worksheet contains payment references for every claim submitted by payers in Remittance.Advice transactions.
...
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 | Unique identifier assigned to a claim by the provider. |
| Claim ID Payer | Unique identifier assigned to a claim by the 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 the 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 claim. Calculates as the sum of Activity.PaymentAmount for the respective activities. |
Data in the worksheet is sorted by:
- Settlement Date, descending;
- Payer ID, ascending;
- Payment Reference, ascending;
- Claim.ID, ascending.
Activity Payments worksheet
The worksheet contains payment references for every activity submitted by payers in Remittance.Advice transactions.
...