AHRQ-19-10005.pdf

PDF 997 KB Posted

Attached to
Healthcare Data Analytics and Statistical Products
Solicitation number
AHRQ-19-10005
Issued by

About this file

Solicitation AHRQ-19-10005

View the file

Other files

File Type Posted
AHRQ-19-10005_Amendment_1.pdf PDF
AHRQ-19-10005_Solicitation_Questions_Responses.pdf PDF
Technical_Specifications_Worksheet.xlsx XLSX spreadsheet
DRAFT_Statement_of_Work.docx DOCX document

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Request for Proposal v. 9/5/18; FAC 100 AHRQ-19-10005 Healthcare Data Analytics and Statistical Products Page 1 of 91

Request for Proposal No. AHRQ-19-10005

PART I - THE SCHEDULE

SECTION A - SOLICITATION FORM

Date Issued: January 4, 2019 Date Questions Due: January 11, 2019 Please Note: All questions and inquires will be processed on a non-attribution basis.

Date Notice of Intent Due: January 18, 2019 Date Proposals Due: February 4, 2019 11:00 AM, EST

You are invited to submit a proposal to the Agency for Healthcare Research and Quality (AHRQ) for Request for Proposal (RFP) No. AHRQ-15-10005 entitled “Healthcare Data Analytics and Statistical Products”. Your proposal must be developed and submitted in accordance with the requirements and instructions of this RFP.

Solicitation Information: Please review the table of contents and refer to the appropriate section of this RFP for requirements, proposal instructions and evaluation information. The Government intends to award this contract without negotiations, so it is imperative that all questions are addressed during the solicitation phase, and that all proposals submitted include the required information and accept the terms and conditions as stated. Failure to comply with proposal instructions or submit required information may result in the removal of a proposal from consideration for award. Please review Section L carefully.

Proposal Intent: If you intend to submit a proposal in response to this solicitation, please inform the Contracting Officer of your intent by notifying the Contracting Officer no later than January 18, 2019. You may email it to scott.henderson@ahrq.hhs.gov.

Questions: All Questions regarding this solicitation shall be received in this office no later than the date shown above. All questions shall be submitted electronically by e-mail to Scott Henderson, Contract Specialist, at the following email address: scott.henderson@ahrq.hhs.gov. Subject line shall read: Proposal Questions RFP No. AHRQ-19-10005. Answers to questions and all solicitation amendments will be posted to the Federal Business Opportunities web page:

www.fbo.gov. It is your responsibility to monitor the web site. Questions should include the following information:

• RFP (or Attachment) Page Number

• Relevant Section Number or Title

Additional Information:

a. A cost plus fixed fee contract is contemplated for a period of one year, with four one-year options.

http://www.fbo.gov/

Healthcare Data Analytics and Statistical Products Page 2 of 91

b. The Government anticipates awarding one contract from this solicitation on or about June 14, 2019.

c. Proposals submitted in response to this solicitation must state that they are valid for a period of at least 120 days (reference FAR clause 52.215-1 in Section L of this document.)

d. The NAICS code for this requirement is 541990 with a size standard of $15.0 million.

Proposal Submission: The proposal shall be signed by an authorized official to bind your organization and must be received by the due date specified above. The proposal must be submitted to the following address:

Agency for Healthcare Research and Quality (AHRQ)* Division of Contracts Management* 5600 Fishers Lane* Mail Stop 06N34B* Rockville, Maryland 20857* Attn: Scott Henderson, (301) 427-1764*

*All boxes must be clearly labeled with this information.

Please read this section carefully. Some mail and package delivery procedures have changed due to security controls. All mail and packages are screened at a local offsite facility before being delivered to 5600 Fishers Lane.

The U.S. Postal Service’s “Express Mail” does not deliver to our Rockville, Maryland address.

Please do not use this means of delivery for proposal submission.

Proposals delivered by commercial package delivery company (example: Fedex, UPS, DHL, etc.):

Submit and label as instructed above. These companies are familiar with the delivery procedures at 5600 Fishers Lane.

Hand carried or hand carry courier service: The 5600 Fishers Lane building security does not allow packages to be delivered directly to the building. Hand carried or courier delivered proposals should be labeled as instructed above, however they must be delivered directly to the offsite screening facility at 12225 Wilkins Avenue Rockville MD 20852. The operating hours at the Wilkins Avenue facility are 7:00 AM to 3:30 PM Monday through Friday. Please note that anyone who arrives at the Fishers Lane location with a delivery will be directed to the screening facility, however this will cause delay. Packages will be accepted and date/time stamped at the screening facility. Please allow ample time as proposals cannot be date/time stamped until they have gone through security.

System for Award Management: In accordance with Federal Acquisition Regulation, all contractors must be registered in the System for Award Management (SAM) database in order to conduct business with the government [See Section I - FAR clause 52.204-7 System for Award

Healthcare Data Analytics and Statistical Products Page 3 of 91

Management]. Access the System for Award Management (SAM) at http://www.sam.gov.

Reminder: The Procurement Integrity Act prohibits the unauthorized disclosure of, inquiry about, or acceptance of procurement information. Communications with any other individual outside the AHRQ contracting office may result in rejection of an offeror’s proposal. All requests for any information concerning this RFP should be referred to Scott Henderson, (301) 427-1764 or e-mail: scott.henderson@ahrq.hhs.gov. Please note e-mail requests should state subject as RFP

