Billing Charges: Standard Extract Table
The Billing Charges data table contains information pulled from RevFlow. Data points like the payers billed (primary, secondary, tertiary), current balance, adjustments, and age of charge are all available.
Data Element | Type | Description |
record_id | Integer | Unique ID for the billing charge record |
patient_account_number | Integer | ID that references the patient account number on the patient data |
date_of_service | DateTime | The date of service for the visit |
charge_date | DateTime | The date the charge was submitted |
charge_id | Integer | Unique ID for the charge record |
update_date | DateTime | Last updated date |
cpt_code | String | CPT Code for the charge record |
mod1 | String | Modifier to CPT Code |
mod2 | String | Modifier to CPT Code |
units | Integer | Number of Units billed |
cur_ins_code | Integer | Internal code for the current insurance |
cur_insurance_code | String | Current Insurance provider |
cur_insurance_class | String | Current Insurance class |
gpms_code | String | Company identifier |
charge_amount | Float | Charge Amount for the charge record |
company_id | Integer | Internal Revflow Company ID |
visit_id | Integer | Internal Revflow Visit ID |
place_of_service_id | Integer | Internal Revflow Place of Service ID |
treating_therapist_id | Integer | Internal Revflow Treating Provider ID |
webpt_treating_therapist_id | Integer | WebPT Internal Treating Therapist ID |
billing_therapist_id | Integer | Internal Revflow Billing Provider ID |
webpt_billing_therapist_id | Integer | WebPT Internal Billing Therapist ID |
md_code | String | Code of Referring Physician |
total_ins_pay_amt | Float | Total insurance payment amount |
total_pat_adj_amt | Float | Total patient adjustment amount |
cur_balance | Float | Current balance |
owed_amt | Float | Owed Amount |
total_pay_amt | Float | Total payed amount |
total_adj_amt | Float | total adjustment amount |
age_start_date | DateTime | Start date for aging |
total_ins_adj_amt | Float | total insurance adjustment amount |
total_pat_pay_amt | Float | total patient payment amount |
pri_ins_code | Integer | Internal Primary insurance Code |
primary_insurance_code | String | Primary Insurance provider |
primary_insurance_class | String | Primary Insurance class |
sec_ins_code | Integer | Internal Secondary insurance Code |
secondary_insurance_code | String | Secondary Insurance provider |
secondary_insurance_class | String | Secondary Insurance class |
ter_ins_code | Integer | Internal Tertiary insurance Code |
tertiary_insurance_code | String | Tertiary Insurance provider |
tertiary_insurance_class | String | Tertiary Insurance class |
cur_ins_class_desc | String | Current insurance class description |
cur_ins_name | String | Current insurance name |
pri_ins_class_desc | String | Primary insurance class description |
pri_ins_name | String | Primary insurance name |
sec_ins_class_desc | String | Secondary insurance class description |
sec_ins_name | String | Secondary insurance name |
ter_ins_class_desc | String | Tertiary insurance class description |
ter_ins_name | String | Tertiary insurance name |
cur_payer_id | Integer | Current Payer Id |
cur_payer_name | String | Current Payer |
cur_payer_desc | String | Current Payer Description |
pri_payer_id | Integer | Primary Payer Id |
pri_payer_name | String | Primary Payer |
pri_payer_desc | String | Primary Payer Description |
sec_payer_id | Integer | Secondary Payer Id |
sec_payer_name | String | Secondary Payer |
sec_payer_desc | String | Seconary Payer Description |
ter_payer_id | Integer | Tertiary Payer Id |
ter_payer_name | String | Tertiary Payer |
ter_payer_desc | String | Tertiary Payer Description |
status | String | Status |
revenue_center_id | Integer | Revenue Center Id |
export_flag | Integer | Export flag 1 = New, 2 = Modified, 3 = Removed |