The new Billing 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, whether it's a charge, payment, or adjustment.
- Claim ID: The unique ID for this claim.
- Claim Status: The current Claim Status.
- Code Group: The Code Group for the procedure code on the claim line.
- Code: The procedure code on the claim line.
- Charge Primary Dx: The primary diagnosis code on the claim line.
- Payment Method: The payment method, if transaction is a payment or adjustment.
- Charges: If the detail line represents a charge, this is the associated dollar amount.
- Insurance Payments: If the detail line represents an insurance payment, this is the associated dollar amount.
- Patient Payments: If the detail line represents a patient payment, this is the associated dollar amount.
- Total Payments: If the detail line represents any payment, this is the associated dollar amount.
- Adjustments: If the detail line represents an adjustment, this is the associated dollar amount.
