Table of Pharmacoepidemiology Data Elements
<< Back to Pharmacoepidemiology and Healthcare Databases
This table of data elements provides a snapshot of the material contained in the various pharmacoepidemology databases listed in the left-most column. When specific information is included in a database (e.g. age, race, site/histology), the letter "Y" appears in the table cell; if no information is available, the letter "N" is used. Some cells contain more specific information, as available.
US Healthcare Database/System | Data collection | Demographics | Cancer Information | Pharmaceutical Use | Inpatient Dx | Inpatient Procedures | Otpt Dx | Outpatient Procedures | Lab Values | Vital Status | Approx. Population Size | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Age | Race | Gender | Residence | Site/Histology | Stage/Severity at Dx | Date of Diagnosis | Agent | Dose | Duration of Tx | |||||||||
Government Databases | ||||||||||||||||||
DOD | Continuous | Y | Y | Y | Address | Yes (ACTUR) | Y | Y | Y | Y | ICD9 | ICD9 | ICD9 | CPT-4 | Y | Y | 9.1M | |
Veterans Affairs | Continuous | Y | Y (about 25% listed unknown) | Y | ZIP Code | Not available in traditional research databases, it is in the EMR (CPRS), the VA Central Cancer Registry has the information. However, access to the Registry is highly limited, especially outside the VA | Not available in traditional research databases, it is in the EMR (CPRS), the VA Central Cancer Registry has the information. However, access to the Registry is highly limited, especially outside the VA | Yes through the Decision Support System (DSS) and Pharmacy Benefits Management Database (PBM) - DSS is typically easier to access | Available from the PBM only until FY 2007, not available in both PBM and DSS | In both PBM and DSS | ICD9, in centralized databases often accessed by researchers (Medical SAS Inpatient Datasets Housed at the Austin Automation Center) | ICD9, in centralized databases often accessed by researchers (Medical SAS Inpatient Datasets Housed at the Austin Automation Center) | ICD9, in centralized databases often accessed by researchers (Medical SAS Outpatient Datasets Housed at the Austin Automation Center) | CPT, in centralized databases often accessed by researchers (Medical SAS Outpatient Datasets Housed at the Austin Automation Center) | All lab values in the EMR. Certain lab values are in the Decision Support System that can be access by researcher (new lab values have been added to the DSS each year since out FY 2003) | Yes (VA Vital Status Files) | Approx. 5.3 million patients in FY '05 | |
Medicare | Continuous | Y | Y | Y | ZIP Code | N | N | Pt D (future) | Y | ICD9 | ICD9 | ICD9 | CPT-4 | N | Yes, no COD | 35M+ | ||
SEER-Medicare | Every 5 years? | Y | Y | Y | Census Tract | Y | Y | N | N | N | ICD-Oncology | Surgery | ICD-O | Some Radt | N | Yes, COD | More than 2.4M in '07 | |
Tennessee Medicaid Database (Linkage to Tennesse Cancer Registry) | Ad hoc | Y | Y | Y | Census Tract | Y | Y | Y | Y | Y | ICD9-CM | ICD9-CM | ICD9-CM | Yes, via Vital Statistics Linkage | Approx. 1.2M in '06 | |||
Ohio Medicaid Database | Ad hoc | Y | Y | Y | Y | ICD9-CM | ICD9-CM | ICD9-CM | CPT-4 | Y | Approx. 1.75M in '06 | |||||||
New Jersey Medicaid Database | Ad hoc | Y | Y | Y | Y | Yes, Linked to NJ Cancer Registry | Yes, Linked to NJ Cancer Registry | Y | Y | Y | ICD9 | ICD9 | ICD9 | Y | Y | Approx. 0.86M in '06 | ||
California Cancer Registry-Medicaid | Ad hoc | ICD9-CM | ICD9-CM | ICD9-CM | Approx. 6.5M in '06 | |||||||||||||
Metropolitan Detroit-Michigan Medicaid | Ad hoc | ICD9-CM | ICD9-CM | ICD9-CM | ||||||||||||||
HMO-Cancer Research Network (HMO-CRN) | ||||||||||||||||||
Fallon Community Health Plan | Continuous | Y | *1 | Y | Address | Yes, partial population | Y | Y | Y | Y | Y | Y | Y | N | Y | 123,000 in '05 | ||
Group Health Cooperative | Continuous | Y | *1 | Y | Address | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | 600,000 | |
Harvard Pilgrim Health Care | Continuous | Y | *1 | Y | Address | Yes, partial population | Y | Y | Y | Y | Y | Y | Y | Y | Y | 804,000 in '03 | ||
HealthPartners | Continuous | Y | *1 | Y | Address | Not yet | Y | Y | Y | Y | Y | Y | Y | N | Y | 642,000 in '06 | ||
Henry Ford/Health Alliance Plan | Continuous | Y | Y | Y | Address | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | 577,000 | |
Kaiser Permanente Colorado | Continuous | Y | *1 | Y | Address | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | 476,000 in '06 | |
Kaiser Permanente Hawaii | Continuous | Y | *1 | Y | Address | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | 223,000 in '06 | |
Kaiser Permanente Georgia | Continuous | Y | *1 | Y | Address | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | ? | 8M in '06 | |
Kaiser Permanente N. California | Continuous | Y | *1 | Y | Address | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | ? | 3.3M in '06 | |
Kaiser Permanente Northwest | Continuous | Y | *1 | Y | Address | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | 490,000 in '06 | |
Kaiser Permanente S. California | Continuous | Y | *1 | Y | Address | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | 3.25M in '06 | |
Lovelace Sandia Health System* | Continuous | Y | *1 | Y | Address | Not yet | Y | Y | Y | Y | Y | Y | Y | ? | ? | 250,000 in '07 | ||
Marshfield Clinic Research Foundation | Continuous | Y | *1 | Y | Address | Y | Y | Y | Y | Y | Y | Y | Y | ? | ||||
HMO-Cancer Research Network (not in HMO-CRN) | ||||||||||||||||||
Scott & White Health System | Continuous | Y | N | Y | Address/ZIP Code | ? | N | Y | Y | Y | Y | Y | Y | Y | N | N | 210,000 | |
Geisinger Health System | Continuous | Y | *1 | Y | Address | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | 1.2M | |
Others | ||||||||||||||||||
UnitedHealth Group | Continuous | Y | Y | Y | Y | Y | Y | ICD-9 | ICD-9 | ICD-9 | CPT-4 | Y | Approx. 13 million | |||||
HealthCore (Wellpoint Health Networks/BC/BS) | Continuous | Y | Y | Y | Y | Y | ICD9-CM | ICD9-CM | ICD9-CM | Y | Approx. 4.4 million members |