Summary Table Queries
This documentation references PopMedNet 2021.1 +
PopMedNet User's Guide
Based on version 2021.1 +
Summary Table Queries
Summary Table Queries execute against Sentinel Common Data Model Summary Tables. The summary tables are created through distributed SAS code written by the Sentinel Operations Center and executed against the 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.
Summary Tables are also used by select users to query Truven Market Scan data via the Sentinel and HDC query tools.
To compose a Summary Table Request
- Click on the New Request button in the request panel on the query tool home page.
- Select the Project to which you with to distribute the request
- Select the summary table request type, (one of the options in the table below. You may not see all types listed depending on your permissions in the project you selected.
- This will display the Request Composer page for the Summary Table Request.
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 |