| ccarc_id | int(11) | NO | | PRI | auto_increment | primary key |
| ccarc_cli_id | int(11) | NO | | | | Client id |
| ccarc_cus_id | int(11) | NO | | | | Customer id |
| ccarc_code | varchar(3) | NO | | MUL | | Match CARCs in common database |
| ccarc_desc | text | NO | | | | Description of CARCs matches CARCs in common database |
| ccarc_mnemonic | text | NO | | | | Mnemonic for CARC set by customer |
| ccarc_denial | tinyint(1) | NO | 0 | | | Indicates whether CARC should be denied 1:denial 0:not denial |
| ccarc_billing_code | int(11) | YES | | | | |
| ccarc_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| ccarc_created | timestamp | YES | CURRENT_TIMESTAMP | | | |