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
Summary Table Queries
Summary Table Queries execute against Mini-Sentinel Common Data Model Summary Tables. The summary tables are created through distributed SAS code written by the Mini-Sentinel Operations Center and executed against the Mini-Sentinel Distributed Database held by each data partner. These tables provide summary counts of individuals by period, age group, and sex. The summary counts include information on medication use (e.g., number of dispensings, users, and days supplied), diagnoses (e.g., number of individuals with the diagnosis), procedures, and the overall data partner population.
The summary queries are grouped into three request models as follows:
Request Model | Request Type |
Enrollment | |
| ICD-9 Diagnosis (3 digit codes) |
| ICD-9 Diagnosis (4 digit codes) |
| ICD-9 Diagnosis (5 digit codes) |
| ICD-9 Procedures (3 digit codes) |
| ICD-9 Procedures (4 digit codes) |
| HCPCS Procedures |
| Pharmacy Dispensings by Drug Class |
| Pharmacy Dispensings by Generic Name |
ICD-9 Diagnosis (3 digit codes) | |
| Pharmacy Dispensings by Drug Class |
| Pharmacy Dispensings by Generic Name |
ICD-9 Diagnosis (3 digit codes) | |
| ICD-9 Diagnosis (4 digit codes) |
| ICD-9 Diagnosis (5 digit codes) |
| ICD-9 Procedures (3 digit codes) |
| ICD-9 Procedures (4 digit codes) |
| HCPCS Procedures |
| Pharmacy Dispensings by Drug Class |
| Pharmacy Dispensings by Generic Name |