| Include Page | ||||
|---|---|---|---|---|
|
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.
| Widget Connector | ||
|---|---|---|
|
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 |
| Include Page | ||||
|---|---|---|---|---|
|