| rcmsa_id | int(11) | NO | | PRI | auto_increment | |
| rcmsa_cus_id | int(11) | NO | | MUL | | customer id |
| rcmsa_cli_id | int(11) | NO | | MUL | | client id |
| rcmsa_date | varchar(8) | NO | | MUL | | report run on date |
| rcmsa_to_date | varchar(8) | NO | | MUL | | ending date of report values |
| rcmsa_type | varchar(10) | NO | | MUL | | primary, secondary, patient, or combined |
| rcmsa_0_30_amount | decimal(12,2) | NO | 0.00 | | | 0 to 30 bucket amount |
| rcmsa_31_60_amount | decimal(12,2) | NO | 0.00 | | | 31 to 60 bucket amount |
| rcmsa_61_90_amount | decimal(12,2) | NO | 0.00 | | | 61 to 90 bucket amount |
| rcmsa_91_120_amount | decimal(12,2) | NO | 0.00 | | | 91 to 120 bucket amount |
| rcmsa_121_amount | decimal(12,2) | NO | 0.00 | | | 121+ bucket amount |
| rcmsa_total_amount | decimal(12,2) | NO | 0.00 | | | total bucket amount |
| rcmsa_0_30_enc_ct | int(11) | NO | 0 | | | 0 to 30 encounter count |
| rcmsa_31_60_enc_ct | int(11) | NO | 0 | | | 31 to 60 encounter count |
| rcmsa_61_90_enc_ct | int(11) | NO | 0 | | | 61 to 90 encounter count |
| rcmsa_91_120_enc_ct | int(11) | NO | 0 | | | 91 to 120 encounter count |
| rcmsa_121_enc_ct | int(11) | NO | 0 | | | 121+ encounter count |
| rcmsa_total_enc_ct | int(11) | NO | 0 | | | total encounter count |
| rcmsa_0_30_enc_ct_percent | decimal(5,4) | NO | 0.0000 | | | 0 to 30 encounter count percentage |
| rcmsa_31_60_enc_ct_percent | decimal(5,4) | NO | 0.0000 | | | 31 to 60 encounter count percentage |
| rcmsa_61_90_enc_ct_percent | decimal(5,4) | NO | 0.0000 | | | 61 to 90 encounter count percentage |
| rcmsa_91_120_enc_ct_percent | decimal(5,4) | NO | 0.0000 | | | 91 to 120 encounter count percentage |
| rcmsa_121_enc_ct_percent | decimal(5,4) | NO | 0.0000 | | | 121+ encounter count percentage |
| rcmsa_total_enc_ct_percent | varchar(12) | NO | | | | total encounter count percentage |
| rcmsa_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| rcmsa_created | timestamp | YES | CURRENT_TIMESTAMP | | | |