RXNT Billing Export Guide (BETA)

Getting Started

If your organization is interested in an ongoing export of your RXNT billing data, notify your RXNT account representative of your interest and provide them with the email address you will use to access your data. 

Note: The email address must be a Gmail or Gmail-based email address (Google Account) as the ongoing export will be provided through a secure web link hosted by Google. The email address does not need to be your primary email address. 

Access Your Data

Once we receive your email address, a web link will be provided to you so you can access the exports. To access the data associated with the URL, you will need to log into the Gmail account for the email address provided to RXNT. Alternatively, you will be prompted to sign in to the Gmail account associated with the email address provided to RXNT if you are logged out of all Gmail accounts prior to clicking on the URL.

Your export file will be updated daily at 8:00a ET and 3:00p ET. The exports will be provided in .csv format and will contain all records (not simply net new records). 

Note: If you prefer to access the data via code, please notify your RXNT account representative. They will schedule a technical consultation to assess the feasibility of this option for your organization. 

Data Elements

The following data elements will be available in the export: 

  • doctor_company_id
  • billing_event_type
  • claim_id
  • claim_status_id
  • claim_status_date
  • era_payment_claim_status_code_id
  • encounter_id
  • display_encounter_id
  • encounter_created_date
  • charge_created_by
  • encounter_detail_id
  • encounter_detail_charge_id
  • encounter_detail_status_code
  • encounter_charge_id
  • charge_type
  • place_of_service
  • service_facility_location_id
  • service_date_from
  • service_date_to
  • batch_date
  • initial_billed_date
  • charge_created_date
  • responsible_payer
  • responsible_party_code
  • rendering_provider
  • rendering_provider_npi
  • rendering_provider_last_name
  • rendering_provider_first_name
  • rendering_provider_entity_name
  • billing_provider_last_name
  • billing_provider_first_name
  • billing_provider_entity_name
  • billing_provider_npi
  • billing_provider
  • supervising_provider_last_name
  • supervising_provider_first_name
  • supervising_provider_middle_initial
  • attending_provider_last_name
  • attending_provider_first_name
  • attending_provider_middle_initial
  • scheduling_provider_last_name
  • scheduling_provider_first_name
  • scheduling_provider_middle_initial
  • scheduling_provider
  • referring_provider_last_name
  • referring_provider_first_name
  • referring_provider_middle_initial
  • procedure_code
  • procedure_name
  • revenue_code
  • dx_A
  • dx_B
  • dx_C
  • dx_D
  • M1
  • M2
  • M3
  • M4
  • charge_amount
  • unit_charge_amount
  • units
  • anesthesia_start_time
  • anesthesia_end_time
  • encounter_fee_schedule_name
  • expected_rate
  • patient_id
  • patient_dob
  • patient_chart_number
  • patient_last_name
  • patient_first_name
  • patient_middle_initial
  • patient_gender
  • patient_street_address_1
  • patient_street_address_2
  • patient_city
  • patient_state
  • patient_zipcode
  • patient_home_phone
  • patient_work_phone
  • patient_cell_phone
  • payer_name
  • primary_insurance_policy_number
  • primary_insurance_group_number
  • primary_insurance_name
  • primary_insurance_phone
  • secondary_insurance_name
  • tertiary_insurance_name
  • payment_id
  • payment_reference
  • is_posted
  • payment_created_date
  • Payment Created By (Coming Soon!)
  • payment_date
  • posted_date
  • payment_method
  • allowed_amount
  • disallowed_amount
  • payment_amount
  • deductible_amount
  • co_insurance_amount
  • co_payment_amount
  • writeoff_amount
  • total_adjustment_amount
  • adjustment_codes
  • reason_code
  • penalty
  • payment_date
  • payment_date
  • charge_is_self_pay
  • resubmission_code_type_id
  • payment_responsible_party_id
  • payment_transaction_code
  • payment_reference
  • transaction_type_code
  • is_denial
  • patient_responsibility_amount
  • leave_open
  • insurance_encounter_detail_payment_id
  • insurance_misc_payment_id
  • patient_encounter_detail_payment_id
  • patient_encounter_misc_payment_id
  • patient_fund_detail_id

If you are interested in RXNT exposing further details in the export, submit an idea to RXNT via email at ideas-PM-rxnt@mailer.aha.io with the subject “RXNT Daily Export” and the field name(s) you’d like to see in the export. These ideas will be considered as they are received and prioritized based on the overall demand for the additional fields. 

Leverage Your Data

Billing Event Type

The column for Billing Event Type describes the type of data found in each row of the data export. There are 7 possible values that fall into two types of rows, payment rows and charge rows. 

Payment Rows:

When building reports or calculations for payments, use payment rows. You can combine these different payment row types into a single report or calculation as needed (or choose only one payment row type if required). For the charge data related to each payment row, you will find the relevant charge data in the columns of the payment row - this can be helpful for identifying payment/charge relationships but isn’t recommended for charge-related calculations. 

  • Insurance Payment
  • Misc Insurance Payment
  • Patient Payment
  • Misc Patient Payment
  • Patient Fund Payment

Charge Rows:

When building reports or calculations for charge-related inquiries, use only charge rows. Payment rows will not provide accurate overall charge reporting, because charges without an associated payment will not appear in the payment rows. Also, attempting to combine Charge and Payment row types in the same reporting will provide incorrect charge calculations - charges that have received a corresponding payment will appear twice.

  • Billed Charge
  • Unbilled Charge
Was this article helpful?
0 out of 0 found this helpful