AHRQ-15-10005.

http://www.sam.gov/

Healthcare Data Analytics and Statistical Products Page 4 of 91

Table of Contents

PART I - THE SCHEDULE

SECTION A - SOLICITATION FORM

SECTION B - SUPPLIES OR SERVICES AND PRICES/COSTS

SECTION C - DESCRIPTION/SPECIFICATION/WORK STATEMENT

SECTION D - PACKAGING AND MARKING

SECTION E - INSPECTION AND ACCEPTANCE

SECTION F - DELIVERIES OR PERFORMANCE

SECTION G - CONTRACT ADMINISTRATION DATA

SECTION H - SPECIAL CONTRACT REQUIREMENTS

PART II – CONTRACT CLAUSES

SECTION I - CONTRACT CLAUSES

PART III- LIST OF DOCUMENTS, EXHIBITS AND ATTACHMENTS

SECTION J – SOLICITATION LIST OF ATTACHMENTS

PART IV– REPRESENTATIONS AND INSTRUCTIONS

SECTION K - REPRESENTATIONS, CERTIFICATIONS, AND OTHER STATEMENTS OF OFFERORS

SECTION L - INSTRUCTIONS, CONDITIONS AND NOTICES TO OFFERORS

SECTION M- EVALUATION FACTORS FOR AWARD

Healthcare Data Analytics and Statistical Products Page 5 of 91

SECTION B - SUPPLIES OR SERVICES AND PRICES/COSTS

B.1 BRIEF DESCRIPTION OF SUPPLIES OR SERVICES

“Healthcare Data Analytics and Statistical Products”. See Section C for a complete description.

B.2 ESTIMATED COST AND FIXED FEE

a. The Estimated Cost (exclusive of fees) for performance of the work under the base period of this contract, including direct and indirect costs is $ To Be Determined (TBD).

b. The Fixed Fee for the base period of this contract is $TBD. The fixed fee shall be paid in installments based on the percentage of completion of work, as determined by the Contracting Officer. Payment shall be subject to the withholding provisions of the Clause ALLOWABLE COST AND PAYMENT and FIXED FEE incorporated herein.

c. The total contract value, represented by the sum of the estimated cost plus the fixed fee for the base period is $TBD.

Period of Performance

Services Estimated Cost

Fixed Fee Total

Base Period Severable $ $ $

B.3 OPTION COSTS

If the Government exercises its option(s) pursuant to the option article in Section H of this contract, the Government’s total contract amount represented by the sum of the estimated cost, and fixed fee will be revised as follows:

Period of Performance

Services Estimated Cost Fixed Fee Total

Option Period 1 Severable $ $ $ Option Period 2 Severable $ $ $ Option Period 3 Severable $ $ $ Option Period 4 Severable $ $ $

The base period and each option are separate and distinct from one another for accumulation of costs and billing purposes.

OPTION TASKS

a. This Labor Hours Portion establishes optional tasks in accordance with Statement of Work Section A.1.7.

b. The Contractor shall bill for direct labor hours in accordance with the fixed hourly rates set forth below.

Healthcare Data Analytics and Statistical Products Page 6 of 91

PERIOD CEILING PRICE*

Optional Task A.1.7 Base Period $ 400,000 Optional Task A.1.7 Option Period 1 $ 400,000 Optional Task A.1.7 Option Period 2 $ 400,000 Optional Task A.1.7 Option Period 3 $ 400,000 Optional Task A.1.7 Option Period 4 $ 400,000

* The Ceiling Prices listed above are per-year amounts.

Labor Category Burdened Labor Rate By Contract Year Base OY 1 OY 2 OY 3 OY 4

Sr. Programmer Jr. Programmer Analyst Administrative Support

Senior Programmers 3 or more years of experience with regular programming in SAS, STATA, and SUDAAN using health related survey data (including analysis of health care quality, patient outcomes, access and continuity/coordination of care, utilization, and expenditures), or comparable formal education in a health-related field or social science; and experience in using the required database or in the type of work that the task entails.

Junior Programmers 1 or more years of experience with regular programming in SAS, STATA, and SUDAAN using health related survey data (including analysis of health care quality, patient outcomes, access and continuity/coordination of care, utilization, and expenditures), or comparable formal education in a health-related field or social science; and experience in using the required database or in the type of work that the task entails.

Analyst Experience with regular programming in SAS, STATA, and SUDAAN using health related survey data (including analysis of health care quality, patient outcomes, access and continuity/coordination of care, utilization, and expenditures), or comparable formal education in a health-related field or social science; and experience in using the required database or in the type of work that the task entails. Experience with supervising a team of staff (programming staff or other). The Analyst will also have experience in working with the client to define task requirements, budget, schedule, and all the details necessary to proceed with the work.

Administrative Support Experience in providing support to the analytic and programming staff in terms of copy editing, preparing memos and documentation, creating back-up copies of data files and other administrative support.

c. The optional tasks shall be subject to the following procedures:

Healthcare Data Analytics and Statistical Products Page 7 of 91

1. Up to two (2) times per year, the Government may issue the Contractor a modification request containing a statement of work for an option task. These tasks shall be accomplished on a labor-hour basis.

