Below are answers to commonly asked questions organized into six categories.
Q. What rule governs how MHDO releases data to the public?
A. MHDO Rule Chapter 120 governs the MHDO’s release of data to the public. You can find a copy of that rule on our Rules and Statutes page.
Q. How do I request data from MHDO?
A. You can find out how to request data on our Request Data or Reports page.
Q. What data can I request?
A. The Data Availability page lists the available data sets. It also shows the organization types that supply the data, the information contained in the data, and the time periods the data represent.
Q. What is the comment period and who can submit a comment?
A. The comment period is the period of time a data request is publicly posted for comment. The comment period allows the data providers and the public to review the data request and submit concerns about the data release to the MHDO. MHDO posts new data requests to its website, on its Current Data Request page, on the first business day of every week; MHDO also sends an electronic notification to the data providers who submit the data and other interested parties, notifying them of new data requests. The comment period is 30 business days after the request first appears on the MHDO website.
Q. How much does it cost to access data from MHDO?
A. MHDO’s data access fees can be found on our Pricing Information page.
Q. What is the difference between the APCD (All Payer Claims Data) data and the Hospital encounter data?
A. Payers submit claims data to the MHDO and hospitals submit hospital encounter data for all encounters inpatient and outpatient as well as for their provider based clinics.
The APCD contains health care claims paid for Maine residents by insurance companies licensed in Maine. It also includes Medicare claims paid for Maine residents and MaineCare (Maine Medicaid) claims. The submissions include files with member eligibility, medical claims, pharmacy claims, and/or dental claims information. These data contain information on the amounts that insurers paid for services. Please see the Data Availability page to see what types of entities submit data for each source and what data are available.
Hospital encounter data are submitted by hospitals and provider-based clinics in Maine. These submissions contain data for every service provided to each patient, regardless of how they were paid (commercial insurer, public, uninsured). However, these data do not include financial information on amounts billed or paid. Please see the Data Availability page to see what types of entities submit data for each source and what data are available.
Q. Does the MHDO data (APCD and hospital encounter) include patients who are uninsured and/or who paid for their care, or only data from payers?
A. Hospital encounter data does include patients who are uninsured but does not include payment information. The Maine APCD does not contain data on patients who are uninsured.
Q. What are the main differences between Level I and Level II data sets?
A. MHDO's Level I data sets are considered de-identified data which means the data elements do not directly or indirectly identify an individual patient and for which there is no reasonable basis to believe that data can be used to identify an individual patient.
MHDO’s Level II data sets are considered a limited data set which includes limited identifiable information specified in the HIPAA regulations. Level II data sets may only be used in ways that maintain individual anonymity.
For more information about which fields are included in the Level I and Level II data sets, refer to the Release Included Elements.
Q. I am interested in purchasing a Level II data set. Do I need to purchase both the Level I and Level II data sets to obtain all the releasable data fields available?
A. No, the Level II data set contains the data elements in Level I, so there’s no need to purchase both.
Q. Is it possible to obtain patient level and provider level data? Is this identified or de-identified data?
A. In the Level II data sets for both APCD and Hospital encounter data, de-identified patient data are available and each patient has a MHDO assigned unique identifier. Identifiable provider data is available for both the APCD and hospital encounter data. The MHDO data dictionary is available and provides details on the specific data elements. Some highlights of the provider data include facility name, facility code, geographic information, service provider state, data processing center code and a national provider identifier where appropriate. For the Hospital encounter data, a unique hospital or clinic is provided for each encounter with the name of the facility, geographic location, and de-identified ordering and performing provider.
Q. What format are the data sets released in?
A. MHDO Data sets are released in fixed-width text (.txt) files. These can be imported on a variety of platforms and are widely recognized by data management and statistical analysis tools. Data users typically use a database like SQL server or a statistical analysis package like SAS.
Q. Is there a way to link the APCD and Hospital encounter data sets together?
A. No, not at this time as there are no direct data elements released in the data that would allow the linkage between the All Payer Claims Database (APCD) and the Hospital encounter data. The MHDO has discussed the feasibility and utility of linking these data sets internally and making available as a combined data set. At this time there is limited utility in developing one patient index across the different data streams (claims and hospital data). Instead MHDO is focusing our resources on making sure that we have the data elements needed to identify unique individuals in the data streams so that we can accurately link records internally and release de-identified records.
Q. Once I’ve been approved to receive MHDO data, how will the data be sent?
A. There are two Options for how Authorized MHDO Data Users can access and work with MHDO datasets
Direct Data Access in Data Enclave
Analyst (Standard Subscription Fee)
Direct Data Access in Data Enclave
Custom Project (DE Estimated Fee)
|Data Access & Formats||Access database tables/views in Vertica HP (read only)||On request, requiring Feasibility Assessment and Estimating by NORC|
|Storage for data files, reports, spreadsheets, documents||
50 GB personal H Drive:
200 GB shared storage available for the research team
|Custom Database Storage + Custom File Storage as agreed with NORC|
|Database Software||Vertica HP database with Dbeaver SQL Client Tool||Vertica HP database with Dbeaver SQL Client Tool + Other Data Management Tools if supported by NORC Data Enclave|
|Data Analysis Software||
SAS or STATA, R Studio, Python
Access to Tableau Desktop with provision of external license
SAS or STATA, R Studio, Python + Other Data Analysis Software, if supported by DE
For Additional Software, customer needs to provide license; software should be Citrix compatible
|Presentation Software||Microsoft Office Productivity Suite - Excel, PPT, Word, etc.||Microsoft Office Productivity Suite - Excel, PPT, Word, etc.|
|Download Files/Reports||5 SDC-reviewed export requests per month (Aggregated Data files, Reports)||Custom Number of Downloads and Size, as agreed with NORC|
|Upload 3rd Party Data||50 GB for Ancillary Data Files||Custom Number of Uploads, as agreed with NORC|
|Support Tier Description||2 day response service level agreement (SLA) for technical issues, defined as: account management, application launch failure, and database connectivity errors. Guaranteed issue resolution.||1 day response service level agreement (SLA) for technical issues, defined as: account management, application launch failure, and database connectivity errors. Guaranteed issue resolution.|
|Training||Self-guided onboarding to Data Enclave/MHDO Data via FAQs and short web-based video. 1 hour initial environment and data access training||Self-guided onboarding to Data Enclave/MHDO Data via FAQs and short web-based video. 1 hour initial environment and data access training|
|Data Objects Permissions||Read only access to data views for all available years in Vertica (low memory and temp table limits)||Creation of Temporary tables in Vertica is allowed. Tables/Views can be migrated to PROD (persistent) by NORC IT only|
Database New Objects
|Creation of Temporary tables in Vertica is allowed||Creation of Temporary tables in Vertica is allowed|
|Request Process||Request and Approval by MHDO/and NORC Data Enclave Database Managers||Project Request and Approval to MHDO/scope & feasibility assessments by NORC|
|NORC Fee Structure||
Hosting Fee Per User/Per Year = $5,200
Additional File Storage = $400/100G
Hosting Fee Per User/Per Year = $5,200
1 TB Vertica Storage ~ $20K / 1 TB
1 TB File Storage ~ $1,000 / 1 TB
Virtual Machine (VM) server 24 CPU / 128 GRAM / 500 HDD with
Windows 2012 R2 ~ $10,000 / 12 month
Virtual Machine (VM) server 12 CPU / 64 GRAM / 500 HDD with
Windows 2012 R2 ~ $5,000 / 12 month
Managed Services Fee (OS patches, Vulner PT Monitoring, Backups, etc.) ~
$150 / machine / month
Total Fees TBD based on final design
|Note: MHDO Data access fees apply as described in MHDO Rule Chapter 50|
*Process for the download option: When the data are ready to be released, you’ll receive an e-mail from MHDO's data vendor, NORC with the links to the data release files to be downloaded. We use the file sharing platform Accellion to ensure a secure file transfer. If you do not have an Accellion account, you’ll need to register for one.
The following instructions will be included in the e-mail:
To begin downloading the files you’ll need to click on one of the links. Because this is a secure download you will be asked to enter the address that received the e-mail. If you do not already have a download account, you will receive a second verification e-mail. Click on the link in that e-mail, choose a password, and you will then be able to authenticate and download the files.
Q. I received an email to download MHDO data, but I need one of my colleagues to download the data. Can I forward them the email?
A. No, the data transmittal email cannot be forwarded to others. Only original recipients are authorized to download the files. Please contact MHDO to modify the Data Custodian of your request if needed.
Q. How long will I have to download the data?
A. You have 90 days after receipt of the e-mail with the instructions to download the data. If you need to access the data after this time you will need to e-mail the MHDO at Webcontact.MHDO@maine.gov and include your Data Request Number in the subject line. The e-mail should explain why you need extended access to download the data files.
Q. What is the average time it takes to download one of MHDO’s larger files?
A. There are a number of factors that can influence the download speed but typically the largest files can take anywhere from several hours to a day to download.
Q. What do I do if I have questions regarding the data?
A. Send your questions in an e-mail to MHDO at Webcontact.MHDO@maine.gov with your Data Request Number in the subject line of the message.
Q. Where can I go to see which data elements are included in the APCD?
A. The MHDO data dictionary is available on our Data Dictionary page.
Q. Is the MHDO data dictionary the same across all payers (e.g., commercial, MaineCare and Medicare)?
A. Yes, the data dictionary applies to all claims records regardless of payer.
Q. Does your medical claims database include both professional and facility claims?
A. Yes, both professional and facility claims are included in the Maine APCD.
Q. Do I need to request the Practitioner Identifiable data elements if I am looking to identify a hospital as a provider in the APCD data?
A. No, you do not need to receive the Practitioner Identifiable data elements to identify a hospital. A facility table is provided in both the Level I and Level II data releases. The table allows data users to link the hospital identifier in the data and determine the claim lines associated with each hospital.
Q. Does the APCD contain denied claims?
A. No, the MHDO claims data submission, Rule Chapter 243, specifically excludes denied claims from all medical, pharmacy, and dental claims file submissions. When a claim contains both approved and denied service lines, only the approved service lines are included as part of the health care claims data set submittal. You will typically see reversals in the data with a claim status code of 22 and negative values in the data are adjustments to previous paid claims. Generally, payers fully reverse a claim line before issuing a replacement. However, we know that there is some variance in this practice. For instance, some Payers will only issue a partial adjustment (meaning that the sum of the entire claim still gives you the right bottom line figure).
Q. What is the difference between the APCD claims datasets and the eligibility data sets?
A. Claims data sets include:
Eligibility data sets include:
For more information, please see our Data Dictionary page.
Q. Can eligibility data be linked to the claims data?
A. The eligibility data can be linked to the claims data; in fact, one of the pre-release QC steps that we perform is checking the match rate between the claims data. You can find the match report from the most recent Release Report on the worksheet "MC Match to Eligibility".
However, the linkage of claims to eligibility can be complex because a payer may submit multiple eligibility records for an individual for a given month, each for a different product type. The eligibility associated with a claim may also come in under a different payer code than the claim.
The fields DC902_IDN, MC902_IDN, ME902_IDN, and PC902_IDN are unique row identifiers within their respective tables. They aren't used for inter-table linkages. Claims data can be linked to corresponding eligibility records by MHDO Member ID and incurred date. The following example SQL shows how the MC data can be linked to the ME data (the table names are our standard level II MC and ME release tables):
FROM vwRelease_MC_Level2_Base a left join
ON a.MC911_MHDO_MEMBERID = b.ME910_MHDO_MEMBERID
and YEAR(a.MC059_FDATE) = b.ME004_YEAR
and MONTH(a.MC059_FDATE) = b.ME005_MONTH
This will return MC claim records and any eligibility records the member has for the month and year that the service was incurred. Please note that, depending on your analysis, you may want to restrict the linkage further by payer code, coverage type or insurance product type. Individuals may have more than one eligibility row for a given month and year; depending on your analysis, you may need to take this into account to prevent duplicating claim lines.
For instance, to restrict an analysis to only medical claims that have a corresponding ASO or ASW eligibility record from the same payer, you could do a query like the following:
FROM vwRelease_MC_Level2_Base a
FROM vwRelease_ME_Level2_Base b
WHERE a.MC911_MHDO_MEMBERID = b.ME910_MHDO_MEMBERID
and YEAR(a.MC059_FDATE) = b.ME004_YEAR
and MONTH(a.MC059_FDATE) = b.ME005_MONTH
and a.MC002_PAYER = b.ME002_PAYER
AND b.ME029_COVERAGE in ('ASO','ASW')
This query will not duplicate medical claim lines even if there are more than 1 qualifying eligibility records available. It will only include medical claim lines that have at least one eligibility record that meets the match criteria. The bottom line is that linkage is possible, but it isn't as simple as linking on a single field. How the linkage is done depends on the specific analysis you are doing.
Q. Will the information provided include carriers that cover employer groups who reside in Maine?
A. The Maine APCD includes all payors as defined by MHDO with greater than $2,000,000 of adjusted premiums or claims processed per calendar year. Please see the Data Availability page to determine if a specific payer would be included in the requested dataset. . Note: As a result of the Gobeille v. Liberty Mutual decision (March 1, 2016) submission of claims data for self-funded ERISA plans is no longer a State requirement. However, we are accepting these data submissions on a voluntary basis.
Q. Does the All Payer Claims Database (APCD) include Medicare Advantage?
A. Yes, the MHDO receives Medicare Part C claims data also referred to as Medicare Advantage Plans. There is a flag in the claims that identifies Medicare plans administered through commercial payers. We have separated these from Medicare plans administered by the government. Therefore, you can determine which claims were Medicare Advantage claims.
Q. Does the APCD Pharmacy Claims include all payers (i.e., MaineCare, Medicare, and private insurance)?
A. The APCD includes pharmacy claims data from the private insurance companies and from Medicare Part D plans (outpatient Prescription Drug Insurance). Part D is provided only through private insurance companies that have contracts with the government.
Q. In the APCD, is there any kind of identifier that we can use to follow an individual across insurers and over time? Are encoded beneficiary identifiers the same across all parts of the data, and would it be possible to see claims of the same individual when they switch from a commercial plan into Medicare/Medicare HMO?
A. Every claim and eligibility record is assigned a MHDO de-identified member number to allow the tracking of de-identified individuals across time and between payers; however, due to variations in how payers supply eligibility information, sometimes the same individual may be assigned more than one MHDO de-identified member number. In general, the Medicare data includes eligibility data that allows us to assign a de-identified member number consistently The Medicare Advantage data are not always submitted with consistent member eligibility data. This is also an issue with pharmacy claims, where a number of plans only provide a contract number that cannot be tied to an individual in the medical claims. For Medicare Part A and B claims data administered by the government, we receive only medical claims. For Medicare Advantage plans, we receive both pharmacy and medical claims.
Q. What geographical identifiers are available in the APCD data? From the data dictionary, it seems that for both plan members and providers, city name, state/province, and ZIP code are available. Could you confirm this?
A. The geographical data elements available in the APCD data are as follows for both providers and de-identified individuals:
Geographical information related to city, state and zip has to be specifically requested and justified during the data request process.
Q. Using the claims information, I need to be able to track the exact health insurance plan for each submitted claim. What are the plan identifiers in your data?
A. The APCD data includes a field which indicates the payer and product type (HMO versus PPO, etc.) but not the specific plan identifier. The claims file has the claim filing indicator code and the eligibility file has the insurance type code which can be referenced in ASCx12.
Q. How are medical claims versioned in the data?
A. According to Rule Chapter 243, the original claim will have a version number of 0, with the next version being assigned a 1, and each subsequent version being incremented by 1 for that service line. There are some payers that are versioning claims differently from what is described in Rule Chapter 243. We have asked these payers for their methodologies and will post them and update this FAQ by July 2017.
Q. Is there a way to identify prescriptions that were filled through mail-order?
A. There is no mail-order indicator, however the pharmacy NPI is released which allows for the pharmacy to be identified.
Q. Can the same member identifiers in past files, be used with future files?
A. The member IDs we assign are consistent across time so that data users don’t
need a full data refresh with each data release- when we send a new quarter of data,
the user should be able to append it to the previous MHDO data that you received.
For every quarterly release, we include information on the member match to eligibility,
which represents the percentage of claims that have a matching eligibility record
for the member. In a recent release, which included all of calendar year 2016 for
commercial data, Q2-Q4 2016 for MaineCare (Medicaid) data and Q3-Q4 2015 for Medicare
data, we had high overall match rates – 97.9% for medical claims, 96.2% for dental
claims and 98.7% for pharmacy claims. MHDO is looking into the stability of the
member identifiers across time and will follow up with users in 2017.
Note: Every claim and eligibility record is assigned a MHDO de-identified member number to allow the tracking of de-identified individuals across time and between payers; Note: due to variations in how payers supply eligibility information, sometimes the same individual may be assigned more than one MHDO de-identified member number.
Q. How does the MHDO define runout?
A. Runout claims data is data with an incurred date within the data request period that is paid after the data request period ends. MHDO’s default runout period is 6 months. Example: if you request MHDO claims data through Q4 of 2016, you will receive data through Q2 2017 (the 6-month runout period will include records incurred in 2016 that were paid during Q2 of 2017).
Q. Where do I find the insurance type or product code that indicates the type of insurance coverage the individual has?
A. Refer to MHDO Rule Chapter 243 for the source information for these fields. Depending on the file type (medical, pharmacy, dental, eligibility), this information is released in the following fields.
Q. How do I interpret the Medicare product codes?
A. Below is a list of ME912_MHDO_PRODUCT codes that are non-standard and specific to Medicare.
Q. How is Medicare Part C and D coded?
A. This information can be found in the MHDO_PRODUCT fields in the release files.
In the eligibility files, these are the codes:
In the claims files, these are the codes:
Q. Does the MHDO get date of death for Medicare patients from CMS and if so, is it included in any of the MHDO releases?
A. Date of Death is not a releasable field and not included in our data releases.
Q. Where can I go to see what data elements are included in the Hospital data sets?
Q. Are there sample data layouts available?
A. The Excel documents "Outpatient Level II Base Layout" and “Inpatient Level II Base Layout” provide a detailed description of the data layout. The MHDO hospital data releases includes ICD-10 data elements. In general, records with discharge dates before 10/1/2015 used ICD-9 data elements while those discharged on or after this date used the new ICD-10 data elements. Note: ICD-9 and ICD-10 data elements are stored in different fields. For instance, the ICD-9 principal diagnosis is stored in the field OP7004_PrincipalDiagnosisCode while the ICD-10 version is stored in OP7104_PrincipalDiagnosis.
Whenever possible, data elements are prefixed with the data element name from the input layout specified in Rule Chapter 241, Uniform Reporting System for Hospital Inpatient Data Sets and Hospital Outpatient Data Sets, which provides additional details on the derivation of each element in Appendix B-2.
Value add fields that are not directly mapped from the input layout are prefixed with identifiers that begin with 4 alphabetic characters, to allow easy differentiation. For example, the patient age, which is calculated using date of birth and the admission/start of care date, is found under the field name OPMVA21_AGE and IPMVA21_AGE.
Effective with the implementation of MHDO’s Rule Chapter 120 –Release of Data to the Public, by default, data releases will include patient county and age. Patient city, Zip code and date of birth will require special justification for inclusion.
Q. Do you have data dictionaries for the hospital encounter outpatient and inpatient data sets?
A. Yes, the MHDO data dictionary is available on our Data Dictionary page.
Q. When each quarter of CY17 hospital inpatient data is released, will it only be that quarters data or are you also releasing the most recent 12 months of data ending in that most recent quarter?
A. The quarterly Inpatient Hospital files are meant to represent encounters that happened at a facility during that quarter, and only in that quarter. For example, the Q1 2017 Inpatient encounter file will include data for the months January- March 2017. The annual 2017 Hospital Inpatient Encounter file would be a compilation of the four quarterly files.
Q. What diagnosis fields are available in the current Rule Chapter 241 layout for the Hospital data?
A. In the current version of Rule Chapter 241, the diagnosis fields that are available are Version 040 which has one principal diagnosis, one admitting diagnosis code, two external injury codes, and eight other diagnosis codes (ICD-9); the versions 050 and 060 layout has one principal diagnosis code, one admitting diagnosis code, two external injury codes, and eight other diagnosis codes (ICD-10). Note: ICD-9 and ICD-10 data elements are stored in different fields. For instance, the ICD-9 principal diagnosis is stored in the field IP7004_PrincipalDiagnosisCode while the ICD-10 version is stored in IP7104_PrincipalDiagnosis. Whenever possible, data elements are prefixed with the data element name from the input layout specified in Rule Chapter 241, Uniform Reporting System for Hospital Inpatient Data Sets and Hospital Outpatient Data Sets, which provides additional details on the derivation of each element in Appendix B-2.
Q. What is the MHDO-assigned Medical Record Number (MRN)?
A. The MHDO-assigned Medical Record Number (MRN) is an obfuscated and transformed version of the MRN that is submitted by facilities to uniquely identify patients. Data users are reminded that the MHDO-assigned Medical Record Number generally cannot be used to track individuals between facilities; the same MRN may be used at different facilities to represent different individuals. Also, even within the same facility, an individual may not retain the same MRN across time; when hospitals merge or when they transition to new data systems, new MRNs may be assigned. The MHDO has no control over the MRN assignment policies within facilities. The MHDO is developing data elements that will allow an individual to be more reliably tracked both across time within a given facility and between facilities. MHDO plans consider a Rule Change to add patient SSN, patient name and patient street address to Chapter 241 Uniform Reporting System for Hospital Inpatient Data Sets and Hospital Outpatient Data Sets in 2017-2018 with an effective date of 2019.
Q. Is this to be implemented for the age at admission or the age at discharge?
A. Age at admission. In the MHDO Hospital Inpatient data, the age field IPMVA21_AGE is calculated based on the admission / start care date (IP2011) and patient’s date of birth (IP2005).
Q. If a patient is 90 years old, then the age on the data file is 90 and the date of birth is allowed to be non-missing? Or set to missing?
A. The rule of top coding applies to patients ages 90 or older. A person that is 90 years old at admission will have the age field IPMVA21_AGE set to value ‘90’ and the date of birth field IP2005_PatientDOB set to missing.
Q. If a patient is older than 90 years old (91, 92, etc.), then the age on the data file is set to 90 and the date of birth is set to missing?
A. The rule of top coding applies to patients ages 90 or older. A person that is 91 years old or older at admission will have the age field IPMVA21_AGE set to value ‘90’ and the date of birth field IP2005_PatientDOB set to missing.
Q. In the MHDO Hospital data, does Emergency Department data include both Inpatient and Outpatient data sets?
A. Yes, Emergency Department (ED) data is a subset of the Hospital for both the Inpatient and Outpatient data sets. The ED data follows the same format as the Outpatient Hospital data. It is processed with the Inpatient and Outpatient data and is available for the same time periods as these datasets.
Effective with the 2015 hospital data there is an ED Flag (IPMVA25_EDFLAG & OPMVA25_EDFLAG) in both the Inpatient and Outpatient data. This flag is set based on the presence of ED-related revenue codes present for each encounter in the Inpatient data and either ED-related revenue codes or ED-related CPT codes in the Outpatient data.
The methodology that we use to identify ED records is any inpatient or outpatient visit that has a revenue code of 0450, 0452, 0456, or 0459 are considered ED visits. In addition, any outpatient visits that include CPT code 99281-99285 are considered ED visits. Note: CMS guidelines call for these CPT codes to always be assigned to 045x revenue codes, however, it allows hospitals to associate these codes with other revenue codes if they had historically done so (https://www.cms.gov/Regulations-and- Guidance/Guidance/Transmittals/downloads/r167cp.pdf). Thus, inclusion of the CPT codes prevents overlooking ED visits due to historical billing practices at facilities or for non-CMS payers.
Update 3/1/2018: It came to our attention that we may be undercounting ED visits at Critical Access Hospital because certain payers are being split out and we cannot use revenue codes to identify ED-related visits. MHDO/HSRI will discuss with CAH’s the best way to identify all ED visits regardless of the payer for future releases. We will be updating our methodology once we find out how we can identify these ED visits.
Q. What Diagnosis Related Group (DRG) information is available in the Inpatient data.
A. MHDO assigns DRGs using the 3M Grouper software. Currently, two different sets of DRG codes and Major Diagnostic Categories (MDC) codes are created: one based on the All Patients Refined Diagnosis Related Groups (APR-DRG) and the other on the Medicare Severity-Diagnosis Related Groups (MS-DRG). The MDHO had previously also distributed two older versions of DRGs (AP-DRGS and CMS-DRGs) which have since been depreciated by their maintainers.
DRG information available in the Inpatient Encounter Data:
|Field Name||Description||Data Type||Length|
|IPMG22_MSVer||MS-DRG verion number||Integer||19|
|IPMG25_APRVER||APR version number||Integer||19|
Both the APR-DRG and the MS-DRG are revised annually. The DRG version used is available in the data and will be determined by the discharge date on the encounter record following the table below.
DRG Version Table:
|Calendar Year||DRG Version||Date Range|
|2013||v30||1/1/2013 - 9/30/2013|
|2014||v31||1/1/2014 - 9/30/2014|
|2015||v32||1/1/2015 - 9/30/2015|
|2016||v33||1/1/2016 - 9/30/2016|
|2017||v34||1/1/2017 - 9/30/2017|
|2018||v35||1/1/2018 - 9/30/2018|
|v36||10/1/2018 - 12/31/2018|
Note each version starts in the 4th quarter of one year and extends through the end of the 3rd quarter of the subsequent year. This means that in each year's hospital encounter data, we will have two different versions of the DRGs—one for Q1-Q3 and the subsequent version for Q4.
Q. What do the MHDO Assigned Payer Category Codes mean?
A. In 2015, we updated the MHDO assigned payer category codes based on conversations with the data user group. The codes ‘12’ Medicare Advantage and ‘00’ Unknown were added, while ‘05’ Blue Cross has been removed. Blue Cross is now recoded as ‘06’ Commercial Carriers. In addition to the category codes, we also include the National Association of Insurance Commissioners (NAIC) Payer Code and Payer Name as received on the encounter records. Payer Names are released if the name does not disclose an individual - over 90% of payer names are released.
As part of the Payer Category Code assignment, MHDO codes payers with 10 or more encounters in the data warehouse at the time of the data processing. For encounters through December 2017, Payer Names below this frequency threshold have a blank Payer Category Code value. Starting with the 2018 data, Payer Names below this frequency threshold have a Payer Category Code value of ‘99’, meaning ‘undetermined’.
|MHDO Assigned Payer Category Code||Category Name||Payer Name Examples|
|01||MEDICARE||MEDICARE, MEDICARE A B, MEDICARE PART A IP|
|02||MEDICAID||MAINECARE, MEDICAID - OUT OF STATE|
|04||TRICARE/USVA||CHAMPVA, TRICARE, VA TOGUS|
|06||COMMERCIAL CARRIERS||AETNA HMO, ANTHEM BCBS, UNITED HEALTH|
|07||CHARITY/UNCOMPENSATED CARE||DISCOUNTED CARE, FREE CARE, UNCOMP CARE|
|08||SELF PAY||SELF PAY NO INSURANCE, S/P SELF PAY|
|09||WORKERS COMPENSATION||BATH IRON WORKS WC, LIBERTY MUTUAL WC|
|11||OTHER||RISK MANAGEMENT, HOSPICE|
|12||MEDICARE ADVANTAGE||AETNA MEDICARE HMO, HUMANA MEDICARE|
|00||UNKNOWN||MH NET, RM DEPT, MISC PAYER MISC ADDRESS|
Q. What does the data element IPMVA23_RVHITS represent in the MHDO Inpatient hospital data?
A. The data element IPMVA23_RVHITS represents a count of the distinct IP60 revenue code values that are populated on inpatient encounter records.
IPMVA23_RVHITS is not calculated as the maximum sequence number on the IP60 rows that belong to distinct inpatient encounter records (meaning, the total number of rows among rows with the same encounter identifier, IP60AD02_MasterIDN, in the IP60 dataset).
The IP60 dataset is structured so that one distinct IDN could have multiple rows and on each row there can be up to three positions populated with a revenue code.
To calculate the count one would need to look both across rows (in as many rows as shown by the IP6002 Sequence Number field) and across columns (three revenue code fields: IP6004, IP6006, IP6008) in the IP60 dataset.
Example: If we have a distinct inpatient encounter with 3 rows in the IP60 dataset (3 rows of data sharing the same IP60AD02_MasterIDN value), there would be a total of 9 “cells” or revenue code positions that could have revenue code values. If only 7 out of the total of 9 “cells” that can hold revenue code values are populated, and they have 7 distinct values, the calculated IPMVA23_RVHITS would be ‘7’.
For situations where a revenue code value appears more than once for a particular IDN, it is counted a single time. As such, in the aforementioned example, if a revenue code appeared twice or more out of the 7 populated values, IPMVA23_RVHITS would be less than 7.
Q. How are geocodes assigned?
A. If your data request includes the release of ZIP codes, you will also receive a geocode. The MHDO assigns a geocode when the city, state, and ZIP code match the entries that appear on the canonical list of geocode values (a data table of Maine geocodes provided by the Maine Office of GIS (MEGIS) is the canonical list used for the assignment and is included in this release). The MHDO will not impute geocodes based on incomplete or conflicting city, state, or ZIP code information. In order to improve our ability to assign geocodes, we are working with those facilities that have not provided consistent city, state, and ZIP code information. Since the beginning of 2016 we are able to assign a geocode for over 99% of the encounters.
Q. How are Health Service Areas (HSA) assigned?
A. If your data request includes the release of ZIP codes, you will also receive two HSA assignments. One (OPML23_OriginalSA or IPML23_Original_SA) is based on the Dartmouth Atlas of Health Care methodology and the other (OPML25_MMC_HSA or IPML25_MMC_HSA) is based on a methodology developed by the MaineHealth/Maine Medical Center Planning Department which is also based on the Dartmouth Atlas of Health Care methodology with a few modifications.
Q. What is the Location of Service in the outpatient data set?
A. The starting with the 2016 data, each release includes a new coding scheme that allows the field OP4005_LocationofService to be categorized as either a 1= Hospital Outpatient encounter or a 2 = Other locations, such as clinics, labs or physician practice. This new field appears on the base record in OP4005A_LOS_Category. The support table vwSupport_LOS_Codes contains descriptions of the LOS provided by the hospitals.
Q. What does it mean if the LOS is blank?
A. If the LOS field is blank for a given record, this usually indicates that the location of service is at the main facility indicated by the OP0102_SubmitterEIN field rather than an associated clinic or other sub-facility.
Beginning with the 1st Quarter of 2018 Inpatient data and 1st Quarter of 2017 Outpatient data, the value add field for patient’s age (IPMVA21 and OPMVA21) has a null value if the calculated age is above 110 years old, or if the admission/start of care date or statement covers period from date (IP2011 or OP2012, respectively) represents a value later than the discharge/statement covers period through date (IP2013 or OP2013, respectively).
Q. What does the Length of Stay calculation represent in the Inpatient and Outpatient data?
A. The Length of Stay field is calculated for both Inpatient and Outpatient data, however it reflects two different types of duration concepts. In Inpatient data, the Length of Stay field (IPMVA20) reflects the time period of hospitalization (the actual duration of the inpatient stay), whereas in the Outpatient data (OPMVA20) it pertains to the time period between the earliest services on the encounter record and the most recent services on the encounter record, so it does not represent a continuous “outpatient stay”.
Q. What should be submitted in Record Type 73 (OP7301 – OP7327) if there was not an external cause of injury? Should we submit empty records?
A. OP73 codes are only expected when there was an external cause of injury. If there is an S or T code (Injury or Poisoning) in OP7104, the first Ecode field is enforced. Only include records when there are values to report; do not send empty records.
Q. When should Record Type 74 (OP7401 – OP7427) records be populated?
A. The OP74 records will only be populated if there are additional (“other”) diagnoses that need to be provided in addition to the principal DX code. Do not send empty records.
Q. What is the easiest way to distinguish between facility records and professional records in the hospital outpatient data file?
A. Type of Bill (OP4004) only applies to facility or institutional claims (UB-04), while Place of Service (OP4006) only applies to professional claims (CMS-1500). Since a bill or claim is either institutional or professional (not both), only one of the fields can be populated. The value placed in either field indicates the type or nature of the institutional or professional bill or claim.
Q. Should I see a procedure code on all Inpatient admissions?
A. No, the service lines where procedures codes are missing are what we would expect to see – for example medical sub-service lines (medical cardiology, medical orthopedics and spine, etc.).
Q. Does the Hospital data include uninsured patients’ diagnoses? In other words, would the uninsured patients’ data be the same as all other patients’ data except that there would be no payment information?
A. Yes, services rendered to the uninsured are reported in the Hospital Inpatient and Outpatient data. Patients with no insurance appear with “self-pay” indicated as the primary “payer.” Note: The hospital encounter data releases exclude all financial data.
Q. Why do some hospitals have high rates of self-pay for pay2 and pay3 fields?
A. There are two hospitals that have confirmed that their system defaults to self-pay in the payer fields after all validated insurance carriers are included
Q. How do you identify Inpatient Rehabilitation Discharges since the conversion to ICD-10?
A. Since the switch to ICD-10 from ICD-9 there is no longer a way to identify rehabilitation discharges in the MHDO hospital inpatient data. Before the transition to ICD 10, hospital data coders were instructed to use a “V” code for any inpatient rehabilitation patient discharge which made the identification that a patient was an inpatient rehabilitation patient. With the introduction of ICD-10s, this concept was not carried forward as the National Center for Health Statics (NCHS) feels that rehabilitation is a procedure, not a diagnosis.
Beginning in the 4th Quarter of 2015 and all of 2016 data, inpatient rehabilitation encounters are not all being grouped into DRGs 945 and 946, instead they are being grouped into other DRGs. NCHS has suggested that looking at revenue codes is the way to identify rehabilitation cases. Below is a list of revenue codes that may be useful for the identification of rehabilitation discharges. MHDO is working with data users and coding experts to determine if there are other ways to code these discharges in the existing data or if we would need additional information submitted from the hospitals.
Q. Why is there only one operating provider attached to an encounter with multiple procedures?
A. The data submission rule, Chapter 241, only gives the hospital the option to provide one operating or attending provider in the layout (record 80). Unfortunately, we cannot tease out which particular procedure the attending or operating was associated with.