| cp_id | int(11) | NO | | PRI | auto_increment | |
| cp_cus_id | int(11) | NO | | MUL | | |
| cp_cli_id | int(11) | NO | | MUL | | |
| cp_pat_id | int(11) | NO | | MUL | | |
| cp_enc_id | int(11) | NO | | MUL | | |
| cp_cs_id | int(11) | NO | 4 | MUL | | code system id for procedure |
| cp_code | varchar(45) | NO | | MUL | | |
| cp_code_id | bigint(20) | NO | 0 | MUL | | code system id for procedure |
| cp_desc | varchar(256) | NO | | | | |
| cp_num_units | decimal(6,3) | NO | 0.000 | | | Number of units. Most often used for injections |
| cp_mod1 | varchar(2) | NO | | | | Modifier 1 |
| cp_mod2 | varchar(2) | NO | | | | Modifier 2 |
| cp_mod3 | varchar(2) | NO | | | | Modifier 3 |
| cp_mod4 | varchar(2) | NO | | | | Modifier 4 |
| cp_test_date | varchar(45) | NO | | | | |
| cp_end_ts | varchar(12) | NO | | | | end datetime of chart procedure |
| cp_end_dt | datetime | YES | | | | end datetime of chart procedure |
| cp_start_dt | datetime | YES | | | | start datetime of chart procedure |
| cp_notes | text | NO | | | | |
| cp_disabled | char(1) | NO | | MUL | | |
| cp_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| cp_created | timestamp | YES | CURRENT_TIMESTAMP | | | |
| cp_not_done_cs_id | int(11) | YES | | | | code system id for not done reason |
| cp_not_done_code | varchar(45) | NO | | | | code for not done reason |
| cp_not_done_desc | varchar(256) | NO | | | | description for not done reason |