MRMP541 - Financial Summary – Month of Service Narrative......

MRMP541 Layout......

MRMP541 Field Descriptions......

MRMP541 Field Mapping......

MRMP542 - Financial Summary – Month of Payment Narrative......

MRMP542 Layout......

MRMP542 Field Descriptions......

MRMP542 Field Mapping......

MRMP543 - Incurred Expense Report Narrative......

MRMP543 Layout......

MRMP543 Field Descriptions......

MRMP543 Field Mapping......

MRMP600 - Pharmacy Statistics Report Narrative......

MRMP600 Layout......

MRMP600 Field Descriptions......

MRMP600 Field Mapping......

MRMP621 - Expenditure and Utilization Analysis Narrative......

MRMP621 Layout......

MRMP621 Field Descriptions......

MRMP621 Field Mapping......

MRMP621A - Expenditure and Utilization Analysis by Aid Category Narrative.....

MRMP621A Layout......

MRMP621A Field Descriptions......

MRMP621A Field Mapping......

MRMP621D - Expenditure and Utilization Analysis by Date of Service Narrative...

MRMP621D Layout......

MRMP621D Field Descriptions......

MRMP621D Field Mapping......

MRMP64 - Quarterly Medicaid Statement of Expenditures – Summary Narrative...

MRMP64 Layout......

MRMP64 Field Descriptions......

MRMP64 Field Mapping......

MRMP649 - Medical Assistance Expenditures by Type of Service Narrative......

MRMP649 Layout......

MRMP649 Field Descriptions......

MRMP649 Field Mapping......

MRMP649A - Third Party Liability Collections and Cost Avoidance Narrative......

MRMP649A Layout......

MRMP649A Field Descriptions......

MRMP649A Field Mapping......

MRMP649O - Medicaid Overpayment Adjustments Narrative......

MRMP649O Layout......

MRMP649O Field Descriptions......

MRMP649O Field Mapping......

MRMP800 - CHIP HCFA-64-21E Report Narrative......

MRMP800 Layout......

MRMP800 Field Descriptions......

MRMP800 Field Mapping......

MRMP801 - Client Cost Sharing Summary Narrative......

MRMP801 Layout......

MRMP801 Field Descriptions......

MRMP801 Field Mapping......

MRMP802 - SCHIP Statistical Enrollment Narrative......

MRMP802 Layout......

MRMP802 Field Descriptions......

MRMP802 Field Mapping......

MRMPBALR - MAR Transaction Summary Narrative......

MRMPBALR Layout......

MRMPBALR Field Descriptions......

MRMPBALR Field Mapping......

1

July 2, 2004Table of Contents

MRMP541 - Financial Summary – Month of Service Narrative

The Financial Summary Month of Service (MRMP541) report lists information on payments by aid category and category of service.

The report is produced monthly. The report period and run date are listed on the report. Only claims with service dates during the past 24 months are counted.

For each aid category and category of service, the budgeted, actual, and adjusted amounts are listed for the current and previous fiscal year-to-date. The report lists the budget amount for the fiscal year end. The system calculates and lists the fiscal year end projected amount, and the dollar and percent variances.

1

July 2, 2004Table of Contents

MRMP541 Layout

MRMP541 IDAHO MEDICAID MANAGEMENT INFORMATION SYSTEM PAGE: zz,zz9

AS OF: mm/dd/ccyy FINANCIAL SUMMARY - MONTH OF SERVICE RUN DATE: mm/dd/ccyy

STATE AID CATEGORY XX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

* * * * * * * * * * * * * * * * FISCAL YEAR TO DATE * * * * * * * * * * * * * * * * ------FISCAL YEAR END ------

------THIS YEAR ------LAST YEAR ------VARIANCE

BUDGET ACTUAL ADJUST BUDGET ACTUAL ADJUST BUDGET PROJECTED DOLLAR PERCENT

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

$$$,$$$,$$9- $$$,$$$,$$$.99- $$$,$$$,$$9.99- $$$,$$$,$$9- $$$,$$$,$$9.99- $$$,$$$,$$9.99- $$$,$$$,$$9- $$$,$$$,$$9-$$$,$$$,$$9- zz9.

