| ccd_cli_id | int(11) | NO | | PRI | | One to One with Client ID# |
| ccd_sales_rep_usr_id | int(11) | NO | 0 | | | User ID# of Sales rep who created the contract |
| ccd_follow_up_usr_id | int(11) | NO | 0 | | | User ID# of customer engagement |
| ccd_implementation_specialist_usr_id | int(11) | YES | | MUL | | User ID# of implementation specialist |
| ccd_first_invoice_date | date | YES | | | | First Invoice Date |
| ccd_contract_execution_date | date | YES | | | | Date Contract Signed |
| ccd_contract_renewal_date | date | YES | | | | Date Contract Renewed |
| ccd_go_live_date | date | YES | | | | Client GO Live date |
| ccd_term_length | int(11) | NO | 0 | | | Length of term in months |
| ccd_setup_fee | decimal(12,2) | YES | | | | Cost to client to setup client application |
| ccd_rcm_rate_pct | decimal(5,4) | YES | | MUL | | RCM % Rate |
| ccd_rcm_minimum | decimal(12,2) | YES | | MUL | | RCM Mimimum Amount |
| ccd_projected_monthly_avg_revenue | decimal(12,2) | YES | | MUL | | Projected average monthly revenue for none RCM clients |
| ccd_migration_date | date | YES | | | | Date migrated from previous company to Azalea |
| ccd_migration_company_id | int(11) | NO | 0 | | | 1: Simplify MD |
| ccd_original_contract_execution_date | date | YES | | | | Contract start date with previous company |
| ccd_invoicing_method | tinyint(4) | NO | 0 | | | Preferred Invoicing Method 1: email, 2: mail |
| ccd_payment_method | tinyint(4) | NO | 0 | | | 1: check, 2: credit card, 3: ACH |
| ccd_payer_is_same_as_client | tinyint(1) | NO | 1 | | | Bill is sent to client |
| ccd_payer_name | varchar(40) | NO | | | | Payer for client |
| ccd_payer_email | varchar(80) | NO | | | | Payer email |
| ccd_payer_address1 | varchar(40) | NO | | | | Payer address |
| ccd_payer_address2 | varchar(40) | NO | | | | Payer address line 2 |
| ccd_payer_city | varchar(30) | NO | | | | Payer city |
| ccd_payer_state | varchar(2) | NO | | | | Payer state |
| ccd_payer_zip | varchar(5) | NO | | | | Payer zip |
| ccd_payer_zip_plus4 | varchar(4) | NO | | | | Payer zip extension |
| ccd_payer_phone | varchar(20) | NO | | | | Payer phone |
| ccd_payer_contact | varchar(40) | NO | | | | Payer contact name |
| ccd_at_risk_date | date | YES | | | | Date client started to be at risk |
| ccd_no_fly_date | date | YES | | | | Date client fell to no fly status |
| ccd_churn_letter_received_date | date | YES | | | | Date Termination letter received |
| ccd_churn_reason | varchar(256) | NO | | | | Termination Reason |
| ccd_finance_churn_letter_date | date | YES | | | | Date Termination letter sent |
| ccd_churning_date | date | YES | | | | Date Client Terminated |
| ccd_churned_date | date | YES | | | | Date client completely churned |
| ccd_collections_date | date | YES | | | | Date Client sent to collections |
| ccd_collection_agency | varchar(40) | NO | | | | Collection Agency |
| ccd_sent_to_legal_date | date | YES | | | | Date client sent to legal |
| ccd_termination_notes | text | YES | | | | Details relating to client termination |
| ccd_follow_up_notes | text | YES | | | | Details relating to client follow up |
| ccd_finance_notes | text | YES | | | | Details relating to client finances |
| ccd_at_risk_notes | text | YES | | | | |
| ccd_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| ccd_created | timestamp | YES | CURRENT_TIMESTAMP | | | |
| ccd_rcm_coordinator_usr_id | int(11) | YES | | MUL | | User ID# of rcm coordinator |
| ccd_collections_method | varchar(20) | NO | | | | active_col: Active Collections, active_ins_col: Active & Ins Collections, all_col: All Collections |