Most Frequently Used (MFU) 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
Most Frequently Used (MFU) Summary Table Queries
The Most Frequently Used (MFU) feature allows you to query the top n events, members, days supply, or dispensing within a specified query type (drugs, diagnoses, or procedures) within the Prevalence tables.
Diagnosis and Procedure Queries
The MFU Diagnosis and Procedure queries provide the top n events or members within the Prevalence tables. The counts are stratified by code, setting of visit, age group, sex, and year.
The MFU 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 an MFU Diagnosis or Procedure query, click on the New Request button in the request panel, select Summary: Most Frequently Used Queries, and select the request type. This will display the Request Composer page for the specific query type.
The request specific criteria for the MFU Diagnosis and Procedure query types only vary from one another by the codes that are included. Note that you cannot query across code types. For example, a single query may not return codes for ICD-9 3-digit and 5-digit diagnoses. The following figure shows the request specific criteria for an MFU ICD-9 3-digit Diagnosis query type:
Enter the following criteria for an MFU Diagnosis or Procedures query:
Control | Description |
|---|---|
Metric Type | Select the metric type from the dropdown menu. Options include Events and Users. |
Output Criteria | Select the number of rankings to return per strata. For example, selecting 20 for an MFU HCPCS query will return the 20 most frequent occurrences of HCPCS codes (by event or user, depending on the metric selected above) per strata. Options include 5, 10, 20, 25, 50, or 100. |
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. |
Drug Queries
The MFU Drug queries provide the top n users, days supplied, or dispensings within the Prevalence tables. The counts are stratified by drug category/name, age group, sex, and year.
The MFU Drug queries include Pharmacy Dispensings by Drug Class and Pharmacy Dispensings by Generic Name. To compose an MFU Drug query, click on the New Request button in the request panel, select Summary: Most Frequently Used Queries, and select the request type. This will display the Request Composer page for the specific query type.
The request specific criteria for the MFU Drug query types only vary from one another by the results that are returned. The following figure shows the request specific criteria for an MFU Pharmacy Dispensings by Drug Class query type:
Enter the following criteria for an MFU Drug query:
Control | Description |
|---|---|
Metric Type | Select the metric type from the dropdown menu. Options include Days Supply, Dispensings, and Users. |
Output Criteria | Select the number of rankings to return per strata. For example, selecting 20 for an MFU Pharmacy Dispensings by Drug Class query will return the 20 most frequent occurrences of drug classes (by user, days supply, or dispensings, depending on the metric selected above) per strata. |
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. |