TOTAL

$$$,$$$,$$9- $$$,$$$,$$$.99- $$$,$$$,$$9.99- $$$,$$$,$$9- $$$,$$$,$$9.99- $$$,$$$,$$9.99- $$$,$$$,$$9- $$$,$$$,$$9-$$$,$$$,$$9- zz9.

*** END OF REPORT ***

1

July 2, 2004Table of Contents

MRMP541 Field Descriptions

Report Field / Description
PAGE: / Page number for reports
AS OF: / From date in MM/DD/CCYY format
RUN DATE: / The date the report was run in MM/DD/CCYY format.
STATE AID CATEGORY / State aid category of public assistance under which a client is eligible for Medicaid benefits. The State can cover additional aid categories not covered by the Federal government.
NONE / A State aid category of assistance code indicating the State statutory category of public assistance, supplemental security income or supplementary payment under which a recipient is eligible for Medicaid benefits.
NONE / Category of Service code description.
FISCAL YEAR TO DATE THIS YEAR BUDGET / This is the sum of budgeted amounts for specified categories.
FISCAL YEAR TO DATE THIS YEAR ACTUAL / This is the total amount paid for claims.
FISCAL YEAR TO DATE THIS YEAR ADJUST / Adjusted paid amount. It is the amount expected to be paid when all claims have been processed.
FISCAL YEAR TO DATE LAST YEAR BUDGET / This is the sum of budgeted amounts for specified categories.
FISCAL YEAR TO DATE LAST YEAR ACTUAL / This is the total amount paid for claims.
FISCAL YEAR TO DATE LAST YEAR ADJUST / Adjusted paid amount. It is the amount expected to be paid when all claims have been processed.
FISCAL YEAR END BUDGET / This is the sum of budgeted amounts for specified categories.
FISCAL YEAR END PROJECTED / This is the projected paid amount for fiscal year end.
FISCAL YEAR END VARIANCE DOLLAR / Total dollar amount paid by Medicaid at the end of the fiscal year.
FISCAL YEAR END VARIANCE PERCENT / This is the percent variance between an expected and actual amount.

MRMP541 Field Mapping

Report Field / Data Element Name / Field Length / Column / Row
PAGE: / ZZZNUM PAGE / 6 / 127 / 1
AS OF: / ZZZDTE FROM MMDDCCYY / 10 / 8 / 3
RUN DATE: / ZZZDTE RUN / 17 / 123 / 3
STATE AID CATEGORY / AID CTG CDE / 2 / 21 / 6
NONE / AID CTG DESC / 80 / 25 / 6
NONE / CTG OF SVC DESC / 80 / 1 / 12
FISCAL YEAR TO DATE THIS YEAR BUDGET / ZMR SUM M BUDGET / 12 / 1 / 14
FISCAL YEAR TO DATE THIS YEAR ACTUAL / ZMR SUM CL PD AMTS / 15 / 14 / 14
FISCAL YEAR TO DATE THIS YEAR ADJUST / ZMR ADJ PD AMT / 15 / 30 / 14
FISCAL YEAR TO DATE LAST YEAR BUDGET / ZMR SUM M BUDGET / 12 / 46 / 14
FISCAL YEAR TO DATE LAST YEAR ACTUAL / ZMR SUM CL PD AMTS / 15 / 59 / 14
FISCAL YEAR TO DATE LAST YEAR ADJUST / ZMR ADJ PD AMT / 15 / 75 / 14
FISCAL YEAR END BUDGET / ZMR SUM M BUDGET / 12 / 91 / 14
FISCAL YEAR END PROJECTED / ZMR PROJ FYE PD AMT / 12 / 104 / 14
FISCAL YEAR END VARIANCE DOLLAR / ZMR FYE DOLLAR AMT / 12 / 116 / 14
FISCAL YEAR END VARIANCE PERCENT / ZMR PCT VARIANCE / 4 / 129 / 14

