| cetcc_id | int(11) | NO | | PRI | auto_increment | |
| cetcc_cus_id | int(11) | NO | | | | |
| cetcc_cli_id | int(11) | NO | | | | |
| cetcc_cet_id | int(11) | NO | | MUL | | Associated configured encounter template |
| cetcc_order | int(11) | NO | | | | Order priority of code |
| cetcc_cpt_id | int(11) | NO | | MUL | | |
| cetcc_cs_id | int(11) | NO | | | | |
| cetcc_code | varchar(15) | NO | | MUL | | |
| cetcc_desc | varchar(40) | NO | | | | |
| cetcc_rev_code | varchar(4) | NO | | | | |
| cetcc_date_of_service | datetime | YES | | MUL | | Date of service |
| cetcc_date_of_service_to | datetime | YES | | MUL | | Date of service to |
| cetcc_num_units | varchar(5) | NO | 1 | | | |
| cetcc_num_units_type | varchar(2) | NO | UN | | | Unit Type (UN, MJ, DA) |
| cetcc_no_unit_multiply | tinyint(1) | NO | 0 | | | |
| cetcc_mod1 | varchar(2) | NO | | | | |
| cetcc_mod2 | varchar(2) | NO | | | | |
| cetcc_mod3 | varchar(2) | NO | | | | |
| cetcc_mod4 | varchar(2) | NO | | | | |
| cetcc_note | varchar(80) | NO | | | | |
| cetcc_ndc | tinyint(1) | NO | 0 | | | |
| cetcc_ndc_unit_count | varchar(10) | NO | | | | |
| cetcc_ndc_units_of_measure | varchar(2) | NO | | | | |
| cetcc_noc | varchar(80) | NO | | | | |
| cetcc_ub04 | tinyint(1) | NO | 0 | | | UB04 |
| cetcc_billing_only | tinyint(1) | NO | 0 | | | Billing Only Indicator |
| cetcc_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| cetcc_created | timestamp | YES | CURRENT_TIMESTAMP | | | |