| ecs_id | int(11) | NO | | PRI | auto_increment | |
| ecs_cus_id | int(11) | NO | 0 | | | Customer ID# |
| ecs_cli_id | int(11) | NO | 0 | MUL | | Client ID# |
| ecs_enc_id | int(11) | NO | 0 | MUL | | Encounter ID# |
| ecs_process_date | date | YES | | | | date the status was processed by clearing house or payer |
| ecs_clh_id | int(11) | NO | 0 | MUL | | Clearing House ID# |
| ecs_ins_id | int(11) | NO | 0 | MUL | | Insurance ID# |
| ecs_ins_type | tinyint(4) | NO | 0 | | | Pri Sec or Tert Insurance |
| ecs_ins_name | varchar(255) | NO | | | | Insurance Name, prioritize id if provided |
| ecs_ins_payer_id | varchar(5) | NO | | | | Insurance Payer ID |
| ecs_accepted | char(1) | NO | | | | 1 = accepted, other values indicates rejected |
| ecs_cscc_id | int(11) | NO | 0 | MUL | | Claim Status Category Code ID# |
| ecs_csc_id | int(11) | NO | 0 | MUL | | Claim Status Code ID# |
| ecs_note | varchar(255) | NO | | | | Status note |
| ecs_archived | tinyint(1) | YES | 0 | MUL | | indicates that status has been acknowledged and should not be include in any processing |
| ecs_path | text | YES | | | | source location of data |
| ecs_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| ecs_created | timestamp | YES | CURRENT_TIMESTAMP | | | |