J-10_WorkloadData_PDAC.doc

RFP-CMS-2007-0019 – Pricing, Data Analysis, and Coding (PDAC)

SADMERC Workload Information 1-1-2007 thru 12-31-2007

1. HCPCS HELPLINE

Average Monthly Telephone Inquiries

5,007 calls offered

Average Monthly Written Inquiries

17 questions

Average Monthly Email Inquiries

169 questions 2.

Durable Medical Equipment Coding System (DMECS)

Size of Database

1.6 million records as of 3/11/08

Average Number of Hits/Month

47,475 in 2007 3.

HCPCS REVIEW WORKLOAD

Average Monthly Number of Items for Review

Average Monthly Number of Conference Calls

Size of ANWG Database

2,979 records (through 2007)

4.

CHANGE REQUESTS

Average Monthly Number of CRs

0 to 1

5.

STATISTICAL ANALYSIS/REPORTS

Number of Standard Monthly Reports

Number of Standard Quarterly Reports

Number of Standard Annual Reports

Average Monthly Number of Ad-Hoc Requests

Average Monthly Number of Law Enforcement Requests

Average Monthly Number Requests from CMS

6.

DATA

Size of Data Warehouse

1,370,911,371 claim-line level records as of 02/2008

Number of Years of Data in Warehouse

14+ years (Oct 1993 – Feb 2008) Size of Database in WebI

The detail data are not stored in WebI database; data warehouse relational tables are accessed.

Number of Years of Data in WebI

14+ years Number of Reports Housed in WebI

Approximately 940

Average Number of Hits/Month

44,980 queries 7.

National Drug Code (NDC)/HCPCS CROSSWALK FILES Size of Database/File

13,686 records as of 3/5/2008

Average Monthly Number of Updates

8. OACD PRICING FILES

Size of Database/File

178 records as of 1/1/2008

Average Monthly Number of Updates

9. Freedom of Information (FOI) Requests

Average Monthly Number of FOI Requests

J-10_Workload Data_PDAC.doc