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