2. The Contractor shall review the statement of work for the option task and submit a proposal for the labor hours associated with accomplishing the optional task, using the labor categories and hourly rates.

3. When the Government and Contractor agree on the statement of work language and labor hours, a modification shall be issued to incorporate the terms of the agreement into the appropriate sections of the contract.

i. The ceiling prices for each specific optional task will be established using the agreed-upon hours and burdened labor rates.

ii. The sum of both option tasks must stay within the limits established above.

4. All option tasks shall be accomplished in their entirety within the given contract year when the modification is issued.

B.4 PROVISIONS APPLICABLE TO DIRECT COSTS

a. Items Unallowable Unless Otherwise Provided

Notwithstanding the clauses, ALLOWABLE COST AND PAYMENT, and FIXED FEE, incorporated into this contract, unless authorized in writing by the Contracting Officer, the costs of the following items or activities shall be unallowable as direct costs:

(1) Acquisition, by purchase or lease, of any interest in real property;

(2) Rearrangement or alteration of facilities;

(3) Purchase or lease of any item of general purpose-office furniture or office equipment regardless of dollar value. (General purpose equipment is defined as any items of personal property which are usable for purposes other than research, such as office equipment and furnishings, pocket calculators, etc.);

(4) Accountable Government property;

(5) Travel to attend general scientific meetings;

(6) Foreign Travel;

(7) Any costs incurred prior to the contract's effective date;

(8) Rental of meeting rooms not otherwise expressly paid for by the contract;

(9) Any formal subcontract arrangements not otherwise expressly provided for in the contract;

(10) Consultant fees;

(11) Information Technology hardware or software; and

Healthcare Data Analytics and Statistical Products Page 8 of 91

(12) Food and Beverages;

Note: Food and Beverages are unallowable costs. Contracting Officer Authorization for Food and Beverages will be only made as specifically authorized by statute, which is extremely rare. The contractor shall not provide food or beverages of any type. The contractor shall not accept food or beverages, even if included in, or provided ‘free’ as part of a meeting/conference ‘package’.

b. Travel Costs

This contract is subject to the provisions of Public Law (P.L.) 99-234 which amends the

Office of Federal Procurement Policy Act to provide that contractor costs for travel, including lodging, other subsistence, and incidental expenses, shall be allowable only to the extent that they do not exceed the amount allowed for Federal employees. The Contractor, therefore, shall invoice and be reimbursed for all travel costs in accordance with Federal Acquisition Regulations (FAR) 31.205-46.

The following applies to Educational Institutions: The Contractor shall invoice and be reimbursed for all travel costs in accordance with OMB Circular A-21 - "Cost Principles for Educational Institutions."

No funding or expenditures will be authorized under this contract for travel or meeting expenses of any person that is not an employee of the contractor or approved subcontractor in accordance with the terms of the contract. See 31 USC § 1345 for appropriations restrictions.

B.5 CONTRACTING OFFICER AUTHORIZATION

Other provisions of this contract notwithstanding, approval of the following items within the limits set forth is hereby granted without further authorization from the Contracting Officer.

To Be Determined

Healthcare Data Analytics and Statistical Products Page 9 of 91

SECTION C - DESCRIPTION/SPECIFICATION/WORK STATEMENT

Independently and not as an agent of the Government, the Contractor shall be required to furnish all the necessary services, qualified personnel, material, equipment, and facilities, not otherwise provided by the Government, as needed to perform the Statement of Work as follows:

Statement of Work

Unless otherwise noted under a specific task, this Statement of Work applies to the base period and all options (if exercised).

Background

The Agency for Healthcare Research and Quality (AHRQ) supports health services research initiatives that seek to improve the quality of health care in America. AHRQ’s mission is to produce evidence to make health care safer, higher quality, more accessible, equitable, and affordable.

AHRQ works to fulfill its mission by conducting research and provides information on a number of critical issues related to healthcare and quality which are of particular interest to government agencies, legislative bodies, health policy makers and other health professionals. The research is primarily based on the Medical Expenditure Panel Survey (MEPS) and the Healthcare Cost and Utilization Project (HCUP).

MEPS is the only national data source measuring how Americans use and pay for medical care, health insurance, and out-of-pocket spending. Annual surveys of individuals and families, as well as their health care providers, provide data on health status, the use of medical services, charges, insurance coverage, and satisfaction with care.

HCUP is the Nation's most comprehensive source of hospital care data, including information on in-patient stays, ambulatory surgery and services visits, and emergency department encounters.

HCUP enables researchers, insurers, policymakers and others to study health care delivery and patient outcomes over time, and at the national, regional, State, and community levels.

In addition, AHRQ produces the National Healthcare Quality and Disparity Report (NHQDR) annually to inform the nation on healthcare quality and disparities in health care. The first report was released in fall of 2003. This report uses the MEPS and HCUP databases to produce their analyses but also utilizes other databases (e.g., the Commonwealth Fund Health Care Quality Survey) in an effort to provide as comprehensive a picture as possible on these issues to policymakers. The National Healthcare Quality and Disparities Report presents trends for measures related to access to care, affordable care, care coordination, effective treatment, healthy living, patient safety, and person-centered care. The report presents, in chart form, the latest available findings on quality of and access to healthcare, as well as disparities related to