MRMP542 - Financial Summary – Month of Payment Narrative

The Financial Summary Month of Payment (MRMP542) report lists information on payments by aid category.

The report is produced monthly. The report period, run date and time are listed on the report. Only claims paid during the current state fiscal year are counted.

For each aid category and category of service, the payment amounts are listed for the current month and the same month last year. The report also lists the six month average payment for the current and previous years and amounts for the current and previous state fiscal year to date. The system calculates and lists the projected year end amount.

1

July 2, 2004Table of Contents

MRMP542 Layout

MRMP542 IDAHO MEDICAID MANAGEMENT INFORMATION SYSTEM PAGE: ZZ,ZZ9

AS OF: MM/DD/YYYY FINANCIAL SUMMARY - MONTH OF PAYMENT RUN DATE: MM/DD/YYYY

STATE AID CATEGORY 99 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

SAME MONTH SIX MONTH AVERAGE STATE FISCAL YEAR TO DATE PROJECTED

THIS MONTH LAST YEAR THIS YEAR LAST YEAR THIS YEAR LAST YEAR YEAR END

Inpatient

999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99

Inpatient Crossover

999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99

Outpatient

999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99

Outpatient Crossover

999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99

Physician

999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99

Physician Crossover

999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99

...

STATE AID CATEGORY TOTAL

999,999,999.99 999,999,999.99 999,999,999.99 999,999,999.99

999,999,999.99 999,999,999.99 999,999,999.99

*** END OF REPORT ***

1

July 2, 2004Table of Contents

MRMP542 Field Descriptions

Report Field / Description
PAGE: / Page number for reports
AS OF: / From date in MM/DD/CCYY format
RUN DATE: / The date and time for reporting run time.
AID CATEGORY / State aid category of public assistance under which a client is eligible for Medicaid benefits. The State can cover additional aid categories not covered by the Federal government.
NONE / A State aid category of assistance code indicating the State statutory category of public assistance, supplemental security income or supplementary payment under which a recipient is eligible for Medicaid benefits.
NONE / Category of Service code description.
THIS MONTH / This is the sum of paid amounts for the specified category on the MRMP542 report.
SAME MONTH LAST YEAR / This is the sum of paid amounts for the specified category on the MRMP542 report.
SIX MONTH AVERAGE THIS YEAR / Average amount paid by Medicaid.
SIX MONTH AVERAGE LAST YEAR / Average amount paid by Medicaid.
STATE FISCAL YEAR TO DATE THIS YEAR / Total of the Paid claims, the paid adjustments, and claim specific dollars for the time period specified.
STATE FISCAL YEAR TO DATE LAST YEAR / Total of the Paid claims, the paid adjustments, and claim specific dollars for the time period specified.
PROJECTED YEAR END / This is the projected paid amount for fiscal year end.
STATE AID CATERGORY TOTAL / Total Expenditure for the specified time frame for State Aid Category.

MRMP542 Field Mapping

Report Field / Data Element Name / Field Length / Column / Row
PAGE: / ZZZNUM PAGE / 6 / 127 / 1
AS OF: / ZZZDTE FROM MMDDCCYY / 10 / 8 / 3
RUN DATE: / ZZZDTE TIME RUN / 17 / 11 / 3
AID CATEGORY / AID CTG CDE / 2 / 30 / 7
NONE / AID CTG DESC / 80 / 34 / 7
NONE / CTG OF SVC DESC / 80 / 1 / 12
THIS MONTH / ZMR SUM 542 PAID / 14 / 3 / 15
SAME MONTH LAST YEAR / ZMR SUM 542 PAID / 14 / 22 / 15
SIX MONTH AVERAGE THIS YEAR / ZMR AVG 542 PAID / 14 / 41 / 15
SIX MONTH AVERAGE LAST YEAR / ZMR AVG 542 PAID / 14 / 60 / 15
STATE FISCAL YEAR TO DATE THIS YEAR / ZMR SUM / 14 / 79 / 15
STATE FISCAL YEAR TO DATE LAST YEAR / ZMR SUM / 14 / 98 / 15
PROJECTED YEAR END / ZMRPROJFYEPDAMT / 14 / 117 / 15
STATE AID CATERGORY TOTAL / ZMR TOT / 14 / 4 / 15

