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.

Provider Analysis and Review (MEDPAR) File: It contains inpatient hospital and skilled nursing facility (SNF) stay records. 2) 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. 3) 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-2018; In-process: 2019-2020 data under CMS review

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: cancer diagnosed in 1995-2013 and Claims 2004-2014; In-process: cancer diagnosed in 1999-2017 and claims 1999-2019 under development of DUA

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) Long Term Care File (LT): provides information on all Medicaid covered services received in long term care institutions including nursing facilities and those serving the mentally retarded. 5) 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 – under TCR IRB review.

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 enrolling 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 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. Unavailable until 2023

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: under TCR IRB review.