The Denial Analytics package has a pre-defined set of fields that will be displayed when drilling through into detail for most measures. When looking at a table of data, any number can be double-clicked to drill through into the detail for that cell.
This will bring up an additional sheet in the same Excel workbook with the following fields:
- Patient ID: The patient's chart number.
- Patient Reverse Name: The patient’s name in the format “[Last Name], [First Name]”.
- Rendering Provider Reverse Name: The rendering provider’s name in the format “[Last Name], [First Name]”.
- Service Location: The Service Location currently on the claim.
- Service Date: The Service Date of the associated claim.
- Post Date: The Post Date of the associated transaction.
- Claim ID: The unique ID for this claim.
- Code: The procedure code on the claim line.
- Code Modifiers: The modifiers on the claim line.
- Diagnoses: The list of diagnosis codes on the claim line.
- Deposit Payer Name: The payer on the deposit that this CARC/RARC was posted on.
- Deposit ID: The unique ID for the deposit that this CARC/RARC was posted on.
- CARC: The Claim Adjustment Reason Code that was posted.
- RARC: The Remittance Advice Remark Code that was posted to give more information about the adjustment. Many CARCs will be received with no associated RARC.
- Payment Type: The payment type that was associated with this CARC line at time of posting.
- Payments: The amount associated with this CARC line that was posted as a payment.
- Adjustments: The amount associated with this CARC line that was posted as an adjustment against the balance of the line. This will most commonly happen with expected contractual adjustments like CO-45's.
- Comments: The amount associated with this CARC line that was posted as a comment-only amount, not being a payment or a taken adjustment. These are most commonly associated with denial CARCs.
- Total Amount: The total amount associated with this CARC line, whether it was posted as a payment, adjustment, or comment.