Healthcare Data Analytics and Statistical Products Page 10 of 91 race and ethnicity, income, and other social determinants of health. Additionally, the NHQDR website links users to the AHRQ website for downloadable copies of the most current annual Report and to the archived Reports. The website Resource section has over 50 links to other related websites for resources and information on healthcare quality and disparities and data sources. The website also includes 3 data analytic tools for understanding healthcare quality and disparities at the national and state level.

A.1 Work Statement The Contractor shall furnish the necessary personnel, materials, services, and facilities, necessary to perform the work described below.

The Contractor shall perform the following tasks:

A.1.1 Administrative requirements

A.1.1.1 Detailed Documentation The Contractor shall provide a Data File Development Report that contains detailed documentation of all data files and work performed related to data editing and analysis. This task shall include cataloguing data files and software, complete with descriptions of their contents and histories, and maintain a back-up system for all data base files. The Contractor shall use a software configuration management tool and data base and file documentation library, approved by AHRQ.

A.1.1.2 Project Management The Contractor shall create a draft and final (upon COR approval) annual Project Management Plan with delivery 30 and 60 days, respectively, after the effective date of the contract or option exercise. The Project Management Plan shall detail the deliverables and delivery dates as stated in the contract along with other contract activities and milestones. The Project Management Plan shall be updated annually.

The Project Management Plan shall include procedures for ensuring all of the following:

adequate availability of staff, including methods for recruiting new personnel as needed; efficient use of computer and programmer resources on each task and using efficient methods of debugging programs; perform tasks in an agreed upon timeline; and maintain consistency and comparability of data used across tasks--including use of the most current versions of variables and files by all programmers on all tasks. The plan shall also include a section on procedures for ensuring the data security and confidentiality.

The Project Management Plan shall include a section on the budgeting, monitoring, and documentation of all applicable contract activities and costs by task grouped as stated in the statement of work. The plan shall provide for the initiation of optional tasks only upon the approval of the COR and exercise of the optional task via contract modification. Optional tasks are discussed in section A.1.7 below.

Healthcare Data Analytics and Statistical Products Page 11 of 91

A.1.1.3 Software Management Prepare an annual AHRQ Software Maintenance Plan which provides for the budgeting, monitoring, and documentation of all applicable contract activities and costs related to software management within the following areas:

1) Release (web products) Management, problem resolution and tracking;

2) Hardware/Server monitoring;

3) Oracle Database - Application and source code;

4) Documentation including the Software Configuration and Maintenance Guide;

5) Quality Management;

6) Quality Assurance review; and

7) Configuration Management.

Provide monthly updates to the Software Maintenance Plan.

A.1.1.4 Reporting The Contractor shall copy the COR on communication with AHRQ analysts unless otherwise advised. The Contractor shall prepare monthly progress and summary cost reports for work performed during the prior month. The monthly reports shall be delivered to the COR in electronic format by the 20th of each month. The progress report should include all approved tasks with the task description, task number, budget and Contractor task manager & programmers, AHRQ Analyst as well as a summary of activities during the month including milestones reached; any specific problems encountered and solutions found; any additional information which has a significant impact on ongoing or planned activities or costs. This should also include the planned activities for the next month. Any changes in the task description should be appended in the task description each month.

The format and delivery mechanism for all monthly, final and other progress reports and contract deliverables shall be as specified in the contract. All documentation prepared and delivered for this contract shall be maintained in a file catalog, current throughout the contract life-cycle and shall be accessible to the government for review at any time during the life of the contract.

At the completion of the contract the Contractor shall provide a draft, for review and approval by the COR, and final project report.

A.1.1.5 Meetings Upon award of the contract the Contractor shall hold a kick off meeting with the COR and other AHRQ staff at the AHRQ location in Rockville, MD or through a conference call. The Contractor shall submit an agenda, and any materials to be used for discussion, at least two days in advance of the kick off meeting. The Contractor shall prepare and distribute minutes within 2 days of the meeting. The minutes shall include the contract number, project director, a list of attendees, a description of the issues discusses, action items, assignments and due dates.

Healthcare Data Analytics and Statistical Products Page 12 of 91

During the project the Contractor shall hold monthly meetings with the COR and other AHRQ staff, as needed at AHRQ location in Rockville, MD, or through conference call during which the project will be discussed. The Contractor shall submit an agenda, and any materials to be used for discussion, at least two days in advance of meetings. The focus of these meetings will be to discuss on going tasks, budget and staff. These meetings present an opportunity to discuss plans, progress, problems, and any other topics which may arise during the course of individual tasks. The Contractor shall prepare and distribute minutes of all monthly meetings, and any other decision making meeting with AHRQ within 2 days of the meetings. The minutes shall include the contract number, project director, a list of attendees, a description of the issues discusses, action items, assignments and due dates.

A.1.1.6 Quality Assurance The Contractor shall document and implement a quality control process for data activities performed under this contract. Such documentation shall be reflected in the Project Management Plan. The Contractor shall ensure that all data products including all data files, publications, online data tools, Web sites and software are working as expected through a systematic and thorough quality control review process. All web based products are subject to Section 508 of the Rehabilitation Act of 1973 (29 U.S.C. 794d) rules.

A.1.1.7 Data Security The Contractor shall provide for the secure and confidential storage of all electronic files as specified by AHRQ. To that end the Contractor shall provide a draft Data Security Plan, for review and approval by the COR, and upon approval a final Data Security Plan.