MRMP543 - Incurred Expense Report Narrative

The Incurred Expense Report Month of Service (MRMP543) report lists information on payments by aid category and category of service.

The report is produced monthly. The report period and run date are listed on the report. Only claims with service dates during the past 24 months are counted.

For each aid category, category of service and month of service, information is listed. The report lists the number of unduplicated eligibles and unduplicated eligibles receiving services, along with the total units of service, percent of eligibles who received service, and service units per user. The report lists totals for paid amount, estimated incurred, and the estimated finalized percent (lag factor). The system calculates and displays the actual cost per user and unit, and lists the estimated cost per eligible receiving service. The system calculates and lists the previous year 12 month average of total units, total paid, total estimated incurred, estimated finalized percent, and actual cost per unit. The system then calculates and lists the current year 12 month average of total units, total paid, total estimated incurred, estimated finalized percent, and actual cost per unit.

1

July 2, 2004Table of Contents

MRMP543 Layout

MRMP543 IDAHO MEDICAID MANAGEMENT INFORMATION SYSTEM PAGE: 99,999

AS OF: XX/XX/XXXX INCURRED EXPENSE REPORT RUN DATE: XX/XX/XXXX

STATE AID CATEGORY XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

CATEGORY OF SERVICE 9999 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

MONTH UNDUP UNITS TOTAL ESTIMATED ACTUAL ACTUAL ESTIMATED

OF UNDUP ELIGIBLE TOTAL PERCENT PER TOTAL ESTIMATED FINALIZED COST/P COST/P COST PER

SERVICE ELIGIBLE RCV SVC UNITS USING USER PAID INCURRED PERCENT USER UNIT ELIGIBLE

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

XXX XX 999,999 999,999 999,999.9 999.99 999.999 $99,999,999.99 $99,999,999 999.999 $99,999.99 $99,999.99 $99,999.99

LAST 12 MONTH PERIOD TO DATE

999,999.9 $99,999,999,999.99 $99,999,999 999.999 $99,999,999.99

CURRENT 12 MONTH PERIOD TO DATE

999,999.9 $99,999,999,999.99 $99,999,999 999.999 $99,999,999.99

*** END OF REPORT ***

1

July 2, 2004Table of Contents

MRMP543 Field Descriptions

Report Field / Description
PAGE / Page number for reports
AS OF / Month name for reports
RUN DATE / The date the report was run in MM/DD/CCYY format.
STATE AID CATEGORY / State aid category of public assistance under which a client is eligible for Medicaid benefits. The State can cover additional aid categories not covered by the Federal government.
NONE / A State aid category of assistance code indicating the State statutory category of public assistance, supplemental security income or supplementary payment under which a recipient is eligible for Medicaid benefits.
CATEGORY OF SERVICE / State category of service for services provided on a claim. The state can cover additional services other than the ones required by the Federal government. Valid values are in the Tables Manual.
NONE / Category of Service code description.
MONTH OF SERVICE / Month and year of Service. Format MMM YY.
UNDUPLICATED ELIGIBLE / Unduplicated count of recipient ids.
UNDUPLICATED RCV SVC / The number of unduplicated Medicaid eligibles receiving services for the month of service, aid category and category of service.
TOTAL UNITS / This is the summed number of service units.
PERCENT USING / The percent of Medicaid eligibles who received service for the month, aid category and category of service.
UNITS PER USER / The units of service per client for the month of service, aid category and category of service.
TOTAL PAID / This is the total amount paid for claims.
TOTAL ESTIMATED INCURRED / This is the total estimated incurred.
ESTIMATED FINALIZED PERCENT / The lag factor is a percentage used to predict the number of months between date of service and date of receipt for a claim.
ACTUAL COST / P USER / The actual cost per user for the month of service, aid category and category of service.
ACTUAL COST / P UNIT / Cost of Medicaid services per unit of service.
ESTIMATED COST PER ELIGIBLE / The estimated cost per eligible.
LAST 12 MONTHS TOTAL UNITS / This is the summed number of service units.
LAST 12 MONTHS TOTAL PAID / This is the total amount paid for claims.
LAST 12 MONTHS TOTAL ESTIMATED INCURRED / This is the total estimated incurred.
LAST 12 MONTHS ESTIMATED FINALIZED PERCENT / The lag factor is a percentage used to predict the number of months between date of service and date of receipt for a claim.
LAST 12 MONTHS ACTUAL COST / P UNIT / Cost of Medicaid services per unit of service.
CURRENT 12 MONTHS TOTAL UNITS / This is the summed number of service units.
CURRENT 12 MONTHS TOTAL PAID / This is the total amount paid for claims.
CURRENT 12 MONTHS TOTAL ESTIMATED INCURRED / This is the total estimated incurred.
CURRENT 12 MONTHS ESTIMATED FINALIZED PERCENT / The lag factor is a percentage used to predict the number of months between date of service and date of receipt for a claim.
CURRENT ACTUAL COST / P UNIT / Cost of Medicaid services per unit of service.

