Oregon Health Authority, Health Policy and Analysis
Oregon Health Authority (OHA) is at the forefront of lowering and containing costs, improving quality, and increasing access to health care in order to improve the lifelong health of Oregonians. The OHA mission is helping people and communities achieve optimum physical, mental and social well-being through partnership, prevention and access to quality, affordable health care. Health Analytics provides leadership, balanced information, and data analysis to support policy development.
Organization Contact
Karen Hampton
Karen.R.Hampton@state.or.us

All Payer All Claims Program

The Oregon All Payer All Claims Database (APAC) is a large database that houses administrative health care data for Oregon's insured populations. It includes medical and pharmacy claims, enrollment data, premium information, and provider information for Oregonians who are insured through commercial insurance, Medicaid, and Medicare. Data files are received on a rolling 12 month basis from the date incurred. Established in 2009, APAC has data for analysis 2011- to the current completed year.

Steps Required to Obtain Data
1. Requests for all types of APAC data begin with completing the APAC-2 form and submitting it to apac.admin@state.or.us. See forms at https://www.oregon.gov/oha/HPA/ANALYTICS/APAC%20Page%20Docs/APAC-2.pdf.
2. Requests for Public Use Files will receive a data use agreement and invoice. Once the agreement is signed and returned, and payment is received, the electronic file will be transmitted.
3. For limited/custom data sets, after review by the Program to determine if the proposed use falls within statutory limitations, the applicant will be asked to complete the APAC-3 form and a Data Elements Workbook.
4. Limited/custom data files require a description of the project and methodology, information on secure storage, individuals accessing the data and information on use of each field for minimum necessary review by a research analyst. The Data Elements Workbook identifies which fields must have the use explained prior to approval. An IRB waiver or approval may be required.
5. The limited/custom data request is assigned to a research analyst for evaluation. The research analyst may request clarification or additional information from the data requestor.
6. After approval by the research analyst, the data request is posted online for comments for two weeks, then reviewed by the Data Review Committee.
7. If approved by the Data Review Committee, a data use agreement and invoice are sent to the data requestor.
8. When the signed data use agreement and payment are received, the data file will be prepared and transmitted.
On average, how long does it take to access the data?
Public use file 1 - 2 months; Limited data file 2 - 4 months
Category
Claims & Transactions
Originating Data Source
Payer
Intended End User
Academia
Business
General Public
Government
Data Type
Raw
Data Format
Public use file is tab delimited; Limited/custom files are pipe-delimited
Additional Processing Required
No
Is the data identifiable?
No
Real or Synthetic Data
Real
Data is Updated
Quarterly data updates; annual release of data files
Free of Charge?
No
Costs outlined in APAC-2 form