New Billing Analytics Drill-through

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.