Data Management and Analysis Core

Current Available Data

The Data Management and Analysis Core (DMAC) makes available the following sources of data in the next 5 years based on specific DUAs.

Texas Medicare: includes the following: 1) Beneficiary Summary File (BSF): It includes a unique beneficiary number, demographic, and monthly enrollment information. 2). Provider Analysis and Review (MEDPAR) File: It contains inpatient hospital and skilled nursing facility (SNF) stay records. 3) Outpatient Standard Analytical File (OUTSAF): It contains Medicare Part B claims for institutional outpatient providers, such as hospital outpatient clinics, ambulatory surgical centers, rural health clinics, and community mental health facilities. 4) Carrier File: It contains Medicare Part B claims from service providers. This file includes all services not received in an inpatient hospital, long-term care facility or pharmacy. All other service records of procedures will be included in this file. 4) Hospice File; Home Health Agency File; and Durable Equipment File. 5) Part D Prescription Drug Event (PDE) File: It contains pharmacy claims, including fill date, National Drug Code (NDC) number, medication name, dosage form, strength, quantity dispensed, days’ supply, route of administration, pharmacy identifier, Part D Plan identifier, and prescriber identifier. – Available year: 2000-2020; 2021 data is coming soon.

Texas Cancer Registry (TCR) linked to Medicare: TCR data includes 1) patient demographics: geographic location (to zip code  level); date of birth, race/ethnicity and gender, 2) diagnosis date and method, 3) topography(cancer site), 4) morphology (histological cancer type), 5) extent of cancer spread at the time of diagnosis (disease stage), 6) type of treatment first received for this cancer, and 7) follow-up information on last date of contact or death and cause of death. Available: cancers (breast, colorectal, prostate, cervix, skin) diagnosed in 1999-2017 and claims 1999-2019; lung cancer diagnosed in 2010-2017 and claims 2009 – 2019. TCR is currently part of SEER. SEER – Medicare data are available for oropharyngeal cancers diagnosed in 2000-2019. SEER – Medicare data for 10 cancer sites diagnosed in 2000-2019 are under DUA development and expected in summer 2023.

TCR linked to Texas Medicaid. Transformed Medicaid Statistics Information System (T-MISS) Analytic Files (TAF): includes 1) Demographic and Eligibility File (DE): includes demographics and Medicaid beneficiary-level enrollment or type of coverage. 2) Inpatient File (IP): includes all inpatient hospitalization information for both fee-for-service claims and managed care encounters. 3) Other Service File (OT): includes physician services and outpatient facility, lab/X-ray, home health, and hospice claims. 4) 4) Pharmacy File (PF): provides information on drugs and other services provided by a pharmacy. Included are national drug codes for prescription and over-the-counter drugs as well as durable medical equipment and some supplies. In progress: TCR IRB approved; currently under DUA development. Available in fall 2023 (expected).

TCR linked to Medicare Health Outcome Survey (MHOS): HOS contains patient-reported outcome measures, ex: physical and mental health-related quality of life from the Veterans RAND 12-items Health Survey, activities of daily living (ADL), smoking, pain, depression, sleep quality, memory problem, from beneficiaries enrolled in Medicare Advantage (MA) program. This survey is conducted annually to a random sample of 1200 subjects at each MA plan with more than 1200 enrollees and to all subjects at each MA plan with 500 to 1200 enrollees. Two years later, the same respondents are surveyed again. Unavailable until late 2023.

TCR-Consumer Assessment of Healthcare Providers and Systems (CAHPS): CMS annually administers CAHPS surveys to assess the health care experience of enrollees in both MA and fee-for-service plans. These surveys ask patients about their experience with, and rating of, their health care providers and plans, including hospital, home health care, doctors, and drug plan, among others. It also collects patient self-rated health and conditions, and ADLs. Currently under DUA review. Available in summer 2023 (expected).

TCR-Medicare Current Beneficiary Survey (MCBS): MCBS collects information on access to and satisfaction with healthcare, usual source of care, and health status, functioning, and medical condition for community dwelling Medicare enrollees. These self-reported data are linked to administrative claims. The sample of enrollees is interviewed up to three times a year over a four-year period. MCBS employs a three-stage cluster sample design and aims to yield about 14,500 completed cases annually. MCBS follows beneficiaries into and out of long-term care facilities to maintain a comprehensive profile of their health care and experience. In progress: TCR IRB approved; currently under DUA development. Available in fall 2023 (expected).