| esp_id | int(11) | NO | | PRI | auto_increment | |
| esp_cus_id | int(11) | NO | | MUL | | |
| esp_cli_id | int(11) | NO | | MUL | | |
| esp_enc_id | int(11) | NO | | UNI | | |
| esp_pss_id | int(11) | NO | | MUL | | |
| esp_pss_status | tinyint(4) | NO | | | | |
| esp_chief_complaint | text | NO | | | | |
| esp_chief_complaint_display | text | NO | | | | |
| esp_subjective_pmh | text | NO | | | | |
| esp_subjective | text | NO | | | | |
| esp_subjective_family | text | NO | | | | |
| esp_subjective_surgical | text | NO | | | | |
| esp_subjective_social | text | NO | | | | |
| esp_subjective_systems | text | NO | | | | |
| esp_subjective_screening | text | NO | | | | |
| esp_subjective_misc | text | NO | | | | |
| esp_objective | text | NO | | | | |
| esp_assessment | text | NO | | | | |
| esp_procedure | text | NO | | | | |
| esp_plan | text | NO | | | | |
| esp_notes | text | NO | | | | |
| esp_clinical_summary | char(1) | NO | 0 | | | |
| esp_med_reconciliation | char(1) | NO | 0 | | | |
| esp_problems_reconciliation | tinyint(1) | NO | 0 | | | Indicates provider reconciled problems with the patient |
| esp_med_allergies_reconciliation | tinyint(1) | NO | 0 | | | Indicates provider reconciled medication allergies with the patient |
| esp_summary_care | char(1) | NO | 0 | | | |
| esp_addendum | int(11) | NO | 0 | MUL | | |
| esp_signed | char(1) | NO | | | | |
| esp_signed_by | int(11) | NO | | MUL | | |
| esp_signed_date | varchar(12) | NO | | | | |
| esp_reviewer_signed | char(1) | NO | | | | |
| esp_reviewer_signed_by | int(11) | NO | | MUL | | |
| esp_reviewer_signed_date | varchar(12) | NO | | | | |
| esp_phy_id_referring | int(11) | NO | | | | |
| esp_phy_id_assisting | int(11) | NO | | | | |
| esp_referring_reason | varchar(45) | NO | | | | |
| esp_referring_date | varchar(8) | NO | | | | |
| esp_vwc_id | int(11) | NO | | | | |
| esp_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| esp_created | timestamp | YES | CURRENT_TIMESTAMP | | | |
| esp_portal_viewable | char(1) | NO | | | | |