| pds_id | int(11) | NO | | PRI | auto_increment | |
| pds_cus_id | int(11) | NO | 0 | MUL | | |
| pds_cli_id | int(11) | NO | 0 | MUL | | |
| pds_pat_id | int(11) | NO | 0 | | | |
| pds_phy_id | int(11) | NO | 0 | MUL | | |
| pds_phy_id_referring | int(11) | NO | 0 | MUL | | |
| pds_phy_id_requested | int(11) | NO | | MUL | | |
| pds_ref_to | char(1) | NO | | | | |
| pds_ref_id | int(11) | NO | | | | |
| pds_pid | varchar(20) | NO | | MUL | | |
| pds_pid_ext | varchar(60) | NO | | MUL | | |
| pds_mrn | varchar(20) | NO | | | | |
| pds_xray_num | varchar(20) | NO | | | | |
| pds_ssn | varchar(11) | NO | | MUL | | |
| pds_fname | varchar(20) | NO | | MUL | | |
| pds_mname | varchar(20) | NO | | | | |
| pds_lname | varchar(20) | NO | | MUL | | |
| pds_suffix | varchar(10) | NO | | | | |
| pds_email | varchar(80) | NO | | | | |
| pds_email_refuse | int(1) | NO | 0 | | | |
| pds_email_no_email | int(1) | NO | | | | |
| pds_bill_type | char(1) | NO | | | | |
| pds_dob | varchar(8) | NO | | MUL | | |
| pds_sex | varchar(7) | NO | | | | |
| pds_ethnicity | varchar(30) | NO | | | | |
| pds_lang_id | int(11) | NO | | | | |
| pds_maritial_status | varchar(15) | NO | | | | |
| pds_address1 | varchar(40) | NO | | | | |
| pds_address2 | varchar(40) | NO | | | | |
| pds_city | varchar(30) | NO | | | | |
| pds_state | varchar(2) | NO | | | | |
| pds_zip | varchar(5) | NO | | | | |
| pds_zip_plus4 | varchar(4) | NO | | | | |
| pds_phone | varchar(20) | NO | | | | |
| pds_phone_work | varchar(20) | NO | | | | |
| pds_phone_other | varchar(20) | NO | | | | |
| pds_fax | varchar(20) | NO | | | | |
| pds_health_exchange | char(1) | NO | 0 | | | |
| pds_health_exchange_opt | char(1) | NO | | | | |
| pds_contact_method | char(1) | NO | 0 | | | |
| pds_apt_not_contact_method | int(11) | NO | | | | |
| pds_employer | varchar(40) | NO | | | | |
| pds_employer_occupation | varchar(30) | NO | | | | |
| pds_employer_status | varchar(30) | NO | | | | |
| pds_employer_address1 | varchar(40) | NO | | | | |
| pds_employer_city | varchar(30) | NO | | | | |
| pds_employer_state | varchar(2) | NO | | | | |
| pds_employer_zip | varchar(5) | NO | | | | |
| pds_employer_zip_plus4 | varchar(4) | NO | | | | |
| pds_guarantor_linked_pat_id | int(11) | NO | | MUL | | |
| pds_guarantor_same_as_patient | char(1) | NO | | | | |
| pds_guarantor | varchar(40) | NO | | | | |
| pds_guarantor_relation | varchar(20) | NO | | | | |
| pds_guarantor_address1 | varchar(40) | NO | | | | |
| pds_guarantor_address2 | varchar(40) | NO | | | | |
| pds_guarantor_city | varchar(30) | NO | | | | |
| pds_guarantor_state | varchar(2) | NO | | | | |
| pds_guarantor_zip | varchar(5) | NO | | | | |
| pds_guarantor_zip_plus4 | varchar(4) | NO | | | | |
| pds_guarantor_phone | varchar(20) | NO | | | | |
| pds_guarantor_phone_work | varchar(20) | NO | | | | |
| pds_guarantor_employer | varchar(40) | NO | | | | |
| pds_guarantor_dob | varchar(8) | NO | | | | |
| pds_guarantor_ssn | varchar(11) | NO | | | | |
| pds_ins1_linked_pat_id | int(11) | NO | | MUL | | |
| pds_ins1_id | int(11) | NO | | MUL | | |
| pds_ins1_policy_num | varchar(40) | NO | | | | |
| pds_ins1_group_num | varchar(40) | NO | | | | |
| pds_ins1_copay | varchar(10) | NO | | | | |
| pds_ins1_start_date | varchar(8) | NO | | | | |
| pds_ins1_end_date | varchar(8) | NO | | | | |
| pds_ins1_insured_same_as_patient | char(1) | NO | | | | |
| pds_ins1_insured | varchar(40) | NO | | | | |
| pds_ins1_insured_relation | varchar(20) | NO | | | | |
| pds_ins1_insured_dob | varchar(8) | NO | | | | |
| pds_ins1_insured_ssn | varchar(11) | NO | | | | |
| pds_ins1_insured_sex | varchar(7) | NO | | | | |
| pds_ins1_employer_name | varchar(40) | NO | | | | |
| pds_ins1_employer_address | varchar(40) | NO | | | | |
| pds_ins1_employer_city | varchar(30) | NO | | | | |
| pds_ins1_employer_state | varchar(2) | NO | | | | |
| pds_ins1_employer_zip | varchar(5) | NO | | | | |
| pds_ins1_employer_zip_plus4 | varchar(4) | NO | | | | |
| pds_ins1_referral_num | varchar(40) | NO | | | | |
| pds_ins1_referral_start_date | varchar(8) | NO | | | | |
| pds_ins1_referral_end_date | varchar(8) | NO | | | | |
| pds_ins1_referral_num_visits | varchar(3) | NO | | | | |
| pds_ins1_verification_path | varchar(50) | NO | | | | |
| pds_ins2_linked_pat_id | int(11) | NO | | MUL | | |
| pds_ins2_id | int(11) | NO | | MUL | | |
| pds_ins2_policy_num | varchar(40) | NO | | | | |
| pds_ins2_group_num | varchar(40) | NO | | | | |
| pds_ins2_copay | varchar(10) | NO | | | | |
| pds_ins2_start_date | varchar(8) | NO | | | | |
| pds_ins2_end_date | varchar(8) | NO | | | | |
| pds_ins2_insured_same_as_patient | char(1) | NO | | | | |
| pds_ins2_insured | varchar(40) | NO | | | | |
| pds_ins2_insured_relation | varchar(20) | NO | | | | |
| pds_ins2_insured_dob | varchar(8) | NO | | | | |
| pds_ins2_insured_ssn | varchar(11) | NO | | | | |
| pds_ins2_insured_sex | varchar(7) | NO | | | | |
| pds_ins2_employer_name | varchar(40) | NO | | | | |
| pds_ins2_employer_address | varchar(40) | NO | | | | |
| pds_ins2_employer_city | varchar(30) | NO | | | | |
| pds_ins2_employer_state | varchar(2) | NO | | | | |
| pds_ins2_employer_zip | varchar(5) | NO | | | | |
| pds_ins2_employer_zip_plus4 | varchar(4) | NO | | | | |
| pds_ins3_linked_pat_id | int(11) | NO | | MUL | | |
| pds_ins3_id | int(11) | NO | | MUL | | |
| pds_ins3_policy_num | varchar(40) | NO | | | | |
| pds_ins3_group_num | varchar(40) | NO | | | | |
| pds_ins3_copay | varchar(10) | NO | | | | |
| pds_ins3_start_date | varchar(8) | NO | | | | |
| pds_ins3_end_date | varchar(8) | NO | | | | |
| pds_ins3_insured_same_as_patient | char(1) | NO | | | | |
| pds_ins3_insured | varchar(40) | NO | | | | |
| pds_ins3_insured_relation | varchar(20) | NO | | | | |
| pds_ins3_insured_dob | varchar(8) | NO | | | | |
| pds_ins3_insured_ssn | varchar(11) | NO | | | | |
| pds_ins3_insured_sex | varchar(7) | NO | | | | |
| pds_ins3_employer_name | varchar(40) | NO | | | | |
| pds_ins3_employer_address | varchar(40) | NO | | | | |
| pds_ins3_employer_city | varchar(30) | NO | | | | |
| pds_ins3_employer_state | varchar(2) | NO | | | | |
| pds_ins3_employer_zip | varchar(5) | NO | | | | |
| pds_ins3_employer_zip_plus4 | varchar(4) | NO | | | | |
| pds_incomplete | char(1) | NO | 0 | MUL | | |
| pds_notes | text | NO | | | | |
| pds_popup_notes | text | NO | | | | |
| pds_disabled | char(1) | NO | | MUL | | |
| pds_rcopia_id | varchar(24) | NO | | | | |
| pds_statement_disabled | char(1) | NO | | | | |
| pds_upa_id | int(11) | NO | | | | |
| pds_palg | char(1) | NO | | | | |
| pds_pms | char(1) | NO | | | | |
| pds_pip | char(1) | NO | | | | |
| pds_med_rec | char(1) | NO | 0 | | | |
| pds_sum_care | char(1) | NO | 0 | | | |
| pds_emergency_name | varchar(80) | NO | | | | |
| pds_emergency_number | varchar(14) | NO | | | | |
| pds_pecr_id | int(11) | NO | | MUL | | |
| pds_created | timestamp | YES | CURRENT_TIMESTAMP | | | |