Prevalence 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
Prevalence Summary Table Queries
The Prevalence query types are based on the Prevalence MSCDM Summary Tables. The Prevalence summary tables represent prevalence counts of diagnoses, procedures, and drug utilization.
Enrollment Queries
The Enrollment query provides a count of unique individuals who are members/patients during the period. The count is stratified by age group, sex, year, drug coverage status, and medical coverage status. The member counts and days covered in the enrollment table can be used as denominators to calculate crude prevalence rates for Prevalence, Incidence, and Most Frequent Utilization query types. See /wiki/spaces/DPM/pages/491765 for more details.
To compose an Enrollment query, click on the New Request button in the request panel, choose Summary: Prevalence Queries, and then the Enrollment request type. This will display the Request Composer page for Enrollment queries. The figure to the right shows the request-specific criteria for an Enrollment query.
Enter the following criteria for an Enrollment query:
Parameter | Description |
Coverage | Select the coverage type from the dropdown menu. Options include Drug and Medical Coverage, Drug Coverage Only, Medical Coverage Only, or All Members (a union of the previous three coverage types) |
Age Stratification | Select the age stratification from the dropdown menu. Options include ten, seven, four, two, or no age stratifications. |
Sex Stratification | Select the sex stratification 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. |
Prevalence Diagnosis and Procedure Queries
The Prevalence Diagnosis and Procedure queries provide counts of unique members with a diagnosis or procedure 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.
The Prevalence Diagnosis and Procedure queries include ICD-9 3-, 4-, or 5-digit Diagnosis, HCPCS Procedure, and ICD-9 3-, and 4-digit Procedure queries.
To compose a Prevalence Diagnosis or Procedure query, click on the New Request button in the request panel, select Summary: Prevalence Queries, and select the request type. This will display the Request Composer page for the specific query type.
The request specific criteria for the Prevalence Diagnosis and Procedure query types only vary from one another by the codes that are queried. The figure to the right shows the request specific criteria for a Prevalence ICD-9 3-digit Diagnosis query type.
You cannot query across code types. For example, you may not include codes for ICD-9 3-digit and 5-digit diagnoses in the same query.
The Prevalence Diagnosis and Procedure queries use 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.
Enter the following criteria for a Diagnosis or Procedures 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. |
Prevalence Drug Queries
The Prevalence Drug queries include Pharmacy Dispensings by Drug Class and Pharmacy Dispensings by Generic Name. They provide counts of unique members who had a drug dispensing during the period, a count of dispensing received by all of these members, and total days supplied by strata. Counts are stratified by drug category/generic drug name, age group, sex, quarter-year, and year.
To compose a Prevalence Drug query, click on the New Request button in the request panel, select Summary: Prevalence Queries, and select the request type. This will display the Request Composer page for the specific query type.
The request specific criteria for the Prevalence 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 and select Q1 –Q4 for the start and ending years if applicable. |