If your organization is interested in receiving an ongoing export of your RXNT billing data, contact your RXNT account representative to request access and provide the email address that will be used to retrieve your data. This email must be a Gmail or Gmail-based (Google Account) address, since the ongoing export is delivered through a secure Google-hosted web link. The email you provide does not need to be your primary address, any valid Google Account will work.
Access your data
Once RXNT receives your email address, a secure web link will be provided so you can access your exports. You must be logged into the Gmail account associated with the email address provided to RXNT in order to open the link. If you are not logged into any Gmail accounts, you will be prompted to sign in when clicking the URL.
Your export file updates three times daily, at 12:00 a.m. ET, 8:00 a.m. ET, and 3:00 p.m. ET. Exports are delivered in .csv format and include all records, not just newly added data.
Data elements
The following data elements will be included in the export:
- adjustment_codes
- adjustment_codes_ins
- admission_date
- admission_hour
- admission_source
- admission_type
- allowed_amount
- anesthesia_end_hour
- anesthesia_procedure
- anesthesia_start_hour
- attending_NPI
- attending_provider
- attending_provider_first_name
- attending_provider_last_name
- attending_provider_middle_initial
- batch_date
- billing_event_type
- billing_provider
- billing_provider_entity_name
- billing_provider_first_name
- billing_provider_last_name
- billing_provider_npi
- case_description
- case_id
- case_name
- case_prior_authorization_code
- case_type
- charge_amount
- charge_created_by
- charge_created_date
- charge_is_self_pay
- charge_type
- claim_adjustment_reason
- claim_external_id
- claim_form_type
- claim_form_type_code
- claim_id
- claim_priority
- claim_sent_date
- claim_status
- claim_status_date
- claim_status_id
- claim_validation_status
- co_insurance_amount
- co_payment_amount
- corporate_company_id
- CPT_code_description
- created_by
- created_by_login_id
- deductible_amount
- disallowed_amount
- discharge_hour
- discharge_status
- display_encounter_id
- doctor_company_id
- doctor_company_name
- dx_A
- dx_B
- dx_C
- dx_D
- encounter_charge_id
- encounter_created_date
- encounter_detail_charge_id
- encounter_detail_id
- encounter_detail_status_code
- encounter_fee_schedule_name
- encounter_icd_type
- encounter_id
- encounter_status
- EPSDT
- EPSDT_condition_indicator
- era_payment_claim_status_code_id
- expected_rate
- external_encounter_id
- external_payment_id
- external_reference_encounter_id
- financial_class_active
- financial_class_active_responsible_party
- financial_class_name
- financial_class_name_responsible_party
- financial_class_payer
- financial_class_responsible_party_name
- health_insurance_type_name
- inactivated_by
- inactivated_date
- initial_billed_date
- insurance_encounter_detail_payment_id
- insurance_misc_payment_id
- is_assignment_accepted
- is_denial
- is_posted
- is_unsettled_encounter
- last_claim_status
- leave_open
- line_item_EMG
- line_item_EPSDT
- line_item_noncovered_charge
- line_item_payer_electronic_id
- line_item_payer_group_number
- line_item_payer_id
- line_item_payer_phone
- line_item_payment_responsible_party
- line_item_place_of_service
- line_item_purchase_service_provider
- line_item_referring_provider
- line_item_rendering_provider
- line_item_res_party_type
- line_item_responsible_payer_policy_number
- line_item_service_date
- line_item_service_to_date
- line_item_status
- line_of_business
- lis_patientid
- M1
- M2
- M3
- M4
- master_case_prior_authorization_todate
- master_cpt_code
- modified_by
- modified_date
- noof_visits
- operating_physician
- operating_physician_npi
- other_operating_physician
- other_operating_physician_npi
- paid_by
- patient
- patient_cell_phone
- patient_chart_number
- patient_city
- patient_dob
- patient_encounter_detail_payment_id
- patient_encounter_misc_payment_id
- patient_first_name
- patient_fund_detail_id
- patient_gender
- patient_gender
- patient_guarantor_pat_report
- patient_home_phone
- patient_id
- patient_last_name
- patient_middle_initial
- patient_other_phone
- patient_responsibility_amount
- patient_state
- patient_street_address_1
- patient_street_address_2
- patient_type
- patient_work_phone
- patient_zipcode
- payer_electronic_id
- payer_group_number
- payer_id
- payer_name
- payer_phone
- payer_policy_number
- payment_amount
- payment_created_by
- payment_created_by_login_id
- payment_created_date
- payment_date
- payment_id
- payment_method
- payment_patient_id
- payment_reference
- payment_responsible_party
- payment_responsible_party_id
- payment_transaction_code
- penalty
- person_relationship
- place_of_service
- posted_date
- primary_insurance_group_number
- primary_insurance_name
- primary_insurance_phone
- primary_insurance_policy_number
- primary_responsible_payer
- prior_authorization_number
- procedure_code
- procedure_code_id
- procedure_name
- ready_to_bill_date
- reason_code
- referring_NPI
- referring_provider
- referring_provider_first_name
- referring_provider_last_name
- referring_provider_middle_initial
- remaining_visits
- rendering_provider
- rendering_provider_ein
- rendering_provider_entity_name
- rendering_provider_first_name
- rendering_provider_last_name
- rendering_provider_npi
- responsible_party_code
- responsible_party_type_id
- responsible_payer
- resubmission_code_type_id
- revenue_code
- scheduling_npi
- scheduling_provider
- scheduling_provider_first_name
- scheduling_provider_last_name
- scheduling_provider_middle_initial
- secondary_insurance_name
- service_date_from
- service_date_to
- service_facility_location_id
- service_facility_location_id_external
- supervising_NPI
- supervising_physician
- supervising_provider_first_name
- supervising_provider_last_name
- supervising_provider_middle_initial
- tertiary_insurance_name
- total_adjustment_amount
- TotalCharges
- transaction_type_code
- UB04_location_type
- unit_charge_amount
- units
- writeoff_amount
If you would like RXNT to include additional details in the export, you can submit an idea by emailing ideas-PM-rxnt@mailer.aha.io with the subject line “RXNT Daily Export” and listing the field name(s) you’d like added. Each request is reviewed as it comes in and prioritized based on overall demand for those fields.
Leverage your data
Billing event type
The Billing Event Type column identifies the type of data contained in each row of the export file. There are seven possible values, which fall into two main categories: payment rows and charge rows.
Payment Rows:
When building reports or running calculations related to payments, you should use payment rows. You can combine multiple payment row types in a single report or calculation if needed, or focus on just one type when appropriate. Each payment row also includes charge-related data within its columns. While this information can help you match payments to their associated charges, it is not recommended for use in charge-based calculations, as the charge-specific data is best derived from the actual charge rows.
- Insurance Payment
- Misc Insurance Payment
- Unapplied Insurance Payment
- Patient Payment
- Misc Patient Payment
- Unapplied Patient Payment
- Patient Fund Payment
Charge Rows:
When creating reports or performing calculations related to charges, be sure to use only charge rows. Payment rows do not provide complete charge information, since any charge without an associated payment will not appear in those rows. Additionally, combining charge and payment row types in the same report will lead to inaccurate results—charges that have received a payment will appear twice, inflating your charge totals.
- Billed Charge
- Unbilled Charge
Still, need help? Contact us!
Have a great idea? Tell us about it!