MRMP543 Field Mapping

Report Field / Data Element Name / Field Length / Column / Row
PAGE / ZZZNUM PAGE / 6 / 127 / 1
AS OF / ZZZMONTH / 10 / 8 / 3
RUN DATE / ZZZDTE RUN / 10 / 122 / 3
STATE AID CATEGORY / AID CTG CDE / 2 / 24 / 6
NONE / AID CTG DESC / 80 / 30 / 6
CATEGORY OF SERVICE / CTG OF SVC / 4 / 22 / 7
NONE / CTG OF SVC DESC / 80 / 30 / 7
MONTH OF SERVICE / ZMR 543 MONTH / 6 / 1 / 13
UNDUPLICATED ELIGIBLE / ZMR CNT DISTINCT RE ID / 7 / 12 / 13
UNDUPLICATED RCV SVC / ZMR CNT NUM OF ELIG / 7 / 22 / 13
TOTAL UNITS / ZMR SUM CL UNITS SVC / 9 / 32 / 13
PERCENT USING / ZMR PCT ELIGIBLE RCV SVC / 6 / 44 / 13
UNITS PER USER / ZMR UNITS PER ELIGIBLE RCV SVC / 7 / 53 / 13
TOTAL PAID / ZMR SUM CL PD AMTS / 14 / 63 / 13
TOTAL ESTIMATED INCURRED / ZMR TOT EST INCUR / 11 / 79 / 13
ESTIMATED FINALIZED PERCENT / ZMR LAG FACTOR / 7 / 92 / 13
ACTUAL COST / P USER / ZMR COST PER ELIGIBLE RCV SVC / 10 / 101 / 13
ACTUAL COST / P UNIT / ZMR COST PER UNIT / 10 / 112 / 13
ESTIMATED COST PER ELIGIBLE / ZMR EST COST PER ELIG / 10 / 123 / 13
LAST 12 MONTHS TOTAL UNITS / ZMR SUM CL UNITS SVC / 9 / 32 / 14
LAST 12 MONTHS TOTAL PAID / ZMR SUM CL PD AMTS / 14 / 63 / 14
LAST 12 MONTHS TOTAL ESTIMATED INCURRED / ZMR TOT EST INCUR / 11 / 79 / 14
LAST 12 MONTHS ESTIMATED FINALIZED PERCENT / ZMR LAG FACTOR / 7 / 92 / 14
LAST 12 MONTHS ACTUAL COST / P UNIT / ZMR COST PER UNIT / 10 / 112 / 14
CURRENT 12 MONTHS TOTAL UNITS / ZMR SUM CL UNITS SVC / 9 / 32 / 14
CURRENT 12 MONTHS TOTAL PAID / ZMR SUM CL PD AMTS / 14 / 63 / 15
CURRENT 12 MONTHS TOTAL ESTIMATED INCURRED / ZMR TOT EST INCUR / 11 / 79 / 15
CURRENT 12 MONTHS ESTIMATED FINALIZED PERCENT / ZMR LAG FACTOR / 7 / 92 / 15
CURRENT ACTUAL COST / P UNIT / ZMR COST PER UNIT / 10 / 112 / 15

