Incidence Summary Table Queries v5.0
This documentation references PopMedNet 5.0 +
For version 4.0.3 documentation, please see PopMedNet User's Guide Version 4.0.3
PopMedNet User's Guide
Based on version 5.0
Incidence Summary Table Queries
Incidence queries are based on the Incidence MSCDM Summary Tables. The Incidence summary tables represent incidence counts of diagnoses and drug utilization.
Incidence is defined as a member with an encounter with the diagnosis of interest (i.e., the index date), in the care setting of interest, in the year of interest with no evidence of that diagnosis in the 90, 180 and 270 days (i.e., the look back periods) before the index date in any care setting. Both medical and drug coverage are required during the 3 possible look back periods, allowing for eligibility gaps of <=45 days. In addition, the tables also report number of encounters in the care setting of interest with that diagnosis in the 90, 180, 270 days after the index date (including the index event). Only the first incident event/index date within each year is considered.
Incidence ICD-9 Diagnosis (3 digit codes) Queries
The Incidence ICD-9 Diagnosis query provides counts of unique members with an incident diagnosis of a 3-digit ICD-9 diagnosis code observed during the period and a count of events experienced within each stratum. The counts are stratified by code, setting of visit, age group, sex, and year.
To compose an Incidence CD-9 Diagnosis (3 digit codes) query, click on the New Request button in the request panel, select Summary: Incidence Queries, and select ICD-9 Diagnosis (3 digit codes). This will display the Request Composer page for the query type.
The figure to the right displays the request specific criteria for the Incidence ICD-9 3-digit Diagnosis query type.
The Incidence ICD-9 Diagnosis query uses a list of codes provided by OptumInsight. The query tool software uses the short name description, as opposed to the long name description, to match code names. The figure to the right shows a 3-digit ICD-9 Diagnosis code selector dialog.
Entering the following criteria for the query:
Parameter | Description |
Code Selection | Click Select under Code Types to open the code selector dialog. There are two ways to search for codes:
The Search Results panel will populate with a list of codes and their short names. Click on a code to add it to the Selected Codes list. Click on the code again in the Selected Codes list to deselect it. Click Save to close the code selector dialog and insert the codes into the query. |
Setting | Select the care setting from the dropdown menu. Options include inpatient, outpatient (ambulatory), emergency department, or any setting. |
Age Stratification | Select the age stratification from the dropdown menu. Options include ten, seven, four, two, or no age stratifications. |
Sex Stratification | Select a sex grouping from the dropdown menu. Options include female only, male only, male and female, or male and female aggregated. |
Observation Period Selector | Enter the start year and ending year for the observation period range. |
Incidence Drug Queries
The Incidence Drug queries include Pharmacy Dispensings by Drug Class and Pharmacy Dispensings by Generic Name. They provide counts of unique members with an incident dispensing during the period. Counts are stratified by drug category/generic drug name, age group, sex, and year.
To compose an Incidence Drug query, click on the New Request button in the request panel, select Summary: Incidence Queries, and select the request type. This will display the Request Composer page for the specific query type.
The request specific criteria for the Incidence Drug query types only vary based on whether drug categories or specific generic drug names are queried. The figure to the right shows the request specific criteria for a Pharmacy Dispensings by Generic Name query type.
The Prevalence Drug queries use a standardized list of drug categories and generic names provided by the Mini-Sentinel Operations Center and mapped from National Drug Codes provided by First DataBank. The figure to the right shows a generic drug name code selector dialog.
Enter the following criteria for a drug query:
Parameter | Description |
Drug Selection | Click Select under Code Set to open the code selector dialog. For Pharmacy Dispensings by Generic Name, there are two ways to search for codes:
For Pharmacy Dispensings by Drug Class, only searching by text string is available. Wildcards (*) may be used. The Search Results panel will populate with a list of codes and their short names.Click on a code to add it to the Selected Codes list. Click on the code again in the Selected Codes list to deselect it. Click Save to close the code selector dialog and insert the codes into the query. |
Age Stratification | Select the age stratification from the dropdown menu. Options include ten, seven, four, two, or no age stratifications. |
Sex Stratification | Select a sex grouping from the dropdown menu. Options include female only, male only, male and female, or male and female aggregated. |
Period Type | Select the period type: Quarterly or Yearly. |
Observation Period Selector | Enter the start year and ending year for the observation period range |