Claims Export

The Claims Export extracts data related to patient claims  Below you will find a detailed definition of possible inputs and outputs.  

Data Location:  Billing > Billing Account Query > Claim

Inputs

  •  Start Date: Beginning encounter date
  • End Date:  Ending encounter date range
  • Submission:  Flag to indicate if the claim has been submitted
  • Status:  List of claim statuses to filter by
  • Claim Sub Status: List of claim sub statuses to filter by.
  • Payer: List of primary payers to filter by.
  • Location: List of service locations to filter by.
  • Rendering: List of rendering providers to filter by
  • Referring: List of referring providers to filter by
  • Supervising: List of supervising providers to filter by
  • Ordering: List of ordering providers to filter by
  • Owner: List of claim owners to filter by

Outputs

  • Claim_Number:  Unique ID for the claim
  • DOS:  Date of service
  • Submission:  Date of the last claim submission to the payer or the patient (via a statement).
  • Status:  Status of the claim
  • Sub_Status:  Sub_status of the claim
  • Billing:  How the claim was billed - Electronic or Paper
  • Level:  Level of the claim.  Primary, Secondary, Tertiary, Statement, Completed
  • Owner: User ID of the claim owner
  • Primary_Insurance:  Name and Address of the primary payer on the claim.
  • Secondary_Insurance: Name and Address of the secondary payer on the claim.
  • Tertiary_Insurance: Name and Address of the tertiary payer on the claim.
  • Chart_Number:  Patient unique ID.  
  • Last_Name: Patient last name
  • First_Name:  Patient first name
  • Charge:  Total of all charges on the claim
  • Balance:  Total outstanding balance on the claim
  • Resp_Party: Name of the responsible party on the claim
  • Aging_date:  Date the claim began aging
  • Aging_days:  Number of days that the claim has been aging
  • Rendering: Name of rendering provider
  • Referring: Name of referring provider
  • Supervising: Name of supervising provider
  • Ordering: Name of ordering provider
  • Purchasing: Name of purchasing provider
  • Attending: Name of attending provider
  • Service_Location: Name of the service location
  • Admission_date:  Date of admission
  • Discharge_Date:  Date of discharge
  • Onset_date:  Date of onset
  • Menstrural_date:  Date of last menstrual period
  • Accident_Date:  Date of accident
  • Accident_State: State where accident occurred
  • Accident_Country:  Country where accident occurred
  • EPSDT:  Early and Periodic Screening, Diagnostic and Treatment date
  • EPSDT_Code_1: Early and Periodic Screening, Diagnostic and Treatment primary code
  • EPSDT_Code_2:  Early and Periodic Screening, Diagnostic and Treatment secondary code