In addition, the Contractor shall provide for the secure and confidential transmission of data between users at the Contractor’s worksite and between the Contractor and the AHRQ network. The Contractor shall establish and maintain a secure encrypted data transmission capability so that confidential data and documents can be shared between AHRQ and the Contractor. The Data Security Plan and actual implementation of data security shall conform to all current government regulations for the use and storage of confidential data. A list of applicable United States (U.S.) laws, Office of Management and Budget (OMB) requirements, HHS policies, standards and guidance, and Federal Government Computer Security guidelines may be found in Section H, Special Contract Requirements. The data system will contain indirectly Personally Identifiable Information (PII). The Contractor shall have access to PII including geographic identifiers, fully specified ICD10, industry and occupation codes, and linking IDs to the National Health Interview Survey. The Contractor shall abide by Federal Information Processing Standards (FIPS) 199 level of “Moderate” security designation.

The Contractor shall abide by all requirements of the Privacy Act of 1974 and FAR Clause 48 CFR 352.239.72. Pursuant to those requirements, the Contractor shall create and publish a System of Records Notice (SORN) in the Federal Register when required and shall publish an updated SORN following a major change to the system, as directed by OMB Memorandum (M) 03-22, OMB Guidance for Implementing the Privacy Provisions of the E-Government Act of 2002, or subsequent replacement guidance. Currently a SORN exists for this project: 09-35-

002. The Application and System Development Requirements are found at the following link:

https://www.ahrq.gov/sites/default/files/wysiwyg/research/publications/pubcomguide/pcguide2ap a.pdf.

https://www.ahrq.gov/sites/default/files/wysiwyg/research/publications/pubcomguide/pcguide2apa.pdf https://www.ahrq.gov/sites/default/files/wysiwyg/research/publications/pubcomguide/pcguide2apa.pdf

Healthcare Data Analytics and Statistical Products Page 13 of 91

As mandated by the Federal Information Security Modernization Act of 2014 (FISMA of 2014) and AHRQ Information Security and Privacy requirements, the system must go through AHRQ’s formal initial Assessment and Authorization (A&A) process and obtain a formal approval to operate (ATO) prior to production data being loaded onto the system. After an ATO is received, the Contractor shall comply with AHRQ’s continuous monitoring program that mandates monthly and quarterly submissions from external Contractors. Details about requirements are referenced in the Security and Privacy Requirements in Section H. All costs for the A&A and continuous monitoring requirements shall be borne by the Contractor.

If a cloud hosted component is chosen as a part of the proposed solution, the cloud service provider must be an authorized Federal Risk and Authorization Management Program (FedRAMP) vendor. A list of authorized FedRAMP cloud service providers can be referenced at fedramp.gov. Note that AHRQ system security requirements, including an abbreviated A&A process, must still be followed for all cloud hosted AHRQ systems.

A.1.1.8 Development and Implementation of Transition Plan The Contractor shall develop and implement a transition plan for transferring all applicable data, documentation and activities to this contract.

The Contractor shall develop a draft and final transition plan subject to COR review and approval. The plan shall identify all activities, data files, software, and documentation that must be transferred in its entirety. The plan shall include the transferring of data files, software, and documentation as well as security arrangements for ensuring the confidentiality of data and adequate staffing of ongoing tasks. The plan shall also include details on the following:

The assignment of specific staff to each task that is to be transferred, The physical transfer and storage of data files, and all relevant documentation, The implementation of file cataloging and maintenance, The implementation of appropriate accounting and security measures.

The Contractor shall make arrangements to transmit materials from the incumbent Contractor, the AHRQ Data Center, or any other sources as needed to assure the shortest turnaround time possible consistent with cost effectiveness.

At closeout the Contractor shall turn over all files, computer programs, tabulations, documentation and other items within ninety (90) days of request made by COR in such form (electronic and paper) that the project may be continued by a successor.

Content of transfer shall contain, but is not limited to, the following:

All deliverables for the terminal option period as indicated by the Deliverables

Schedule Documentation and files associated with task A.1.2.1, specifically, prescribed

Healthcare Data Analytics and Statistical Products Page 14 of 91 medicines editing, income and assets editing, editing for out-of-pocket premiums for private health insurance, and the creation of the NHIS-MEPS linkage file.

Documentation and files associated with task A.1.2.3, specifically the prescribed medicines public file, the longitudinal file, pooled linkage file and the replicates for variable estimation file.

Documentation and files associated with task A.1.2.4, the production of Statistical Briefs and Research Findings.

Software, data files, documentation and programming files for the following web tools o HCUP Fast Stats o HCUPnet o MEPS Summary Tables HC o MPESnet HC o MEPS Summary Tables IC o MEPSnet IC o National Healthcare Quality and Disparities Reports and online tools

A.1.2 Database Requirements

A.1.2.1 Maintaining AHRQ Databases The Contractor shall maintain, store, catalogue, document, edit, and update files for AHRQ (MEPS and HCUP) databases.

