DOI: 10.57761/2wqj-ph37
title: MarketScan Commercial Database

description: Data Documentation



[User Guide](<https://docs.google.com/document/d/1vqEtN2PZ1FSE1v-ifjlmk7l7zJIZZvbCVO_QkdlEqMY/edit?usp=sharing>)

[Data Dictionary](<https://drive.google.com/file/d/1SxCaqLUjY2GbKTnhvLENfgeHQqGylWkj/view?usp=sharing>)


description: #Documentation  


Facility files contain diagnosis and procedure information provided by types of provider at a given facility, for a given individual for a given episode of care. Linkable to other tables using Enrollee ID. Row Entity level: Facility at which a service or set of services were provided for a patient, during a given episode of care. Common analyses: facility cost of a given procedure.



Key variables of interest: Bill Type code Case ID Coinsurance Copayment Net payments Primary diagnosis and eight secondary diagnosis variables Facility Header ID Health Plan ID Diagnosis Related Grouping Principal procedure and five secondary procedure variables Setting where service occurred Provider Type Date of inpatient service End date for a service




description: #Section 10  
This dataset was created on `2020-01-10 18:38:35.112` by merging multiple datasets together. The source datasets for this version were:



**MarketScan Population**: Aggregate demographic information about the eligible population is contained in the population files.



**MarketScan Facility Header**: Header records from the inpatient and outpatient services. One record represents one facility-based service or set of services for an individual.



**MarketScan Enrollment Detail**: The Enrollment Tables contain person-level enrollment records with demographic and plan information on users and non-users of services contained in the MarketScan Commercial Claims and Encounters and Medicare Supplemental Databases.



**MarketScan Inpatient Services**: This file contains individual inpatient claim records that were used to create admissions records.



**MarketScan Outpatient Services**: Individual outpatient claim records.



**MarketScan Inpatient Admissions**: Inpatient admission summary records. Inpatient meaning that the patient is formally admitted to the hospital with a doctor's order



**MarketScan Annual Enrollment Summary**: One record summarizes the number of days an individual was enrolled in a given calendar year. Commercial health data contains benefit information for enrollees and their dependents, for as long as the enrollee is an active employee.



**MarketScan Outpatient Pharmaceutical Claims**: Individual outpatient prescription drug claim records.


description: #Section 2  


This file contains individual inpatient claim records that were used to create admissions records. One record identifies one inpatient stay at a given facility.



Linkable to other tables using Enrollee ID Common measures: most expensive procedures in inpatient setting, admission rates, etc.



Key variables of interest: Date of Admission Admission Type Data Type Date of Discharge Length of Stay Principal Diagnosis for a given admission Principal diagnosis and 14 secondary diagnoses Procedure principal Principal procedure and 14 secondary procedures Net payments to hospital, respectively Gross payments to hospital, respectively Net payments to physician, respectively Gross payments to physician, respectively Total Coinsurance (for the case) Total copay (for the case) Total deductible (for the case) Net total payments (for the case) Gross total payments (for the case)




description: #Section 4  


The population files contain aggregate information ONLY. The population file is not linkable to any other dataset.



Key variables of interest:



- 
- Age Group
- 
- Employee Classification
- 
- Employment Status
- 
- Geographic Location
- 
- Relationship to Primary Beneficiary
- 
- Health Plan Indicator
- 
- Industry
- 
- Population Count by Quarter
- 
- Population Quarter indicator
- 
- Sex
- 

<!-- -->




description: #Section 5  


This file contains data on continuous periods of enrollment per individual. Specifically, it has multiple records per enrollee, with one record per enrollee per month during the database year.



Contains specific start and end dates of continuous enrollment periods Linkable to other tables using Enrollee ID Common measures: percent eligibility over a given time period



Key variables of interest: Date Enrollment Start Date Enrollment End Enrollee ID Member Days Benefit Plan Link Month 1 to 12 Plan Indicator Month 1 to 12




description: #Section 6  


Admission summary records. One record identifies one inpatient stay at a given facility.



Summary version of MarketScan Inpatient Services file Linkable to other tables using Enrollee ID Common measures: admission/readmission rates



Key variables of interest: Date of Admission Admission Type Data Type Date of Discharge Length of Stay Principal Diagnosis for a given admission Principal diagnosis and 14 secondary diagnoses Procedure principal Principal procedure and 14 secondary procedures Net payments to hospital, respectively Gross payments to hospital, respectively Net payments to physician, respectively Gross payments to physician, respectively Total Coinsurance (for the case) Total copay (for the case) Total deductible (for the case) Net total payments (for the case) Gross total payments (for the case)




description: #Section 7  


Linkable to other tables using Enrollee ID Common analyses: adherence to treatment for a given condition.



Key variables of interest: Capitated Basis Payment Flag Coinsurance Copay Deductible Net payments as reported by the carrier Gross payments as reported by the carrier Principal diagnosis and three secondary diagnoses Facility ID Facility Proof Paid Date Physician Flag Principal procedure Procedure group Procedure Type Provider ID Quantity Revenue Code Service Setting Provider Type Service Date Service Category The end date for a service




description: #Section 9  


Summary version of MarketScan Enrollment Detail file Linkable to other tables using Enrollee ID Common measures: percent eligibility over a given time period



Key variables of interest: Data Type Month 1 to 12 Enrollment Indicator Month 1 to 12 Enrollment Months Enrollee ID Member Days Month 1 to 12 Member Days Benefit Plan Link Month 1 to 12 Plan Indicator Month 1 to 12