MRMP600 - Pharmacy Statistics Report Narrative

The Pharmacy Statistics (MRMP600) report lists pharmacy information for the MAR report period by MAR Grouping description.

The report is produced monthly. The report period, run date and time are listed on the report. Only claims paid during the current MAR report period are counted.

The dollars paid, number of claims paid, average cost per prescription, and units of service per dollars are listed by MAR Grouping description.

1

July 2, 2004Table of Contents

MRMP600 Layout

MRMP600 IDAHO MEDICAID MANAGEMENT INFORMATION SYSTEM PAGE: 99,999

AS OF: MM/DD/CCYY PHARMACY STATISTICS REPORT RUN DATE: MM/DD/CCYY

NUMBER AVERAGE COST UNITS OF

DOLLARS OF PER SERVICE /

PAID CLAIMS PAID PRESCRIPTION DOLLARS

MAR GROUPING: MEDICAID

$99,999,999.99 999,999,999 $99,999,999.99 999,999.99

*** END OF REPORT ***

1

July 2, 2004Table of Contents

MRMP600 Field Descriptions

Report Field / Description
PAGE / Page number for reports
AS OF: / Month name for reports
RUN DATE / The date the report was run in MM/DD/CCYY format.
MAR GROUPING DESC / Funding Source description.
DOLLARS PAID / Total Dollars Paid, includes paid claim amounts and claims specific dollars.
NUMBER OF CLAIMS PAID / Count of claims paid.
AVERAGE COST PER PRESCRIPTION / Average Cost per prescription. (Dollars paid/Number of Claims paid)
UNITS OF SERVICE / DOLLARS / Average units per dollars paid. (quanity dispensed/dollars paid)

MRMP600 Field Mapping

Report Field / Data Element Name / Field Length / Column / Row
PAGE / ZZZNUM PAGE / 6 / 127 / 1
AS OF: / ZZZMONTH / 10 / 8 / 3
RUN DATE / ZZZDTE RUN / 10 / 23 / 3
MAR GROUPING DESC / FUND SRC DESC / 60 / 16 / 11
DOLLARS PAID / ZMR DOLL PD / 14 / 17 / 12
NUMBER OF CLAIMS PAID / ZMR NUM CLMS / 11 / 43 / 12
AVERAGE COST PER PRESCRIPTION / ZMR AVG CST / 14 / 68 / 12
UNITS OF SERVICE / DOLLARS / ZMR UNIT DOLL / 11 / 96 / 12

MRMP621 - Expenditure and Utilization Analysis Narrative

The Expenditure and Utilization Analysis (MRMP621) report lists expenditure information by State Task Code.

The report is produced monthly. The report period and run date are listed on the report.

For each State Task Code, the number of clients, number of clients, expenditure amount, copay amount, total units of service, units per client, units per client, cost per client, cost per user, and cost per unit are listed.

1

July 2, 2004Table of Contents

MRMP621 Layout

MRMP621 IDAHO MEDICAID MANAGEMENT INFORMATION SYSTEM PAGE: zz9

AS OF: mm/dd/ccyy RUN DATE: mm/dd/ccyy

EXPENDITURE AND UTILIZATION ANALYSIS

REPORT PERIOD – mm/ccyy

****** UNITS ******* ********** COST **********

TOTAL # OF % OF TOTAL PER PER PER PER PER

STATE TASK CODE ELIG. CLIENTS ELIG. EXPENDITURES COPAY UNITS ELIG. USER ELIG. USER UNIT

9999-XXXXXXXXXXXXXXXXXXXXXXXXXXXX999,999 999,999 99.9 $99,999,999 $99,999 999,999 999.99 999.99 $999.99 $999.99 $999.99