The Contractor shall provide services for designing, testing, and running programs to edit raw data including matching, resolving logical inconsistencies and performing imputations, matching algorithms, and other available methods to account for missing data; creating appropriate sample weights and variance estimates in an efficient manner; and performing quality control checks on final versions of the files. These checks shall entail producing population weighted frequencies of selected variables, and benchmarking the results against other sources of similar information. The data editing tasks shall include creating and documenting new variables and edited versions of existing variables, including updating files when appropriate and documenting updates, maintaining histories of variables created or edited, and keeping track of the latest versions of variables that have been revised.

The Contractor shall be responsible for the following MEPS tasks:

1. Annually create MEPS prescribed medicines file by logically editing and imputing household- and pharmacy-reported information about prescription drugs, and then linking the two sources. The methodology is described in the following report:

https://meps.ahrq.gov/mepsweb/data_stats/Pub_ProdResults_Details.jsp?pt=M ethodology+Report&opt=2&id=1132

2. Annually editing and top-coding variables derived from reported household-reported income data, and imputing missing data, as described in the documentation for the MEPS Full Year Consolidated Data File:

https://meps.ahrq.gov/mepsweb/data_stats/Pub_ProdResults_Details.jsp?pt=Methodology+Report&opt=2&id=1132 https://meps.ahrq.gov/mepsweb/data_stats/Pub_ProdResults_Details.jsp?pt=Methodology+Report&opt=2&id=1132

Healthcare Data Analytics and Statistical Products Page 15 of 91 https://meps.ahrq.gov/data_stats/download_data/pufs/h181/h181doc.shtml#Inc omeTax

3. Annually editing and imputing household-reported out-of-pocket premiums for private health insurance using methods summarized in documentation for the MEPS Person-Round-Plan File:

https://meps.ahrq.gov/data_stats/download_data/pufs/h179/h179doc.shtml#Ou tofPocket343

4. Annually editing and imputing household-reported assets using imputation.

5. Annually create a file that links the MEPS sample to their respective identifiers in the National Health Interview Survey. The file is described here:

https://meps.ahrq.gov/data_stats/download_data/pufs/meps_nhislink/meps15_ nhislink.pdf

Databases will contain indirectly PII. The Contractor shall have access to PII including continuous poverty measures and imputed National Drug Codes. The Contractor shall abide by Federal Information Processing Standards (FIPS) 199 level of “Moderate” security designation.

A.1.2.2 Statistical Data Analysis and Programming The Contractor shall provide programming and statistical analysis services using MEPS and HCUP data. The Contractor shall work with econometric and statistical techniques used with a variety of large data sources including national surveys, discharge and claims databases. On average, there are 30 analytical tasks that need programming during any given month requiring seven programmers working full-time. The Contractor shall design, program, test and run statistical analyses using software programs such as SAS, STATA, SUDAAN, and R.

The Contractor shall be responsible for the following tasks:

1. Developing analytic files and plans- often employing complex algorithms for combining information across a variety of variables and multiple datasets stored at different levels;

2. Applying imputation techniques for missing data;

3. Development of statistical and econometric models including longitudinal analyses;

4. Conducting literature reviews and synthesis;

5. Conducting statistical analyses for statistical briefs and chartbooks (MEPS-HC, MEPS-IC, and HCUP);

6. Developing and testing data collection methodologies;

7. Developing survey design plans -Instrument design work shall include focus group and cognitive research efforts;

8. Conducting analysis for microsimulation modeling projects using data from

MEPS, NHIS, CPS, MCBS and with detailed insurance coverage information;

9. Conducting state level analysis to produce simulated public program eligibility

– the task entails editing wage hours, and weeks of work data, merging in data from NHIS, categorizing often complex family relationships, editing immigration https://meps.ahrq.gov/data_stats/download_data/pufs/h181/h181doc.shtml#IncomeTax https://meps.ahrq.gov/data_stats/download_data/pufs/h181/h181doc.shtml#IncomeTax https://meps.ahrq.gov/data_stats/download_data/pufs/h179/h179doc.shtml#OutofPocket343 https://meps.ahrq.gov/data_stats/download_data/pufs/h179/h179doc.shtml#OutofPocket343 https://meps.ahrq.gov/data_stats/download_data/pufs/meps_nhislink/meps15_nhislink.pdf https://meps.ahrq.gov/data_stats/download_data/pufs/meps_nhislink/meps15_nhislink.pdf

Healthcare Data Analytics and Statistical Products Page 16 of 91 status using data from NHIS and CPS, and applying complex eligibility algorithms;

10. Constructing and updating unique hierarchical databases by statistically matching data from the MEPS-HC, MEPS-IC and other employee and employer databases

11. Conducting analysis with MEPS-IC will require a programmer with Census Bureau Special Sworn Status (AHRQ will facilitate). To obtain Special Sworn Status the Contractor must pass a moderate risk background check, including fingerprinting. Additionally, the Contractor must complete annual confidentiality trainings on Data Stewardship and the use and protection of Title 26 data for the Census Bureau.

12. Sampling and related analysis:

The Contractor shall provide programming services required to identify and select the MEPS sample. The tasks shall include: 1) Formatting and quality control of NHIS data files for use in the MEPS sample selection, 2) Quality control review of variables necessary for sample selection, 3) Identification of sample domains, 4) Implementation of MEPS sampling specifications, 5) Preparation of data files to be transmitted to the MEPS-HC Contractor, and 6) Destruction of older NHIS data files in accordance with the AHRQ-NCHS IAA.

13. Benchmarking AHRQ Databases to external data sources.

