Most Frequently Used (MFU) Summary Table Queries
This documentation references PopMedNet 2021.1 +
PopMedNet User's Guide
Based on version 2021.1 +
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.
The following are criteria for an MFU Diagnosis or Procedures query:
Control | Configuration |
---|---|
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.
The following are criteria for an MFU Drug query:
Control | Configuration |
---|---|
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. |