_436.charts_cpt_codes
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| chcp_id | int(11) | NO | PRI | auto_increment | ||
| chcp_cus_id | int(11) | NO | MUL | |||
| chcp_cli_id | int(11) | NO | MUL | |||
| chcp_pat_id | int(11) | NO | MUL | |||
| chcp_cpt_id | int(11) | NO | MUL | |||
| chcp_code | varchar(15) | NO | ||||
| chcp_desc | varchar(40) | NO | ||||
| chcp_rev_code | varchar(4) | NO | ||||
| chcp_date_of_service | varchar(8) | NO | ||||
| chcp_date_of_service_to | varchar(8) | NO | ||||
| chcp_num_units | varchar(3) | NO | 1 | |||
| chcp_mod1 | varchar(2) | NO | ||||
| chcp_mod2 | varchar(2) | NO | ||||
| chcp_mod3 | varchar(2) | NO | ||||
| chcp_mod4 | varchar(2) | NO | ||||
| chcp_note | varchar(80) | NO | ||||
| chcp_ndc | char(1) | NO | ||||
| chcp_ndc_unit_count | varchar(10) | NO | ||||
| chcp_ndc_units_of_measure | varchar(2) | NO | ||||
| chcp_authorization_num | varchar(60) | NO | ||||
| chcp_ub04 | char(1) | NO | ||||
| chcp_billing_only | char(1) | NO | 0 | |||
| chcp_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| chcp_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| chcp_id |
|