14. Documentation of statistical data analysis and programing as related to the above tasks.

Statistical analysis and programming will require access to PII. The Contractor shall have access to PII including geographic identifiers, fully specified ICD10, industry and occupation codes, continuous poverty measures, imputed National Drug Codes, and linking IDs to the National Health Interview Survey. The Contractor shall abide by Federal Information Processing Standards (FIPS) 199 level of “Moderate” security designation.

Above tasks will require the Contractor to access internal datasets as well as other federal and state government healthcare data e.g., Medicare Provider Enrollment, Chain, and Ownership System (PECOS); Medicare Data on Provider Practice and Specialty (MD-PPAS); Medicare and Medicaid Claims and Enrollment Data; Center for Medicare and Medicaid Services (CMS) Plan Finder data and Marketplace public use files; HRSA healthcare data and Census Bureau data;

CDC surveys such as NHIS, NHANES, NMACS and BRFSS may also be required for analyses.

Additionally, the Agency may provide commercially available data sets such as MEDSTAT, Marketscan, and clinically-enhanced administrative databases for analytical purposes.

A.1.2.3 MEPS Public Use Data Files (PUF) The Contractor shall create four public-use files annually (samples provided at the links below) from MEPS data along with required documentation about the variables and file contents as well as the codebook. The Contractor shall also prepare the SAS, SPSS and STATA programming statements (TXT file type) for posting. For web posting, all documents will be in html and PDF formats that are 508 compliant.

Healthcare Data Analytics and Statistical Products Page 17 of 91

