| pre_id | int(11) | NO | | PRI | auto_increment | |
| pre_cus_id | int(11) | NO | 0 | MUL | | |
| pre_cli_id | int(11) | NO | 0 | MUL | | |
| pre_diag_cs_id | int(11) | NO | 2 | MUL | | |
| pre_pat_id | int(11) | NO | 0 | MUL | | |
| pre_phy_id | int(11) | NO | 0 | MUL | | |
| pre_phy_id_referring | int(11) | NO | 0 | MUL | | |
| pre_precert_num | varchar(20) | NO | | | | |
| pre_pid | varchar(20) | NO | | MUL | | |
| pre_mrn | varchar(20) | NO | | | | |
| pre_ssn | varchar(11) | NO | | | | |
| pre_fname | varchar(20) | NO | | | | |
| pre_mname | varchar(20) | NO | | | | |
| pre_lname | varchar(20) | NO | | | | |
| pre_suffix | varchar(10) | NO | | | | |
| pre_email | varchar(80) | NO | | | | |
| pre_bill_type | char(1) | NO | | | | |
| pre_dob | varchar(8) | NO | | | | |
| pre_age | varchar(3) | NO | | | | |
| pre_sex | varchar(7) | NO | | | | |
| pre_race | varchar(50) | NO | | | | |
| pre_maritial_status | varchar(15) | NO | | | | |
| pre_address1 | varchar(40) | NO | | | | |
| pre_address2 | varchar(40) | NO | | | | |
| pre_city | varchar(30) | NO | | | | |
| pre_state | varchar(2) | NO | | | | |
| pre_zip | varchar(5) | NO | | | | |
| pre_zip_plus4 | varchar(4) | NO | | | | |
| pre_phone | varchar(20) | NO | | | | |
| pre_phone_work | varchar(20) | NO | | | | |
| pre_phone_other | varchar(20) | NO | | | | |
| pre_fax | varchar(20) | NO | | | | |
| pre_employer | varchar(40) | NO | | | | |
| pre_employer_occupation | varchar(30) | NO | | | | |
| pre_employer_status | varchar(30) | NO | | | | |
| pre_employer_address1 | varchar(40) | NO | | | | |
| pre_employer_city | varchar(30) | NO | | | | |
| pre_employer_state | varchar(2) | NO | | | | |
| pre_employer_zip | varchar(5) | NO | | | | |
| pre_employer_zip_plus4 | varchar(4) | NO | | | | |
| pre_guarantor | varchar(40) | NO | | | | |
| pre_guarantor_relation | varchar(20) | NO | | | | |
| pre_guarantor_address1 | varchar(40) | NO | | | | |
| pre_guarantor_address2 | varchar(40) | NO | | | | |
| pre_guarantor_city | varchar(30) | NO | | | | |
| pre_guarantor_state | varchar(2) | NO | | | | |
| pre_guarantor_zip | varchar(5) | NO | | | | |
| pre_guarantor_zip_plus4 | varchar(4) | NO | | | | |
| pre_guarantor_phone | varchar(20) | NO | | | | |
| pre_guarantor_phone_work | varchar(20) | NO | | | | |
| pre_guarantor_employer | varchar(40) | NO | | | | |
| pre_guarantor_dob | varchar(8) | NO | | | | |
| pre_guarantor_ssn | varchar(11) | NO | | | | |
| pre_ins1_id | int(11) | NO | | | | |
| pre_ins1_policy_num | varchar(40) | NO | | | | |
| pre_ins1_group_num | varchar(40) | NO | | | | |
| pre_ins1_start_date | varchar(8) | NO | | | | |
| pre_ins1_end_date | varchar(8) | NO | | | | |
| pre_ins1_insured | varchar(40) | NO | | | | |
| pre_ins1_insured_relation | varchar(20) | NO | | | | |
| pre_ins1_insured_dob | varchar(8) | NO | | | | |
| pre_ins1_insured_ssn | varchar(11) | NO | | | | |
| pre_ins1_insured_sex | varchar(7) | NO | | | | |
| pre_ins1_employer_name | varchar(40) | NO | | | | |
| pre_ins1_employer_address | varchar(40) | NO | | | | |
| pre_ins1_employer_city | varchar(30) | NO | | | | |
| pre_ins1_employer_state | varchar(2) | NO | | | | |
| pre_ins1_employer_zip | varchar(5) | NO | | | | |
| pre_ins1_employer_zip_plus4 | varchar(4) | NO | | | | |
| pre_ins1_referral_num | varchar(40) | NO | | | | |
| pre_ins1_referral_start_date | varchar(8) | NO | | | | |
| pre_ins1_referral_end_date | varchar(8) | NO | | | | |
| pre_ins1_referral_num_visits | varchar(3) | NO | | | | |
| pre_ins1_in_network | tinyint(1) | NO | 1 | | | Indicates that Provider is in/out of network with primary ins |
| pre_ins2_id | int(11) | NO | | | | |
| pre_ins2_policy_num | varchar(40) | NO | | | | |
| pre_ins2_group_num | varchar(40) | NO | | | | |
| pre_ins2_start_date | varchar(8) | NO | | | | |
| pre_ins2_end_date | varchar(8) | NO | | | | |
| pre_ins2_insured | varchar(40) | NO | | | | |
| pre_ins2_insured_relation | varchar(20) | NO | | | | |
| pre_ins2_insured_dob | varchar(8) | NO | | | | |
| pre_ins2_insured_ssn | varchar(11) | NO | | | | |
| pre_ins2_insured_sex | varchar(7) | NO | | | | |
| pre_ins2_employer_name | varchar(40) | NO | | | | |
| pre_ins2_employer_address | varchar(40) | NO | | | | |
| pre_ins2_employer_city | varchar(30) | NO | | | | |
| pre_ins2_employer_state | varchar(2) | NO | | | | |
| pre_ins2_employer_zip | varchar(5) | NO | | | | |
| pre_ins2_employer_zip_plus4 | varchar(4) | NO | | | | |
| pre_ins2_in_network | tinyint(1) | NO | 1 | | | Indicates that Provider is in/out of network with secondary ins |
| pre_date_of_service | varchar(8) | NO | | | | |
| pre_acs_id | int(11) | NO | | MUL | | |
| pre_date_scheduled | varchar(12) | NO | | | | |
| pre_date_scheduled_on | varchar(8) | NO | | | | |
| pre_ts_date_scheduled | int(11) | NO | | | | |
| pre_scheduled_location | varchar(100) | NO | | | | |
| pre_visit_time | varchar(3) | NO | | | | |
| pre_loc_id | int(11) | NO | | | | |
| pre_spl_id | int(11) | NO | | | | |
| pre_sty_id | int(11) | NO | | | | |
| pre_pss_id | int(11) | NO | | MUL | | |
| pre_ps_id | int(11) | NO | 0 | | | |
| pre_notes | text | NO | | | | |
| pre_employment_related | char(1) | NO | 0 | | | |
| pre_auto_accident | char(1) | NO | 0 | | | |
| pre_auto_accident_state | varchar(2) | NO | | | | |
| pre_other_accident | char(1) | NO | 0 | | | |
| pre_current_type | char(1) | NO | 0 | | | |
| pre_date_of_current | varchar(8) | NO | | | | |
| pre_first_date | varchar(8) | NO | | | | |
| pre_unable_to_work_from | varchar(8) | NO | | | | |
| pre_unable_to_work_to | varchar(8) | NO | | | | |
| pre_hospitalized_from | varchar(8) | NO | | | | |
| pre_hospitalized_to | varchar(8) | NO | | | | |
| pre_outside_lab | char(1) | NO | 0 | | | |
| pre_outside_lab_charges | varchar(10) | NO | | | | |
| pre_billing_date | varchar(8) | NO | | | | |
| pre_ts_created | int(11) | NO | | | | |
| pre_stat | char(1) | NO | | | | |
| pre_outpatient | tinyint(1) | NO | 1 | | | Indicates if visit is inpatient or outpatient |
| pre_usr_id_modified | int(11) | NO | 0 | MUL | | Creating User ID# |
| pre_usr_id_created | int(11) | NO | 0 | MUL | | Creating User ID# |
| pre_cus_id_to | int(11) | NO | | MUL | | |
| pre_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| pre_created | timestamp | YES | CURRENT_TIMESTAMP | | | |
| pre_ins1_total_deduc | decimal(10,2) | YES | | | | Primary Insurance Total Deductible |
| pre_ins1_rem_deduc | decimal(10,2) | YES | | | | Primary Insurance Remaining Deductible |
| pre_ins1_total_oop | decimal(10,2) | YES | | | | Primary Insurance Total Out of Pocket |
| pre_ins1_oop_rem_bal | decimal(10,2) | YES | | | | Primary Insurance Out of Pocket Remaining Balance |
| pre_ins1_coins | decimal(4,3) | YES | | | | Primary Insurance CoInsurance |
| pre_ins2_total_deduc | decimal(10,2) | YES | | | | Secondary Insurance Total Deductible |
| pre_ins2_rem_deduc | decimal(10,2) | YES | | | | Secondary Insurance Remaining Deductible |
| pre_ins2_total_oop | decimal(10,2) | YES | | | | Secondary Insurance Total Out of Pocket |
| pre_ins2_oop_rem_bal | decimal(10,2) | YES | | | | Secondary Insurance Out of Pocket Remaining Balance |
| pre_ins2_coins | decimal(4,3) | YES | | | | Secondary Insurance CoInsurance |