| ccp_id | int(11) | NO | | PRI | auto_increment | |
| ccp_cus_id | int(11) | NO | | MUL | | |
| ccp_cli_id | int(11) | NO | | MUL | | |
| ccp_pat_id | int(11) | NO | | MUL | | |
| ccp_enc_id | int(11) | NO | | MUL | | |
| ccp_type | int(11) | NO | | MUL | | |
| ccp_date | varchar(8) | NO | | | | |
| ccp_start_ts | varchar(12) | NO | | | | start datetime of care plan event |
| ccp_stop_dt | datetime | YES | | | | stop datetime of care plan event |
| ccp_referred_dt | datetime | YES | | | | date of referral |
| ccp_stop_ts | varchar(12) | NO | | | | stop datetime of care plan event |
| ccp_start_dt | datetime | YES | | | | start datetime of care plan event |
| ccp_code | varchar(40) | NO | | MUL | | |
| ccp_code_desc | varchar(256) | NO | | | | Code Description |
| ccp_cs_id | int(11) | NO | | MUL | | |
| ccp_phy_id | int(11) | NO | | MUL | | |
| ccp_desc | text | NO | | | | |
| ccp_priority | int(11) | YES | 0 | | | priority |
| ccp_referral_status | varchar(20) | YES | pending | | | status of associated referral |
| ccp_rep_rec | char(1) | NO | | | | |
| ccp_not_done_cs_id | int(11) | YES | | | | code system id for not done reason |
| ccp_not_done_code | varchar(45) | NO | | | | code for not done reason |
| ccp_not_done_desc | varchar(256) | NO | | | | description for not done reason |
| ccp_assigned_usr_id | int(11) | YES | | | | id of assigned user |
| ccp_assigned_grp_id | int(11) | YES | | MUL | | id of assigned group |
| ccp_disabled | char(1) | NO | | MUL | | |
| ccp_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| ccp_created | timestamp | YES | CURRENT_TIMESTAMP | | | |