The Contractor shall prepare the micro-data files to be posted on the MEPS website (https://meps.ahrq.gov/mepsweb) in ASCII and SAS transport formats.

Annual PUF files are as follows:

The prescribed medicines file:

https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC -178A The Contractor shall be responsible for the following tasks:

• Pre-match editing, linking, and imputation of Pharmacy Component data

• Pre-match editing and imputation of Household Component data (charge and payment records and non-charge and payment records)

• Matching of Pharmacy Component and Household Component data

• Editing Sources of Payment data for consistency

• Developing data for public release

• Performing quality control and benchmarking of final edited prescribed medicines

• Linking Multum data to prescribed medicines.

MEPS longitudinal file:

https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC -183 The Contractor shall construct a public-use file for longitudinal data which contains all variables in the corresponding two years of consolidated files. For example, HC-183 represents all variables in 2014 full-year consolidated file and 2015 full-year consolidated file The Contractor shall create all files used for PUF release: Documentation file, Codebook files (PDF version and HTML version), SAS programming statements file, SPSS programming statements file, Stata programming statements file, ASCII data file, SAS transport data file.

The Contractor shall coordinate the release of the PUF to the MEPS Web site.

MEPS 1996-201X Pooled Linkage Variance Estimation File:

https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC -036 and MEPS 1996-201X Replicates for Variance Estimation File:

https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC

-036BRR

The Contractor shall create a new pooled linkage variance estimation file annually in order to provide a common variance structure for the years covering 1996 to the most current data year available.

The Contractor shall create a new replicates for variance estimation file annually for the years covering 1996 to the most current data year available.

https://meps.ahrq.gov/mepsweb https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC-178A https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC-178A https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC-183 https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC-183 https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC-036 https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC-036 https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC-036BRR https://meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC-036BRR

Healthcare Data Analytics and Statistical Products Page 18 of 91

A.1.2.4 MEPS Web publications

The Contractor shall write programs using analyst provided specifications and perform statistical analysis on selected MEPS variables needed for a Statistical brief. There will be five such requests annually. MEPS Statistical Briefs are online statistical reports that contain a set of estimates accompanied by limited text (two pages) of descriptive statistical analyses accompanied by graphics (five figures or tables). The Contractor shall perform technical editing, copyediting, and finalizing figures as well as supporting adherence of Section 508 compliance and updating the style guide as necessary. Documentation of required programming for the completion of the tasks shall be provided.

See the following example:

Characteristics of Practices Used as Usual Source of Care Providers during 2015, by Age— Results from the MEPS Medical Organizations Survey Statistical Brief 509 https://meps.ahrq.gov/data_files/publications/st509/stat509.pdf

The Contractor shall write programs using analyst provided specifications and perform statistical analysis on selected MEPS variables needed for one Research Findings Report annually. MEPS Research Findings Reports are online statistical reports that contain a set of estimates accompanied by text (five pages) of descriptive statistical analyses accompanied by graphics (ten figures or tables). The Contractor shall perform technical editing, copyediting, and finalizing figures as well as supporting adherence of Section 508 compliance and updating the style guide as necessary. Documentation of required programming for the completion of the tasks shall be provided.

See the following example:

The Uninsured in America, 2013-2015: Estimates for Non-Elderly Adults Uninsured throughout Each Calendar Year, by Selected Population Sub-groups and State Medicaid Expansion Status

Research Findings 35 https://meps.ahrq.gov/data_files/publications/rf35/rf35.pdf

A.1.3 AHRQ Data Center Tasks and Services The Contractor shall provide onsite support for the AHRQ Data Center including the development of and updates to policy and procedure manuals, inventory control, training, technical support, data migration, and other functions that pertain to the support and operations of the Data Center and secure local area network data environment. It shall also include programming for short-term special requests and descriptive statistical publications. A monthly report of Data Center activities shall be provided.

https://meps.ahrq.gov/data_files/publications/st509/stat509.pdf https://meps.ahrq.gov/data_files/publications/rf35/rf35.pdf

Healthcare Data Analytics and Statistical Products Page 19 of 91

The Contractor shall provide continuous onsite technical services for MEPS and HCUP data;

and serve as the contact point for AHRQ Data Center from 9:00 a.m. to 5:30 p.m. on days the Federal Government is open.

The Contractor shall be responsible for receiving and reviewing applications regarding accessing sensitive data and answering any questions from prospective data center users. On average, every year there are 40 applications submitted for AHRQ data requests from AHRQ data center. Additionally, the Contractor shall be responsible for monitoring and providing assistance to approximately a combined 200 onsite and remote (Census Research Data Centers) data users.

The Contractor shall provide assistance regarding MEPS data to AHRQ Data Center users in-person or remotely, as needed. This shall include remaining available throughout the Data Center users’ entire stay at the AHRQ Data Center. The AHRQ Data Center is located at 5600 Fishers Lane, Rockville, MD 20857.

The Contractor shall also provide technical support for developing analytical files using confidential data; merge data brought by the outside users; and consult with staff and/or outside users on security arrangements for the use of the data within the AHRQ data center.

Data Center activities will necessitate access to PII. The Contractor shall have access to PII including geographic identifiers, fully specified ICD10, industry and occupation codes, continuous poverty measures, imputed National Drug Codes, and linking IDs to the National Health Interview Survey. The Contractor shall abide by Federal Information Processing Standards (FIPS) 199 level of “Moderate” security designation.

The Contractor shall provide HCUP data librarian and analytic services to on-site and remote AHRQ staff. The Contractor shall provide on-site file and data transfer services, monitor and serve as gatekeeper for HCUP data access accounts and confidential data maintained in the secure LAN, maintain a log of data files, and ensure arrangements made with third parties to access datasets or analytic files are accomplished in accordance with AHRQ data use guidelines.

The Contractor shall serve as the gatekeeper for confidential data maintained onsite in the AHRQ Data Center. This includes MEPS data, HCUP data, CMS research files and a number of other files used for research in conjunction with MEPS and HCUP data. The Contractor shall maintain a log of data files and prepare weekly data center project reports.

The Contractor shall monitor PC and LAN use and storage and coordinate equipment upgrades and license renewals with AHRQ Secure LAN administrator.

The Contractor shall install MEPS and HCUP and secondary data files, execute data transfers to and from the AHRQ network to other MEPS and/or HCUP Contractors and users.

The Contractor shall provide two levels of “virtual seats” (basic and enhanced) in a secure data environment for analytic processing and storage using HCUP secure data. The basic virtual seat will provide a means for an AHRQ-approved outside researcher to gain access to HCUP data on the secure LAN and to develop analytic files and run statistical programming analyses using software such as (but not limited to) SAS, STATA, and SUDAAN. The Contractor shall provide four basic virtual seats at any one time. The enhanced virtual seat will provide access to data on the secure LAN as described for the basic virtual seat and with expanded processing and data storage capacity sufficient to accommodate running ten analyses in parallel, and the capacity to use additional statistical software such as R, Shiny R, Stat Transfer, and Python; the Contractor shall provide five enhanced virtual seats at any one time.

Healthcare Data Analytics and Statistical Products Page 20 of 91

A.1.4 Website Management, Web Tools and Publications

A.1.4.1 Website Management The Contractor shall maintain and manage MEPS and HCUPnet websites which shall include development, testing, and production sites. The Contractor shall configure these sites such that any deployment to the production website that contains errors can be immediately reverted to a stable instance, until such errors can be corrected. Both MEPS and HCUPnet are to be hosted by the Contractor on a secure server.

In addition to the above, the Contractor shall be responsible for the following tasks:

The Contractor shall prepare and post 20 MEPS Public Use Files annually on the MEPS website (four shall be created (as specified in the section A.1.2.3) before posting and the remaining 16 will be posted.

https://meps.ahrq.gov/mepsweb/data_stats/download_data_files.jsp

The Contractor shall provide general support for MEPS PUFs. The work shall include the following.

• Maintain the PUF data release schedule on the AHRQ MEPS Web site.

• Perform data management activities for PUFs residing on the project network drive.

• Investigate data issues affecting PUF files and provide programming support to resolve these.

• Review PUF materials sent to AHRQ from the MEPS Data Collection Contractor, check the correctness of the PUF postings to the MEPS Web site, and create HTML versions of the PUF codebooks.

• Check the accuracy of data created by SPSS and Stata programs posted (as user notes) to the MEPS Web site for reading PUF data.

• Provide editorial support for PUF activities.

• Investigate web-based publishing issues that affect the PUFs.

A.1.4.2 Web Tools

The Contractor shall provide technical editing, graphical services and quality control services to facilitate timely and accurate data products for posting on designated websites. The Contractor shall perform quality control activities on Individual pages, links and databases on an ongoing fashion. Any errors found shall be corrected within four hours of discovery.

The Contractor shall monitor AHRQ websites 24/7 every day. The Contractor shall notify AHRQ as soon as an unexpected website outage is encountered. This notification shall include proposed solutions and a timeline for implementation.

All web…

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it.