Include Page | ||||
---|---|---|---|---|
|
Data Checker Requests
The PopMedNet software supports querying against the Data Characterization data model. The Data Characterization tables are created from data quality review and characterization output. The tables contain information regarding the distribution and missingness of variables among the data held by each data partner.
Data Checker requests allow you to query the Data Characterization data model and generate tables and charts of the results. You may select which data partners to include in the request.
There are nine Data Checker request types. The sections below describe the general instructions for composing Data Checker requests and viewing results and the details of each request type and its specific parameters.
Request Type | Description |
---|---|
Demographic: Ethnicity | Ethnicity distribution among, within, and contributed by selected data partners |
Demographic: Race | Race distribution among, within, and contributed by selected data partners |
Diagnosis: Diagnosis Codes | Count and distribution of specified diagnosis codes among, within, and contributed by the selected data partners. May be filtered by diagnosis code type |
Diagnosis: PDX | Distribution of discharge diagnosis types by encounter type among and within selected data partners |
Presence of specified National Drug Codes at the selected data partners | |
Dispensing: RxAmt | Distribution of pharmacy dispensing amount supply among, within, and contributed by selected data partners |
Dispensing: RxSup | Distribution of pharmacy dispensing days supply among, within, and contributed by selected data partners |
Metadata: Data Completeness | Completeness and availability of data by table and data partner |
Procedure: Procedure Codes | Count and distribution of specified procedure codes among, within, and contributed by the selected data partners. May be filtered by procedure code type. |
Data Checker Request Types
Anchor | ||||
---|---|---|---|---|
|
Demographic: Ethnicity
The Demographic: Ethnicity Data Checker request queries for the ethnicity distribution among, within, and contributed by the selected data partners.
Result Views
Three result views are available for the Demographic: Ethnicity request. Expand the sections below for details on each view and samples of the tables and charts available.
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected variables among the selected data partners Sample table: Sample bar chart: Sample pie chart:
|
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected variables within the selected data partners. Percentages calculated across columns. Sample table: Sample bar chart: Sample pie chart: |
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent contributed by the selected data partners to the selected variables. Percentages calculated across rows. Sample table: Sample bar chart: Sample pie chart: |
Anchor | ||||
---|---|---|---|---|
|
Demographic: Race
The Demographic: Race Data Checker request queries for the race distribution among, within, and contributed by the selected data partners.
Result Views
Three result views are available for the Demographic: Race request. Expand the sections below for details on each view and samples of the tables and charts available.
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected variables among the selected data partners. Sample table: Sample bar chart: Sample pie chart: |
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected variables within the selected data partners. Percentages calculated across columns. Sample table: Sample bar chart: Sample pie chart: |
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent contributed by the selected data partners to the selected variables. Percentages calculated across rows. Sample table: Sample bar chart: Sample pie chart: |
Anchor | ||||
---|---|---|---|---|
|
Diagnosis: Diagnosis Codes
The Diagnosis: Diagnosis Codes Data Checker request queries counts and distribution of codes among, within, and contributed by the selected data partners.
Result Views
Three result views are available for the Diagnosis: Diagnosis Codes request. Expand the sections below for details on each view and samples of the tables and charts available.
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected codes among the selected data partners Sample table: Sample bar chart (counts): Sample bar chart (percentages): Sample pie chart: |
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected codes within the selected data partners. Percentages calculated across columns. Sample table: Sample bar chart (counts): Sample bar chart (percentages): Sample pie chart
|
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent contributed by the selected data partners to the selected codes. Percentages calculated across rows. Sample table: Sample bar chart: Sample pie chart: |
Anchor | ||||
---|---|---|---|---|
|
Diagnosis: PDX
The Diagnosis: PDX Data Checker request queries for the distribution of discharge diagnosis types by encounter type among and within selected data partners.
Result Views
Two result views are available for the Diagnosis: PDX request. Expand the sections below for details on each view and samples of the tables and charts available.
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution by Encounter Type of the selected PDX variables among the selected data partners. Percentages calculated across columns. Sample table: Sample bar chart: |
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution by Encounter Type of the selected PDX variables within the selected data partners. Percentages calculated across columns. Sample table: Sample bar chart: |
Anchor | ||||
---|---|---|---|---|
|
Dispensing: NDC
The Dispensing: NDC Data Checker request queries for the presence of specified National Drug Codes at the selected data partners.
Result Views
One result view is available for the Demographic: Ethnicity request. Expand the section below for details on this view and a samples of the table available.
Expand | ||
---|---|---|
| ||
Calculation: if the code is present at the selected data partner, the cell is marked with a 1. If the code is not present, the cell is marked with a 0. The final column provides a count of the data partners at which the code is present. Sample table: |
Anchor | ||||
---|---|---|---|---|
|
Dispensing: RxAmt
The Dispensing: RxAmt Data Checker request queries for the distribution of pharmacy dispensing amount supply among, within, and contributed by selected data partners.
Result Views
Three result views are available for the Dispensing: RxAmt request. Expand the sections below for details on each view and samples of the tables and charts available.
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected RxAmt ranges among the selected data partners. Sample table: Sample bar chart: Sample pie chart: |
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected RxAmt ranges within the selected data partners. Percentages calculated across columns. Sample table: Sample bar chart: Sample pie chart: |
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent contributed by the selected data partners to the selected RxAmt ranges. Percentages calculated across rows. Sample table: Sample bar chart: Sample pie chart: |
Anchor | ||||
---|---|---|---|---|
|
Dispensing: RxSup
The Dispensing: RxSup Data Checker request queries for the distribution of pharmacy dispensing days supply among, within, and contributed by selected data partners.
Result Views
Three result views are available for the Dispensing: RxSup request. Expand the sections below for details on each view and samples of the tables and charts available.
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected RxSup ranges among the selected data partners. Sample table: Sample bar chart: Sample pie chart: |
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected RxSup ranges within the selected data partners. Percentages calculated across columns. Sample table: Sample bar chart: Sample pie chart: |
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent contributed by the selected data partners to the selected RxSup ranges. Percentages calculated across rows. Sample table: Sample bar chart: Sample pie chart: |
Anchor | ||||
---|---|---|---|---|
|
Metadata: Data Completeness
The Metadata: Data Completeness Data Checker request queries for the completeness and availability of data by table and data partner.
Result Views
One result view is available for the Metadata: Data Completeness request. Expand the sections below for details on this view and a samples of the table available.
Expand |
---|
Calculation: the start and end date of each table in the select data partner's database. Also includes the minimum and maximum dates of the data partner's data across all tables and the minimum and maximum dates across the entire distributed database. Sample table: |
Anchor | ||||
---|---|---|---|---|
|
Procedure: Procedure Codes
The Procedure: Procedure Codes Data Checker request queries counts and distribution of codes among, within, and contributed by the selected data partners.
Result Views
Three result views are available for the Procedure: Procedure Codes request. Expand the sections below for details on each view and samples of the tables and charts available.
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected codes among the selected data partners Sample table: Sample bar chart (counts): Sample bar chart (percentages): Sample pie chart: |
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent distribution of the selected codes within the selected data partners. Percentages calculated across columns. Sample table: Sample bar chart (counts): Sample bar chart (percentages): Sample pie chart: |
Expand | ||
---|---|---|
| ||
Calculation: the sum and percent contributed by the selected data partners to the selected codes. Percentages calculated across rows. Sample table: Sample bar chart: Sample pie chart: |
Include Page | ||||
---|---|---|---|---|
|