Charges: Standard Extract Table
The Charges data table includes information on charges related to billable notes in the WebPT EMR. Key data points include CPT codes, number of units billed, and primary insurance.
| Data Element | Type | Description |
| record_id | Integer | ID for the record may not be unique |
| visit_date | Date | Date of the visit |
| record_pointer | Integer | Unique ID for the charge record |
| cpt | String | CPT Code |
| clinic_id | Integer | Reference to the clinic file on the clinic_id field |
| patient_id | Integer | Reference to the patient file for the patient_id field |
| case_id | Integer | Reference to the cases file for the case_id field |
| visit_id | Integer | Reference the visit file with the visit_id field |
| therapist_id | Integer | Reference to the therapist files on the therapist_id field |
| cosign_therapist_id | Integer | Reference to the therapist files on the therapist_id field |
| insurance_id | Integer | Reference to the patient insurance for the primary insurance on field patient_identity_id |
| insurance_type_id | integer | Reference the patient_insurance file on insurance_type_id field. 1 = HMO, 2 = PPO, 3 = Medicare, 4 = EPO, 5 = Self Pay, 6 = Medicaid, 7 = WCOMP, 8 = Tricare, 9 = Commercial, 10 = Auto/PIP, 11 = POS, 12 = GEHA, 13 = VA, 14 = Employer, 15 = Other, 16 = Medicare Replacement, 17 = BCBS |
| units | Integer | Number of units for the CPT |
| charge_amount | Numeric (20,2) | Amount for the CPT based off the fee schedule |
| cpt_code_id | Integer | Unique ID for the CPT code |
| client_id | Integer | Reference to the clinic file on the company_id field |
| note_type | String | Type of note associated with the charge, DN = Daily Note, IE = Initial Exam, PN = Progress Note, DS = Discharge |
| cpt_prefix | String | CPT Prefix |
| cpt_suffix | String | CPT Suffix |
| cpt_modifier | String | CPT Modifier |
| modified_date | Date | Date the charge record modified |
| note_finalized_date | Date | Date the note was finalized |
| PrimaryIns | Integer | Reference to the patient insurance for the primary insurance on field patient_identity_id |
| export_flag | Integer | Export flag 1 = New, 2 = Modified, 3 = Removed |
| discharge_date | Date | Date the case was discharged |