| rcmsg_id | int(11) | NO | | PRI | auto_increment | |
| rcmsg_cus_id | int(11) | NO | | MUL | | customer id |
| rcmsg_cli_id | int(11) | NO | | MUL | | client id |
| rcmsg_date | varchar(8) | NO | | MUL | | report run on date |
| rcmsg_from_date | varchar(8) | NO | | MUL | | starting date of values |
| rcmsg_to_date | varchar(8) | NO | | MUL | | ending date of values |
| rcmsg_days_in_ar | decimal(12,2) | NO | 0.00 | | | combined aging total / (pa sum of monthly gross billings [up to a year] / number of days [up to a year]) |
| rcmsg_payment_ratio | varchar(12) | NO | | | | pa total payments for month / pa gross billings for month = displayed as percent |
| rcmsg_payment_per_patient | decimal(12,2) | NO | 0.00 | | | pa total payments for month / this total encounters |
| rcmsg_total_encounters | int(11) | NO | 0 | | | total encounters for month by DOS, all statuses |
| rcmsg_hold_encounters_credit_balance | int(11) | NO | 0 | | | total encounters for month by DOS, all HOLD status with credit balances |
| rcmsg_incomplete_encounters | int(11) | NO | 0 | | | total encounters for month by DOS, all INCOMPLETE, EMR INCOMPLETE statuses |
| rcmsg_new_encounters | int(11) | NO | 0 | | | total encounters for month by DOS, all NEW status |
| rcmsg_unsigned_charts | int(11) | NO | 0 | | | total charts for month by DOS, all UNSIGNED status |
| rcmsg_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| rcmsg_created | timestamp | YES | CURRENT_TIMESTAMP | | | |