This report contains service information from RoCS which shows the service variance information and actual Medicaid billing in service units. The contents also include financial information from CARS. 

Since the service and financial information has been separated due to system changes, this report is the only report which combines this information and shows a comparison including all the information.

This report will be generated monthly immediately after the Medicaid billing information has been accepted by Public Aid. Please note that the Medicaid billing information is usually accepted one to two weeks after the service variance files have been generated.

Column 1 = Program Name:

Valid DMH Program number, excluding PAS-MH (790)

Projected service units from Agency Plan (CAPS).  Each unit equals one hour for non residential program (Key Statistic = C or O). For residential program one unit equals one night (Key Statistic = R).

Column B = Actual RoCS Unit Srvs: 

Actual year-to-date NON-REJECTED service units from data submitted monthly by agency to BIS.

Each unit equals one hour for non residential program (Key Statistic = C or O). For residential program one unit equals one night (Key Statistic = R).

Column C = MCO Total Hours: 

Actual year-to-date NON-REJECTED Medicaid billable service units. Each unit equals one Medicaid billable hour for all valid agency programs.

Column D = MHGRF (*CARS update date) ALL: 

Actual year-to-date Agency General Revenue Fund (GRF) award. 

Selection criteria includes fund codes 40, 41, 42, 43, 44, 47, 48, 49, 59, 69 and 89. 

Note: *CARS update date is from OCAPS inquiry system under DMH report number 5.

Column E = GRF PROGRAM MATCH (*CARS update date): 

Actual year-to-date Agency General Revenue Fund (GRF) federal Match. 

Selection criteria includes fund codes 40, 41, 42, 43, 44, 47, 48, 49, 59, 69 and 89.  Program code equals 11, 12, 13, 21, 23, 35, 54, 57, 58, 62, 81 series , and 95.  If program code = 62, then match award will be 70% of original award.  If program code = 81 series or program code equals 233 or 232 then match award will be 70% of original award.

Note: *CARS update date is from OCAPS inquiry system under DMH report number 5.

50% of actual year-to-date Agency Medicaid billable amount.

Accepting indicators equals accepted paid (PD), reduced rate paid (RD), accepted paid non voucher (NV).

Medicaid Billing file update date: file resource from BIS.

** (The next data is column F divided by column E to show the ratio of Medicaid actual payment to the actual GRF match award.)

Annual unduplicated projected clients from Agency Plan (CAPS) by AGENCY UNIT PROGRAM LEVEL.

Actual year-to-date unduplicated registered clients served from service reporting system BY AGENCY UNIT PROGRAM LEVEL.

Actual year-to-date Medicaid clients served BY AGENCY UNIT PROGRAM LEVEL.

Accepting indicators equals accepted paid (PD), reduced rate paid (RD), accepted paid non voucher (NV).

** (The next data is column I divided by column H to show the ratio of Medicaid actual clients served to the actual RoCS clients served BY AGENCY UNIT PROGRAM LEVEL).

Columns are defined as above for Report by program level, except information is distributed by NETWORK AND PROGRAM.

CROSS INFORMATION BETWEEN MCO & ROCS BY NETWORK, AGENCY AND PROGRAM

Columns are defined as above for Report by program level, except information is distributed by NETWORK, AGENCY, UNIT AND PROGRAM.

Unduplicated Client Information is only by agency unit and program level. For unduplication report by statewide, contact Wei-Shin Wang in Central Office.